@anonymous-piwik-user opened this Issue on March 20th 2009
PHP Fatal error:  Uncaught exception 'Exception' with message 'Error query: SQLSTATE[23000]: 
Integrity constraint violation: 1048 Column 'config_browser_name' cannot be null' in /path/to/piwik/core/Tracker/Db.php:193
Stack trace:
<a href='/0'>#0</a> /path/to/piwik/core/Tracker/Visit.php(240): Piwik_Tracker_Db->query('INSERT INTO pwk...', Array)
<a href='/1'>#1</a> /path/to/piwik/core/Tracker/Visit.php(106): Piwik_Tracker_Visit->handleNewVisit('1', false)
<a href='/2'>#2</a> /path/to/piwik/core/Tracker.php(60): Piwik_Tracker_Visit->handle()
<a href='/3'>#3</a> /path/to/piwik/piwik.php(52): Piwik_Tracker->main()
<a href='/4'>#4</a> {main}
  thrown in /path/to/piwik/core/Tracker/Db.php on line 193

Can't tell much more as the insert failed. Changed pwk_log_visit so the field can be null to fix this for now.

@robocoder commented on March 20th 2009 Contributor

What Piwik version?
Can you find a potential match (or range of matches) in your web server log (eg apache's access.log) around the same time?

@anonymous-piwik-user commented on March 20th 2009

I did a grep on all access_logs in question and broke it down to these unique UA's that have been recorded within the same minute:

Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; GTB5; .NET CLR 1.1.4322; OfficeLiveConnector.1.3; OfficeLivePatch.0.0; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
SimplePie/1.1 (Feed Parser; http://simplepie.org; Allow like Gecko) Build/2.00801022216E+13
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)
Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.0.7) Gecko/2009021910 Firefox/3.0.7
Mozilla/5.0 (compatible; Google Desktop)
Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)
Wget/1.10.1

If I should guess I would blame it on wget.

@anonymous-piwik-user commented on March 20th 2009

Sorry, forgot to mention that the piwik version is 0.2.32

@mattab commented on March 21st 2009 Owner

already fixed. will be in next release

This Issue was closed on March 21st 2009
Powered by GitHub Issue Mirror