phpbb2 vers SMF

Discussion dans 'Web, design' créé par kaRma, 4 Octobre 2006.

Statut de la discussion:
Fermée.
  1. Offline
    kaRma Drink Fast Corp.
    Je suis entrain de faire passer tout mes forums vers la plateforme SimpleMachines que je préfère nettement.

    J'utilise la version RC1.1 de SMF et j'ai réussi a convertir grace à leur petits fichiers tout beau et tout pret un forum : www.mxv.be/forum
    Il etait en phpbb2.0.18

    Maintenant j'essaye de faire pareil avec un autre forum en version 2.0.21, ca ne fonctionne pas ...
    Idem pour un autre version 2.0.13 !

    Et ca m'emmerde :-D

    Lorsque je convertis, voila l'erreur qu'il me met :

    Code:
    Converting ranks... Successful.
    Converting groups... Successful.
    Converting members... Unsuccessful!
    This query:
    
        SELECT
        u.user_id AS ID_MEMBER, SUBSTRING(u.username, 1, 80) AS memberName,
        SUBSTRING(u.username, 1, 255) AS realName,
        SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS lastLogin,
        u.user_regdate AS dateRegistered,
        SUBSTRING(u.user_from, 1, 255) AS location,
        u.user_posts AS posts, IF(u.user_level = 1, 1, mg.ID_GROUP) AS ID_GROUP,
        u.user_new_privmsg AS instantMessages,
        SUBSTRING(u.user_email AS emailAddress, 1, 255) AS emailAddress,
        u.user_unread_privmsg AS unreadMessages,
        SUBSTRING(u.user_msnm AS MSN, 1, 255) AS MSN,
        SUBSTRING(u.user_aim AS 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 websiteTitle,
        SUBSTRING(u.user_website, 1, 255) AS websiteUrl,
        u.user_allow_viewonline AS showOnline, u.user_timezone AS timeOffset,
        IF(u.user_viewemail = 1, 0, 1) AS hideEmail, 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 messageLabels,
        '' AS personalText, '' AS timeFormat, '' AS usertitle, '' AS memberIP,
        '' AS secretQuestion, '' AS secretAnswer, '' AS validation_code,
        '' AS additionalGroups, '' AS smileySet, '' AS passwordSalt,
        '' AS memberIP2
        FROM `mxvbe13`.pen_users AS u
        LEFT JOIN `mxvbe13`.pen_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
        LEFT JOIN `mxvbe13`.pencal_membergroups AS mg ON (BINARY mg.groupName = CONCAT('phpBB ', r.rank_title))
        WHERE u.user_id != -1
        GROUP BY u.user_id
        LIMIT 0, 500;
    
    Caused the error:
    
        You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS emailAddress, 1, 255) AS emailAddress,
        u.user_unread_privmsg AS unreadMessag' at line 9


    Comment je pourrais fixer ca ?


    Merci d'avance !
    kaRma, 4 Octobre 2006
    #1
  2. Offline
    kaRma Drink Fast Corp.
    ptit up de desespoir :beuh:
    kaRma, 5 Octobre 2006
    #2
  3. Offline
    AssiuM Fan
    Est-ce que depuis tu as résolu le problème ? Si oui, pourrais-tu m'expliquer la procédure que tu as employée ? ça pourrait m'intéresser dans un avenir proche...
    AssiuM, 8 Novembre 2006
    #3
  4. Online
    Jereck Procrastinateur
    Equipe GamerZ.be
    Pour celui en 2.0.13, passe le en 2.0.18 puis sous SMF
    Jereck, 8 Novembre 2006
    #4
Statut de la discussion:
Fermée.