Support » Plugin: Koko Analytics » Not all Referrers shown since v1.0.3

  • Resolved davinian

    (@davinian)


    Hi, I’ve been using Koko alongside Google Analytics Dashboard (GADWP) since version 1 of Koko and recently noticed Koko stopped recording Referrers (Google, Facebook, Twitter etc.) after version 1.0.3. It still records Bing but nothing else.

    I am currently running the latest version (1.0.7) of Koko, but did roll-back each version to 1.0.3 where I discovered the Referrers started to be counted/shown again.

    I am not sure if this is an issue with my server setup or if something (major) changed in version 1.0.4 of Koko, but thought I’d open a ticket to see if anyone has any suggestions/comments?

    I’m running WordPress Multisite, Koko is activated on single sites not Network. Server is using PHP 7.2 / Nginx and use Redis Object Cache (plugin).

    (sorry, should have said Pages/Post Types still appear to be counted by the visits from ALL Referrers since v1.0.4)

    Let me know if you have any questions.

    Regards,
    David

    • This topic was modified 2 years, 3 months ago by davinian.
    • This topic was modified 2 years, 3 months ago by davinian.
Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Author Danny van Kooten

    (@dvankooten)

    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.

    Thread Starter davinian

    (@davinian)

    @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
    
    Plugin Author Danny van Kooten

    (@dvankooten)

    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
    
    Thread Starter davinian

    (@davinian)

    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'

    Plugin Author Danny van Kooten

    (@dvankooten)

    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.

    Thread Starter davinian

    (@davinian)

    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

    Plugin Author Danny van Kooten

    (@dvankooten)

    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.

    Thread Starter davinian

    (@davinian)

    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

    Plugin Author Danny van Kooten

    (@dvankooten)

    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!

    Thread Starter davinian

    (@davinian)

    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!

    Thread Starter davinian

    (@davinian)

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

    Thanks again for a great plugin.

    Plugin Author Danny van Kooten

    (@dvankooten)

    Hey @davinian,

    Awesome, I’m glad to hear it!!

Viewing 12 replies - 1 through 12 (of 12 total)
  • The topic ‘Not all Referrers shown since v1.0.3’ is closed to new replies.