Convert problèm illegal mix

[benkrim31]

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

[ThorstenE]

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?

[benkrim31]

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

[ThorstenE]

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

[benkrim31]

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

If i send you ftp log  can you help me?

thanks

[smiths]

Nice information for us thanks for sharing.