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.
Open the .sql file
Find:
ORDER BY ID_MEMBER = 0, dateRegistered;
Replace:
ORDER BY ID_MEMBER, dateRegistered;
That should hopefully allow the script to complete correctly.
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!
Ahh so a new version of YaBB is out. Need to look into it :).
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'
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
Change
ORDER BY LENGTH(code) DESC;
to
ORDER BY code DESC;
Edit the convert.php and yabb21_to_smf.php.
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'
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?
Quote from: 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.
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!
Heh. The 2.1 converter takes care of the duplicate column name and so on.
Would it be possible to create a YaBB 2.2 converter to SMF 1.1.4? Thanks again.
Yea it would be possible? Can you please give the 2.1 converter a try and see if that works?
Just tried it and I got a load of display name errors appearing as guests. See thread in this forum.
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
Quote from: 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
Be sure to try out Jay's new test:
http://www.simplemachines.org/community/index.php?topic=220575.msg1414829#msg1414829
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?
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.
Quote from: 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.
Okay, thanks mate. I appreciate it, and look forward to it. :)
Any news on this?
No news. I've been pretty busy with other things :(.
Quote from: JayBachatero on February 10, 2008, 04:35:42 PM
No news. I've been pretty busy with other things :(.
No worries.
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?
id you get any other errors?
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.
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.
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 ...
Converting...
Converting membergroups... Successful.
Converting members...
In the Browser status line it says "Done" this is in IE and FF2/3 any ideas?!
Stewart
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 :|
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.
QuoteI'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:
/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
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.
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.
Interesting, well 1 of the settings paths.pl was wrong, fixed that and here's what I get...
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?
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:
'gender' => $userData[11],
replace:
'gender' => (int) $userData[11],
That should hopefully force it to be cast as an integer and satisfy the database.
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 ..
'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? 1 : ($data['gender'] == 'Female' ? 2 : 0)) : '',
'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.
Here's my own member info details...
### 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',""
Right after some investigating the following lines in yabb21_to_smf.php cause the first set of problems ...
'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 ...
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 ...
'fromName' => substr(htmlspecialchars($userData[$i][0]), 0, 255),
The above is the item that references the "From user" is the
- after $userData the reference to the first entry in the YaBB data? if so it's actually the time stamp.
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
change:
'gender' => isset($data['gender']) ? ($data['gender'] == 'Male' ? 1 : ($data['gender'] == 'Female' ? 2 : 0)) : '',
to
'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?
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"
Try changing this line.
'dateRegistered' => parse_time($data['regdate']),
to
'dateRegistered' => (int) $data['regtime'],
That chucked up a MySQL error...
ALTER TABLE `tnmsv3`.smf_members
ORDER BY ID_MEMBER = 0, dateRegistered;
Does one remove the = 0 from the convert.php in that query?
Yea remove the = 0
Ok sorted that one out, next .... :)
Incorrect date value: '' for column 'birthdate' at row 1
Change
'birthdate' => isset($data['bday']) ? ($data['bday'] == '' || strtotime($data['bday']) == 0 ? '0001-01-01' : strftime('%Y-%m-%d', strtotime($data['bday']))) : '',
to
'birthdate' => isset($data['bday']) ? ($data['bday'] == '' || strtotime($data['bday']) == 0 ? '0001-01-01' : strftime('%Y-%m-%d', strtotime($data['bday']))) : '0001-01-01',
Then now this is an issue too..
'lastLogin' => isset($data['lastonline']) ? $data['lastonline'] : '',
giving this error...
Incorrect integer value: '' for column 'lastLogin' at row 1
MySQL must be running in strict mode for all these errors to occur..
That line can be changed to:
'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..
Yeah, Jay and I realised it's a strict mode issue :-)
Typical... the next issue I'm having is this ...
Incorrect integer value: '' for column 'msgtime' at row
During step 4...
Converting personal messages... Unsuccessful!
Yea I talked to him via IM and MySQL is running in strict mode. The converter needs to be updated to support strict mode.
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
No problems man, am just sat on my sofa watching sh!t TV ;-)
That script doesn't give any output, you did something wrong I think :)
Would it be quicker to do this via IM ?
oops,
I didn't even check for syntax errors.
Fixed in this one
Morning Gents,
Sleepy, here's the latest error :)
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
Ah dang.
Find:
'temp_filename' => "ADD COLUMN temp_filename tinytext NOT NULL default ''",
Replace:
'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.
Got another for you ...
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
Did the changes we made over MSN get you any further since I last seen you?
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 ...
'temp_filename' => "ADD COLUMN temp_filename tinytext(6) NOT NULL default ''",
to this ...
'temp_filename' => "ADD COLUMN temp_filename tinytext(6) NOT NULL",
Stew.
tinytext fields have a predefined size. You can't specify a size for it unless it's a varchar column.
'temp_filename' => "ADD COLUMN temp_filename tinytext NOT NULL",
And the next step ...
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
Change
'smileysEnabled' => empty($message[9]),
to
'smileysEnabled' => empty($message[9]) ? '0' : '1',
Sleepy, after leaving it running for like 13 hours it's still going and the step amount doesn't look right ...
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...
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 ...
Converting...
Converting posts (part 2)...
Stew
Quote from: Gilrod on June 27, 2008, 03:28:00 AM
The status bar is saying "Done" and nothing is happening at all, also the screen layout is different...
This is all it says ...
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.
If I have some time tonight I'll try and take a look into this issue.
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...
Ok so keep us updated.
Something is definitely wrong with step 11...
http://*************/convert.php?step=1&substep=2522500&cstep=11&start=0
Remember we only have ~940k posts
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?
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
Ok.. Well maybe its possibly looping due to the -1 past time it gets..
Find (We already changed this once):
if ($_GET['substep'] != 0)
Replace:
if ($_GET['substep'] > 0)
Balls...
FAIL....
Are all these changes just to make the convert be strict compliant?
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.
There is no file fix for YaBB 2.1 to 2.2 so that shouldn't be an issue.
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
You can upload it to your site and PM me the link to the file.
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.
Uploading now, will be in touch soon.
Jay, did you manage to download the data from that link I MSN'd you?
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:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi205.photobucket.com%2Falbums%2Fbb58%2Fsanjosebass%2FPicture9.png&hash=03233ad9592c2f0cfe944e51d361a051b96d3f8e)
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
Try this attached file.
Thanks SleePy.
Any idea on how long it should take to convert 13,000 posts and 300 users?
Actually, I past the Post import and then I hit this error:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi205.photobucket.com%2Falbums%2Fbb58%2Fsanjosebass%2FPicture14.png&hash=86827848d7827511b0f3fb3826af5ee3da901dea)
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
Common conversion errors. (http://www.simplemachines.org/community/index.php?topic=146192.0)
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:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi205.photobucket.com%2Falbums%2Fbb58%2Fsanjosebass%2FPicture2.png&hash=581dc49e682fffe0863dd171d17afaa1d82248ac)
Any ideas?
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.
It may be time to split it up and make a yabb 2.2 converter I think.. Looks like things have changed
Yea I was thinking the same thing. I'm pretty sure other things changed as well. Just haven't come across them.
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!
It's changed a bit - here is a .msg file from my Yabb 2.1 install.
Quoteadmin|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
Quote1212045642|murf|lmartinez|||Re: dawia exceler|1212045642|Hi Len. I still want the reel, but I'm not available on Saturday. Can you ship it? 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. The exceler retails for around $65 I think. |1212045642|0 |76.21.32.102|s|||
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.
Jay - I added the Yabb 2.2 msg file in my previous post as a comparison.
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.
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.
Any luck with my stuff Jay?
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 :(
Quote from: 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 :(
Hey SleePy - will this take care of my PM issues?
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.
Quote from: 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.
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.
Attached is the error I ran into...
Quotehttp://xxx.xxx.xxx.xxx/convert.php?step=1&substep=1800&cstep=8&start=0
EDIT: Added the step URL above
OOps,
Thats what happens when you copy and paste ;D
Find:
while ($row = mysql_fetch_assoc($result))
convert_query("
DELETE {$to_prefix}log_topics
SET ID_TOPIC = $row[ID_TOPIC]");
Replace:
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.
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?
Find:
'msgtime' => empty($userData[$i][6]) ? (int) $userData[$i][6] : '0',
Replace:
'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 :)
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
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.
heh, got this ...
QuoteConverting...
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
Quote from: Gilrod on July 12, 2008, 06:07:03 AM
heh, got this ...
QuoteConverting...
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....
try the attached version..
What did you change? as it seems to be doing a lot of thinking.
i changed
while ($row = mysql_fetch_assoc($result))
convert_query("
DELETE {$to_prefix}log_topics
SET ID_TOPIC = $row[ID_TOPIC]");
mysql_free_result($result);
to
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
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)
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 :)
well it doesn't work...
After re-doing it all from scratch I just get a "done" in the status bar during topics (2)
:(
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.
ah balls, I closed it down... will restart it now and report back in like 4hrs...
Stew
Quotehttp://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!!!!
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.
27635 - Topics....
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.
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.
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.
There was no continue button... at all... :(
I'll restart from scratch.
Quote from: SleePy on July 12, 2008, 04:16:48 PM
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
while ($row = mysql_fetch_assoc($result))
convert_query("
UPDATE {$to_prefix}log_topics
SET ID_TOPIC = $row[ID_TOPIC]");
mysql_free_result($result);to
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?
Sleepy - FYI I used the version of the script in the stickied topic...
QuoteConverting 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
Oops
Find:
while ($row = mysql_fetch_assoc($result))
convert_query("
DELETE {$to_prefix}log_topics
WHERE ID_TOPIC = $row[ID_TOPIC]");
Replace:
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.
Interestingly, I've let it continue from the error mentioned previously...
However I've got the following url during "Posts (Part 2)"
Quotehttp://tnmsv3.XXXXXXXXXXX.com/convert.php?step=1&substep=0&cstep=11&start=0
Should the substep be changing as with the other steps?
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 :|
Well the data I rar'd up for Jay is still available for download, but it's 100MB ;-)
hmmm getting this now ...
QuoteConverting...
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
Gilrod, please attach your version of yabb22_to_smf.sql
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.
Any luck Sleepy?
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.
I take it you've not had any time Sleepy?
from another post:
Quote from: SleePy on July 23, 2008, 03:01:36 PM
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 ;)
I have no idea what oscon is?!??
http://www.simplemachines.org/community/index.php?topic=248682.0
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.
Cool :-)
Let me know how you get/got on.
I'll be on MSN if you sign in
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).
Will give it a go...
/me crosses his fingers for good luck.
D'oh!!
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'
/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 :)
No worries man, I just want away from YABB ASAFP, and this is the best way to go :-)
So purely Selfish reasons ;-)
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"
QuoteConverting...
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
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).
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.
Is the server reporting any usage? Such as php, mysql and others taking up processes?
Checked again...
Definitely dead, oh and no resource usage... Typically.
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.
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.
Sleepy, where did we get to?!
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?
yeah that was it... Give me a shout on MSN next time you are on.
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
Hoped there would have been some progress on this...
???
Nick
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
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
Sent a pm.
If all goes good for you as well, then I think I will post up the beta file for public testing :)
Could i get a copy. i finally got mysql for my forums and would like to move on from yabb.
sent you a 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. =)
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
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
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
sure, no problem. ill pm it to you.
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.
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.
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.
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
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
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?
edit the yabb22_to_smf.php and find
) CHARACTER SET utf8 COLLATE utf8_general_ci");
replace it with
)");
then save the file and restart the conversion.
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'
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?
Yes. Using the ones that you guys have lead me towards. Could the 2.2.2 version of yabb I have be causing issues?
Does this one work then?
Get this now. :o
Converting...
Unsuccessful!
This query:
;
Caused the error:
Query was empty
Alright then, This one should hopefully work. If not then something else has gone amiss.
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.
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:
- trying to convert YaBB 2.2.1 to SMF 1.1.0
- is converting like hell for messages
- then he´s putting out some error messages for unsuccessful boards and categories (and he´s not converting them)
- finally he is accumulating 1.2 GB+ in the attachments folder. in my yabb-attachments-folders are just 11 MB (!)
Those are my error messages:
QuoteConverting 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
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.