Join GitHub today
GitHub is home to over 31 million developers working together to host and review code, manage projects, and build software together.Sign up
DB field piwik_log_visit.location_provider too small #9564
Default the field piwik_log_visit.location_provider is 100 chars. But that is to small. I have already data that is 153 chars long. So I manually changed the length to about 200 chars.
ex of an location entry:
So I think this field should be updated to a length of 200 chars.
This is found in version 2.15.0
We should increase it, however we cannot do this in Piwik 2 as the update could take too long for some database. I'll move it to Piwik 3.0 for now @mattab feel free to change or close if you think it is not needed.
Not sure why there is a PHP error as we trim the length of a provider to max 100 characters here: https://github.com/piwik/piwik/blob/2.16.0-b3/plugins/Provider/Columns/Provider.php#L77
And yes, changing this will take a long time with a full table. But I think this could be put with the other issues I had with to small database fields. Like the int vs bigint issue with auto increment fields. And I had also another issue with a small int field.
referenced this issue
Jan 19, 2016
Yes, it must be a character set problem since both use same PHP code. We should possibly switch to
We can provide this update with the other issues you created #9565 and #3288 but we committed to not have any such db updates in Piwik 2.X. Piwik 2.16.0 should be the last minor release of Piwik and then only some patch releases will follow see http://piwik.org/blog/2016/01/announcing-long-term-support-in-piwik-2-the-analytics-platform-for-your-mission-critical-projects/ so we can only include it in Piwik 3