snitz convertor error

[Oldiesmann]

Thanks for the info. I'll keep your version in there since it could be either way.

I'll go ahead and make the changes to the SQL file and post the new version here, then tell Jay to use it

EDIT: Updated SQL file attached

[m771401]

Well, I've tried everything convert.php and .sql I could find in these forums. All do the same.
I enter all the info, hit continue, it churns for 30+ minutes. Then returns a page "step1" says a couple of things are successful but stops on "converting messages..(this take some time....)". I get no other output.

Now, what I had to do was use enterprise manager, conntect to server, download database to a local installation of MSDE. Then on the same machine I installed XAMPP. Used the migration tools from MySQL to get the data from MSSQL to MySQL. Seemed to work without errors.

Installed smf in it's own database then ran the converter script. I get the forum with all the boards, but no members and no messages and I also can't log in with the admin account.

Any suggestions?

[winrules]

How big is your foum (posts/members)?

[m771401]

32k post and 2900 users.

[bulletbrain]

With the files you've provided here I've got past the substep 8 (forum posts) but get this error when trying to convert the topics.

Code Select Expand

Converting posts (this may take some time)... Successful.
Converting topics... Unsuccessful!
This query:

    SELECT
    t.TOPIC_ID AS ID_TOPIC, t.T_STICKY AS isSticky, t.FORUM_ID AS ID_BOARD,
    MIN(m.ID_MSG) AS ID_FIRST_MSG, MAX(m.ID_MSG) AS ID_LAST_MSG,
    t.T_AUTHOR AS ID_MEMBER_STARTED, t.T_LAST_POST_AUTHOR AS ID_MEMBER_UPDATED,
    t.T_REPLIES AS numReplies, t.T_VIEW_COUNT AS numViews,
    t.T_STATUS = 0 AS locked
    FROM (`mydatabase`.FORUM_TOPICS AS t, `mydatabase`.smf_messages AS m)
    WHERE m.ID_TOPIC = t.TOPIC_ID
    GROUP BY t.TOPIC_ID
    HAVING ID_FIRST_MSG != 0
    AND ID_LAST_MSG != 0
    LIMIT 0, 500;

Caused the error:

    'mydatabase.t.T_STICKY' isn't in GROUP BY

I'm presuming it's something within this section of code but I'm a bit stuck at the moment.

Code Select Expand

/******************************************************************************/
--- Converting topics...
/******************************************************************************/

TRUNCATE {$to_prefix}topics;
TRUNCATE {$to_prefix}log_topics;
TRUNCATE {$to_prefix}log_boards;
TRUNCATE {$to_prefix}log_mark_read;

---* {$to_prefix}topics
SELECT
t.TOPIC_ID AS ID_TOPIC, t.T_STICKY AS isSticky, t.FORUM_ID AS ID_BOARD,
MIN(m.ID_MSG) AS ID_FIRST_MSG, MAX(m.ID_MSG) AS ID_LAST_MSG,
t.T_AUTHOR AS ID_MEMBER_STARTED, t.T_LAST_POST_AUTHOR AS ID_MEMBER_UPDATED,
t.T_REPLIES AS numReplies, t.T_VIEW_COUNT AS numViews,
t.T_STATUS = 0 AS locked
FROM ({$from_prefix}FORUM_TOPICS AS t, {$to_prefix}messages AS m)
WHERE m.ID_TOPIC = t.TOPIC_ID
GROUP BY t.TOPIC_ID
HAVING ID_FIRST_MSG != 0
AND ID_LAST_MSG != 0;
---*

Any help with this would be appreciated.

[JayBachatero]

Try this one.

[rav4oz]

Have been following this post through and have applied all SQL files to this point. I am now getting these errors.

Code Select Expand


Converting members... Unsuccessful!
This query:

    SELECT
    MEMBER_ID AS ID_MEMBER, SUBSTRING(M_NAME, 1, 255) AS realName,
    SUBSTRING(M_PASSWORD, 1, 64) AS passwd,
    SUBSTRING(M_EMAIL, 1, 255) AS emailAddress,
    SUBSTRING(M_COUNTRY, 1, 255) AS location,
    SUBSTRING(M_HOMEPAGE, 1, 255) AS websiteTitle,
    SUBSTRING(M_HOMEPAGE, 1, 255) AS websiteUrl,
    SUBSTRING(REPLACE(M_SIG, '\n', '<br />'), 1, 65534) AS signature,
    SUBSTRING(M_AIM, 1, 16) AS AIM, SUBSTRING(M_ICQ, 1, 255) AS ICQ,
    SUBSTRING(M_MSN, 1, 255) AS MSN, SUBSTRING(M_YAHOO, 1, 32) AS YIM,
    IF(M_LEVEL = 3, 1, 0) AS ID_GROUP, M_POSTS AS posts,
    UNIX_TIMESTAMP(REPLACE(M_DATE, '\0', '')) AS dateRegistered,
    SUBSTRING(M_TITLE, 1, 255) AS usertitle,
    UNIX_TIMESTAMP(REPLACE(M_LASTHEREDATE, '\0', '')) AS lastLogin, M_HIDE_EMAIL AS hideEmail,
    IF(M_RECEIVE_EMAIL, 4, 0) AS notifyTypes, M_DOB AS birthdate,
    CASE M_SEX WHEN 'Male' THEN 1 WHEN 'Female' THEN 2 ELSE 0 END AS gender,
    SUBSTRING(IF(IFNULL(M_USERNAME , '') = '', 1, 80) AS memberName,
    SUBSTRING(M_LAST_IP, 1, 255) AS memberIP, '' AS lngfile, '' AS buddy_list,
    '' AS pm_ignore_list, '' AS messageLabels, '' AS personalText,
    '' AS timeFormat, '' AS avatar, '' AS secretQuestion, '' AS secretAnswer,
    '' AS validation_code, '' AS additionalGroups, '' AS smileySet,
    '' AS passwordSalt, SUBSTRING(M_LAST_IP, 1, 255) AS memberIP2
    FROM `pra073111034676`.FORUM_MEMBERS
    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 memberName,
    SUBSTRING(M_LAST_IP, 1, 255) AS memberIP, '' A


[JayBachatero]

Try using the converter in this topic: Snitz Forums

Also please keep further discussion in that topic.  I'll lock this topic for now.