Simple Machines Community Forum

SMF Support => Converting to SMF => YaBB/YaBB SE => Topic started by: unpossible on January 03, 2008, 11:15:44 PM

Title: Converting from YaBB 2.2
Post by: unpossible 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.
Title: Re: Converting from YaBB 2.2
Post by: SleePy 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.
Title: Re: Converting from YaBB 2.2
Post by: unpossible 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!
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on February 01, 2008, 03:34:35 AM
Ahh so a new version of YaBB is out.  Need to look into it :).
Title: Re: Converting from YaBB 2.2
Post by: Revo1 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'
Title: Re: Converting from YaBB 2.2
Post by: Revo1 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
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero 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.
Title: Re: Converting from YaBB 2.2
Post by: Revo1 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'
Title: Re: Converting from YaBB 2.2
Post by: Revo1 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?
Title: Re: Converting from YaBB 2.2
Post by: Revo1 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!
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on February 03, 2008, 07:43:52 PM
Heh.  The 2.1 converter takes care of the duplicate column name and so on.
Title: Re: Converting from YaBB 2.2
Post by: Rovin 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.
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero 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?
Title: Re: Converting from YaBB 2.2
Post by: Rovin 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.
Title: Re: Converting from YaBB 2.2
Post by: afrohead 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
Title: Re: Converting from YaBB 2.2
Post by: Revo1 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
Title: Re: Converting from YaBB 2.2
Post by: Rovin 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?
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero 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.
Title: Re: Converting from YaBB 2.2
Post by: Rovin 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. :)
Title: Re: Converting from YaBB 2.2
Post by: Rovin on February 10, 2008, 03:49:56 PM
Any news on this?
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on February 10, 2008, 04:35:42 PM
No news.  I've been pretty busy with other things :(.
Title: Re: Converting from YaBB 2.2
Post by: Rovin on February 10, 2008, 05:44:07 PM
No news.  I've been pretty busy with other things :(.

No worries.
Title: Re: Converting from YaBB 2.2
Post by: oldYabber on May 09, 2008, 09:44:00 AM
I also made it to the polls portion going back to the yabb21_to_smf.php script and deleting "= 0" and there it quit.
I viewed my board and it had and the different boards and categories but no members or messages so I quit. Would rolling back to 2.1 and trying again work better?
Title: Re: Converting from YaBB 2.2
Post by: SleePy on May 09, 2008, 09:18:49 PM
id you get any other errors?
Title: Re: Converting from YaBB 2.2
Post by: oldYabber on May 10, 2008, 02:21:06 PM
Nope. It seemed there were only two options. Hit the try again button infinitum or just close the window. Then I went to index php and there was my message board but no messages or members. Then I got frustrated with YaBButt  for the umpteenth time since 1Gold and quit like a big sissy.
Title: Re: Converting from YaBB 2.2
Post by: SleePy on May 10, 2008, 10:07:59 PM
I don't see a Yabb 2.2 converter. I might of missed it though.
If it isn't already, you can add it to our converter requests page and hopefully when time permits for us who are making converters we can get to them.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 22, 2008, 10:26:33 AM
Hmmmm I've wanting to convert my YaBB 2.2.1 site to smf, so am using the latest converter I can find, however this is all that happens ...

Code: [Select]
Converting...
Converting membergroups... Successful.
Converting members...

In the Browser status line it says "Done" this is in IE and FF2/3 any ideas?!

Stewart
Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 22, 2008, 12:21:22 PM
How big of a forum do you have Gilrod?
If you have a really big forum, using the command line converter may be the only way :|
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 22, 2008, 12:40:54 PM
Not really ...

Total Topics:     27635
Total Posts:    940524
Total Members:    1911

I'd expect to see it refreshing every 20-30 seconds, but nothing it just sits there and does nothing.
Title: Re: Converting from YaBB 2.2
Post by: ThorstenE on June 23, 2008, 03:06:43 AM
Quote
I'd expect to see it refreshing every 20-30 seconds
this means converter is already working. A conversion of 940.000 Post will take long time (up to several hours).
my old phpbb was converted in 2 Hours (250.000 Posts)

try the command-line-version (only possible, if you have shell access  to the host), it should be a little bit faster:
Code: [Select]
/path/to/php/php -f /path/to/convert.php --path_to=/path/to/smf --path_from=/path/from/yabb --db_pass=xxxx --convert_script=yabb21_to_smf.sql --debug


Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 23, 2008, 03:34:29 AM
Ok I think you missed something ...

It's "failing" in the member convert, it doesn't even get to the posts conversion yet.

And am actually trying to run it on a Windows Server.
Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 23, 2008, 01:46:02 PM
Add ?debug=1 to the end of the url.
This should put it into debug mode, hopefully it will spit out more errors or information that can lead us to the issue.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 23, 2008, 03:49:09 PM
Interesting, well 1 of the settings paths.pl was wrong, fixed that and here's what I get...

Code: [Select]
Caused the error:

    Incorrect integer value: '' for column 'gender' at row 1

There was a LOT of rubbish that was printed prior to that, is it worth posting that too?
Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 23, 2008, 04:45:10 PM
It may be.  Most likely though it was the query it was trying to execute.

Edit,
Though try this.
Open the yabb21_to_smf.php

Find:
Code: [Select]
'gender' => $userData[11],

replace:
Code: [Select]
'gender' => (int) $userData[11],

That should hopefully force it to be cast as an integer and satisfy the database.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 23, 2008, 04:54:14 PM
Same error...

Basically I think it's down to the fact that we don't ask our members to specify sex, so all the values are blank. Can't I just remove that line?

Interestingly if I removed that line you mentioned the error still comes up, so I looked for "gender" again, and this line seems to be the culprit, if I remove it the error is different ..

Code: [Select]
'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? 1 : ($data['gender'] == 'Female' ? 2 : 0)) : '',
Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 23, 2008, 04:58:20 PM
Code: [Select]
               'gender' => 0,
You could change it to that. It would force it to be 0 for all members. Which is unspecified when SMF translates it for its gender field.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 23, 2008, 05:00:51 PM
Here's my own member info details...

Code: [Select]
### User variables for ID: admin ###

'password',"REMOVED"
'realname',"Stewart"
'email',"REMOVED"
'regdate',"07/05/05 at 19:00:00"
'regreason',""
'webtitle',""
'weburl',""
'spamcount',""
'spamtime',""
'signature',"[url=http://ps3tag.com/cards/view/493][img]http://ps3tag.com/cards/../files/cards/493.jpg[/img][/url]"
'postcount',"192"
'position',"Administrator"
'addgroups',"4"
'icq',""
'aim',""
'yim',""
'skype',""
'gender',""
'usertext',""
'userpic',"blank.gif"
'regtime',"1120604400"
'location',""
'bday',""
'timeselect',"4"
'timeoffset',"0"
'timeformat',"MM D+ YYYY @ HH:mm:ss*"
'hidemail',"checked"
'msn',""
'gtalk',""
'template',"TNMS 2007"
'language',"English"
'lastonline',"1214251972"
'lastpost',"1214078442"
'lastim',"1213632449"
'im_ignorelist',""
'im_notify',"1"
'im_popup',"on"
'im_imspop',""
'cathide',""
'postlayout',"130|425|11"
'session',"REMOVED"
'sesquest',"password"
'sesanswer',"REMOVED"
'favorites',""
'dsttimeoffset',"1"
'pageindex',"1|1|1"
'lastips',"192.168.7.197|78.32.110.249|78.32.67.168"
'onlinealert',""
'pmactprev',""
'pmmessprev',""
'pmviewMess',""
'buddylist',""
'offlinestatus',"offline"
'awaysubj',""
'awayreply',""
'awayreplysent',""
'stealth',""

Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 24, 2008, 07:44:26 AM
Right after some investigating the following lines in yabb21_to_smf.php cause the first set of problems ...

