Advertisement:

Author Topic: Converting from YaBB 2.2  (Read 117693 times)

Offline unpossible

  • Newbie
  • *
  • Posts: 2
Converting from YaBB 2.2
« on: January 03, 2008, 11:15:44 PM »
I'm currently testing making the conversion from YaBB 2.2 to SMF 1.1.4 using the convert.php intended fro YaBB 2.1, which runs into the following error:



Converting membergroups... Successful.
Converting members... Unsuccessful!
This query:

    ALTER TABLE `smftest`.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 has any suggestions how to get around this problem, I would really appreciate it.

Offline SleePy

  • Site Team
  • SMF Master
  • *
  • Posts: 28,941
  • Gender: Male
  • Thats his happy face.
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: Converting from YaBB 2.2
« Reply #1 on: January 04, 2008, 06:11:03 PM »
Open the .sql file

Find:
Code: [Select]
    ORDER BY ID_MEMBER = 0, dateRegistered;
Replace:
Code: [Select]
    ORDER BY ID_MEMBER, dateRegistered;
That should hopefully allow the script to complete correctly.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub
G+

Offline unpossible

  • Newbie
  • *
  • Posts: 2
Re: Converting from YaBB 2.2
« Reply #2 on: January 04, 2008, 09:59:04 PM »
It took me a while to realize you probably meant the .php files.  But it did fix that problem.  And it also helped me figure out the other error messages that popped up afterwards.

The conversion wasn't perfect.  PMs, Registration Dates, and some old posts didn't come out right, but it got my needs taken care of.

Thank you very, very much for the help!

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Converting from YaBB 2.2
« Reply #3 on: February 01, 2008, 03:34:35 AM »
Ahh so a new version of YaBB is out.  Need to look into it :).
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline Revo1

  • Semi-Newbie
  • *
  • Posts: 23
Re: Converting from YaBB 2.2
« Reply #4 on: February 03, 2008, 02:29:58 AM »
Thanks for the advise, SleePy, and thanks for the convertor, Jay. Following unpossible's comment about continuing the deletion of = 0 in all of the continuing errors in the upgrade, I almost have it all complete, but I come across an error I'm stumped.

Converting topics (part 2)... Unsuccessful!
This query:

    UPDATE `weightle_smf`.smf_log_topics
    SET ID_TOPIC = 1
    WHERE tempID = 1090798235;

Caused the error:

    Unknown column 'tempID' in 'where clause'

Offline Revo1

  • Semi-Newbie
  • *
  • Posts: 23
Re: Converting from YaBB 2.2
« Reply #5 on: February 03, 2008, 03:01:15 AM »
I decided to delete the topic causing the error. I then got another topic with the same error, and I deleted that. Topic conversion completed successful after that, but now I'm getting the following:

This query:

    ALTER TABLE `weightle_smf`.smf_smileys
    ORDER BY LENGTH(code) DESC;

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 'LENGTH(code) DESC' at line 2

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Converting from YaBB 2.2
« Reply #6 on: February 03, 2008, 03:30:44 AM »
Change
ORDER BY LENGTH(code) DESC;
to
ORDER BY code DESC;

Edit the convert.php and yabb21_to_smf.php.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline Revo1

  • Semi-Newbie
  • *
  • Posts: 23
Re: Converting from YaBB 2.2
« Reply #7 on: February 03, 2008, 09:21:00 AM »
Thank you, Jay, but it looks like the errors are just going to keep popping up at this point:

This query:

    ALTER TABLE `weightle_smf`.smf_boards
    ADD tempID tinytext,
    ADD tempCatID tinytext;

Caused the error:

    Duplicate column name 'tempID'

Offline Revo1

  • Semi-Newbie
  • *
  • Posts: 23
