Topic: Cannot register user - collation error

PunBB 1.2.12 / Linux server / MySQL 4.1.10a-log / PHP 4.3.9

I get this error when trying to register a user:


Error: Unable to fetch user info.

Illegal mix of collations (ascii_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '=' (Errno: 1267)


I do not have access to the servers.

I tried setting 'lang_encoding' to utf-8, but that did not help. I left it so and then added '$db->query("SET NAMES 'UTF8'");' at end of include/dblayer/common_db.php and an ini_set to config.php to make utf8 default character set. But these didn't help either.

Finally, I reverted all those changes except for the lang_encoding. Then I altered the character-set and collation of the PunBB database to ascii and ascii_general_ci (and also of punbb_users table). But this also did not help.

Please help.

Re: Cannot register user - collation error

Changing database collation to utf-8_general_ci solved this issue. It was ascii_general_ci before.