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

Jump to bottom

INSERT statement into piwik_log_visit fails (stable version 2.16.0) #9922

Closed
netbrothers-tr opened this issue Mar 14, 2016 · 2 comments
Closed

INSERT statement into piwik_log_visit fails (stable version 2.16.0) #9922

netbrothers-tr opened this issue Mar 14, 2016 · 2 comments
Labels
answered For when a question was asked and we referred to forum or answered it.
Milestone
2.16.1

Comments

@netbrothers-tr
Copy link

After upgrading to the latest stable version (2.16.0) Piwik generates the following error in the Apache error log.

Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1364 Field 'config_resolution' 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_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, visit_total_time, location_city, location_country, location_latitude, location_longitude, location_region, location_provider) VALUES [...]

Shouldn't be NULL a valid value for the field config_resolution? It seems Piwik can't always determine the screen resolution. The according line in the code is here:
https://github.com/piwik/piwik/blob/2fe8faacdbde76121dfabca6088a300d6e8fae7d/core/Columns/Updater.php#L260

Seeking for confirmation or disproval by the community if this is a general problem or just ours. Thanks to all!
@tsteur
Copy link
Member

tsteur commented Mar 14, 2016

I presume this can happen if the Resolution plugin is disabled. By any chance, is it disabled?

Otherwise it should work as Resolution should always return a non-null value (a string)

@netbrothers-tr
Copy link
Author

Thanks for the hint! 👍 It stemmed from an incompatible UserSettings plugin that has been active still, i.e. our mistake. After uninstalling it, the regarding columns were gone. So the issue is obsolete.

@tsteur tsteur added the answered For when a question was asked and we referred to forum or answered it. label Mar 15, 2016
@tsteur tsteur added this to the 2.16.1 milestone Mar 15, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Milestone
2.16.1
Development

No branches or pull requests
2 participants
@tsteur @netbrothers-tr