A very useful module, but utf-8 names for sections are unusable as the default collation used by the module is non-utf8. Here's the SQL error that props up:

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' query: SELECT sname FROM summary_section WHERE sname = .....

Comments

info@zrix.com’s picture

info@zrix.com commented

This error is usually an outcome of when MySQL CHARACTER SET is not set UTF-8 Unicode (utf8). To give a more precise and exact solution, please tell me the MySQL database version you are using as well as your hosting provider name.

Usually the problem can be resolved by running this command in MySQL.

Please take a backup of your database before running the commands below:

Alter database default CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE access CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

info@zrix.com’s picture

info@zrix.com commented
Status: Active » Postponed (maintainer needs more info)

This error is usually an outcome of when MySQL CHARACTER SET is not set UTF-8 Unicode (utf8). To give a more precise and exact solution, please tell me the MySQL database version you are using as well as your hosting provider name.

Usually the problem can be resolved by running this command in MySQL.

Please take a backup of your database before running the commands below:

Alter database default CHARACTER SET utf8 COLLATE utf8_general_ci;

ALTER TABLE access CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

info@zrix.com’s picture

info@zrix.com commented
Status: Postponed (maintainer needs more info) » Closed (fixed)