Print Page - Database Issue

Title: Database Issue
Post by: spoony321 on November 11, 2015, 03:58:11 AM

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

Title: Re: Database Issue
Post by: Skhilled on November 11, 2015, 07:42:34 AM

Hi spoony321 and welcome to Docskillz! ;D

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 (http://www.docskillz.com/docs/index.php?topic=334.0)

Title: Re: Database Issue
Post by: spoony321 on November 11, 2015, 12:32:50 PM

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

Title: Re: Database Issue
Post by: Chen Zhen on November 11, 2015, 05:25:12 PM

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.

Title: Re: Database Issue
Post by: spoony321 on November 11, 2015, 10:32:47 PM

Thanks guys the tool done the job.

Title: Re: Database Issue
Post by: Skhilled on November 12, 2015, 08:30:30 AM

Glad you've got it sorted. :D

Docskillz

The Good Stuff => SMF Arcade Support => Topic started by: spoony321 on November 11, 2015, 03:58:11 AM