Just loaded 2.6.0-rc1, using MySQL 4.1.3 on Fedora Core 2. I enabled the controluser features and get the errors below when loading the initial page. Some googling turns up some character set collation changes in MySQL that are probably responsible but I don't see what I need to do to fix this.
http://dev.mysql.com/doc/mysql/en/InnoDB_news-4.1.3.html http://dev.mysql.com/doc/mysql/en/News-4.1.2.html
Running mysqlcheck --all-databases says everything's ok. All tables seem to have locked to the latin1_swedish_ci collation.
SQL-query: DocumentationEdit
SELECT COMMENT FROM `pma_column_info` WHERE db_name = 'bugs' AND table_name = '' AND column_name = '(db_comment)'
MySQL said: Documentation #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
SQL-query: DocumentationEdit
SELECT COMMENT FROM `pma_column_info` WHERE db_name = 'bugs' AND table_name = '' AND column_name = '(db_comment)'
MySQL said: Documentation #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi Kenneth,
Kenneth Porter wrote:
Just loaded 2.6.0-rc1, using MySQL 4.1.3 on Fedora Core 2. I enabled the controluser features and get the errors below when loading the initial page. Some googling turns up some character set collation changes in MySQL that are probably responsible but I don't see what I need to do to fix this.
Please don't post this to the devel list. We have a users mailing list and a support tracker for requests like yours.
Regards,
- --
Alexander M. Turek rabus@users.sourceforge.net
_ __ __ _ _ _ _ __ | |__ _ __ | / |_ _ / \ __| |_ __ ___ (_)_ __ | '_ | '_ | '_ | |/| | | | | / _ \ / _` | '_ ` _ | | '_ \ | |_) | | | | |_) | | | | |_| |/ ___ \ (_| | | | | | | | | | | | .__/|_| |_| .__/|_| |_|__, /_/ ___,_|_| |_| |_|_|_| |_| |_| |_| |___/ http://www.phpmyadmin.net