Code: [Select]
'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? 1 : ($data['gender'] == 'Female' ? 2 : 0)) : '',

'dateRegistered' => parse_time($data['regdate']),

'birthdate' => isset($data['bday']) ? ($data['bday'] == '' || strtotime($data['bday']) == 0 ? '0001-01-01' : strftime('%Y-%m-%d', strtotime($data['bday']))) : '',

'lastLogin' => isset($data['lastonline']) ? $data['lastonline'] : '',

The entire PM conversion fails, looking at some of the lines, they imply that the order of the data in the YaBB format is not what is expected, here is how it appears in the yabb .msg file ...

Code: [Select]
113419747019612|derrydale||||Re: (No subject)|1134215470|Hi Alan, thanks for this. My address:<br><br>MESSAGE REMOVED|113419747019612|0|82.34.168.xx|s|||
I'm new to php, being a relatively amateurish Perl coder as well, so am a little unsure about how things are referenced etc, but as I said the php implies that format for the expected data is different ...

Code: [Select]
'fromName' => substr(htmlspecialchars($userData[$i][0]), 0, 255),

The above is the item that references the "From user" is the

I commented out the entire 4th step and then it says it's finished, but obviously there are NO posts/messages at all.

Thanks in advance if anyone can help.

Stewart
Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 24, 2008, 12:40:20 PM
change:
Code: [Select]
'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? 1 : ($data['gender'] == 'Female' ? 2 : 0)) : '',
to
Code: [Select]
'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? 1 : ($data['gender'] == 'Female' ? 2 : 0)) : '0',
Does it get though the gender conversion now?
What is the step it is failing on?
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 24, 2008, 12:55:20 PM
In my previous post, for my tests I literally commented out each of those 4 lines that it failed on during step2.

Doing the change you've just suggested for "gender" worked.

Now it's failing on "Incorrect integer value: '' for column 'dateRegistered' at row 1"

Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on June 24, 2008, 01:06:31 PM
Try changing this line.
Code: [Select]
'dateRegistered' => parse_time($data['regdate']),
to
Code: [Select]
'dateRegistered' => (int) $data['regtime'],
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 24, 2008, 01:08:36 PM
That chucked up a MySQL error...

Code: [Select]
ALTER TABLE `tnmsv3`.smf_members
ORDER BY ID_MEMBER = 0, dateRegistered;

Does one remove the = 0 from the convert.php in that query?
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on June 24, 2008, 01:16:28 PM
Yea remove the = 0
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 24, 2008, 01:22:35 PM
Ok sorted that one out, next .... :)

Code: [Select]
Incorrect date value: '' for column 'birthdate' at row 1
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on June 24, 2008, 01:27:44 PM
Change
Code: [Select]
'birthdate' => isset($data['bday']) ? ($data['bday'] == '' || strtotime($data['bday']) == 0 ? '0001-01-01' : strftime('%Y-%m-%d', strtotime($data['bday']))) : '',
to
Code: [Select]
'birthdate' => isset($data['bday']) ? ($data['bday'] == '' || strtotime($data['bday']) == 0 ? '0001-01-01' : strftime('%Y-%m-%d', strtotime($data['bday']))) : '0001-01-01',
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 24, 2008, 02:45:06 PM
Then now this is an issue too..

Code: [Select]
'lastLogin' => isset($data['lastonline']) ? $data['lastonline'] : '',
giving this error...

Code: [Select]
Incorrect integer value: '' for column 'lastLogin' at row 1
Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 24, 2008, 04:49:21 PM
MySQL must be running in strict mode for all these errors to occur..

That line can be changed to:
Code: [Select]
'lastLogin' => isset($data['lastonline']) ? $data['lastonline'] : '0',
But if mysql is in strict mode I think we will just see more errors occur..
I don't think the YaBB 2.1 converter was wrote for MySQL Strict mode..
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 24, 2008, 04:57:28 PM
Yeah, Jay and I realised it's a strict mode issue :-)

Typical... the next issue I'm having is this ...

Code: [Select]
Incorrect integer value: '' for column 'msgtime' at row
During step 4...

Converting personal messages... Unsuccessful!

Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on June 24, 2008, 04:58:29 PM
Yea I talked to him via IM and MySQL is running in strict mode.  The converter needs to be updated to support strict mode.
Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 24, 2008, 05:12:13 PM
Gilrod,

I hope you don't mind testing :)

Let me know how this one works out. I made changes and hopefully found all columns that need specified correctly
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 24, 2008, 05:16:06 PM
No problems man, am just sat on my sofa watching sh!t TV ;-)

Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 24, 2008, 05:20:33 PM
That script doesn't give any output, you did something wrong I think :)

Would it be quicker to do this via IM ?
Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 24, 2008, 05:27:09 PM
oops,
I didn't even check for syntax errors.

Fixed in this one
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 25, 2008, 04:41:48 AM
Morning Gents,
Sleepy, here's the latest error :)

Code: [Select]
Converting notifications... Successful.
Unsuccessful!
This query:

    ALTER TABLE `tnmsv3`.smf_messages
    CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL default 0,
    DROP PRIMARY KEY,
    DROP INDEX topic,
    DROP INDEX ID_BOARD,
    DROP INDEX ID_TOPIC,
    DROP INDEX ID_MEMBER,
    ADD COLUMN temp_filename tinytext NOT NULL default '';

Caused the error:

    BLOB/TEXT column 'temp_filename' can't have a default value
Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 25, 2008, 01:33:09 PM
Ah dang.

Find:
Code: [Select]
                    'temp_filename' => "ADD COLUMN temp_filename tinytext NOT NULL default ''",
Replace:
Code: [Select]
                    'temp_filename' => "ADD COLUMN temp_filename tinytext(6) NOT NULL default ''",
A 6 should do it for tinytext.

That part of the query only happens though when the uploads directory exists.

The sad thing is that was step 10 and it took a while to get there.
We could cheat a little I believe and after the start of all the other steps before step 10. We just have it do a return.
It would mean we modify the file in 9 places previous to this so we just skip over the rest of the converter sections.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 25, 2008, 06:10:52 PM
Got another for you ...

