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
piwik logs import sometimes fails with "Data too long for column" #11981
Comments
Thanks for the report, this indeed seems like something we should change soon (even if Windows Server 2003 should not be a commonly used OS). |
Ok. Just checked that. Actually the config_os_version should have a length of @cherouvim could you please check if the file linked above looks the same on your Piwik? |
Yes, they are exactly the same:
FYI I've upgraded from 1.12 to 3.0.4 by using the existing old database and a fresh files installation via the exact following commands:
|
@cherouvim could you please run this sql query to check what piwik has stored for this field: SELECT option_value FROM piwik_option WHERE option_name = 'version_log_visit.config_os_version'; |
|
That's weird. As it should have been updated to that only after the field was adjusted. Maybe that is a side effect as you updated from a very old version. |
Thanks. Used this query:
|
it seems this issue was caused by a "partial upgrade" so maybe we can close it as there is no real issue with columns too small? |
I've solved my problem by executing the custom query. Regarding whether this issue is reproducible and may affect other people (in the rare occasion that they'll upgrade from a really old piwik installation like I did) I think it does. Whether it is important to exactly pinpoint what may go wrong during the upgrade, is up to you. FYI I'd been using that old piwik installation without ever doing anything weird on it, such as altering code or executing any direct SQL. |
Closing as wontfix for now (although we may want to fix this issue in the future, IIRC some other opened issue is similar) |
I use piwik 3.0.4 with MySQL 5.7.19 and the following command to import logs:
Sometimes it fails with
Error when connecting to Piwik: HTTP Error 500: Internal Server Error
and on the apache error log I see:By doing
show create table piwik_log_visit
I can see that the length of columnconfig_os_version
is 10, so it chokes when it tries to import the textServer 2003
which is 11.The text was updated successfully, but these errors were encountered: