Error updating to 4.3.0-rc1 (Mysqli prepare error: Unknown column 'hash' in 'field list')

Support & Bugs
1

I tried to run the automatic update to 4.3.0-rc1 today, but got the following error

Mysqli prepare error: Unknown column ‘hash’ in ‘field list’

I’m not sure how to revert the change or move forward. Any help would be greatly appreciated.

2

First question - why are you updating to a RC version, if you don’t know how to revert to the older version? RC is a release candidate, not necessarily a stable version.

Reverting is only possible (the simple way) via backup restore. More complicated is the manual way (reverting schema changes, restore all “old” files, edit options table to reflect the former version).

But the chances are better to make this work than reverting: Have a look at the update schema changes here: https://github.com/matomo-org/matomo/blob/4.x-dev/core/Updates/4.3.0-b3.php and https://github.com/matomo-org/matomo/blob/4.x-dev/core/Updates/4.3.0-b4.php
You can see, that a column was added to the segment table and filled with an md5 hash. You can now try to redo those changes. Search for the matomo version number row in the “options” table and set it back to the last working version of matomo. Then call the update from the console: https://matomo.org/docs/update/#database-upgrade-for-high-traffic-matomo-servers
That will try to do the schema changes again.

1 Like
3

Thanks, that helped. I was able to run the cli update command and everything worked out.