Mysql collation error when trying to update

Post Reply
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Mysql collation error when trying to update

Post by alexscj »

Hello, I'm trying to update from version 202201071114 to 202211180853 and getting a MySQL error:

Code: Select all

2022-11-18 03:17:04: Mysql error 1253: COLLATION 'utf8_bin' is not valid for CHARACTER SET 'utf8mb4' (ALTER TABLE `rot_gallery_info` CHANGE `source_url` `source_url` VARCHAR(512) CHARACTER SET utf8mb4 COLLATE utf8_bin NOT NULL)  (2.2612729072571, 0.00078988075256348)
Please advise :geek:
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql collation error when trying to update

Post by admin »

Hello!

Try to run update again plz
Don't forget to run script update
alexscj
Posts: 160
Joined: Mon Apr 01, 2013 3:04 pm

Re: Mysql collation error when trying to update

Post by alexscj »

All good now, thank you!
admin
Site Admin
Posts: 37202
Joined: Wed Sep 10, 2008 11:43 am

Re: Mysql collation error when trying to update

Post by admin »

Thank you)
Don't forget to run script update
Post Reply