Code: [Select]
Unsuccessful!
This query:

    ALTER TABLE `tnmsv3`.smf_messages
    CHANGE COLUMN ID_MSG ID_MSG int(10) unsigned NOT NULL default 0,
    DROP PRIMARY KEY,
    DROP INDEX topic,
    DROP INDEX ID_BOARD,
    DROP INDEX ID_TOPIC,
    DROP INDEX ID_MEMBER,
    ADD COLUMN temp_filename tinytext(6) NOT NULL;

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 '(6) NOT NULL' at line 8
Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 26, 2008, 01:14:53 AM
Did the changes we made over MSN get you any further since I last seen you?
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 26, 2008, 03:50:19 AM
That is what happened after the fix... I did send it back to you in msn, however you never came back to me, so I assumed you were busy.

Just so I know I'm not fooking this up...

We wanted to change this ...
Code: [Select]
'temp_filename' => "ADD COLUMN temp_filename tinytext(6) NOT NULL default ''",
to this ...

Code: [Select]
'temp_filename' => "ADD COLUMN temp_filename tinytext(6) NOT NULL",
Stew.
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on June 26, 2008, 10:20:05 AM
tinytext fields have a predefined size.  You can't specify a size for it unless it's a varchar column.

Code: [Select]
'temp_filename' => "ADD COLUMN temp_filename tinytext NOT NULL",
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 26, 2008, 11:43:53 AM
And the next step ...

Code: [Select]
Converting posts (part 1 - this may take some time)... Unsuccessful!
This query:

    INSERT INTO `tnmsv3`.smf_messages
    (ID_TOPIC, ID_BOARD, subject, posterName, posterEmail, posterTime, icon, posterIP, body, smileysEnabled, modifiedTime, modifiedName, temp_filename)
    VALUES ('3166', '5', 'Rush - what are they like?', 'Matt_Callow', **************', '1071598776', 'xx', '217.206.177.18', 'There\'s a bit of a discussion going on over here...<br>http://www.melodicrock.com/phorum33/list.php?f=1<br><br>Enjoy!', '', '0', '', ''),
    ('3166', '5', 'Re: Rush - what are they like?', 'Slim', '**************', ', '1071599686', 'xx', '62.253.32.5', 'I see some poor soul has described [i]Counterparts[/i] as a \'true masterpiece\' lmao<br><br>Very sad .. ;D<br><br>', '1', '0', '', ''),
    ('3166', '5', 'Re: Rush - what are they like?', 'Reg_Sweeting-Jones', '**************', ', '1071610023', 'xx', '81.86.90.146', '[quote]I see some poor soul has described [i]Counterparts[/i] as a \'true masterpiece\' lmao<br /><br />Very sad .. ;D<br /><br />[/quote]<br>Truly deranged.', '1', '0', '', ''),
    ('3166', '5', 'Re: Rush - what are they like?', 'Neil_Pudney', '**************', ', '1071615333', 'xx', '80.46.152.4', '[quote]I see some poor soul has described [i]Counterparts[/i] as a \'true masterpiece\' lmao<br /><br />Very sad .. ;D<br /><br />[/quote]<br> Glad to see you\'ve put them right :-)', '1', '0', '', ''),
    ('3166', '5', 'Re: Rush - what are they like?', 'Jon_M', 'j**************', , '1071634845', 'xx', '62.6.139.12', 'Well, they\'re like a little rabbit really...', '1', '0', '', ''),
    ('3166', '5', 'Re: Rush - what are they like?', 'Dave_Lack', '**************', ', '1071797572', 'xx', '81.101.68.134', 'Can\'t wait for the Counterparts debate..... ;)', '1', '0', '', '');

Caused the error:

    Incorrect integer value: '' for column 'smileysEnabled' at row 1
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on June 26, 2008, 12:17:59 PM
Change
Code: [Select]
'smileysEnabled' => empty($message[9]),
to
Code: [Select]
'smileysEnabled' => empty($message[9]) ? '0' : '1',
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 27, 2008, 03:28:00 AM
Sleepy, after leaving it running for like 13 hours it's still going and the step amount doesn't look right ...

Code: [Select]
http://XXXXXXXXXXXX/convert.php?step=1&substep=1342750&cstep=11&start=0
Notice the substep amount... and we've only got 920k posts or there abouts...

UPDATE:

I let it run still, and have just checked it now and it seems to of died...

Code: [Select]
http://XXXXXXXXXXXX/convert.php?step=1&substep=1346750&cstep=11&start=0
The status bar is saying "Done" and nothing is happening at all, also the screen layout is different...

This is all it says ...

Code: [Select]
Converting...
Converting posts (part 2)...

Stew
Title: Re: Converting from YaBB 2.2
Post by: Conservationist on June 27, 2008, 09:56:12 AM
The status bar is saying "Done" and nothing is happening at all, also the screen layout is different...

This is all it says ...

Code: [Select]
Converting...
Converting posts (part 2)...

I've gotten a few of those, but even more -- totally blank screens.

I am unsure whether this is the ISP killing the process, or it simply crashing, as it has done several times.

People here are very helpful, but this process seems mystifyingly complex. Without SleePy, I'd be back on the drink.

I have had FAR better luck converting forums that were always YaBB 2/2.1 than those which were converted at any time from YaBB 1.4.

I may attempt to convert, in one case, from the original 1.4 forum using the generic YaBB converter, even though initial advice was NOT to go that route. I will post anything I learn here.
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on June 27, 2008, 10:11:44 AM
If I have some time tonight I'll try and take a look into this issue.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 27, 2008, 10:57:48 AM
Well since Sleepy and I were messing with the script and "continuing" instead of restarting the process I've decided to do a reboot as it were and have started from scratch, it's been running since my last post and has just started the posts...

I'll let you know how it goes...
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on June 27, 2008, 11:01:52 AM
Ok so keep us updated.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 28, 2008, 02:28:58 AM
Something is definitely wrong with step 11...

Code: [Select]
http://*************/convert.php?step=1&substep=2522500&cstep=11&start=0
Remember we only have ~940k posts
Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 28, 2008, 03:02:56 AM
Odd

Go to the SMF database and then into the smf_messages table.

Search for any ID_MSG that is equal to 0.
Do you get any?

That query there is just looping through the messages table correcting any incorrect ids. It should stop when it stop affecting rows (by its updates)..

How many are you converting at once (Since I know you edited that)?
Did you make sure to change it in all places?
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 28, 2008, 12:50:34 PM
Right, there are none that are zero (0).

Also there are 912260 entries, Am assuming that is 1 per post? if so the total number of posts actually is 940523.

Also I upp'd the steps to 500, so not a MASSIVE lift from 150.

Stew

Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 28, 2008, 01:26:24 PM
Ok.. Well maybe its possibly looping due to the -1 past time it gets..

Find (We already changed this once):
Code: [Select]
            if ($_GET['substep'] != 0)
Replace:
Code: [Select]
            if ($_GET['substep'] > 0)
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on June 29, 2008, 03:57:15 PM
Balls...

FAIL....

Are all these changes just to make the convert be strict compliant?
Title: Re: Converting from YaBB 2.2
Post by: SleePy on June 29, 2008, 05:08:49 PM
Yes and no..
That last one was a bug I think as it shouldn't catch itself in a loop.
It may have something to do with the fact it is yabb 2.2 with the yabb 2.1 converter as well, but I really hope not.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 01, 2008, 06:11:44 PM
There is no file fix for YaBB 2.1 to 2.2 so that shouldn't be an issue.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 03, 2008, 10:57:41 AM
Well, after getting sleepy' work file for the converter I've been running it ever since and it's STILL on Posts (Part2) with the following URL ...

