Z phpBB na SMF - krok po kroku

[richcio]

Siema,

postanawiam pomóc znajomemu i zmienić mu forum z phpbb na smf w wersji 2.0

I mam kilka pytań:

• SMF wgrać do tego samego katalogu co PHPBB ? A co z plikami, podmieniać je czy co?
• Bazy użyć tej samej z której korzysta phpbb ?
• Wgrać konwenter na serwer .

I to wsyzstko ?

[trzycha]

Zainstaluj smf tam gdzie stał przemo (usuń pliki przema poza config.php). Baza może być ta sama bo później możesz przecież usunąć tabele przema albo zainstalować smf na nowej bazie.
Po wgraniu konwertera postępuj wg instrukcji.
Cieszcie się smf

[richcio]

Usunąłem pliki phpbb, wgrałem smf, zainstalowałem, odpaliłem conventer i już jest błąd podczas konwentorowania :

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:

    SELECT
    u.user_id AS id_member, SUBSTRING(u.username, 1, 80) AS member_name,
    SUBSTRING(u.username, 1, 255) AS real_name,
    SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS last_login,
    u.user_regdate AS date_registered,
    SUBSTRING(u.user_from, 1, 255) AS location,
    u.user_posts AS posts, IF(u.user_level = 1, 1, IFNULL(mg.id_group, 0)) AS id_group,
    u.user_new_privmsg AS instant_messages,
    SUBSTRING(u.user_email, 1, 255) AS email_address,
    u.user_unread_privmsg AS unread_messages,
    SUBSTRING(u.user_msnm, 1, 255) AS msn,
    SUBSTRING(u.user_aim, 1, 16) AS aim,
    SUBSTRING(u.user_icq, 1, 255) AS icq,
    SUBSTRING(u.user_yim, 1, 32) AS yim,
    SUBSTRING(u.user_website, 1, 255) AS website_title,
    SUBSTRING(u.user_website, 1, 255) AS website_url,
    u.user_allow_viewonline AS show_online, u.user_timezone AS time_offset,
    IF(u.user_viewemail = 1, 0, 1) AS hide_email, u.user_avatar AS avatar,
    REPLACE(u.user_sig, '\n', '<br />') AS signature,
    u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
    u.user_notify_pm AS pm_email_notify, u.user_active AS is_activated,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
    '' AS personal_text, '' AS time_format, '' AS usertitle,
    '' AS secret_question, '' AS secret_answer, '' AS validation_code,
    '' AS additional_groups, '' AS smiley_set, '' AS password_salt,
    '' AS member_ip, '' AS member_ip2
    FROM `csomania_lunq`.phpbb_users AS u
    LEFT JOIN `csomania_lunq`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
    LEFT JOIN `csomania_lunq`.smf_membergroups AS mg ON (mg.group_name = CONCAT('phpBB ', r.rank_title))
    WHERE u.user_id != -1
    GROUP BY u.user_id
             ORDER BY null
LIMIT 0, 500;

Caused the error:

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

Co robić ? (dodam, że użwam wersji 2.0 rc i konwentera i smf)