Print Page - Convert problèm illegal mix

Title: Convert problèm illegal mix
Post by: benkrim31 on January 07, 2011, 10:12:19 PM

Hello all , Sorry i'am french if my english is bad sorry.

I have download SMF , i'am actually in vbulletin and i want convert my vbulletin forum to SMF.

I download the converter file and i have this problèm when i load the convert file :

Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics... Unsuccessful!
This query:

SELECT
t.threadid AS id_topic, t.forumid AS id_board, t.sticky AS is_sticky,
t.pollid AS id_poll, t.views AS num_views, t.postuserid AS id_member_started,
CASE WHEN (ISNULL(ul.userid) OR TRIM(ul.userid) = '') THEN 0 ELSE ul.userid END AS id_member_updated,
t.replycount AS num_replies,
IF(t.open, 0, 1) AS locked, MIN(p.postid) AS id_first_msg,
MAX(p.postid) AS id_last_msg
FROM `poker__mania_biz_forum`.thread AS t
INNER JOIN `poker__mania_biz_forum`.post AS p ON (p.threadid = t.threadid)
LEFT JOIN `poker__mania_biz_forum`.user AS ul ON (ul.username = t.lastposter)
GROUP BY t.threadid
HAVING id_first_msg != 0
AND id_last_msg != 0
LIMIT 0, 500;

Caused the error:

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

Please can you help me thank you very much

Title: Re: Convert problèm illegal mix
Post by: ThorstenE on January 08, 2011, 02:50:17 AM

The converter asks for SMF charset at the first page (Set SMF's default character set to:).. Try it with "UTF-8" and if the error still appears try it with "ISO-8859-1".

While installing SMF you can choose SMFs default charset. I suspect you choosed UTF-8?

Title: Re: Convert problèm illegal mix
Post by: benkrim31 on January 08, 2011, 12:01:43 PM

Hello thanks for you reply , yes i choose UTF8 and i try with iso i've got the same problem :( .

I have vbulletin 4.0.8 and i want realy convert on SMF

Title: Re: Convert problèm illegal mix
Post by: ThorstenE on January 08, 2011, 02:06:15 PM

WIthout looking at the database I have no clue what's going wrong... I suspect you have different collations in vBulletin (tables thread and post).
Maybe this can fix the issue:
http://www.simplemachines.org/community/index.php?topic=272956.msg1791154#msg1791154

Title: Re: Convert problèm illegal mix
Post by: benkrim31 on January 08, 2011, 05:27:17 PM

hi thanks for your help , but dont work for me . :(

If i send you ftp log can you help me?

thanks

Title: Re: Convert problèm illegal mix
Post by: smiths on August 17, 2011, 02:04:53 AM

Nice information for us thanks for sharing.

Simple Machines Community Forum

SMF Support => Converting to SMF => vBulletin => Topic started by: benkrim31 on January 07, 2011, 10:12:19 PM