No Tracking since 1.8.3

Support & Bugs
1

Hi there

I noticed that Piwik doesn’t track anymore since 1.8.3 - I can’t figure out why. Piwik page is:

http://stats.simplylinux.ch/

And for the time being I did also deactivate the DNT plugin - just to be sure.

2

Edit /piwik.php enable debugging, set to true

then go to: http://stats.simplylinux.ch/piwik.php?action_name=Linux%20für%20alle&idsite=1&rec=1&r=670624&h=13&m=28&s=15&url=http%3A%2F%2Fwww.simplylinux.ch%2F&urlref=http%3A%2F%2Fstats.simplylinux.ch%2Findex.php%3Fmodule%3DMultiSites%26action%3Dindex%26idSite%3D1%26period%3Dday%26date%3Dyesterday

do you see an error ? send me the output thanks

3

Yes, there is:


Debug enabled - Input parameters: <br/>array ( 'action_name' => 'Linux für alle', 'idsite' => '1', 'rec' => '1', 'r' => '670624', 'h' => '13', 'm' => '28', 's' => '15', 'url' => 'http://www.simplylinux.ch/', 'urlref' => 'http://stats.simplylinux.ch/index.php?module=MultiSites&action=index&idSite=1&period=day&date=yesterday', )
Loading plugins: { Provider,Goals }
Current datetime: 2012-09-08 06:36:19
Action is a Page URL, Action name = Linux für alle, Action URL = http://www.simplylinux.ch/
COOKIE _pk_uid, rows count: 0, cookie size = 0 bytes array ( )
Visitor doesn't have the piwik cookie...
The visitor was not matched with an existing visitor...
Visitor detected, but last action was more than 30 minutes ago...
New Visit (IP = 84.226.154.24)
array (
  'idsite' => 1,
  'visitor_localtime' => '13:28:15',
  'idvisitor' => '8e7991fa4255ec31',
  'visitor_returning' => 0,
  'visitor_count_visits' => 1,
  'visitor_days_since_last' => 0,
  'visitor_days_since_order' => 0,
  'visitor_days_since_first' => 0,
  'visit_first_action_time' => '2012-09-08 06:36:19',
  'visit_last_action_time' => '2012-09-08 06:36:19',
  'visit_entry_idaction_url' => 774,
  'visit_entry_idaction_name' => 4387,
  'visit_exit_idaction_url' => 774,
  'visit_exit_idaction_name' => 4387,
  'visit_total_actions' => 1,
  'visit_total_time' => '0',
  'visit_goal_converted' => 0,
  'visit_goal_buyer' => 0,
  'referer_type' => 3,
  'referer_name' => 'stats.simplylinux.ch',
  'referer_url' => 'http://stats.simplylinux.ch/index.php?module=MultiSites&action=index&idSite=1&period=day&date=yesterday',
  'referer_keyword' => '',
  'config_id' => 'ad3667beeb41c73f',
  'config_os' => 'LIN',
  'config_browser_name' => 'CH',
  'config_browser_version' => '22.0',
  'config_resolution' => 'unknown',
  'config_pdf' => 0,
  'config_flash' => 0,
  'config_java' => 0,
  'config_director' => 0,
  'config_quicktime' => 0,
  'config_realplayer' => 0,
  'config_windowsmedia' => 0,
  'config_gears' => 0,
  'config_silverlight' => 0,
  'config_cookie' => 0,
  'location_ip' => 'T��',
  'location_browser_lang' => 'en-us,en',
  'location_country' => 'ch',
  'location_provider' => 'adslplus.ch',
)
<b>Error query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '757636' for key 'PRIMARY' In query: INSERT INTO piwik_log_visit (idsite, visitor_localtime, idvisitor, visitor_returning, visitor_count_visits, visitor_days_since_last, visitor_days_since_order, visitor_days_since_first, visit_first_action_time, visit_last_action_time, visit_entry_idaction_url, visit_entry_idaction_name, visit_exit_idaction_url, visit_exit_idaction_name, visit_total_actions, visit_total_time, visit_goal_converted, visit_goal_buyer, referer_type, referer_name, referer_url, referer_keyword, config_id, config_os, config_browser_name, config_browser_version, config_resolution, config_pdf, config_flash, config_java, config_director, config_quicktime, config_realplayer, config_windowsmedia, config_gears, config_silverlight, config_cookie, location_ip, location_browser_lang, location_country, location_provider, location_continent) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array ( 0 => 1, 1 => '13:28:15', 2 => '�y��BU�1', 3 => 0, 4 => 1, 5 => 0, 6 => 0, 7 => 0, 8 => '2012-09-08 06:36:19', 9 => '2012-09-08 06:36:19', 10 => 774, 11 => 4387, 12 => 774, 13 => 4387, 14 => 1, 15 => '0', 16 => 0, 17 => 0, 18 => 3, 19 => 'stats.simplylinux.ch', 20 => 'http://stats.simplylinux.ch/index.php?module=MultiSites&action=index&idSite=1&period=day&date=yesterday', 21 => false, 22 => '�6g��A�?', 23 => 'LIN', 24 => 'CH', 25 => '22.0', 26 => 'unknown', 27 => 0, 28 => 0, 29 => 0, 30 => 0, 31 => 0, 32 => 0, 33 => 0, 34 => 0, 35 => 0, 36 => 0, 37 => 'T��', 38 => 'en-us,en', 39 => 'ch', 40 => 'adslplus.ch', 41 => 'eur', )</b>

But it doesn’t make much sense. Cardinality is at 757635 and there is no 757636 entry yet.

4

Indeed first time I see this error.

Can you try REPAIR the table in phpmyadmin.
Otherwise check there is no row with id = 0 in this table ?
Finally if this doesn’t work, try to export and re-import full DB ?

see more tips on: How to fix: MySQL Duplicate entry for key PRIMARY on Auto_Increment - Software Projects Inc.

5

Repair did do something in PMA:


Table	Op	Msg_type	Msg_text
c1_stats.piwik_log_visit	repair	warning	Number of rows changed from 757635 to 757637
c1_stats.piwik_log_visit	repair	status	OK

I’ll see how it goes

6

Ok, reparing the table fixed the problem.