Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 2.1.0
-
Fix Version/s: 2.1.0
-
Component/s: Database/Schema
-
Labels:
-
Sprint:Sprint 5 - Cumberland, Sprint 6 - Cumberland, Sprint 7 - Cumberland, Sprint 8 - Cumberland, Sprint 9 - Cumberland, Sprint 10 - Cumberland, Sprint 11 - Cumberland
Description
When following the Cumberland release notes (running the sql scripts) and then running upgrade-utf8.py the views in the content editor cause problems due to casting in the query.
mysql -uroot -p -h127.0.0.1 db-structure/global-tsacommon/tsacommon-spike.sql
mysql -uroot -p -h127.0.0.1 db-structure/content_editor_google.sql
mysql -uroot -p -h127.0.0.1 db-structure/content_repository.sql
mysql -uroot -p -h127.0.0.1 db-structure/global-tsacommon/tsacommon-root.sql
./upgrade-utf8.py
Error connecting (1267, "Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '<>'") (lastStatement=[show create table `content_editor_google`.`vKeywordUpdated`])
