Page 1 of 1

Mysql collation error when trying to update

Posted: Fri Nov 18, 2022 8:49 am
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:

Re: Mysql collation error when trying to update

Posted: Fri Nov 18, 2022 9:13 am
by admin
Hello!

Try to run update again plz

Re: Mysql collation error when trying to update

Posted: Fri Nov 18, 2022 9:25 am
by alexscj
All good now, thank you!

Re: Mysql collation error when trying to update

Posted: Fri Nov 18, 2022 11:37 am
by admin
Thank you)