Synchronise verify error

Home

Forum Synchronise verify error

	Welcome, Guest. Please login or register. Did you miss your activation email? October 13, 2008, 09:57:00 PM

Joomla Forum

Joomla Hacks

Joomla-SMF Forum Support

Joomla-SMF 1.0.x (Moderators: -Wolverine, kai920)

Synchronise verify error

0 Members and 1 Guest are viewing this topic.

« previous next »

Pages: [1]

Author

Topic: Synchronise verify error (Read 1063 times)

Sam

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 6

Synchronise verify error

« on: April 22, 2008, 03:50:57 PM »

Hi. I've gone through everything I need to but keep getting this error on verifying..
Failed:Error verifying user synchronization.: db_error:Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation \\\'=\\\' SQL=SELECT count(*) FROM smf_members LEFT JOIN jos_users ON jos_users.username=smf_members.memberName WHERE jos_users.username IS NULL1
I'm new to this so it's probably somthing blindingly obvious that I've not seen
Joomla vers. 1.0.12
smf vers. 1.1.3
Ant help is much apreciated! Grin


	Logged

locutus

Joomla Expert

Karma: +26/-46
Offline

Offline

Posts: 233

Re: Synchronise verify error

« Reply #1 on: April 23, 2008, 02:17:56 AM »

Like it said, there is a mix of collations. You can convert joomla 1.0.x to UTF8. I hope you are helped with this link: http://help.joomla.org/component/option,com_easyfaq/task,view/id,94/Itemid,268/


	Logged

Need JSMF help? Visit http://locutusweb.asw15.org/index.php?board=3.0

Sam

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 6

Re: Synchronise verify error

« Reply #2 on: April 23, 2008, 03:07:59 AM »

Thanks very much for the reply! I'll have a crack at it later and let you know if it floats Grin


	Logged

Sam

Joomla Newbie

Karma: +0/-0
Offline

Offline

Posts: 6

Re: Synchronise verify error

« Reply #3 on: April 23, 2008, 09:32:36 AM »

Hi again. I followed the instructions in the link and on checking the mysql version it reads 4.1.11. In the instructions it states.. use MySQL version 4.1.2 or newer (older versions don't support utf-8).
Is there any other way around the problem? Thanks Grin


« Last Edit: April 23, 2008, 09:50:18 AM by Sam »	Logged

locutus

Joomla Expert

Karma: +26/-46
Offline

Offline

Posts: 233

Re: Synchronise verify error

« Reply #4 on: April 24, 2008, 06:07:43 AM »

You say, you have mysql 4.1.11. Then your version is newer than 4.1.2. So there is no problem to follow the howto.

BTW if your server is mysql 4.1.1 and lower (older), you couldn't have utf8 tables in the first place.

Please let us know if it works out.