No update option in dashboard from una 12 to 13.
My UNA 12 doesn't have an update to 13 option in the dashboard. Is there a way to initiate the upgrade?
-
Hello change in developer mode to beta channel.
-
ok I did that, now I get an error 500 on the site and a mysql error in studio.
-
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
-
in database change everything to utf8mb4_unicode_ci
-
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;
-
So every table should be "utf8mb4_unicode_ci" ?
-
I changed everything in the database to utf8mb4_unicode_ci and it still says the same thing.
-
Ok I updated everything to 13 and now pages are giving an error 500. For example view video pages, messenger page, etc.
-
Edit: I needed to update the apps. Pages work now. But the Messenger is still a blank page.
-
messenger works now
