Top referrers not working (+ serendipity_referrers empty)

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
CadEx
Regular
Posts: 12
Joined: Fri Oct 26, 2007 9:57 pm

Top referrers not working (+ serendipity_referrers empty)

Post by CadEx »

Damn it!
I can't figure out, why serendipity_referrers is still empty after three weeks, also I came to my blog myself via external links. What is wrong?
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Top referrers not working (+ serendipity_referrers empty

Post by garvinhicking »

Hi!

Did you enable referrer tracking in your s9y configuration?

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
CadEx
Regular
Posts: 12
Joined: Fri Oct 26, 2007 9:57 pm

Post by CadEx »

Yes, it is activated.
Sadly. Would have been such an easy solution.

Thx for your fast reply.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

What's your URL? Which s9y version are you using? Which database version are you using? Which webserver are you using (Apache/IIS)?

REgards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
CadEx
Regular
Posts: 12
Joined: Fri Oct 26, 2007 9:57 pm

Post by CadEx »

rulersatwork.com/dday
1.2
mySQL 4.1.20
Apache
PHP 5.2.2
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Can you please tell execute this SQL query in phpMYAdmin and tell me your result(s):

Code: Select all

SELECT * FROM serendipity_config WHERE name LIKE '%refer%'
and

Code: Select all

SELECT * FROM serendipity_referrers
and

Code: Select all

SHOW FIELDS FROM serendipity_referrers
Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
CadEx
Regular
Posts: 12
Joined: Fri Oct 26, 2007 9:57 pm

Post by CadEx »

1.

Code: Select all

name 	value 	authorid
trackReferrer 	true 	0
blockReferer 	  	0
@serendipity_topreferrers_plugin:59c6bc4bb467c5dda09c979b19289e17/limit 	3 	0
@serendipity_topreferrers_plugin:59c6bc4bb467c5dda09c979b19289e17/use_links 	false 	0
@serendipity_topreferrers_plugin:59c6bc4bb467c5dda09c979b19289e17/interval 	7 	0

2.
empty.


3.

Code: Select all

Field 	Type 	Null 	Key 	Default 	Extra
entry_id 	int(11) 	  	PRI 	0 	 
day 	date 	  	PRI 	0000-00-00 	 
count 	int(11) 	  	  	0 	 
scheme 	varchar(5) 	YES 	  	NULL 	 
host 	varchar(128) 	  	PRI 	  	 
port 	varchar(5) 	YES 	  	NULL 	 
path 	varchar(255) 	YES 	  	NULL 	 
query 	varchar(255) 	YES 	  	NULL 	 
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

One thought: Can you check your serendipity_suppress DB table?

Referrers are only tracked if people come from another page at least 2 times. Single referrers are not tracked and put into the database.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
CadEx
Regular
Posts: 12
Joined: Fri Oct 26, 2007 9:57 pm

Post by CadEx »

I don't know exactly, how the serendipity_suppress table is working, but for example golem.de is in it 4 times, and even with the same path.

But what does this have to do with suppression? I did not specify referrers to be suppressed in the configuration.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Post by garvinhicking »

Hi!

Suppression cannot be configured, it happens automatically. Can you show how your suppress table looks like ("SELECT * FROM serendipity_suppress").

It seems because of some reason you might have too little entries there. If onle one person per day comes from golem, s9y does not put that referrer into your real database table, because it thinks of it as spam referrers.

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply