Database Issue

[spoony321]

Hi All,

SMF 2.0.11
SMF Arcade 2.5 RC3

Used the purge tool to remove previous arcade and db.  I get the following error:

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation 'ifnull'
File: /home/********/public_html/forum/Sources/ArcadeList.php
Line: 178

Appreciate any help

[Skhilled]

Hi spoony321 and welcome to Docskillz! 

Did you happen to change hosting recently or make a change to you database? Different hosting use various collations. Your arcade database is either utf8_unicode or utf8_general and your hosting uses the other. You can go into phpmyadmin or whatever your hosting uses and see what it is.

But to change whatever the arcade db currently to whatever your server uses I suggest you use this:

Changing Database Collations

[spoony321]

Hi Skhilled i am on my on VPS with total control, so the answer would be no.  will take a look at your link

[Chen Zhen]

Try one of the versions of the collation tool from this link:
http://web-develop.ca/index.php?topic=32.0

After using the tool, uninstall it then delete it.

[spoony321]

Thanks guys the tool done the job.

[Skhilled]

Glad you've got it sorted.