Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

'config_browser_name' cannot be null #618

Closed
anonymous-matomo-user opened this issue Mar 20, 2009 · 4 comments
Closed

'config_browser_name' cannot be null #618

anonymous-matomo-user opened this issue Mar 20, 2009 · 4 comments
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.

Comments

@anonymous-matomo-user
Copy link

```
PHP Fatal error: Uncaught exception ‘Exception’ with message ‘Error query: SQLSTATE23000:
Integrity constraint violation: 1048 Column ’config_browser_name’ cannot be null’ in /path/to/piwik/core/Tracker/Db.php:193
Stack trace:

  1. /path/to/piwik/core/Tracker/Visit.php(240): Piwik_Tracker_Db→query(‘INSERT INTO pwk…’, Array)
  2. /path/to/piwik/core/Tracker/Visit.php(106): Piwik_Tracker_Visit→handleNewVisit(‘1’, false)
  3. /path/to/piwik/core/Tracker.php(60): Piwik_Tracker_Visit→handle()
  4. /path/to/piwik/piwik.php(52): Piwik_Tracker→main()
  5. {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
Copy link
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-matomo-user
Copy link
Author

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-matomo-user
Copy link
Author

Sorry, forgot to mention that the piwik version is 0.2.32

@mattab
Copy link
Member

mattab commented Mar 21, 2009

already fixed. will be in next release

This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Projects
None yet
Development

No branches or pull requests

3 participants