Re: Converting from YaBB 2.2
« Reply #8 on: February 03, 2008, 10:26:51 AM »
So I'm looking at yabb_to_smf.php and found the following:

      if ($_GET['substep'] == 0)
      {
         convert_query("
            ALTER TABLE {$to_prefix}categories
            ADD tempID tinytext");
         convert_query("
            ALTER TABLE {$to_prefix}boards
            ADD tempID tinytext,
            ADD tempCatID tinytext");
      }

I took out ADD tempID tinytext, from the code altering the boards table, but I still get a dupicate tempID error. Should I take out the categories one as well?

Offline Revo1

  • Semi-Newbie
  • *
  • Posts: 23
Re: Converting from YaBB 2.2
« Reply #9 on: February 03, 2008, 11:20:31 AM »
Change
ORDER BY LENGTH(code) DESC;
to
ORDER BY code DESC;

Edit the convert.php and yabb21_to_smf.php.
I got it working. What happened was I had an old YaBB 1 Gold SP 1.3.1 that I upgraded to 2.2, thinking it'd be easier to convert from the latest YaBB. After some time and failure I decided to try converting YaBB 1. Well, after 24 hours of working, reworking, etc., trying to get the thing to convert, I got mixed up between going back and forth from the YaBB 1 and YaBB 2.2 installations - trying to get the convertors for them to work. Well, I just realized I was messing with YaBB 1 with your suggestion of deleting LENGTH(code) and replacing it with just code. Thanks, Jay. It worked on my YaBB2.2 board, as that was what your suggestion was for. I appreciate it!

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Converting from YaBB 2.2
« Reply #10 on: February 03, 2008, 07:43:52 PM »
Heh.  The 2.1 converter takes care of the duplicate column name and so on.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline Rovin

  • Semi-Newbie
  • *
  • Posts: 74
    • The Console
Re: Converting from YaBB 2.2
« Reply #11 on: February 06, 2008, 05:25:23 PM »
Would it be possible to create a YaBB 2.2 converter to SMF 1.1.4? Thanks again.

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Converting from YaBB 2.2
« Reply #12 on: February 06, 2008, 05:48:59 PM »
Yea it would be possible?  Can you please give the 2.1 converter a try and see if that works?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline Rovin

  • Semi-Newbie
  • *
  • Posts: 74
    • The Console
Re: Converting from YaBB 2.2
« Reply #13 on: February 06, 2008, 05:50:20 PM »
Just tried it and I got a load of display name errors appearing as guests. See thread in this forum.

Offline afrohead

  • Newbie
  • *
  • Posts: 3
Re: Converting from YaBB 2.2
« Reply #14 on: February 08, 2008, 12:56:58 PM »
I too would like to convert from YaBB 2.2.  Over the next couple of weeks I will try and use the 2.1 converter on my 2.2 board.  My board has over 65000 posts and 14000 users so it should be a good test.  I'll let you know what I find out.  Thanks

Offline Revo1

  • Semi-Newbie
  • *
  • Posts: 23
Re: Converting from YaBB 2.2
« Reply #15 on: February 08, 2008, 01:08:13 PM »
I too would like to convert from YaBB 2.2.  Over the next couple of weeks I will try and use the 2.1 converter on my 2.2 board.  My board has over 65000 posts and 14000 users so it should be a good test.  I'll let you know what I find out.  Thanks
Be sure to try out Jay's new test:

http://www.simplemachines.org/community/index.php?topic=220575.msg1414829#msg1414829

Offline Rovin

  • Semi-Newbie
  • *
  • Posts: 74
    • The Console
Re: Converting from YaBB 2.2
« Reply #16 on: February 08, 2008, 01:57:49 PM »
I used the converter mentioned in the sticky (attached) and I thought it had worked fine. All my posts, threads and members are fine, but the polls are not. They have numerous errors like, being connected to the wrong threads, etc.

Any ideas on how to solve this?

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,561
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: Converting from YaBB 2.2
« Reply #17 on: February 08, 2008, 02:18:23 PM »
Seems like the poll conversion needs another look >_<.  Took me ages to fix the poll issues.  I'll look into it and see what's wrong.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline Rovin

  • Semi-Newbie
  • *
  • Posts: 74
    • The Console
Re: Converting from YaBB 2.2
« Reply #18 on: February 08, 2008, 02:51:39 PM »
Seems like the poll conversion needs another look >_<.  Took me ages to fix the poll issues.  I'll look into it and see what's wrong.

Okay, thanks mate. I appreciate it, and look forward to it. :)

Offline Rovin

  • Semi-Newbie
  • *
  • Posts: 74
    • The Console
Re: Converting from YaBB 2.2
« Reply #19 on: February 10, 2008, 03:49:56 PM »
Any news on this?