Maps Database error

I keep getting emails with this Database error from maps:

SELECT `m`.`country`, `m`.`lat`, `m`.`lng`, COUNT(`p`.`ID`) AS `num`
            FROM `bx_map_countries` AS `m` 
            INNER JOIN `Profiles` AS `p` ON (`p`.`Country` = `m`.`country` AND `p`.`Status` = 'Active') 
            INNER JOIN `bx_map_profiles` AS `pm` ON (`pm`.`id` = `p`.`ID` AND `pm`.`failed` = 0 AND `pm`.`allow_view_location_to` = '3')
            WHERE `m`.`failed` = 0  AND `m`.`lat` < 79.0384374249 AND `m`.`lat` > -38.8225909762  AND `m`.`lng` < 180 AND `m`.`lng` > -180  
            GROUP BY `p`.`Country`
            LIMIT 250

Mysql error: Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Could someone possible give me the steps to fix this in the php.myadmin

Regards

Toni

I have the same problem but for my payment mod

I unistall the payment mod and install back but still giving me database error

Hello what version of dolphin do you use ?

I am using Dolphin version 7.0.3

I have read in other forum posts this could be related to the: utf8_unicode and utf8_general

Regards

Toni

Another question, did you make fresh install or used update pack ?

This was a totally fresh install.

Regards

Toni

Yea I did Fresh Install too

In most cases this is not happening and we can not reproduce it, however here is possible fix:

http://www.boonex.com/trac/dolphin/changeset/14515

This fix should work if you make clean install after applying this changeset.

ticket is also created: http://www.boonex.com/trac/dolphin/ticket/2219

Hi Alex

Thank you for your support and reply. However, I have absolutely no idea on what I'm supposed to do! Please kindly forward the steps/process so I may fix this issue

Regards

Toni

Please try to perform clean install, but before installing apply this changeset:

http://www.boonex.com/trac/dolphin/changeset/14515

it will show if this possible fix helps

AlexT

Thank's I got working

I have to fix my database to get it done

@ Tony if you need help send me a PM with you msn : adress so we can fix this VIA Teamviewer

Thanks to UFO360 it has finally been solved. He gave me a lot of his time and went through my database step by step. Basically I had to find ... collate utf8_unicode_ci ... and remove it in my database Profiles which was where the issue was coming from.

He then told me to change: ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;

to this

) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

I then re imported Profiles into my Databsae and it solved the problem. UFO360, there is now way I could have done this without you and I have now learned more about editing the database, etc Thanks once again for all the time you gave me. This is what's making the Dolphin Forum Community strong and it's great to be a member here.

Regards

Toni

Thank's a lot  >> Tonil

I'm doing the same thing they did to me helping other is fun

Hello  

I get the same  error  on dolphine 7.0.4  after a  new instalation