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

No default value for location_browser_lang in piwik_log_visit #11438

Closed
jurgenhaas opened this issue Mar 2, 2017 · 5 comments
Closed

No default value for location_browser_lang in piwik_log_visit #11438

jurgenhaas opened this issue Mar 2, 2017 · 5 comments
Labels
duplicate For issues that already existed in our issue tracker and were reported previously.

Comments

@jurgenhaas
Copy link

I'm running Piwik 3.0.1 (upgraded to 3.0.2 today) and just realized that my upgrade to MySQL 5.7 a couple of days ago started to prevent Piwik from logging visits. The errors are like this:

[Thu Mar 02 09:08:05.913094 2017] [:error] [pid 6312] [client 46.223.59.40:51104] Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1364 Field 'location_browser_lang' doesn't have a default value In query: INSERT INTO piwik_log_visit (idvisitor, config_id, location_ip, idsite, visit_first_action_time, visit_goal_buyer, visit_goal_converted, visit_last_action_time, visitor_days_since_first, visitor_days_since_order, visitor_returning, visitor_count_visits, visit_entry_idaction_name, visit_entry_idaction_url, visit_exit_idaction_name, visit_exit_idaction_url, visit_total_actions, visit_total_interactions, visit_total_searches, referer_keyword, referer_name, referer_type, referer_url, config_browser_engine, config_browser_name, config_browser_version, config_device_brand, config_device_model, config_device_type, config_os, config_os_version, visit_total_events, visitor_localtime, visitor_days_since_last, config_resolution, config_cookie, config_director, config_flash, config_gears, config_java, config_pdf, config_quicktime, config_realplayer, config_silverlight, config_windowsmedia, visit_total_time, location_country, location_provider) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) Parameters: array (   0 => 'X\xa7i\x17\xcf\x04\x8a"',   1 => '\x14?\x1fA\xfd\x890#',   2 => '.\xdf;(',   3 => 1,   4 => '2017-03-02 08:08:05',   5 => 0,   6 => 0,   7 => '2017-03-02 08:08:05',   8 => '7',   9 => 0,   10 => 1,   11 => 5,   12 => 8988,   13 => 192,   14 => 8988,   15 => 192,   16 => 1,   17 => 1,   18 => 0,   19 => NULL,   20 => NULL,   21 => 1,   22 => 'https://www.paragon-es.de/contact',   23 => 'WebKit',   24 => 'SF',   25 => '10.0',   26 => '',   27 => '',   28 => 0,   29 => 'MAC',   30 => '10.12',   31 => 0,   32 => '09:08:05',   33 => '0',   34 => '2560x1440',   35 => 1,   36 => 0,   37 => 0,   38 => 0,   39 => 1,   40 => 1,   41 => 0,   42 => 0,   43 => 0,   44 => 0,   45 => 0,   46 => 'de',   47 => 'kabel-badenwuerttemberg.de', ), referer: https://www.paragon-es.de/imprint

I saw a few old issues about that topic and all are closed and state that the bugs are fixed. So I wonder why they are still present here. Has Piwik missed a db upgrade at one point here? If so, what can I do to fix this?

@jurgenhaas
Copy link
Author

Any chance to get some help for this?

@jurgenhaas
Copy link
Author

I have now done ALTER TABLE piwik_log_visit MODIFY location_browser_lang varchar(20) null; and this seems to solve the problem. Still would be interested in the proper solution.

@tsteur
Copy link
Member

tsteur commented Mar 5, 2017

This is the correct fix. This update should have been executed in 3.0.0 update but by the looks it didn't. Did you maybe have the UserLanguage plugin disabled?

@jurgenhaas
Copy link
Author

Yes, UserLanguage is disabled. Well, it is now and I'm pretty sure it always has been.

@tsteur
Copy link
Member

tsteur commented Mar 6, 2017

This is related to #11221 and will add a note to cover this case there as well.

@tsteur tsteur closed this as completed Mar 6, 2017
@tsteur tsteur added the duplicate For issues that already existed in our issue tracker and were reported previously. label Mar 6, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
duplicate For issues that already existed in our issue tracker and were reported previously.
Projects
None yet
Development

No branches or pull requests

2 participants