Gallery Errors

[philcross]

Ive installed SMF Gallery on 2.0 and get the following error when I click on the Gallery icon....

Databse Error

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'ifnull'
File: /home/xxxxxxxxx/public_html/xxxforum/Sources/Subs-MGallery.php
Line: 3370

Any ideas please anyone?

It is one of several mods installed this evening - all others seem OK.

[CapadY]

Did you check if there is also an UTF8 language package for the galery ?

[[SiNaN]]

You have to change the collation of gallery tables to utf-8 using phpMyAdmin.

For further support please use the support topic of the mod. You can reach it by clicking the "Support and comments for this mod" button on the page you downloaded the mod.

[Sarge]

It seems that the default database collation is utf8_unicode_ci, but the SMF tables are in utf8_general_ci. When the SMF Gallery mod was installed, the default database collation was used for the mod tables.

utf8_unicode_ci has more extensive sorting rules than utf8_general_ci, but both collations are in the utf8 character set, so you should be able to use either one without problems, at least in SMF.

To make the error go away, change the collation of the gallery tables to utf8_general_ci using phpMyAdmin, as Blue Dream suggested.

If you plan to install more mods, you might want to change the default database collation to utf8_general_ci as well.