Software: IPB
Version: 2.1.x
This is the official support topic for IPB 2.1.x converter. Use this topic to ask for support for this converter.
Changelog
! The password salt was being replace with an empty string causing passwords to be incorrect. (ipb21_to_smf.sql)
! Replace \n with <br /> for the maintenance mode message. (ipb21_to_smf.sql)
! Cast width and height as a string for the database insert when converting attachments. (ipb21_to_smf.sql)
! When converting attachments add the width and height for images. (ipb21_to_smf.sql)
convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
[Scoobydoo_voice]Rutro Raggy[/Scoobydoo_voice]- :o
So lets say I've just used the convert.php and ipb22_to_smf.sql files to convert IPB 2.1.7... Have I just done a bad thing? That was a silly mistake on my part. Should I wipe it and start over? I swear I thought we were using IPB 2.2xx... If it's a bad thing, is there a way where I don't have to wipe the db and start from scratch?
You should be able to convert w/o having to erase everything.
Quote from: JayBachatero on February 15, 2007, 10:26:44 AM
You should be able to convert w/o having to erase everything.
Hi Juan- Okay I started over from scratch and installed and configured SMF 1.1.2. Next I copied * convert.php (63.03 KB - downloaded 123 times.) « Last Edit: January 28, 2007, 04:34:18 PM by JayBachatero » and * invision21_to_smf.sql (33.89 KB - downloaded 7 times.) « Last Edit: February 12, 2007, 02:13:07 AM by JayBachatero » and ran the conversion. I'm converting from IPB 2.1.7...
Here are the results:Avatars: do not show up except for the ones that were linked to url's.
Signatures: The code in the signatures did not convert and is visible. (ex-
[size=]"Smart People Play Smart .....Stupid people suck! Don't play stupid". Me[/size]
Images: Images in the posts seem to have converted properly (I checked a few).
Links: Email links in the posts seem to have converted properly.
Hyperlinks in the posts did not convert at all. There is just a single space wherever a link was.
Hyperlinks within signatures did not convert at all. Same as post hyperlinks.
Permissions: Basically, none of the permissions came across properly but I think that may be more to do with the way they may have been set up on IPB; possibly in a non-IPB standard manner.
Quick update:
I decided to check the code for one of the signatures in IPB and it looks like this:
[size=3][font=Comic Sans Ms]"Smart People Play Smart .....Stupid people suck! Don't play stupid". Me[/font][/size]
Then I looked at the same signature in SMF after the conversion and it looks like this:
[size=][font=Comic Sans Ms]"Smart People Play Smart .....Stupid people suck! Don't play stupid". Me[/font][/size]
I checked a few more and it looks like all numbers were dropped. Hope this gives some clues.
Thanks!
Ok try this file. Let me know how it goes.
Quote from: JayBachatero on February 16, 2007, 06:36:01 PM
Ok try this file. Let me know how it goes.
I'm going to try it right now. Stand by for a report....
And thanks for sticking with me on this!
Oh- which version of the convert.php do you want me to use with this?
The same one that you are using now.
Okay- LOTS better! I think we're down to just a couple of things.
First the good stuff:
All links are now showing and working now.
Stuff that still needs to be fixed:
The numbers are still being stripped out of the [size=] and [attachmentid=796] shows up when a picture is uploaded. The good news is that the attachment is there.
Avatars are still not showing up
And I'll slide one in that I haven't mentioned yet- The PM count imports but you can't see the actual PM's.
Almost there! Thanks.
Damn it. I'll look at the size issue. Is this with the sig or post? About the attachmentid thats for the inline images. SMF doesn't support that. I guess I can make the converter remove that. I'll look into the avatar problem as well. Umm gotta look into the PM's as well >_<.
Ok this should fix the size issue and PM's. Let me know. The PM fix was made by Sarke a few days ago for the 2.0 converter.
Okay- going to try it now. Thanks.
Hey okay- the messages are working now. Great! However the size thing still isn't.
PS- and <span> type tags are showing too.
Can you please get me an example of the post with the error? But get the post form the database cause IPB changed the [tag] to html tags.
Here's his entire signature copied out of the database table:
[size=]Bill Smith[/size]<br />[size=]EL CONQUISTADOR[/size]<br /><br /><br />CorpsVets 2003,2004,2006, 2007<br />Nite Express 1995-1996<br />Expressions 1989-1991<br />Suncoast Sound 1985-1986(no I didn't march-that would be cheating)<br />LA. Southernaires 1981-1982<br />Bleu Raeders 1980<br /><br />[size=][font=Comic Sans Ms]"Smart People Play Smart .....Stupid people suck! Don't play stupid". Me[/font][/size]<br />I believe in God.....I just happen to spell it "NATURE". Frank Lloyd Wright
I'm on AIM as rjscott9999 if it's easier.
I meant taken straight from the database. Not by editing a post. The original post from IPB's tables.
Quote from: JayBachatero on February 16, 2007, 11:43:19 PM
I meant taken straight from the database. Not by editing a post. The original post from IPB's tables.
Yes- I grabbed that signature from the database.
Quote from: rjscott on February 16, 2007, 09:21:01 PM
Here's his entire signature copied out of the database table:
[size=]Bill Smith[/size]<br />[size=]EL CONQUISTADOR[/size]<br /><br /><br />CorpsVets 2003,2004,2006, 2007<br />Nite Express 1995-1996<br />Expressions 1989-1991<br />Suncoast Sound 1985-1986(no I didn't march-that would be cheating)<br />LA. Southernaires 1981-1982<br />Bleu Raeders 1980<br /><br />[size=][font=Comic Sans Ms]"Smart People Play Smart .....Stupid people suck! Don't play stupid". Me[/font][/size]<br />I believe in God.....I just happen to spell it "NATURE". Frank Lloyd Wright
Juan- did this help you? I grabbed it right from the database table.
I used the convert with the sql.. Im getting 2 lines. convert sucessful? But nothing happans to my smf? not topic/ categories nothing went to my smf... even though it says successful.
My ibp is uner /forum while smf is under /smf
Please help me
OK...I'm a bit confused. Where do I upload converter.php to?? My main IPB directory?
Quote from: techbot on February 20, 2007, 09:15:54 PM
OK...I'm a bit confused. Where do I upload converter.php to?? My main IPB directory?
No. You upload convert.php to the directory in which you installed your Simple Machines Forum. You also upload the sql file to the same place.
ahhh gotcha. thanks for the fast reply! lemme try this out...
so i do a full install of my smf forum, then upload my IPB sql file into the SMF database and run the converter? Sorry for the questions, this is my first time on SMF
Quote from: techbot on February 20, 2007, 09:22:19 PM
ahhh gotcha. thanks for the fast reply! lemme try this out...
so i do a full install of my smf forum, then upload my IPB sql file into the SMF database and run the converter? Sorry for the questions, this is my first time on SMF
No. When you run the convert.php (www.yoursite.com/forums/convert.php or something) just follow the directions. You will be asked for the path to you IPB forum and the converter will grab what it needs, leaving your IPB intact. Good luck.
I'm getting the following message
QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: SELECT command denied to user 'trampledelight12'@'62.214.98.165' for table 'ibf_members'
Quote from: techbot on February 21, 2007, 12:28:39 AM
I'm getting the following message
QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: SELECT command denied to user 'trampledelight12'@'62.214.98.165' for table 'ibf_members'
I'm not well versed enough to help at this point. I looks like you may not have permission to access your IPB database. Someone else will have to jump in and give you advice on this message.
Quote from: rjscott on February 19, 2007, 01:21:56 PM
Quote from: rjscott on February 16, 2007, 09:21:01 PM
Here's his entire signature copied out of the database table:
[size=]Bill Smith[/size]<br />[size=]EL CONQUISTADOR[/size]<br /><br /><br />CorpsVets 2003,2004,2006, 2007<br />Nite Express 1995-1996<br />Expressions 1989-1991<br />Suncoast Sound 1985-1986(no I didn't march-that would be cheating)<br />LA. Southernaires 1981-1982<br />Bleu Raeders 1980<br /><br />[size=][font=Comic Sans Ms]"Smart People Play Smart .....Stupid people suck! Don't play stupid". Me[/font][/size]<br />I believe in God.....I just happen to spell it "NATURE". Frank Lloyd Wright
Juan- did this help you? I grabbed it right from the database table.
Is this from the SMF tables or the IPB table? It has to be from the IPB table.
Quote from: techbot on February 21, 2007, 12:28:39 AM
I'm getting the following message
QuoteSorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: SELECT command denied to user 'trampledelight12'@'62.214.98.165' for table 'ibf_members'
http://www.simplemachines.org/community/index.php?topic=146192.0
Quote from: JayBachatero on February 21, 2007, 10:06:36 AM
Quote from: rjscott on February 19, 2007, 01:21:56 PM
Quote from: rjscott on February 16, 2007, 09:21:01 PM
Here's his entire signature copied out of the database table:
[size=]Bill Smith[/size]<br />[size=]EL CONQUISTADOR[/size]<br /><br /><br />CorpsVets 2003,2004,2006, 2007<br />Nite Express 1995-1996<br />Expressions 1989-1991<br />Suncoast Sound 1985-1986(no I didn't march-that would be cheating)<br />LA. Southernaires 1981-1982<br />Bleu Raeders 1980<br /><br />[size=][font=Comic Sans Ms]"Smart People Play Smart .....Stupid people suck! Don't play stupid". Me[/font][/size]<br />I believe in God.....I just happen to spell it "NATURE". Frank Lloyd Wright
Juan- did this help you? I grabbed it right from the database table.
QuoteIs this from the SMF tables or the IPB table? It has to be from the IPB table.
Whoops- Here's the info from the IPB table:
<!--sizeo:3--><span style="font-size:12pt;line-height:100%"><!--/sizeo-->Bill Smith<!--sizec--></span><!--/sizec--><br /><!--sizeo:2--><span style="font-size:10pt;line-height:100%"><!--/sizeo-->EL CONQUISTADOR<!--sizec--></span><!--/sizec--><br /><br /><br />CorpsVets 2003,2004,2006, 2007<br />Nite Express 1995-1996<br />Expressions 1989-1991<br />Suncoast Sound 1985-1986(no I didn't march-that would be cheating)<br />LA. Southernaires 1981-1982<br />Bleu Raeders 1980<br /><br /><!--sizeo:3--><span style="font-size:12pt;line-height:100%"><!--/sizeo--><!--fonto:Comic Sans Ms--><span style="font-family:Comic Sans Ms"><!--/fonto-->"Smart People Play Smart .....Stupid people suck! Don't play stupid". Me<!--fontc--></span><!--/fontc--><!--sizec--></span><!--/sizec--><br />I believe in God.....I just happen to spell it "NATURE". Frank Lloyd Wright
And here is one from the IPB table with similar and span tag issues:
<span style='font-family:Arial'><br />David M. Lastname, Ph.D., P.E.<br />CorpsVets Executive Director '04-<br />CorpsVets Contra '98-04, '06<br />CorpsVets Euphonium '05<br />CorpsVets Bugle repairman '05-<br />USNA D&B Instructor '93-95<br />Geneseo Knights Contra '82-85<br /><br /></span><br /><!--sizeo:5--><span style="font-size:18pt;line-height:100%"><!--/sizeo--><b><!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->Fund-raise<!--colorc--></span><!--/colorc-->, Fund-raise, <!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->Fund-raise<!--colorc--></span><!--/colorc-->, Fund-raise,<!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->Fund-raise<!--colorc--></span><!--/colorc-->, Fund-raise, <!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->Fund-raise<!--colorc--></span><!--/colorc-->, Fund-raise, <!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->Fund-raise<!--colorc--></span><!--/colorc-->, Fund-raise, <!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->Fund-raise<!--colorc--></span><!--/colorc-->, Fund-raise, <!--coloro:#FF0000--><span style="color:#FF0000"><!--/coloro-->Fund-raise<!--colorc--></span><!--/colorc-->, Fund-raise<br /><!--coloro:#009900--><span style="color:#009900"><!--/coloro-->Recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit<!--colorc--></span><!--/colorc--></b><!--sizec--></span><!--/sizec-->
Ok I'll debug it later on and see what's wrong in the regex.
Quote from: JayBachatero on February 21, 2007, 10:36:51 AM
Ok I'll debug it later on and see what's wrong in the regex.
Thanks- it is very much appreciated. Not entirely the same subject but I still can't figure out why the avatars are not showing up. Links to external avatars work.
hi.... i have a problem T-T When i try to convert from ipb 2.1.7 to smf 1.1.2 i get this....
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Notice: unserialize() [function.unserialize]: Error at offset 5 of 190 bytes in /home/myuser/public_html/convert.php(668) : eval()'d code on line 89
Fatal error: Unsupported operand types in /home/myuser/public_html/convert.php(668) : eval()'d code on line 89
Any ideas? :(
P.S. I dont know if i should have posted here, or in a new topic :S
Quote from: JayBachatero on February 21, 2007, 10:36:51 AM
Ok I'll debug it later on and see what's wrong in the regex.
Quick Note: I copied the signature code from the IPB table and pasted it directly into the SMF table and the signature worked like a charm. Is it possible that the signature table only needs importing and not converting?
Ok try this one. Should fix the size bug.
Dark try that one also. I made a change. Hopefully that fixes the error.
Quote from: JayBachatero on February 21, 2007, 07:04:08 PM
Ok try this one. Should fix the size bug.
Sorry but this one breaks things-
Converting board permissions... Unsuccessful!
This query:
UPDATE `greeneleafad`.smf_boards
SET memberGroups = '0, 10, 11, 24, 25, 26'
WHERE ID_BOARD =;
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 '' at line 3
Ok here.
Quote from: JayBachatero on February 21, 2007, 08:18:34 PM
Ok here.
Wow, that was quick! I'm reinstalling SMF/db so it's nice and fresh. I'll let you know how it goes in a few minutes.
Thanks once again.
hmm here's what I'm getting. seems to be a problem converting the polls
QuoteConverting poll options...
Notice: Array to string conversion in /mounted-storage/home20a/sub001/sc20038-PLDS/www/forums/convert.php(827) : eval()'d code on line 8
Notice: Array to string conversion in /mounted-storage/home20a/sub001/sc20038-PLDS/www/forums/convert.php(827) : eval()'d code on line 8
Unsuccessful!
This query:
INSERT INTO `trampledelight1`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (1, SUBSTRING('What kinds of trample would you like to see more of?', 1, 255), 'Array', 1, 255), 'Array');
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 ''Array')' at line 3
I found and deleted each of the polls from the old forums...now I'm getting the same thing as Dark...
QuoteConverting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Notice: unserialize() [function.unserialize]: Error at offset 5 of 178 bytes in /mounted-storage/home20a/sub001/sc20038-PLDS/www/forums/convert.php(665) : eval()'d code on line 89
Fatal error: Unsupported operand types in /mounted-storage/home20a/sub001/sc20038-PLDS/www/forums/convert.php(665) : eval()'d code on line 89
What version of IPB are you using?
IPB 2.1.4
Quote from: JayBachatero on February 21, 2007, 08:18:34 PM
Ok here.
Okay that fixed the size issue. Now the only thing left is the span issue. The odd thing is that the code doesn't look correct in IPB but it works. Some, but not all of the < and ' are represented by their ascii? codes.
One other thing- our IPB forum is using iso-8859-1. I did not select the utf-8 option when I installed SMF but I can't seem to find a place in the admin panel for seeing which is being used. In any case, I'm wondering if that has anything to do with conversion issues at all.
Quote from: techbot on February 21, 2007, 08:39:06 PM
IPB 2.1.4
I think you might be using the wrong converter. Are you using the converter form this topic?
rjscott try this one.
Quote from: JayBachatero on February 21, 2007, 08:48:56 PM
I think you might be using the wrong converter. Are you using the converter form this topic?
rjscott try this one.
If you mean which convert.php I'm using- I am using the one that you have a link to in your first post in this thread.
Quote from: JayBachatero on February 21, 2007, 08:48:56 PM
I think you might be using the wrong converter. Are you using the converter form this topic?
rjscott try this one.
Ooohhh this one broke all kinds of tag things. Here's what the converted stuff looks like now.
[span style=\'font-family:Arial\']<br />David W. Stollberg, Ph.D., P.E.<br />CorpsVets Executive Director \'04-<br />CorpsVets Contra \'98-04, \'06<br />CorpsVets Euphonium \'05<br />CorpsVets Bugle repairman \'05-<br />USNA D&B Instructor \'93-95<br />Geneseo Knights Contra \'82-85<br /><br />[/span]<br />[size=18pt][b][color=#FF0000]Fund-raise[/color], Fund-raise, [color=#FF0000]Fund-raise[/color], Fund-raise,[color=#FF0000]Fund-raise[/color], Fund-raise, [color=#FF0000]Fund-raise[/color], Fund-raise, [color=#FF0000]Fund-raise[/color], Fund-raise, [color=#FF0000]Fund-raise[/color], Fund-raise, [color=#FF0000]Fund-raise[/color], Fund-raise<br />[color=#009900]Recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit, recruit[/color][/b][/size]
Sorry that wasn't meant for you. It was meant for techbot.
Damn it. Got an example? The sigs with the special chars might have to stay like that :(.
Quote from: JayBachatero on February 21, 2007, 09:19:42 PM
Sorry that wasn't meant for you. It was meant for techbot.
Damn it. Got an example? The sigs with the special chars might have to stay like that :(.
Oh, no problem. I'll run the last one again. :-)
I think it might be a rare case with IPB and having sigs like that so it's not really worth going through all this trouble for a few sigs :(.
Quote from: JayBachatero on February 21, 2007, 09:23:52 PM
I think it might be a rare case with IPB and having sigs like that so it's not really worth going through all this trouble for a few sigs :(.
I agree. I ran the other sql file again and it put things back to where we were with the size tags being fixed. Thanks for all of your help. I really appreciate it. If you have any tips on getting the avatars to show up, or can point me to a thread, I would appreciate it.
Thanks!
Quote from: JayBachatero on February 21, 2007, 08:48:56 PM
I think you might be using the wrong converter. Are you using the converter form this topic?
Edit...
I'm using the one from the converter page http://www.simplemachines.org/download/?converters that says "Invision 2"
Also...I didn't think to mention this...I'm trying to use SMF 1.1.1 instead of 1.1.2
Quote from: rjscott on February 21, 2007, 09:28:06 PM
Quote from: JayBachatero on February 21, 2007, 09:23:52 PM
I think it might be a rare case with IPB and having sigs like that so it's not really worth going through all this trouble for a few sigs :(.
I agree. I ran the other sql file again and it put things back to where we were with the size tags being fixed. Thanks for all of your help. I really appreciate it. If you have any tips on getting the avatars to show up, or can point me to a thread, I would appreciate it.
Thanks!
Is it the uploaded avatars?
Quote from: techbot on February 21, 2007, 09:39:37 PM
Quote from: JayBachatero on February 21, 2007, 08:48:56 PM
I think you might be using the wrong converter. Are you using the converter form this topic?
Edit...
I'm using the one from the converter page http://www.simplemachines.org/download/?converters that says "Invision 2"
Also...I didn't think to mention this...I'm trying to use SMF 1.1.1 instead of 1.1.2
Use the one on this topic.
That's whats confusing me....in the first post I see an sql file and a link that says "convert.php" ... but that link takes me to another thread with converters. When I look through those, it has IPB 1.3.x and 2.2...nothing for 2.1.x
You need the .sql in this topic and the convert.php form the other topic.
OK...now I'm really lost. I've just used the convert.php, i haven't used the sql file. Sorry, I'm used to postnuke and the likes where the sql that they include isn't NEEDED, but you can use it if you like.
Please give me the short dirty version here...I get the sql file from here. I use the convert.php from the other topic?? The IPB 2.2 one?
Ok lets start all over. When you are converting you need two files. A .sql and convert.php. convert.php reads the .sql file and does the conversion. So what you need to do is download http://www.simplemachines.org/community/index.php?action=dlattach;topic=149652.0;attach=27740 and http://www.simplemachines.org/community/index.php?action=dlattach;topic=140741.0;attach=25726. Upload both of them to the SMF dir. Then point your browser to convert.php and follow the steps.
Ok, you are my hero! That one actually worked! :D Thank you :)
Quote from: Dark Shadow MX on February 21, 2007, 10:52:22 PM
Ok, you are my hero! That one actually worked! :D Thank you :)
Yeah, JayBachatero rocks! Great job.
Ok updated the first post with the working version.
Hi! I'm having errors converting..
Do you have a converter for IPB 2.2.1 to SMF 1.1.2? thanks
edit: sorry I only just found out the 2.2.1 converter thanks
Unable to "convert" avatars from IPB 2.1.6 -> SMF 1.1.2, using the .sql and convert.php from this topic.
Repeating error for every avatar file in IPB:
Notice: Undefined variable: oldAvatarDir in x\public_html\convert.php(829) : eval()'d code on line 58
Warning: copy(/x.jpg) [function.copy]: failed to open stream: No such file or directory in x\public_html\convert.php(829) : eval()'d code on line 59
Any ideas, anyone?
did you leaved your IPB installation safe? because if you deleted the IPB files, there's no way to convert the avatars. Everything else doesn't matter as long as you have the SQL File
Yes, of course my IPB installation is intact, otherwise the conversion wouldn't even start.
You using the files form this topic?
As stated above, yes, I'm using the files from this topic.
Quote from: Carello on March 09, 2007, 06:24:04 PM
Yes, of course my IPB installation is intact, otherwise the conversion wouldn't even start.
yes, it would start, mainly because the converter uses the SQL, not the files.
Check where your avatars from your IPB instalation are, it could be the converter looking into a different location
Please correct me if I'm wrong, but the converter looks for the conf_global.php in the IPB installation folder to get database name, MySQL user/pass and table prefixes, doesn't it?
So if the IPB files were deleted, that information would not be available to the converter, and it would not work.
And as far as I can tell, the IPB installation is the standard one, nothing has been changed, user uploaded avatars are in it's default location (/uploads).
I fixed the avatar problem right away simply by copying them manually, I just thought I'd let you know that the converter was unable to do the job, in case the problem should arise again for someone else.
Juan- Not meaning to take a side road but... if I just want to update my already converted forum with new posts from the same IPB forum, which tables would I need to grab info from? Our SMF forum is about to go live and I just need to update the new posts, attachments. I don't want to re-convert because for whatever reason, the permissions, boards, settings didn't convert and had to be done manually. That took hours of work to figure out and I would like to try to avoid doing that again.
Thoughts? Ideas?
I would edit the converter and just leave the topics and messages sections.
Quote from: JayBachatero on March 11, 2007, 02:36:13 PM
I would edit the converter and just leave the topics and messages sections.
You say that sort of like you are talking to someone who knows what they're doing :-) I'll take a look at it but I'm no JayBachatero! LOL
Ok try this. It converts topics, pots attachments and avatars.
I'm trying it now. I'll report back in a few.
Quote from: JayBachatero on March 11, 2007, 02:58:38 PM
Ok try this. It converts topics, pots attachments and avatars.
Converting...
Converting attachments... Successful.
Converting user avatars... Successful.
Recalculating forum statistics... Successful.
Conversion Complete
Okay- question- did the converter grab all posts or just new posts? I ask because I made a test post on IPB before running it and the quotes didn't work. I checked other posts that were already in smf and they are fine.
It grabs all posts. Well it should grab all posts.
Quote from: JayBachatero on March 11, 2007, 03:38:05 PM
It grabs all posts. Well it should grab all posts.
Okay- let me look around some more and I'll report back.
Quote from: JayBachatero on March 11, 2007, 03:38:05 PM
It grabs all posts. Well it should grab all posts.
Okay-I quoted in IPB and ran the converter again. It worked! The only thing that seems to elude the converter all the time is the avatars.
Quote from: rjscott on March 11, 2007, 03:49:51 PM
Quote from: JayBachatero on March 11, 2007, 03:38:05 PM
It grabs all posts. Well it should grab all posts.
Okay-I quoted in IPB and ran the converter again. It worked! The only thing that seems to elude the converter all the time is the avatars.
Oh and it re-imported users into the Regular Members permission group... If it could skip that step... or just import users who signed up in the last 30 days... Yeah, I'm asking too much, aren't I?
Quote from: rjscott on March 11, 2007, 03:53:08 PM
Quote from: rjscott on March 11, 2007, 03:49:51 PM
Quote from: JayBachatero on March 11, 2007, 03:38:05 PM
It grabs all posts. Well it should grab all posts.
Okay-I quoted in IPB and ran the converter again. It worked! The only thing that seems to elude the converter all the time is the avatars.
Oh and it re-imported users into the Regular Members permission group... If it could skip that step... or just import users who signed up in the last 30 days... Yeah, I'm asking too much, aren't I?
You can't really convert the users since the converter truncates the tables.
Understand.
Well once again, I thank you for the great work. I don't understand why the avatars refuse to play nice on my conversion but oh well. I even tried copying them directly into the attachments folder but no joy.
Do you think it has anything to do with the IPB files being encrypted? If so, do you think disabling IPB encryption would show the real names and allow a successful conversion?
Any chance of a script that will turn all topics, all posts, everything as read for everyone? I don't want to shock them too much with having three years worth of 'new' stuff turn up!
Umm make them just do mark all as read when they log in.
Quote from: JayBachatero on March 11, 2007, 05:20:09 PM
Umm make them just do mark all as read when they log in.
Brilliant! LOL
dude, this totally rocks, you saved my butt. Seems like this should get posted to the official converter page, right?
Quote from: superg on April 04, 2007, 02:16:28 PM
dude, this totally rocks, you saved my butt. Seems like this should get posted to the official converter page, right?
I'll be updating the converters in the first page this week :).
I have a problem while trying to download the PHP from http://www.simplemachines.org/community/index.php?topic=140741.0 (no link there woks for me, just sending me to the index page.
I have an 2.1.5 and the Invision 2 Converter form http://www.simplemachines.org/download/?converters led me to the Array error.
Can somebody send me the convert.php file for 2.1.x? Thanks.
P.S. Evertything is OK already. Looks like the differences are in the SQL file and it generally worked with the correct (and attached) SQL.
Hi,
I am doing the conversion and this is the error I got pasted below. I've noticed a few different files to use for the conversion posted in this thread but I want to be sure I get the right one. Could someone please tell me which conversion method will work? This error came from using the one posted here: http://www.simplemachines.org/download/?converters I am using Invision 2 Converter.
Converting poll logs... Unsuccessful!
This query:
INSERT INTO `ez_forum`.smf_log_polls
(ID_POLL, ID_MEMBER)
VALUES ('', '64'),
('', '64'),
('', '64'),
('', '109'),
('', '109'),
('', '109'),
('', '5'),
('', '76'),
('', '76'),
('', '5'),
('', '51'),
('', '5'),
('', '51'),
('', '80'),
('', '76'),
('', '51'),
('', '80'),
('', '80'),
('', '70'),
('', '70'),
('', '70'),
('', '95'),
('', '125'),
('', '125'),
('', '125'),
('', '41'),
('', '41'),
('', '41'),
('', '79');
Caused the error:
Duplicate entry '0-64-0' for key 1
Thanks Dottye for posting that for me, I wasn't able to get into the forums to post this problem. If anyone can help with this I would greatly appreciate it :)
I just tried the sql and converter from this thread and I am still seeing this error:
Converting poll logs... Unsuccessful!
This query:
INSERT INTO `ez_forum`.smf_log_polls
(ID_POLL, ID_MEMBER)
VALUES ('', '64'),
('', '64'),
('', '64'),
('', '109'),
('', '109'),
('', '109'),
('', '5'),
('', '76'),
('', '76'),
('', '5'),
('', '51'),
('', '5'),
('', '51'),
('', '80'),
('', '76'),
('', '51'),
('', '80'),
('', '80'),
('', '70'),
('', '70'),
('', '70'),
('', '95'),
('', '125'),
('', '125'),
('', '125'),
('', '41'),
('', '41'),
('', '41'),
('', '79');
Caused the error:
Duplicate entry '0-64-0' for key 1
I've got the same. Just opened the SQL file, deleted the part about the pool logs, uploaded it and reran the convertor (I know I'm losing part of the info, but not an essential one, so I'm happy).
Use the file in the first post.
I went through the process and got this
Converting...
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Notice: unserialize(): Error at offset 5 of 178 bytes in /home/content/s/t/i/stinger/html/smf/convert.php(671) : eval()'d code on line 89
Fatal error: Unsupported operand types in /home/content/s/t/i/stinger/html/smf/convert.php(671) : eval()'d code on line 89
What should I do?
Using the convert file from this topic?
Beforehand I beg pardon for a bad angiyskiy language. I use machine translator.
Problem : at converting of IPB 2.1.4 -> SMF 1.1.2 turns out error.
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options...
Notice: Undefined index: question in /home/altaisat/public_html/forums/test/convert/convert.php(827) : eval()'d code on line 11
Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)... Successful.
Converting topic notifications... Unsuccessful!
This query:
INSERT INTO `altaisat_ipb`.smf_log_notify
(ID_MEMBER, ID_TOPIC)
VALUES ('262', '7'),
('5', '123'),
('68', '50'),
('5', '2'),
('5', '88'),
('5', '36'),
('5', '136'),
('255', '101'),
('255', '174'),
('5', '94'),
('5', '21'),
('5', '20'),
('5', '185'),
('5', '73'),
('212', '188'),
('5', '24'),
('5', '135'),
('5', '191'),
('5', '199'),
('5', '202'),
('5', '9'),
('5', '204'),
('43', '207'),
('5', '208'),
('5', '181'),
('5', '70'),
('5', '216'),
('5', '32'),
('5', '220'),
('5', '65'),
('5', '51'),
('5', '174'),
('255', '32'),
('5', '225'),
('5', '105'),
('5', '228'),
('296', '223'),
('296', '338'),
('290', '234'),
('5', '239'),
('5', '238'),
('366', '338'),
('328', '244'),
('379', '386'),
('5', '58'),
('328', '278'),
('366', '349'),
('354', '359'),
('371', '25'),
('364', '359'),
('255', '121'),
('308', '25'),
('401', '383'),
('255', '25'),
('379', '383'),
('255', '119'),
('413', '406'),
('304', '394'),
('366', '420'),
('366', '447'),
('68', '32'),
('366', '105'),
('366', '21'),
('366', '468'),
('479', '32'),
('443', '490'),
('392', '221'),
('366', '506'),
('504', '24'),
('504', '223'),
('504', '204'),
('504', '349'),
('366', '520'),
('392', '533'),
('366', '599'),
('570', '32'),
('570', '105'),
('570', '544'),
('570', '580'),
('596', '32'),
('570', '681'),
('620', '686'),
('365', '32'),
('366', '705'),
('664', '673'),
('2', '716'),
('570', '694'),
('570', '442'),
('570', '791'),
('570', '79'),
('585', '800'),
('815', '746'),
('826', '813'),
('593', '500'),
('843', '821'),
('846', '824'),
('872', '842'),
('366', '843'),
('901', '868'),
('914', '70'),
('827', '879'),
('747', '752'),
('747', '752'),
('747', '764'),
('78', '884'),
('78', '17'),
('78', '115'),
('78', '102');
Caused the error:
Duplicate entry '747-752-0' for key 1
ALL files of converters were used from this topiс.
Please help.
PS: I russian.
At the use of all files *.sql an error turns out on this stage.
Converting topic notifications... Unsuccessful!
Beforehand thank you.
iam having trouble to convert. it converts everything just perfect, the members, topics, posts, the forum categories, but not the forums it self :(
Which converter are you using? Do you get any errors while converting?
hi all
Are the files in the first post still the ones i have to use ?
I like to convert from Invision Power Board v2.1.7 to SMF 1.1.4
Thank you for an short answer
Regards from Italy ;)
Yes
start converting get this at end/ What i need to repair/
I'm running into this on convert from IPB 2.1.5...
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Unsuccessful!
This query:
INSERT INTO `smf`.smf_membergroups
(ID_GROUP, groupName, maxMessages, onlineColor, stars)
VALUES
(6 + 3, SUBSTRING('Moderators', 1, 255), 500, '', '');
Caused the error:
Duplicate entry '9' for key 1
Any suggestions?
have you retried the conversion? "Duplicate entry" sometimes is a reason for to much queries and cause the server to overload.
Quote from: ThorstenE on June 25, 2008, 02:08:34 AM
have you retried the conversion? "Duplicate entry" sometimes is a reason for to much queries and cause the server to overload.
I did, same thing each time. :/
Open the .sql file
Find:
INSERT INTO {$to_prefix}membergroups
Replace:
INSERT IGNORE INTO {$to_prefix}membergroups
Quote from: SleePy on June 25, 2008, 01:35:29 PM
Open the .sql file
Find:
INSERT INTO {$to_prefix}membergroups
Replace:
INSERT IGNORE INTO {$to_prefix}membergroups
Now it just hangs at the permissions step, but no error message...
Converting...
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
No continue button or anything. Should I assume it hit an error?
Is the continue button disabled?
Is it attempting to go to a page such as your browser showing its loading?
It's not even there. And it definitely didn't finish successfully, since going to the main index of the forum shows nothing.
The file was upload corrupt.
Try a different program to edit the file and upload it. You can't use MS Word to edit the file.
Quote from: SleePy on June 25, 2008, 03:04:13 PM
The file was upload corrupt.
Try a different program to edit the file and upload it. You can't use MS Word to edit the file.
The SQL file? I didn't use MS Word, I used emacs. I'm on Linux.
Ahh sorry, Just most people when they need to edit something they open it in ms word and don't realize that it will mes up the file :|
Try this one:
Thanks again, but still no dice. It stops at the same point. :/
Is there a way I could tweak or simplify the permissions on my IPB install to help it out?
Is there error different or did it make it to a different section this time?
The permission system is complicated and it attempts to convert it, while its not needed to convert the permission system it is sometimes nice :)
Just some times the converter gets in a loop while doing error checking to prevent missed inserts and sometimes duplicate ids get inserted.
Quote from: SleePy on June 26, 2008, 01:17:49 AM
Is there error different or did it make it to a different section this time?
The permission system is complicated and it attempts to convert it, while its not needed to convert the permission system it is sometimes nice :)
Just some times the converter gets in a loop while doing error checking to prevent missed inserts and sometimes duplicate ids get inserted.
Nope, same thing, gets to that same spot. Is there any way to enable logging that might help?
Does the original work if you try that one again?
It seems quiet odd that it suddenly breaks :|
Does clearing your cookies and having it start over work or does it produce worse errors?
Quote from: SleePy on June 27, 2008, 02:45:23 AM
Does the original work if you try that one again?
It seems quiet odd that it suddenly breaks :|
Does clearing your cookies and having it start over work or does it produce worse errors?
With the original SQL (without the IGNORE) I now get:
Converting...
Error in convert script - line 3!
Error in convert script - line 5!
Error in convert script - line 6!
Error in convert script - line 7!
Error in convert script - line 8!
Error in convert script - line 9!
Error in convert script - line 12!
Converting members... Unsuccessful!
This query:
* ATTENTION: You don't need to run or use this file! The convert.php script does everything for you! */
TRUNCATE `smf`.smf_members;
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 '* ATTENTION: You don't need to run or use this file! The convert.php script doe' at line 1
Have you tried another browser to download the file?
Is your FTP client sent to use auto for the mode of transfer?
That comment right there is at the top of all the converter .sql files. By seeing that it says the file is corrupted and isnt' able to be read properly.
Quote from: SleePy on June 28, 2008, 12:56:35 AM
Have you tried another browser to download the file?
Is your FTP client sent to use auto for the mode of transfer?
That comment right there is at the top of all the converter .sql files. By seeing that it says the file is corrupted and isnt' able to be read properly.
Weird. I copied it using scp to the server initially. When I went back to the original SQL file like you suggested I just opened it in emacs and removed the IGNORE part from the SQL query. I'll re-download the original and try it again.
The ignore part actually needed added to the query :|
hi all! i'm trying to convert the ipb 2.1.7 to smf 1.1.5 with the latest .sql script attached to reply #110 of this nice topic.
here it is my error:
Converting...
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Successful.
Converting board permissions...
Fatal error: Cannot redeclare magicmask() (previously declared in E:\Web\smf_convert.php(910) : eval()'d code:41) in E:\Web\smf_convert.php(913) : eval()'d code on line 61
thank you for helping me! :)
Try the attached file.
Give or take a few minor bobbles I managed to convert an IPB 2.1.7 database to SMF 1.1.5 using the SQL file in the post above, however I'm finding a lot of
Quote[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]
in the posts.
As far as I can tell it's everywhere someone has just done what I did here, quote something random from off site using just
Quotestuff
without the quote=someone. Any ideas?
To answer my own question, I ran the following SQL query on the database and while the result is still not 100% it's only a few very complex (nested lists and font changes) posts that have issues.
UPDATE smf_messages SET body = replace(body, "[!--quoteo--][div class=\\'quotetop\\']QUOTE[/div][div class=\\'quotemain\\'][!--quotec--]", "[quote]");
Doesn't wanna work AT ALL for me :( I feel about ready to explode.
The database for the IPB forum is on a different server, something I don't have access to, so I backed up the database and then imported it into the PHPMyAdmin for my SMF forum which I want to move the posts to and then tried to run the attached sql file by copy pasting the information in it into a query.
But all it wants to say is:
Error
SQL query:
/* ATTENTION: You don't need to run or use this file! The convert.php script does everything for you! *//******************************************************************************/ ---~ name : "Invision Power Board 2.1"/******************************************************************************/ ---~ version : "SMF 1.1 RC3" ---~ settings : "/conf_global.php" ---~ globals : INFO ---~ from_prefix : "`$INFO[sql_database]`.$INFO[sql_tbl_prefix]" ---~ table_test : "{$from_prefix}members"/******************************************************************************/ - -- Converting members...
/******************************************************************************/ TRUNCATE {$to_prefix}members;
MySQL said: Documentation
#1064 - 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 '---~ name: "Invision Power Board 2.1"
---~ version: "SMF 1.1 RC3"
---~ setti' at line 1
I'm trying to convert IPB 2.1.4 to SMF 1.1.5
QuoteYou don't need to run or use this file!
you need the convert.php from this topic (http://www.simplemachines.org/community/index.php?topic=140741.0).. upload it to SMF directory (and also the invision21_to_smf.sql).. then start convert.php with a browser..
Our docs should also help: Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
That method won't work, I tried, because the two SQL databases are on different servers.
All our converters here will only work with the database on the same server.. The only way would be making a dump of the database and import into SMF's database..
That's what I did. I stated that in my post. I created a backup of the IPB database and imported it into the SMF one, but the convert.php won't do it since the IPB install points to a database on a different server to the actual forum, so I tried running the .sql file as a query and that didn't work.
Change the config.php then So it knows which database to use
The converter will not alter any of the IPB data. It will only be looking at it during the conversion.
How would I do this?
The error I get, by the way, is:
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of Invision Power Board 2.1. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.
The error MySQL gave was: SELECT command denied to user 'ukpcoforum'@'213.171.218.168' for table 'ibf_members'
Well, I'm going to attempt to move the IPB database to the same server first... Wish me luck.
Well, that method is working, but it comes across an error when converting Permissions (that's fine, I can do that manually), and the Boards don't seem to appear. It successfully converts the boards according to the converter, but when I load up the page there are no boards there at all.
can you restart conversion and post the error message?
Converting permissions... Unsuccessful!
This query:
INSERT INTO `ukpcoforum`.smf_membergroups
(ID_GROUP, groupName, maxMessages, onlineColor, stars)
VALUES
(6 + 3, SUBSTRING('Administrators', 1, 255), 50, '', '');
Caused the error:
Duplicate entry '9' for key 1
please try the attached version..
Still says the same...
I'm more concerned about the fact that the boards and posts don't appear.
ok, give this one a try..
(Edit: wrong version attached, updated)
Converting board permissions...
Fatal error: Cannot redeclare magicmask() (previously declared in /home/fhlinux168/u/ukpcoforum.co.uk/user/htdocs/smf/convert.php(911) : eval()'d code:41) in /home/fhlinux168/u/ukpcoforum.co.uk/user/htdocs/smf/convert.php(914) : eval()'d code on line 61
Boards and posts still won't show up either.
As for the boards/posts not appearing, in smf_boards, it looks like it has gotten ID_CAT and ID_PARENT confused with each other. I manually switched the values around in each board and now they appear along with the posts!
Give this one a try:
try this one
Thanks for the updated files but since I manually edited the database, everything's been fine and I've set the SMF forum up, so I can't really go back and redo it now. Thank you for all your help, though.
I converted my forum successful, but emotions not show in posts.
Quote
[img src=\"style_emoticons/[#EMO_DIR#]/biggrin.gif\" style=\"vertical-align:middle\" emoid=\":D\" border=\"0\" alt=\"biggrin.gif\" /] [img src=\"style_emoticons/[#EMO_DIR#]/biggrin.gif\" style=\"vertical-align:middle\" emoid=\":D\" border=\"0\" alt=\"biggrin.gif\" /] [img src=\"style_emoticons/[#EMO_DIR#]/biggrin.gif\" style=\"vertical-align:middle\" emoid=\":D\" border=\"0\" alt=\"biggrin.gif\" /]
How I can solve this?
Try this attached file and see if it provides better results.
Hello,
I have a question: how to convert from ipb 2.1 if I have only database (and I don't want to buy ipb 2.1.3 for migrating to smf)
This database is from some project of other person and he doesn't want to give me IPB as well.
Can I convert only DB by some mean?
DB only conversion is possible, but you must emulate the conf_global.php file from IPB.
Create a file named conf_global:
<?php
$INFO[sql_database] = 'name_of_your_database';
$INFO[sql_tbl_prefix] = 'ibp_table_prefix';
?>
replace name_of_your_database with the database name and ipb_table_prefix with the prefix from all tables ( I think it's ipb_ or similar).
the upload this file to a directory and specify this directory in convert.php
Thank you a lot, it helps me to convert DB.
One more fix in your file (you forgot quotes in array indexes):
<?php
$INFO['sql_database'] = 'name_of_your_database';
$INFO['sql_tbl_prefix'] = 'ibp_table_prefix';
?>
Hi,
Thanks for SMF and all the excellent support.
I am converting a big board from IPB2.1.6 and am getting this error when I get to converting posts:
QuoteConverting posts (this may take some time)... Unsuccessful!
This query:
INSERT INTO ...(lists entire database)
Caused the error:
Got a packet bigger than 'max_allowed_packet' bytes
Any ideas? Thank you very much.
You can try to reduce the numer of parallel converted posts:
in invision21_to_smf.sql find:
---* {$to_prefix}messages 200
replace it with:
---* {$to_prefix}messages 100
If you get the same error again you can reduce the number to 50, hopefully that helps...
Had to reduce it to 25...but now it is running. WIll give you an update...whenever it gets done. Thanks!
:D Making Progress!
Made it through the topic and post conversion, then got:
QuoteRecalculating forum statistics... Successful.
Unsuccessful!
This query:
REPLACE INTO {$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1249593263),
("conversion_from", "invision21_to_smf.sql");
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 '{$to_prefix}settings (variable, value)
VALUES ("conversion_time", 1249593263)' at line 1
Thanks again for any suggestions!
that's not a problem (minor bug in convert.php), the conversion has already finished:
QuoteRecalculating forum statistics... Successful.
Everything should be fine ;)
Quote from: TE on August 07, 2009, 01:55:34 AM
that's not a problem (minor bug in convert.php), the conversion has already finished:
QuoteRecalculating forum statistics... Successful.
Everything should be fine ;)
Yes, I checked the board and it's alive! Thank you so much, this will make alot of people happy! :)
Hello There!
I tried to convert our IPB 2.1 Installation to SMF 2.0RC2.
I used the IPB21_to SMF2 Converter from the Download Section and followed some Advices and chaged a few SQL Statements in this Forum to handle some converting-errors.
now the converter stops at /convert.php?step=1&substep=7&start=9500 with this Messages on Screen:
Quote
Notice: Undefined index: convert_script in /var/www/smf/convert.php on line 977
Warning: Invalid argument supplied for foreach() in /var/www/smf/convert.php on line 980
Notice: Undefined index: convert_script in /var/www/smf/convert.php on line 992
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /var/www/smf/convert.php on line 2513
Notice: Undefined variable: result in /var/www/smf/convert.php on line 2514
Notice: Undefined index: db_fetch_assoc in /var/www/smf/convert.php on line 1391
Fatal error: Function name must be a string in /var/www/smf/convert.php on line 1391
Does anybody has some advice for me?
I have big problem
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
this is the ipb data base structure
http://pastie.org/10652450 (http://pastie.org/10652450)
any help ??
thnx
take a look at http://www.simplemachines.org/community/index.php?topic=527681.0