Unusual Problem

[theengineer]

Hi , Ive installed a Oscmax a few times without any problems but just recently ,after a fresh install upon trying to login to the admin side i get this weird error :
1267 - Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'

select admin_files_id from admin_files where FIND_IN_SET( '1', admin_groups_id) and admin_files_is_boxes = '1' and admin_files_name = 'catalog.php'

I usulaly just create the database within plesk and whne creating db there isnt much i can do with regard to settings.Any help on this i would deeply appreciated.thanks again.

[theengineer]

Ok After Alot of searching and pulling my hair out i found a soloution on another forum (just by luck lol)

Oh Please note do this at youre own risk and back up Youre database.php

Find

PHP Code:

if ($$link) mysql_select_db($database); 


in admin/includes/functions/database.php, line 21

Replace with :

PHP Code:

if ($$link){
     mysql_select_db($database);
     mysql_query("SET NAMES 'utf8'", $$link);
} 


Fingers crossed this should work as it worked for me.