-
Mysql error:
Aug 11 10:01:51 [317] /studio/launcher.php Database query error
Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
Query: SELECT `p`.`object` FROM `sys_objects_page` AS `p` INNER JOIN `sys_seo_uri_rewrites` AS `r` ON (`p`.`uri` = `r`.`uri_orig`) WHERE `r`.`uri_rewrite` = :uri
Account ID: 1
Aug 11 10:01:56 [317] /studio/dashboard.php Database query error
Error: Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,IMPLICIT) for operation '='
Query: SELECT `p`.`object` FROM `sys_objects_page` AS `p` INNER JOIN `sys_seo_uri_rewrites` AS `r` ON (`p`.`uri` = `r`.`uri_orig`) WHERE `r`.`uri_rewrite` = :uri
Account ID: 1
@LeonidS There is nothing in the sys_seo_uri_rewrites table
-
Hello @Genesis !
Yes, dear @PavelS is right - you need to change the collation from one to another. For the mentioned tables it would be like:
alter table Database name.`sys_seo_uri_rewrites` CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
-