Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: rayraypico on March 16, 2008, 05:43:16 PM

Title: Converting Members from Yabb2.1
Post by: rayraypico on March 16, 2008, 05:43:16 PM
This is the error message that I am getting

Converting members... Unsuccessful!
This query:

    ALTER TABLE `rayray_smf`.smf_members
    ORDER BY ID_MEMBER = 0, dateRegistered;

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 '= 0, dateRegistered' at line 2

If anyone understands this please explain.  Try to explain in simplest terms because I do not have a good understanding of SQL databases
Title: Re: Converting Members from Yabb2.1
Post by: rayraypico on March 16, 2008, 05:50:23 PM
OK OK nevermind I think I was able to get past that problem...next problem can someone tell me why my boards and other items did not convert over?  Also I cannot login with any of the accounts??

If you want to see what I am looking at here it is

http://www.freepornforum.org/SMF (http://www.freepornforum.org/SMF)
Title: Re: Converting Members from Yabb2.1
Post by: rayraypico on March 16, 2008, 06:06:44 PM
Ok I am talking to myself but I hope this will help whoever reads this

I downloaded the convert.php file that is stickied to this thread.  I ran it again and got stuck with the same error from my first post
Title: Re: Converting Members from Yabb2.1
Post by: Rumbaar on March 18, 2008, 09:01:05 PM
I've never done a conversion before, so can't offer direct support.

Well did you get the converter from the Download section.  From what I can tell the one in the sticky is an older version than that.  Try the later version with the same instructions and see how you go.
Title: Re: Converting Members from Yabb2.1
Post by: rayraypico on March 19, 2008, 06:54:21 PM
Thanks for the input but it did not work...anyone out their have any ideas???
Title: Re: Converting Members from Yabb2.1
Post by: Rumbaar on March 19, 2008, 07:25:34 PM
So you download the latest version and tried the whole process from scratch once again, and still experienced the same issue?  Did you read the whole sticky to see if anyone else had experience similar results?
Title: Re: Converting Members from Yabb2.1
Post by: rayraypico on March 20, 2008, 06:46:42 PM
Quote from: Rumbaar on March 19, 2008, 07:25:34 PM
So you download the latest version and tried the whole process from scratch once again, and still experienced the same issue?  Did you read the whole sticky to see if anyone else had experience similar results?

I got it Rumbaar thank you for your guidance.
Title: Re: Converting Members from Yabb2.1
Post by: Rumbaar on March 20, 2008, 10:27:38 PM
Were you able to perform a successful conversion?