http://**************/convert.php?step=1&substep=2039400&cstep=11&start=0

Notice the substep is over 2m, again we only have ~900k posts.

When I spoke to Sleepy last he said that if this latest didn't work then he suspects that Jay would have to look at it.

Jay when we first spoke you suggested I provided you with a copy of the data, I've RAR it all up into a 106MB file, where do I stick it?

Stew
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on July 03, 2008, 11:20:57 AM
You can upload it to your site and PM me the link to the file.
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 03, 2008, 12:55:48 PM
Jay would you understand why its getting caught in the loop there on the second stage of converting posts? Thats step 11.
I was thinking it was the while loop there and the timeout protection was kicking in to early or when it was forced to -1 for the timeout that it caused it to reloop again.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 03, 2008, 02:19:49 PM
Uploading now, will be in touch soon.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 05, 2008, 03:53:47 PM
Jay,  did you manage to download the data from that link I MSN'd you?
Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 08, 2008, 11:04:06 PM
Hey there SleePy, I was using the Yabb 2.1 converter for my Yab 2.2.2 forum and I managed to get everything going up until the point where it wanted to import the Poll information.

See here:

(http://i205.photobucket.com/albums/bb58/sanjosebass/Picture9.png)

And it also says that it imported the posts, but when I went to the forum they weren't there.

Any suggestions?

I am willing to let you log onto my site if you would like to test.

Let me know... I will also hit you up via AIM as well...

Thanks!

MG
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 08, 2008, 11:41:21 PM
Try this attached file.
Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 08, 2008, 11:56:20 PM
Thanks SleePy.

Any idea on how long it should take to convert 13,000 posts and 300 users?
Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 09, 2008, 12:00:38 AM
Actually, I past the Post import and then I hit this error:

(http://i205.photobucket.com/albums/bb58/sanjosebass/Picture14.png)

Good news is all of my posts appear to be there, bad news is I'm not sure if this error is significant or not.

Let me know SleePy - and THANKS!!!! You're the man.

Marce
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 09, 2008, 12:09:21 AM
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 09, 2008, 06:08:28 AM
Update...

As far as I can tell, almost everything made it over properly EXCEPT for the PM's.

Here is a screen shot of what my Inbox looks like:

(http://i205.photobucket.com/albums/bb58/sanjosebass/Picture2.png)

Any ideas?
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on July 09, 2008, 10:08:48 AM
Seems like the order of things for PMs have changed so things are getting added to the wrong place.

Send me one of the .msg files so that I can look into it.
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 09, 2008, 12:56:48 PM
It may be time to split it up and make a yabb 2.2 converter I think.. Looks like things have changed
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on July 09, 2008, 01:36:00 PM
Yea I was thinking the same thing.  I'm pretty sure other things changed as well.  Just haven't come across them.
Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 09, 2008, 02:52:59 PM
Hey guys, I've attached a .msg file. Let me know if you need anything else. Hopefully I am not breaking the rules by posting this, and if so, just let me know and I will get it to you gents another way.

Thanks!
Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 09, 2008, 03:18:17 PM
It's changed a bit - here is a .msg file from my Yabb 2.1 install.

Quote
admin|Welcome to SanJoseBass.com!|1181177090|Thanks for signing up, I really appreciate it. Take a look around and try to contribute as much as possible. If you have any suggestions feel free to post them in The Suggestion Box located in the forum. <br /><br />Thanks!<br /><br />Marce|118117709023988|66.249.72.43|1

Vs. Yabb 2.2

Quote
1212045642|murf|lmartinez|||Re: dawia exceler|1212045642|Hi Len. &nbsp;I still want the reel, but I'm not available on Saturday. &nbsp;Can you ship it? &nbsp;If you send it by UPS, I'll mail you a check for the $50 plus half the shipping costs.<br /><br />If not, it might make more sense for me to buy a new reel. &nbsp;The exceler retails for around $65 I think. &nbsp;|1212045642|0 |76.21.32.102|s|||
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on July 09, 2008, 03:20:48 PM
There are like 3 time stamps for each entry.  I'm going to have to download YaBB and take a look at the source files.  I got most of the stuff in the right order just need to find out what did they add in 2.2.  I'll have to do that when I get home from work though.
Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 09, 2008, 03:23:39 PM
Jay - I added the Yabb 2.2 msg file in my previous post as a comparison.
Title: Re: Converting from YaBB 2.2
Post by: JayBachatero on July 09, 2008, 03:44:01 PM
Yea I analized the file before posting.  I got the subject, body and sender figured out but need to check how much their PM system changed.
Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 10, 2008, 12:19:06 AM
Thanks Jay - let me know if I could assist in any way. Also, I need to get this moved over for one of my sites soon, so if you would like for me to pay for your services, I am willing to do that as well.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 11, 2008, 02:57:23 PM
Any luck with my stuff Jay?
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 11, 2008, 05:34:50 PM
Try this one out

note it is a yabb 2.2 converter. I was working on trying to get yabb installed so I can see what else changed, but it doesn't see to like me :(
Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 11, 2008, 05:39:14 PM
Try this one out

note it is a yabb 2.2 converter. I was working on trying to get yabb installed so I can see what else changed, but it doesn't see to like me :(

Hey SleePy - will this take care of my PM issues?
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 11, 2008, 05:56:23 PM
This one may work.
I still haven't been able to get yabb installed. But I have a friend who is going to try and get it going so I can work on updating it (hopefully).

I only can guess the changes based of information Jay gave me on how the pm message format is now.
Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 11, 2008, 06:04:54 PM
This one may work.
I still haven't been able to get yabb installed. But I have a friend who is going to try and get it going so I can work on updating it (hopefully).

I only can guess the changes based of information Jay gave me on how the pm message format is now.

If you need me to install a fresh version for you let me know, I have a few available empty sites that I can give you full access to.

I will test this version now.

Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 11, 2008, 06:16:07 PM
Attached is the error I ran into...

Quote
http://xxx.xxx.xxx.xxx/convert.php?step=1&substep=1800&cstep=8&start=0

EDIT: Added the step URL above
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 11, 2008, 06:46:50 PM
OOps,

Thats what happens when you copy and paste ;D

Find:
Code: [Select]
            while ($row = mysql_fetch_assoc($result))
                convert_query("
                    DELETE {$to_prefix}log_topics
                    SET ID_TOPIC = $row[ID_TOPIC]");

Replace:
Code: [Select]
            while ($row = mysql_fetch_assoc($result))
            {
                convert_query("
                    DELETE {$to_prefix}log_topics
                    WHERE ID_TOPIC = $row[ID_TOPIC]");

btw, I did just get yabb installed :D
Now to just get things tested. I tried pms and the changes I made worked for pms and they appear to convert right now.
Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 11, 2008, 07:04:22 PM
Being that I'm a very ansy kind of guy I decided to cut and paste the PM code section from the 2.2 converter to the 2.1 converter and it looks as though everything came over correctly EXCEPT for the time stamp of the PM.

I have "December 31st, 1969"

Is this what you see?

Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 11, 2008, 07:38:26 PM
Find:
Code: [Select]
                    'msgtime' => empty($userData[$i][6]) ? (int) $userData[$i][6] : '0',
Replace:
Code: [Select]
                    'msgtime' => !empty($userData[$i][6]) ? (int) $userData[$i][6] : '0',
As well you could use the attached. I did try to fix some of the bbc code. I haven't worked out yet how to deal with the timestamp bbc nor the /me. But I try to change others and fix them up :)

Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 11, 2008, 08:18:08 PM
Sleepy - take a look at this code when you have a moment. I still am getting the SET_ID_TOPIC error, but I think the syntax of your suggested fix isn't correct. It's as though you are adding an enclosure "{" where it doesn't belong (forgive me, I am not a programmer).

Here is what it looks like in your last attachment:

Quote
      {
         $result = convert_query("
            SELECT ID_TOPIC
            FROM {$to_prefix}log_topics
            GROUP BY ID_TOPIC
            HAVING COUNT(ID_MEMBER) > 1");

         while ($row = mysql_fetch_assoc($result))
            convert_query("
               DELETE {$to_prefix}log_topics
               SET ID_TOPIC = $row[ID_TOPIC]");
         mysql_free_result($result);

         pastTime(-3);
      }

and here is what it would look like with your suggested changes:

Quote
      {
         $result = convert_query("
            SELECT ID_TOPIC
            FROM {$to_prefix}log_topics
            GROUP BY ID_TOPIC
            HAVING COUNT(ID_MEMBER) > 1");

            while ($row = mysql_fetch_assoc($result))
            {
                convert_query("
                    DELETE {$to_prefix}log_topics
                    WHERE ID_TOPIC = $row[ID_TOPIC]");
         mysql_free_result($result);

         pastTime(-3);
      }

Thoughts?  :D
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 11, 2008, 09:29:39 PM
yea.. Remove the extra {.
Sorry about that..

I have been working on converters all day making sure they shouldn't have any issues with 2.0 (when I release the 2.0 versions) and its just been line after line of code needing manual updates.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 12, 2008, 06:07:03 AM
heh, got this ...

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

    DELETE `tnmsv3`.smf_log_topics
    SET ID_TOPIC = 1;

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 'SET ID_TOPIC = 1' at line 2
Title: Re: Converting from YaBB 2.2
Post by: baycrew on July 12, 2008, 07:43:15 AM
heh, got this ...

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

    DELETE `tnmsv3`.smf_log_topics
    SET ID_TOPIC = 1;

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 'SET ID_TOPIC = 1' at line 2

And I as well....
Title: Re: Converting from YaBB 2.2
Post by: ThorstenE on July 12, 2008, 01:00:47 PM
try the attached version..
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 12, 2008, 02:56:35 PM
What did you change? as it seems to be doing a lot of thinking.
Title: Re: Converting from YaBB 2.2
Post by: ThorstenE on July 12, 2008, 03:22:23 PM
i changed
Code: [Select]
while ($row = mysql_fetch_assoc($result))
convert_query("
DELETE {$to_prefix}log_topics
SET ID_TOPIC = $row[ID_TOPIC]");
mysql_free_result($result);

to
Code: [Select]
while ($row = mysql_fetch_assoc($result))
convert_query("
UPDATE {$to_prefix}log_topics
SET ID_TOPIC = $row[ID_TOPIC]");
mysql_free_result($result);

i'm not 100% sure, but i think this must be an update of the log_topics-table..

also possible could be

Code: [Select]
while ($row = mysql_fetch_assoc($result))
convert_query("
DELETE FROM {$to_prefix}log_topics
WHERE ID_TOPIC = $row[ID_TOPIC]");
mysql_free_result($result);

i cannot test myself (i think it's time to install a Yabb for me)
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 12, 2008, 04:16:48 PM
It was meant to be a delete :)

The first query before it was finding the duplicate ids. This query is using that information to remove them to prevent the duplicate id error when adding the primary index back :)
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 12, 2008, 09:16:47 PM
well it doesn't work...

After re-doing it all from scratch I just get a "done" in the status bar during topics (2)

:(
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 13, 2008, 12:35:23 AM
Does it keep refreshing while its in progress of its work?

What is the querystring (The part after the ? in the url)?
This would let me know exactly what step it is currently on (or possibly a step after that) and such.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 13, 2008, 04:00:03 AM
ah balls, I closed it down... will restart it now and report back in like 4hrs...

Stew
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 14, 2008, 04:58:24 AM
Quote
http://tnmsv3.jawltd.com/convert.php?step=1&substep=26100&cstep=8&start=0

Arriving considerably later than planned, my net connection died at 9am on Sunday!!!!
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 14, 2008, 12:54:23 PM
Ok, well you are stuck on step 8.
 
How many topics do you have on your board?
 
from the url you gave me it is showing 26,100 topics so far have been converted and fixed.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 14, 2008, 04:03:12 PM
27635 - Topics....
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 14, 2008, 05:57:58 PM
Is it still running?

It just hasn't completed yet then. Its only done 26k out of the almost 28k topics you have. It is getting there.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 14, 2008, 06:33:07 PM
No dude, this has totally stopped...

And I've no idea why, the status bar = "DONE" and it's been sat at the 26000 for 1/2 a day.
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 14, 2008, 06:50:27 PM
any continue button :|
If there is no continue button you can try hitting go in the url and see if you can get it to start again.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 15, 2008, 03:57:13 AM
There was no continue button... at all... :(

I'll restart from scratch.
Title: Re: Converting from YaBB 2.2
Post by: ThorstenE on July 15, 2008, 04:10:58 AM
It was meant to be a delete :)
did you use the updated version from me? then you have to change the code as above explained. my version uses an UPDATE but SleePy meant a DELETE..

change
Code: [Select]
while ($row = mysql_fetch_assoc($result))
convert_query("
UPDATE {$to_prefix}log_topics
SET ID_TOPIC = $row[ID_TOPIC]");
mysql_free_result($result);

to
Code: [Select]
while ($row = mysql_fetch_assoc($result))
convert_query("
DELETE FROM {$to_prefix}log_topics
WHERE ID_TOPIC = $row[ID_TOPIC]");
mysql_free_result($result);


maybe, this is the reason for the stop?
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 15, 2008, 08:43:55 AM
Sleepy - FYI I used the version of the script in the stickied topic...

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

    DELETE `tnmsv3`.smf_log_topics
    WHERE ID_TOPIC = 1;

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 'WHERE ID_TOPIC = 1' at line 2
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 15, 2008, 01:08:26 PM
Oops
 
Find:
Code: [Select]
   while ($row = mysql_fetch_assoc($result))
    convert_query("
     DELETE {$to_prefix}log_topics
     WHERE ID_TOPIC = $row[ID_TOPIC]");

Replace:
Code: [Select]

   while ($row = mysql_fetch_assoc($result))
    convert_query("
     DELETE FROM {$to_prefix}log_topics
     WHERE ID_TOPIC = $row[ID_TOPIC]");

Sorry for all the bugs. Its hard trying to guess the changes when they work fine for a small sized board (ie my test board). Its the bigger boards is where this correct testing goes into play.
I need to find time to write a flood script for Yabb to post thousands of posts so I can get a large sized board.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 15, 2008, 07:15:56 PM
Interestingly, I've let it continue from the error mentioned previously...

However I've got the following url during "Posts (Part 2)"

Quote
http://tnmsv3.XXXXXXXXXXX.com/convert.php?step=1&substep=0&cstep=11&start=0

Should the substep be changing as with the other steps?
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 16, 2008, 01:00:50 AM
Yes it should..

That stupid section has me in a fun loop here to try and figure it out..

Do you have a test board or something I can try this out on Gilrod?
I think that is going to be my best option to try and debug this out.. Its a troublesome section right there that is not wanting to work right.
On my small home tests it goes through that just fine though :|
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 16, 2008, 04:55:45 AM
Well the data I rar'd up for Jay is still available for download, but it's 100MB ;-)

Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 16, 2008, 11:44:48 AM
hmmm getting this now ...

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

    DELETE `tnmsv3`.smf_log_topics
    SET ID_TOPIC = 1
    WHERE tempID = 1025876070;

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 'SET ID_TOPIC = 1
    WHERE tempID = 1025876070' at line 2
Title: Re: Converting from YaBB 2.2
Post by: ThorstenE on July 16, 2008, 12:58:30 PM
Gilrod, please attach your version of yabb22_to_smf.sql
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 16, 2008, 01:07:59 PM
Do you mind if I get a link to that?
I won't be able to look at it until friday as I am backing up my data today on my laptop for the service I am taking it in for tomorrow.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 21, 2008, 10:22:20 AM
Any luck Sleepy?
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 21, 2008, 05:58:28 PM
I am sorry Gilrod,
time ran short suddenly and Oscon is in the works right now for me.

I am going to try and run some tests to see what I can't get fixed up today..

Though during my first test that only had a few messages the loop problem didn't occur. So I don't know if its just an issue with the amount of messages there are.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 23, 2008, 03:24:24 PM
I take it you've not had any time Sleepy?
Title: Re: Converting from YaBB 2.2
Post by: ThorstenE on July 23, 2008, 03:55:11 PM
from another post:

Currently I am in the middle of oscon (I am typing from the show room floor right now), so I don't got time at the moment to program something up that might work.
he is back soon i think ;)
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 23, 2008, 04:05:11 PM
I have no idea what oscon is?!??
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 23, 2008, 11:34:01 PM
http://www.simplemachines.org/community/index.php?topic=248682.0

Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 27, 2008, 11:44:19 PM
Gilrod,

Just so you dont think I forgot.

I found a bug bug in part two of the topics conversion which may have been part of these issues. It was trying to drop the tempid columns to early or never get to them.
I changed some code and it made it through.
Its currently working on posts.. Will let you know once it finishes (hope it finishes tonight otherwise I start over tomorrow).


Edit, also just found one in the second part of post conversion. Which is where I think we where currently having issues.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on July 29, 2008, 04:00:55 PM
Cool :-)

Let me know how you get/got on.

I'll be on MSN if you sign in
Title: Re: Converting from YaBB 2.2
Post by: SleePy on July 31, 2008, 09:39:49 PM
Do you want to try it again?

So far I have got it through topic and most of post. But there doesn't seem to be any errors occurring that I can see of so far. Its been running since a little after noon. Its just taking a while (Note for me its almost 7 pm).
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on August 01, 2008, 04:55:26 AM
Will give it a go...
Title: Re: Converting from YaBB 2.2
Post by: SleePy on August 01, 2008, 07:48:44 PM
/me crosses his fingers for good luck.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on August 02, 2008, 05:12:03 PM
D'oh!!

Code: [Select]
Converting polls and poll choices (part 2)... Successful.
Converting poll votes... Unsuccessful!
This query:

    INSERT IGNORE INTO `tnmsv3`.smf_log_polls
    (ID_POLL, ID_MEMBER, ID_CHOICE, tempID)
    VALUES ('0', '1605', '0', '0'),
    ('0', '1464', '0', '0'),
    ('0', '1538', '0', '0'),
    ('0', '1589', '0', '0'),
    ('0', '996', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '301', '0', '0'),
    ('0', '787', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '1714', '0', '0'),
    ('0', '1087', '0', '0'),
    ('0', '686', '0', '0'),
    ('0', '1042', '0', '0'),
    ('0', '1109', '0', '0'),
    ('0', '1042', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '1109', '0', '0'),
    ('0', '533', '0', '0'),
    ('0', '301', '0', '0'),
    ('0', '988', '0', '0'),
    ('0', '1464', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '1632', '0', '0'),
    ('0', '1714', '0', '0'),
    ('0', '1802', '2', '0'),
    ('0', '1464', '0', '0'),
    ('0', '787', '0', '0'),
    ('0', '1589', '0', '0'),
    ('0', '1042', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '1109', '0', '0'),
    ('0', '1405', '0', '0'),
    ('0', '698', '0', '0'),
    ('0', '533', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '0', '1', '0'),
    ('0', '58', '1', '0'),
    ('0', '1048', '2', '0'),
    ('0', '1280', '2', '0'),
    ('0', '544', '0', '0'),
    ('0', '143', '0', '0'),
    ('0', '265', '1', '0'),
    ('0', '0', '3', '0'),
    ('0', '1072', '0', '0'),
    ('0', '1173', '5', '0'),
    ('0', '1176', '1', '0'),
    ('0', '1908', '1', '0'),
    ('0', '1351', '0', '0'),
    ('0', '1746', '0', '0'),
    ('0', '727', '1', '0'),
    ('0', '154', '4', '0'),
    ('0', '0', '0', '0'),
    ('0', '1782', '0', '0'),
    ('0', '160', '0', '0'),
    ('0', '1377', '2', '0'),
    ('0', '1270', '0', '0'),
    ('0', '1170', '0', '0'),
    ('0', '1171', '2', '0'),
    ('0', '0', '1', '0'),
    ('0', '0', '1', '0'),
    ('0', '1441', '2', '0'),
    ('0', '1779', '5', '0'),
    ('0', '447', '2', '0'),
    ('0', '0', '3', '0'),
    ('0', '1851', '1', '0'),
    ('0', '1650', '1', '0'),
    ('0', '0', '2', '0'),
    ('0', '509', '0', '0'),
    ('0', '1094', '4', '0'),
    ('0', '110', '2', '0'),
    ('0', '1753', '2', '0'),
    ('0', '850', '1', '0'),
    ('0', '1073', '1', '0'),
    ('0', '436', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '1042', '0', '0'),
    ('0', '116', '0', '0'),
    ('0', '301', '0', '0'),
    ('0', '1392', '0', '0'),
    ('0', '787', '0', '0'),
    ('0', '988', '0', '0'),
    ('0', '0', '0', '0'),
    ('0', '1834', '0', '0'),
    ('0', '1087', '0', '0'),
    ('0', '1464', '0', '0'),
    ('0', '1538', '0', '0'),
    ('0', '1195', '0', '0');

Caused the error:

    Unknown column 'tempID' in 'field list'
Title: Re: Converting from YaBB 2.2
Post by: SleePy on August 05, 2008, 04:34:30 PM
/me swears he replied to this topic..

Well, Go to the log_polls table and manually create that column. It can be anything that will hold a big value (an int of 10 or a varchar of 255 would do fine).

By the way, thanks for working and helping fix up these converters :)
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on August 06, 2008, 09:40:30 AM
No worries man, I just want away from YABB ASAFP, and this is the best way to go :-)

So purely Selfish reasons ;-)
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on August 11, 2008, 04:27:41 PM
Right seems there is a problem ...

http://***.com/convert.php?step=1&substep=56500&cstep=18&start=0

It stops there, however it does error out the browser simply reports "done"

Quote
Converting...
Converting poll votes... Successful.
Recalculating forum statistics...

Am thinking of giving you direct FTP access to my server so you can test on it directly, what do you think?

Stew
Title: Re: Converting from YaBB 2.2
Post by: SleePy on August 11, 2008, 07:33:20 PM
Give it a little time, this is the finishing part. It should be refreshing soon.
If I remember right this is the part I hate to wait the longest on. Its because I couldn't tweak any part of that conversion since its built into the convert.php :| (Though I wonder if I can supply it settings).
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on August 11, 2008, 08:11:01 PM
hmmm just looked again and it has not moved on in the slightest... :-/

will leave it running overnight but I do think it's died.
Title: Re: Converting from YaBB 2.2
Post by: SleePy on August 11, 2008, 10:47:11 PM
Is the server reporting any usage? Such as php, mysql and others taking up processes?
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on August 12, 2008, 02:40:32 AM
Checked again...

Definitely dead, oh and no resource usage... Typically.
Title: Re: Converting from YaBB 2.2
Post by: SleePy on August 12, 2008, 01:16:31 PM
Well that stinks. It is the very last step :(

Does the forum work ok though? You might just need to run a few commands from the Admin panel in SMF to do most of the work it would of done.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on August 13, 2008, 04:24:24 PM
Hmmmm

I think I might be looking at a total reinstall...

I've just entered the URL and for some inane reason my apache server is taking over 900MB of ram, scratch that 1.3GB of ram, then it drops to normal sizes and the browser reports "Done" nothing else...

:-/

Looking at the DB via Mysql5 admin it reports to being ok....

Am totally confused now.
Title: Re: Converting from YaBB 2.2
Post by: Gilrod on August 17, 2008, 03:19:26 PM
Sleepy, where did we get to?!
Title: Re: Converting from YaBB 2.2
Post by: SleePy on August 18, 2008, 12:31:12 AM
I believe you contacted me on msn and we worked into getting into the admin panel and where running the find and repair errors tools?

Title: Re: Converting from YaBB 2.2
Post by: Gilrod on August 18, 2008, 03:41:59 PM
yeah that was it... Give me a shout on MSN next time you are on.
Title: Re: Converting from YaBB 2.2
Post by: NemesisNG on August 25, 2008, 12:14:35 PM
Have used this convertor today for the first time.

I have used the file from the sticky topic, with the slight modification in this topic a few posts above to get it working.

Everything has gone through as planned, but I've lost the registered date for all members and I've lost the time stamp for all PM's.

Apart from that it's sweet!

Many, many thanks!

Nick
Title: Re: Converting from YaBB 2.2
Post by: NemesisNG on September 14, 2008, 07:33:51 PM
Hoped there would have been some progress on this...

 ???

Nick

Title: Re: Converting from YaBB 2.2
Post by: SleePy on September 15, 2008, 01:06:09 AM
I have rewrote the yabb 2.2 converter. So far both me and Gilrod have had successful results from the sounds of it (I went offline when he made the change for a minor bug and was running the converter again). We are both using the same yabb 2.2 data though so it doesn't help to much :P

If you want to try it, I will send you the file. I would highly recommend reinstalling SMF before you try this new converter as it operates in a new manner that the old converter did not, so this way it just will clean up anything that the old converter might of broke up.

I think I also got the pms outbox thing sorted. If I didn't I kept a second unused converter step that will dedicate to doing this properly :D
Title: Re: Converting from YaBB 2.2
Post by: NemesisNG on September 16, 2008, 07:43:28 AM
Would be quite happy to test this new version out and report back.

I've got a full yabb backup I'm converting from so can do a fresh smf at the same time on the sandbox site.

Nick
Title: Re: Converting from YaBB 2.2
Post by: SleePy on September 16, 2008, 05:01:38 PM
Sent a pm.

If all goes good for you as well, then I think I will post up the beta file for public testing :)
Title: Re: Converting from YaBB 2.2
Post by: dontshoot on September 16, 2008, 05:44:14 PM
Could i get a copy. i finally got mysql for my forums and would like to move on from yabb.
Title: Re: Converting from YaBB 2.2
Post by: SleePy on September 16, 2008, 06:24:53 PM
sent you a pm.
Title: Re: Converting from YaBB 2.2
Post by: dontshoot on September 17, 2008, 09:03:57 PM
Worked great! It hung a little at the end when it was cleaning installation. But otherwise works fine. Only thing that didn't transfer over were the pm's. but i don't mind. (They needed to be cleaned up anyway.) and Post count based groups  Required posts reset to 0 but that was a 5 minute fix

Once it finished i ran "Find and repair any errors." "Recount all forum totals and statistics." in Forum Maintenance. and everything important transfer d over.
(members, post, member groups, boards and posts)

Just wanted to say thank you. Yabb was great for a long time. But its was defiantly time to upgrade. it came down to smf or phpbb. You pretty much know who won that. =)
Title: Re: Converting from YaBB 2.2
Post by: SleePy on September 17, 2008, 10:33:00 PM
Yea I was told pms where not converting. :P

Required posts for what? To be in the post count group?

Edit, I think I fixed the pms not converting if you want to try it again. Although it sounds like you are happy with them not converting :D
Title: Re: Converting from YaBB 2.2
Post by: dontshoot on September 19, 2008, 03:42:48 AM
yeah i dont mind the pm's being wiped. i glad it was. maybe you should keep that as a optional download for people that what the pm's wiped.

What i was talking about the form rank. Like 0 post = Newbie. 50 post = whatever then 100 posts and so on. They all were rest to 0 posts. but it took me only a few minutes to fix it.

thanks again.

now i gotta find out why SimplePortal blocks are all weird sizes in ie but fine in firefox.  :P
Title: Re: Converting from YaBB 2.2
Post by: SleePy on September 20, 2008, 11:24:51 PM
Do you have a sample membergroups.txt file I can look at? This files is in the vars directory. You can send it how ever :)

I did update the yabb 2.2 beta topic btw.
http://www.simplemachines.org/community/index.php?topic=249777

So anyone wanting to try the yabb 2.2 converter is welcome
Title: Re: Converting from YaBB 2.2
Post by: dontshoot on September 21, 2008, 06:04:33 PM
sure, no problem. ill pm it to you.
Title: Re: Converting from YaBB 2.2
Post by: SleePy on September 22, 2008, 12:16:59 AM
Ok thanks. I believe it is now fixed in my sources :)
Seems like it wasn't using the right match string to get the post group info.
Title: Re: Converting from YaBB 2.2
Post by: AzJose on September 22, 2008, 08:38:22 PM
When I run the yabb22_to_smf.php I get nothing back, just a blank screen.

I have both the convert.php and yabb22_to_smf.php in the /smf folder

Any thoughts? Thanks.
Title: Re: Converting from YaBB 2.2
Post by: SleePy on September 22, 2008, 09:48:26 PM
Updated Converters List & Support Topics (http://www.simplemachines.org/community/index.php?topic=140741.0)
 
Have you tried using the convert.php from that file.
Title: Re: Converting from YaBB 2.2
Post by: AzJose on September 22, 2008, 11:04:01 PM
Ok, I got the one on the very bottom, I was using the one in the zip.

Gonna search out some more, but now I get this..

Converting...
Unsuccessful!
This query:
CREATE TABLE `db_atr_joomla`.smf_convert (
real_id TINYTEXT NOT NULL ,
temp TINYTEXT NOT NULL ,
type TINYTEXT NOT NULL
) CHARACTER SET utf8 COLLATE utf8_general_ci;
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 'COLLATE utf8_general_ci' at line 5
Title: Re: Converting from YaBB 2.2
Post by: ThorstenE on September 23, 2008, 01:18:46 AM
which MySQL version are you using? this error appears when trying to convert with UTF-8 as character set and using MySQL 4.0 or earlier versions (they don't support UTF-8)..

try converting your forum without UTF-8
Title: Re: Converting from YaBB 2.2
Post by: AzJose on September 23, 2008, 01:36:54 AM
Yes, the SQL is 4.0.21

When the convert loads, I fill in the paths and sql password. I leave the default character set to ISO-8859-1. And I still get the same error. Is there something in the php files I need to tweak?

Title: Re: Converting from YaBB 2.2
Post by: ThorstenE on September 23, 2008, 01:50:21 AM
edit the yabb22_to_smf.php and find
Code: [Select]
) CHARACTER SET utf8 COLLATE utf8_general_ci");replace it with
Code: [Select]
)");then save the file and restart the conversion.
Title: Re: Converting from YaBB 2.2
Post by: AzJose on September 23, 2008, 02:19:45 AM
I must be going blind, I cannot find that bit of code at all.

Ok, I am blind, there was another version of the yabb2_to_smf.php I found in the forums. Fixed that.

Now I get another issue. Guess I am just a problem child.  ;) BTW I am using yabb 2.2.2 so dunno if that is gonna make an issue as well.

Successful.
Converting membergroups... Unsuccessful!
This query:
REPLACE INTO `db_atr_joomla`.smf_membergroups
(id_group, group_name, online_color, min_posts, stars)
VALUES (2, SUBSTRING('Global Moderator', 1, 80), SUBSTRING('olive', 1, 20), '-1', SUBSTRING('#stargmod.gif', 1, 255)),
(3, SUBSTRING('Moderator', 1, 80), SUBSTRING('green', 1, 20), '-1', SUBSTRING('#starmod.gif', 1, 255)),
(1, SUBSTRING('Admin', 1, 80), SUBSTRING('blue', 1, 20), '-1', SUBSTRING('#staradmin.gif', 1, 255));
Caused the error:

Unknown column 'group_name' in 'field list'
Title: Re: Converting from YaBB 2.2
Post by: SleePy on September 23, 2008, 02:39:33 PM
Which file did you find?
Which file where using? I am guessing the beta version of the yabb 2.2 converter that is released on this board?
Title: Re: Converting from YaBB 2.2
Post by: AzJose on September 24, 2008, 10:06:44 AM
Yes. Using the ones that you guys have lead me towards. Could the 2.2.2 version of yabb I have be causing issues?
Title: Re: Converting from YaBB 2.2
Post by: SleePy on September 24, 2008, 02:32:56 PM
Does this one work then?
Title: Re: Converting from YaBB 2.2
Post by: AzJose on September 24, 2008, 03:00:44 PM
Get this now.  :o

Converting...
Unsuccessful!
This query:
;
Caused the error:

Query was empty
Title: Re: Converting from YaBB 2.2
Post by: SleePy on September 24, 2008, 03:31:42 PM
Alright then, This one should hopefully work. If not then something else has gone amiss.
Title: Re: Converting from YaBB 2.2
Post by: AzJose on September 24, 2008, 03:40:46 PM
Where is the beer/cheers smiley??  ;D You guys rock!

Converting...
Recalculating forum statistics... Successful.
Conversion Complete
Congratulations, the conversion has completed successfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.

Title: Re: Converting from YaBB 2.2
Post by: pikarl on February 26, 2009, 12:37:12 PM
Hi,

its been a longer time after the last posts in this tread. Now I read all of them and did not find my problem. Here it comes:

Those are my error messages:

Quote
Converting personal messages... Successful.
Converting boards and categories...
Notice: Undefined index: iaf in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: raumfahrer.net in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: adminforum in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 11 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 1 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 10 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 6 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: fragenastro in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: technikastro in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: news in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: baustelle in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: intern in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: papierkorb in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: rn_redaktion in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 4 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 5 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 8 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: fragenraumfahrt in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: visionen in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652

Notice: Undefined index: 7 in /srv/www/vhosts/raumfahrer.net/httpdocs/yabbtest/yabb2_to_smf.php on line 652
Successful.
Converting mark read data... Unsuccessful!
This query:

   INSERT INTO `raumcon`.log_boards
   (logTime, ID_MEMBER, ID_BOARD)
   VALUES ('1235498694', '60', '17'),
   ('1235331378', '60', '18'),
   ('1235491873', '60', '5'),
   ('1234375478', '60', '8'),
   ('1235484928', '60', '20'),
   ('1235496619', '60', '16'),
   ('1231120332', '60', '11'),
   ('1235041315', '60', '6'),
   ('1235149001', '60', '9'),
   ('1234375652', '60', '4'),
   ('1235462077', '60', '12'),
   ('1235438229', '60', '7'),
   ('1234802755', '60', '13'),
   ('1235353186', '60', '19'),
   ('1235124657', '60', '14'),
   ('1235414426', '60', '15');

Caused the error:

   Unknown column 'logTime' in 'field list'

I also had a look at the newly filled smf attachment folder. Those 1.2 GB (19000+ files!) look like included pictures which are just embedded from external servers. They should stay there.

I appreciate any comments. :D
Title: Re: Converting from YaBB 2.2
Post by: ThorstenE on February 26, 2009, 01:45:24 PM
you used the wrong version from our YaBB converter (yabb2_to_smf.php). use the yabb22_to_smf.php instead.
http://www.simplemachines.org/community/index.php?topic=249777.0

a short note: delete your SMF and re-install it before you convert.  the old converter drops some indexes from the database tables and this is an issue in future use.