location_geoip_continent
doesn't have a default value
#15136
Labels
answered
For when a question was asked and we referred to forum or answered it.
I currently have trouble with the following error
General error: 1364 Field 'location_geoip_continent' doesn't have a default value
.I tried to install Piwik on a fresh new server. Matomo on the old server was already udapted to the last version. I downloaded Matomo from the matomo.org on the new server and push a backup of the database to my new server.
Everything was fine except that the new serve refuse to track new events.
After looking closely I notice that
location_geoip_continent
is not a column that is used anymore. The new ones are namedlocation_*
and notlocation_geoip_*
.I fixed the issue by running this:
Maybe it's possible to remove the columns as well...
I hope this issue can help someone...
The text was updated successfully, but these errors were encountered: