Not all Referrers shown since v1.0.3

Hey David,

Thanks for the helpful details, much appreciated!

Would it be possible for you to show me the tables in your database by any chance? I’m specifically interested in the table schema for the koko_analytics_referrer_urls and koko_analytics_referrer_stats tables.

Here’s the SQL needed to show that:

DESCRIBE wp_koko_analytics_referrer_stats;
DESCRIBE wp_koko_analytics_referrer_urls;

Let me know please.

• This reply was modified 4 years, 9 months ago by Danny van Kooten.

@dvankooten thanks for coming back.

Here’re the results – as this is a WP Network, there are other site tables, but the default site is just wp_koko_etc…

I also checked the other sites (total 3 sites) only 2 use Koko and wp_2_koko_etc… show exact same results for the query.

Let me know if you need anything else.

DESCRIBE wp_koko_analytics_referrer_stats;
Field		Type			Null	Key	Default	Extra
date		date			NO	PRI	NULL	
id		mediumint(8) unsigned	NO	PRI	NULL
visitors	mediumint(8) unsigned	NO		NULL
pageviews	mediumint(8) unsigned	NO		NULL

DESCRIBE wp_koko_analytics_referrer_urls;
id		mediumint(8) unsigned	NO	PRI	NULL
url		varchar(255)		NO	UNI	NULL

Hey @davinian,

Thank you. The issue is that, somehow, your wp_koko_analytics_referrer_urls table is missing an AUTO_INCREMENT specifier for its id column. This is due to a temporary bug that lived in an earlier version of the plugin and I attempted to fix retroactively here, but somehow that did not the trick for you.

Can you please run the below SQL command and then re-run the command to show your table schema? Does the “Extra” column now contain the “auto_increment” statement?

ALTER TABLE wp_koko_analytics_referrer_urls MODIFY id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT

Thanks @dvankooten

Tried to run the SQL and get following error – have also tried to manually change to AUTO_INCREMENT but get same error. Any thoughts?

ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'

Hey @davinian,

Awesome – that error message explains it all. Please allow me some time to replicate this and come up with a proper fix for you.

Hi @dvankooten just a thought (quick fix), would deactivate/removing the plugin also delete the db tables, and then re-install? Or would I need to manually delete the tables?

As I mention, I am still using Google Analytics at the moment so historical data is not an issue.

Regards,
David

Hey @davinian,

If you update to version 1.0.8 (which I just released) then this issue should resolve itself. Let me know if it doesn’t please.

Hi @dvankooten, I’ve updated and it looks like it is recording/showing “new” referrers like Google, Twitter and Facebook, but doesn’t seem to show Bing.com any more, or show the historical referral data ~ any thoughts?

Regards, David

Hi David,

Most likely the data your were seeing before was incorrect, so traffic coming from Google.com would be accounted to Bing.com, so I would take what you saw before with a grain of salt. Going forward things should be collected correctly again!

Hi @dvankooten, I have run a number of tests from a separate device and looks like Bing is not being counted/shown? Everything else seems ok.

Regards,
David

p.s. no longer using the Google Analytics plugin after the recent update and permissions change – I will be recommending Koko to all my clients going forward!

@dvankooten it’s recording Bing now so think everything is working ??

Thanks again for a great plugin.

Hey @davinian,

Awesome, I’m glad to hear it!!