Software: IPB
Version: 1.3.x
This is the official support topic for IPB 1.3 converter. Use this topic to ask for support for this converter. I merged all the changes that were floating around. Lets use this topic to get a final working version.
Changelog
! Initial update
! Poll convert update.
convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
Hi, I have a problem with the converter.
I have the following error:
QuoteConverting poll options... Unsuccessful!
This query:
INSERT INTO `forzona`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (187, SUBSTRING('0', 1, 255), 'foto1: foto van Janet.', 1, 255), '3'),
(187, SUBSTRING('1', 1, 255), 'foto2: foto van Maj', 1, 255), '3'),
(187, SUBSTRING('2', 1, 255), 'foto3: foto van Loebas', 1, 255), '2'),
and at the bottom of the page:
QuoteCaused 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 ''3'),
(187, SUBSTRING('1', 1, 255), 'foto2: foto van Maj', 1, 255), '3'' at line 3
And this is the exported query from the IPB database:
QuoteINSERT INTO `ibf_polls` VALUES (187, 7338, 1129495368, 'a:8:{i:0;a:3:{i:0;i:0;i:1;s:23:"foto1: foto van Janet.";i:2;i:3;}i:1;a:3:{i:0;i:1;i:1;s:20:"foto2: foto van Maj";i:2;i:3;}i:2;a:3:{i:0;i:2;i:1;s:23:"foto3: foto van Loebas";i:2;i:2;}i:3;a:3:{i:0;i:3;i:1;s:22:"foto4: foto van Mesje";i:2;i:1;}i:4;a:3:{i:0;i:4;i:1;s:22:"foto5: foto van Cyber";i:2;i:1;}i:5;a:3:{i:0;i:5;i:1;s:20:"foto6: foto van Puc";i:2;i:3;}i:6;a:3:{i:0;i:6;i:1;s:22:"foto7: foto van Heidi";i:2;i:2;}i:7;a:3:{i:0;i:7;i:1;s:23:"foto8: foto van Shanon";i:2;i:0;}}', 95, 15, 8, 'Hier kun je stemmen, en geef ook je commentaar');
How can I correct this error, to get the conversion to work?
I've tried Sarke's solution: http://www.simplemachines.org/community/index.php?topic=137630.msg903435#msg903435
But now I get this error:
QuoteCaused the error:
Duplicate entry '12-0' for key 1
Quote from: Puc conDoin on February 04, 2007, 02:44:00 PM
I've tried Sarke's solution: http://www.simplemachines.org/community/index.php?topic=137630.msg903435#msg903435
But now I get this error:
QuoteCaused the error:
Duplicate entry '12-0' for key 1
Ok what table did you get this error on?
Still the same table: `forzona`.smf_poll_choices
Truncate the table and try again. I just reuploaded the file.
Did you mean that I had to empty the table?
I reinstall SMF (after deleting all SMF tables) every time I have an error on the conversion. Then I restart the conversion from the beginning.
I used your newly uploaded sql-file, but got the same error on the same table:
Duplicate entry '12-0' for key 1
Even when I remove entry 12 from the original database, I still get the "Duplicate entry"-error. On the next database row that follows.
Try this one.
Thanx! The error on the poll choices table didn't show up anymore! ;D
But unfortunately, another error has come up:
QuoteConverting personal messages (step 1)... Unsuccessful!
This query:
INSERT IGNORE INTO `forzona`.smf_personal_messages
(ID_PM, ID_MEMBER_FROM, msgtime, fromName, subject, body)
and
QuoteCaused the error:
Got a packet bigger than 'max_allowed_packet' bytes
Hi,
Out of interest, has the un-html_special_chars been implemented yet?
Thanks,
Orb!ter
Quote from: Puc conDoin on February 08, 2007, 05:12:09 PM
QuoteCaused the error:
Got a packet bigger than 'max_allowed_packet' bytes
I tried to run the conversion on another server, with older versions of PHP and MySQL (3.23), which resulted in this error:
QuoteConverting personal messages (step 1)... Unsuccessful!
This query:
INSERT INTO `forzona_nl`.smf_personal_messages
(ID_PM, ID_MEMBER_FROM, msgtime, fromName, subject, body)
and
QuoteCaused the error:
MySQL server has gone away
The MySQL documentation site says something about a maximum allowed packet size of 1 Mb:
http://dev.mysql.com/doc/refman/5.0/en/gone-away.html and http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
Quote from: Orb!ter on February 09, 2007, 02:11:55 AM
Hi,
Out of interest, has the un-html_special_chars been implemented yet?
Thanks,
Orb!ter
No not yet. I'll try and look into it tonight when I get home from school.
Puc conDoin you will need to ask your host about this error.
Quote from: JayBachatero on February 09, 2007, 01:21:14 PM
Puc conDoin you will need to ask your host about this error.
Ok, are you sure about this?
What would happen if you limit the conversion of personal messages to 50 or 100 at a time? How many are converted at a time in the current conversion-program?
If I'm correct the limit is 200 or 500. One of the two. You can try limiting it to just 100.
Where do I find this? Can I change that in this code in convert.php?
$special_table = strtr(trim(substr($line, 4)), array('{$to_prefix}' => $to_prefix));
if (preg_match('~^([^ ()]+?)( \(update .+?\))? (\d+)$~', trim($special_table), $match) != 0)
{
$special_table = $match[1];
$special_update = $match[2] != '' ? substr($match[2], 9, -1) : '';
$special_limit = empty($match[3]) ? 500 : (int) $match[3];
}
elseif (preg_match('~^([^ ()]+?) \(update (.+?)\)$~', trim($special_table), $match) != 0)
{
$special_table = $match[1];
$special_update = $match[2];
$special_limit = 200;
}
else
{
$special_update = false;
$special_limit = 500;
}
No need to edit convert.php. In the .sql file there is a line like this ---* {$to_prefix}tablename Change that to ---* {$to_prefix}tablename 100. The 100 is the limit.
Ok, thanx! I will try this today and let you know how this works out.
Quote from: JayBachatero on February 12, 2007, 01:52:43 AM
No need to edit convert.php. In the .sql file there is a line like this ---* {$to_prefix}tablename Change that to ---* {$to_prefix}tablename 100. The 100 is the limit.
Thank you very much for this! This solution worked, and now everything seems to be converted!
I've had some problems while editing board online/offline settings in the SMF admin panel. After saving, the whole forum went blank for everyone.
I've found what caused the problem. The board offline message in the configuration file was in a multi-line format. IPB supported this. SMF seems to support only single line messages.
When I looked in my SMF configuration file, I found out that the first line in the board-offline message was the one I set before via the SMF admin-panel. But the following lines after that one, were from my old IPB configuration file!
After removing those "old" lines, the problem was gone.
Maybe this is a little glitch in the conversion process?
I believe that I fixed this in the new file that I put up. I guess yours stayed there from the previous conversion.
This week I found out that I have a "little" problem on the converted board:
One of the admins on the converted board was able to login, see all the forums and was able to perform all the admin/mod actions. But this admin couldn't login to the admin-controlpanel, and she wasn't able to update her own profile.
First, we didn't have any idea what the problem was. But when this admin set a new password, she didn't have above problems anymore.
Later, various users were complaining that they couldn't edit their profile anymore. I suggested to them that they needed to set a new password. They couldn't do that trough their own profile. They had to log out, and use the "Forgot your password?" option. This fixed the problem for them.
Some users don't have this problem. I was able to login, to use all my admin rights, get into the control panel and edit my profile with no problems.
Something seemed to be wrong with the passwords. Is it possible that the converter caused this?
Converting...
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting permissions... Unsuccessful!
This query:
INSERT INTO `krajator_1`.silk_forum_membergroups
(ID_GROUP, groupName, maxMessages, onlineColor, stars)
VALUES
(9 + 3, SUBSRING('-=Moderator=-', 1, 255), 50, '', '');
Caused the error:
No database selected
I have this error when I'm converting database from ipb 1.3.1 > SMF.
Please tell me what to do. It looks like, the converter is losing database connection.
Quote from: Puc conDoin on February 22, 2007, 03:00:50 AM
This week I found out that I have a "little" problem on the converted board:
One of the admins on the converted board was able to login, see all the forums and was able to perform all the admin/mod actions. But this admin couldn't login to the admin-controlpanel, and she wasn't able to update her own profile.
First, we didn't have any idea what the problem was. But when this admin set a new password, she didn't have above problems anymore.
Later, various users were complaining that they couldn't edit their profile anymore. I suggested to them that they needed to set a new password. They couldn't do that trough their own profile. They had to log out, and use the "Forgot your password?" option. This fixed the problem for them.
Some users don't have this problem. I was able to login, to use all my admin rights, get into the control panel and edit my profile with no problems.
Something seemed to be wrong with the passwords. Is it possible that the converter caused this?
Might be related to the passwords and their hash. I'll look into this and see what's going on.
Quote from: vincent1982 on February 23, 2007, 05:17:53 AM
Converting...
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting permissions... Unsuccessful!
This query:
INSERT INTO `krajator_1`.silk_forum_membergroups
(ID_GROUP, groupName, maxMessages, onlineColor, stars)
VALUES
(9 + 3, SUBSRING('-=Moderator=-', 1, 255), 50, '', '');
Caused the error:
No database selected
I have this error when I'm converting database from ipb 1.3.1 > SMF.
Please tell me what to do. It looks like, the converter is losing database connection.
Are you using the attachment on this topic?
I'm also having an issue with 1.3 -> 1.1.2. Convert.php is timing out and not converting anything.
I found Jay on AIM last night, but to make my day worse than it already was, my DSL went down. Thanks for looking at it briefly Jay, any more suggestions would help immensely.
Hit me up today on AIM. I'm going to have to debug the converter.
Thanks, will do.
i downloaded the converter and the file but what next? i want to convert my invisionfree 1.3 to smf
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Hiya Jay, just to let you know there's a small bug in the invision_to_smf.sql file
where on line 395 SUBSRING should read SUBSTRING (missing T character)
Ok.The conversion was successful but after sometime i got error in the whole forum.It is this -
QuoteParse error: syntax error, unexpected T_STRING in /home/ulgaming/public_html/forum/Settings.php on line 32
Did you get this fixed?
I get the poll error but I don't really care about saving my polls. Will this affect anything else or will my "converted" board work?
Thank you for writing this software :p
Greetings all. I am running IPB1.3 and want to upgrade. I was wondering:
a - is this board THAT much better than it?
b - does the converter run smoothly
c - this may be a general question, but can SMF have custom pages?
I want the end result to be like this:
http://www.hikingnewengland.com/
Thanks for any advice!
Cheers!
a.) I think it's a matter of opinion for each person. I too am looking to convert from IPB 1.3.x to SMF, which is why I'm here. So far I like SMF more because it is actively supported, along with security patches etc. IPB 1.3 is no longer supported by IPS so it's hard to get help when you need it. IMO, SMF is safer to use and still free. There are some feature differences, some of which can be added with mods and some of which don't have mods written for them. But that's to be expected in any kind of software change. But really, I'm quite enjoying SMF.
b.) I tested a conversion of an IPB 1.3.x database the other day and it went *very* smoothly. Not a single problem, fast and easy. It was quite impressive.
c.) You can always alter your board's look and layout however you like if you have a bit of PHP and HTML knowledge. There are also lots of modifications that can help you get the look you want, such as TinyPortal, Ad Management Mod, Custom Pages Mod, etc.
I suggest doing a bit of reading around, investigating mods, maybe setting up a test board and playing with it to get a feel for it.
Ok, so I hit that error converting poll options. I was using the converter on the converter downloads page. Is that converter a match to the one that was posted in this thread?
If not, and I'm in the middle of the conversion, will replacing the converter I'm in the middle of using with the one in this thread mess anything up?
ATM the converters on the converter pare are not up to date. Use the one on this topic.
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 permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Unsuccessful!
This query:
ALTER TABLE `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
Open the sql file
Find:
ALTER TABLE {$to_prefix}smileys
ORDER BY LENGTH(code) DESC;
Replace:
ALTER TABLE {$to_prefix}smileys
ORDER BY code DESC;
Hi,
I'm running IPB 1.3 and SMF 1.1.4. I have uploaded both files, but when i run the convert.php, i get this error:
Parse error: syntax error, unexpected $end in /home/tacp/public_html/community/convert.php on
help please.
thanks!
Try reuploading the files again. Seems like they got corrupt.
Hi there, Jay. :)
I just made the conversion without much in the way of problems for the boards. I did have to delete some custom member groups I had on Invision and transfer the members into standard groups in order to get the permissions conversion accomplished, but that was no big deal.
My question, though, has to do with the calendars. The two sites I used the IPB on really didn't have a whole lot of activity on the boards themselves, but the calendar listings are extensive. Is there any conversion tool for the IPB 1.3 -> SMF calendar portion?
Thanks!
I haven't tried converting the calendars but it can be done but it will require some work :(.
hi
when I try to convert IPB 1.3 Final (using Russian character set cp1251) i get the following error:
Recalculating forum statistics... Unsuccessful!
This query:
SELECT ID_BOARD, memberGroups
FROM `ipb`.smf_boards
WHERE FIND_IN_SET(0, memberGroups);
Caused the error:
Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (cp1251_general_ci,IMPLICIT) for operation 'find_in_set'
what can I do?
thx
i had problems using apache, mysql and php on windows (Denwer emulator). When i copied converter and forums to hoster convertion proceed fine.
I'm trying to convert from IPB 1.3 Final t SMF 1.1.4. I got this error during the conversion, don't know how to go on.
***(I've removed some of the quote, as this is a list of all various poll options from the forum, and some of the lines may contain inappropriate language)
INSERT INTO `yun0net_forum`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (1, SUBSTRING('0', 1, 255), 'yes', 1, 255), '2'),
(1, SUBSTRING('1', 1, 255), 'well duh', 1, 255), '3'),
(1, SUBSTRING('2', 1, 255), 'of course', 1, 255), '1'),
(1, SUBSTRING('3', 1, 255), 'certainly', 1, 255), '5'),
(1, SUBSTRING('4', 1, 255), 'no (and my name is jenni)', 1, 255), '1'),
(2, SUBSTRING('0', 1, 255), '640x480', 1, 255), '0'),
***(etc)
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 ''2'),
(1, SUBSTRING('1', 1, 255), 'well duh', 1, 255), '3'),
(1,' at line 3
My server has mysql-5.0.45.
There must be a way to fix this, what do I do?
Use the file in this topic.
You mean the sql one in the first post? Ok, I didn't know that was any different. I'll give it a shot.
The link to convert.php only links to this topic (http://www.simplemachines.org/community/index.php?topic=140741.0) which then links back to this one, though.
Ok the new sql file worked for the poll choices table problem, thankyou! :)
But now I have a new one. This showed up next:
QuoteConverting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Unsuccessful!
This query:
ALTER TABLE `yun0net_forum`.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
so I did what you said to someone with the same problem here:
Quote from: SleePy on August 09, 2007, 09:04:39 PM
Open the sql file
Find:
ALTER TABLE {$to_prefix}smileys
ORDER BY LENGTH(code) DESC;
Replace:
ALTER TABLE {$to_prefix}smileys
ORDER BY code DESC;
And it seemed to work, it moved on from the smilies table, but then it said this:
QuoteRecalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `yun0net_forum`.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
how can that be, the "ORDER BY LENGTH(code) DESC;" doesn't even exist in the file any more!
Use the updated convert.php file. Updated Converters List & Support Topics (http://www.simplemachines.org/community/index.php?topic=140741.0)
oh god, I'm so silly! I never noticed a file attached to that topic! Thanks a lot, that worked! WOohoooOoO! :)
Hi what should i do to convert my IPB to SMF???
Thanks in advanced...
**edit
Nevermind. :)
I'm trying to install the SMF, but after I press Connect, the page times out. I had a friend try it on a different computer and the same thing happened. So frustrating!
I suggest you make a new topic for this issue. It's not related to the conversion.
Quote from: KapsiaoGina on February 11, 2008, 05:49:30 AM
Hi what should i do to convert my IPB to SMF???
Thanks in advanced...
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Hey there,
I read the topic and used to updated convert.php as well as the sql-file. That way I could solve the first few problems but I still get one error in the end:
QuoteConverting 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...Duplicate entry '0-1-0' for key 1
Also the avatars don't seem to be converted as all users are missing their image.
Can you help me with this?
Thanks
Mario
edit: I'm trying to upgrade from IPB1.3final to the newest SMF
edit2:
I used the different files offered in the post (also the one in the middle) and got a different error. This all seems a bit odd to me:
QuoteConverting...
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 permissions...Duplicate entry '9' for key 1
For the avatars,
did you get any errors?
Does php have permission to view those files?
Does php have permission to write to the SMF attachments folder?
The poll logs error is saying that a member on your ipb forum voted twice. You will need to go into your ipb database and remove the duplicate vote.
Hi,
Pardon me in advance for my bad english, french is my native language.
I've been desesperately trying to convert my IPB 1.3.1 board to SMF, because IPB 1.3.1 is very unsecure and I alerady got hacked about 20 times since 4 months (People upload files in my directories to spam thousand of ppl via email). However I keep running into problems when converting.
My board is a place where users can upload electronic music they made themselves, meaning they can upload the files into their post in mp3 format by posting a new topic. So far there are 202 MP3 uploaded and maybe 50 avatars. This means that if I want to convert I absolutely want to keep all files attachments, I am not willing to reupload 202 files one by one into their respective, especially since it'S hard to figure out which file go with what topic, as the files has weird names such as "post-12-1206937968.ibf".
My problem is that when I convert my IPB 1.3.1 board I get this error:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fwww.mtv-music-generator.com%2Fxlib%2Fipb2smferror.gif&hash=53bcd83602cb89cc32989e3c97bc4d7faf518808)
If i go check my board topics, posts, polls, members and such stuff seems to have been all converted, as well as board categories (altough there are some minor reordering and resync to do), however, all topic/posts attachments as well as everyone's uploaded avatars are missing.
After reading some stuff elsewhere it seemed like I should try to copy all of them manually in the SMF attachment folder. This took a long while, a VERY long while. I had 772 MB worth of attachments to upload and my upload speed is around 100 KB/sec. So I tried another conversion, and I still got the same problem, including the image above. No avatar attached to people profile (those who uploaded it) and no files attached to any post.
Afterward I read that maybe it was because my attachment directory was not writeable, so I checked, and they were CHMODed to 755, so I decided to try CHMODing them to 777, and converting, and it still didn't fixed the problem.
I am using 1and1.com, my IPB install has no mods installed (except the mod installer itself) and is installed on MySQL 4.0, and I am using the converter said to be the lastest, which was in this topic or linked from this topic, as well as the lastest SMF version. And before trying converting again I always go check phpmyadmin in my host CP and remove all database stuff starting with smf (as I prefixed them).
Anybody know what I may be doing wrong? I am getting very worried here, because MyBB doesn't have IPB conversion yet, and I don't like PHPBB, and I would hate if it was because of the hosting provider I am using or something worse. :(
Thank you in advance!
P.S: It isn't the first time I tried a conversion to SMF. A few weeks ago I did the same thing with an older version of the converter and attachments were still missing
I keep getting this error when I try to run the convertor.
Notice: Undefined index: charsets in /home/airspee/public_html/online-community/convert.php on line 378
DJ Omnimaga,
That error is saying that there is two permission sets in IPB that have the id of 9. You will need to use phpMyAdmin and go to the permissions table and find this duplicate id and remove one of them.
vwchris,
Are you using the convert.php and sql attached to the first post of this topic?
Yes.
It fails trying to build topics and convert posts
ok, well I seen another post by jay so its known
What error do you get on the conversion process itself (ignoring that charset one)
first this
Converting...
Converting members... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Incomplete.
Not quite done yet!
This conversion has paused to avoid overloading your server, and hence not working properly.
Don't worry though, nothing's wrong - simply click the continue button below to start the converter from where it left off.
then
Notice: Undefined index: charsets in /home/airspee/public_html/online-community/convert.php on line 378
combined with this
Converting...
Converting topics... Successful.
Converting posts (this may take some time)... Incomplete.
then this
Notice: Undefined index: charsets in /home/airspee/public_html/online-community/convert.php on line 378
combined with this
Converting...
Converting posts (this may take some time)... Incomplete.
it keeps cycling there until you hit continue then I get
Converting...
Converting posts (this may take some time)... Duplicate entry '66640' for key 1
and thats all I can do.
Don't hit continue. It is working on the conversion and you may have double submitted the data which resulted in the duplicate key.
figured that out, thanks for the help.
Quote from: SleePy on April 17, 2008, 07:25:56 PM
DJ Omnimaga,
That error is saying that there is two permission sets in IPB that have the id of 9. You will need to use phpMyAdmin and go to the permissions table and find this duplicate id and remove one of them.
vwchris,
Are you using the convert.php and sql attached to the first post of this topic?
could you explain more into details how I could do this? I am in phpMyAdmin now and selected the appropriate database and I checked the documentation of phpMyAdmin on table permissions and I couldn't find what I need. Could you post a step by step (preferably with screenshots) on how to find the duplicate table in my database so I don't delete something I shouldn't?
EDIT: I found something called Perm_id in the database,
perm_id perm_name
1 Validating Forum Mask
3 Member Forum Mask
2 Guest Forum Mask
4 Admin Forum Mask
5 Banned Forum Mask
However it doesn't seems to be what I want because I see no permission with a ID of 9 there, just 1 through 5
For IPB you are looking for pid in the posts table that has an id of 66640
There should be two of them. It would be a hard guess, but one of them needs to be removed.
If you do the wrong one, find and repair errors in SMF should help you resolve these by fixing them.
sorry, still no luck figuring out what you mean. Ok let me make this clear: I am a real n00b at MySQL administration, all I wanted is to run a forum, but found out that IPB 1.3.1 was insecure so I want to convert now. However it is the first time I am messing with PHPMYadmin for real (altough I looked at it before). I went into ibf_posts, and i seeno posts with the id of 66640. In fact it doesn't even go higher than 2183 right now.
I even tried doing a query to check if pid 66640 existed and no results were found
phpmyadmin comes with a search feature.
Just search the "posts" table by "pid" of "66640"
There should be two of them, remove one.
as I said in my previous post. I did used the search feature, and i found no results:
QuoteMySQL returned an empty result set (i.e. zero rows). (Query took 0.0007 sec)
SQL query:
SELECT `pid`
FROM `ibf_posts`
WHERE `pid` =66640
LIMIT 0 , 30
Are you clicking the continue button as the converter is converting?
If you got javascript enabled it will automatically continue after a selected time. This is to prevent it from overloading your server.
When I click convert after selecting what I want to convert and entering my db password i get that page i posted as screenshot on the previous page. There is no continue button there. Unless you were replying to someone else's post.
Oh well so far I am sorry but I couldn't figure out anything that was told to me in that thread, I guess I am not ready to do board conversions unless I become PhpMyAdmin expert I guess I will just stick to IPB 1.3.1 until I finished learning it in 2-3 months and get my website hosting space shut down for spam sent from hacker php files they uploaded using exploits.
Sorry for taking all your time.
Does anyone know where I could maybe get SMF conversion help and support in french?
We do have language specific boards below the general english ones.
I am sad we can't get this or figure out why its occuring, but all indicators of why it would occur are by you being said they don't exist or you are not doing it.
Are you sure that duplicate key error didn't change now?
i think part of the problem is that I am a beginner at MySQL, phpMyAdmin and board conversion, and you try to help me as if I used those for 8 years x.x
I am sorry if its appearing to come to you to advanced.
Can you pm me your admin and site details and such so I can attempt the conversion myself? I just need things that will help me get the conversion done and be able to look at phpmyadmin myself.
hold on...
re-reading the previous page of the topic including vwchris posts, it seems you confused myself as him x.x, since the post ID 66640 thing seems to be related to his problem.
I still haven't found any forum permission that had the ID of 9 though. According to the error it is entry 9, but there is only 5 entries and searching for entry 9 seems to return no results.
I feel a bit relunctant to give my website acct password and login to someone I hardly know online though to be honest, especially when my credit card info and all that stuff is stored there x.x, atm I try to ask everywhere for help but not much luck yet, as no one I know ever used IPB or knows nothing about MySQL. I will try giving away my pass as last resort
Doh,
That might help :P Thats what happens when you try to help to many people in one topic.
Ok, Go to your IPB database and look for the "groups" table.
In there (it hopefully shouldn't be that big that you need to search), you will find two groups with the ID of 9.
I do understand the need to not want to give out information. It is totaly up to you to give it out, whether it is temporarily information or not. But before you do, please read A reminder about admin / ftp passwords etc. (http://www.simplemachines.org/community/index.php?topic=87130.0)
Ok I went there, but it didn't went up to 9 either. Highest group ID is 6:
Sorry for the large image
EDIT: I also attached a screenshot of permissions
Well looking at the actual conversion code for IPB it seems it is actually coming from group 6..
Can you also attach an image from your smf_membergroups table?
I want to see where it might of gone wrong.
here is it
Ok, lets try this attached script..
I bumped the id group it was using, so it should be doing it. Hopefully :|
still the same error, except that it says "Converting permissions...Duplicate entry '15' for key 1" instead of "Converting permissions...Duplicate entry '9' for key 1"
At the start of the conversion.
Add ?debug=1
into the url.
And attempt the conversion again, Hopefully if I read the convert.php code right this should put it into a debug mode...
ok this is what I got now:
I am going to have to let jay look at this, I am not sure what is up now..
DJ Omnimaga,
Can you try the attached file?
It should hopefully ignore the duplicate errors and help with this.
nope, still getting the same error, with ?debug=1 or not :(
Ok, Hopefully I got it right this time.
Forgot that php was handling lots of the work instead of straight SQL commands.
Thanks for being so patient with me while we try to get this going :)
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/32/d221544684/htdocs/smf/convert.php on line 780
Invision Power Board to SMF Converter
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 permissions... Successful.
Converting board permissions...
Fatal error: Cannot redeclare magicmask() (previously declared in /homepages/32/d221544684/htdocs/smf/convert.php(910) : eval()'d code:41) in /homepages/32/d221544684/htdocs/smf/convert.php(913) : eval()'d code on line 41
Well thats good :) We made it past permissions and now are onto board permissions.
I don't know why so many errors are occurring though.. Very odd.
I added a function check around the function so it shouldn't duplicate the function for what ever reason it was :|
Edit, I even took the precaution to make it check the other function we use in there as well :)
yeah I hope my database isn't broken :S, I would hate if my forum was impossible to convert and that I had to restart from scratch :S
Now this time things went fine until 2nd page. It said the conversion was paused or something to avoid overloading server (didn't got time to read as the page automatically changed afterward) and then landed on a page saying the following:
QuoteWarning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /homepages/32/d221544684/htdocs/smf/convert.php on line 780
Notice: Undefined index: charsets in /homepages/32/d221544684/htdocs/smf/convert.php on line 378
Invision Power Board to SMF Converter
Converting...
Converting attachments... Successful.
Converting avatars...
Warning: copy(/homepages/32/d221544684/htdocs/uploads/upload.wikimedia.org/wikipedia/commons/1/1c/CMS_Higgs-event.jpg) [function.copy]: failed to open stream: No such file or directory in /homepages/32/d221544684/htdocs/smf/convert.php(1075) : eval()'d code on line 7
Successful.
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.
Please check this box to delete the converter right now for security reasons. (doesn't work on all servers.)
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the Invision Power Board installation.
We hope you had a smooth transition!
As for now, all attachments seems to be there, only problem is that they won't show up for guests x.x
Aside from that things seems fine. I have no idea why the other SQL errors occured though
I don't have a good idea either, It would be something I need to dig into though I guess.
Go to Admin -> Permissions
Click Guests
And then down on the right click the box to allow guests to view attachments.
ok, now another problem is that auto-login doesn't work :(
Everytime I visit the board I have to login again, even if I set a time to stay logged in. With IPB I didn't had this problem. Idk if it's related to a conversion problem or the server
Sometimes that means the cookie is corrupted.
You can try changing your cookie name in Admin -> Server Settings to something else.
Sometimes it also happens because of database driven sessions (either on or off) which can be enabled in the Feature configuration tab in that same section.
hi, im spanish and would change my smf to IPB, but i don't make it, would you care to explain to me a bit like one makes? I don't understand English very well, sorry im spanish
any help?
What doesn't make it?
Do you get any errors?
im upload the .sql and the convert.php to my ftp but appear this message: Unable to find the settings for Invision Power Board 1.3. Please double check the path and try again.
You need to specify in the second field there the path to IPB.
It will ask you to set a path to the IPB forum. This should be the path used by the computer and not a url!
Such as /home/cpanelusername/public_html/ipb_forum/ (This is only an example).
We do have a Español (Spanish) (http://www.simplemachines.org/community/index.php?board=16.0) board where you can speak Spanish and it may help in the conversion process :)
ok thanks, im create a new directory en my ftp with the name: ipb but the message is =
Call me crazy, but I've volunteered to take over a forum that was using IPB 1.3 final. Here's the thing, all I have from the old forum is an sql backup. I stuck it on the new server in the forum directory, but rcvd the same "Unable to find the settings for Invision Power Board 1.3. Please double check the path and try again" error message MaNaRa rcvd.
I understand that it can't find IPB setting, because IPB was never installed.
Will I have to:
1. Install IPB, restore the database backup, and then convert
2. Get some particular files from the old server that SMF is requiring and then convert
3. kick myself in the teeth for tackling this project
4. other
Please note, although I have some webmastering experience I don't really know jack squat about php, sql, smf, or any other combination of letters I see you gurus slinging about. BUT - I am willing to learn if that counts for anything :)
you would need to import the backup into a database.
You would then need to emulate the configuration files for it to complete the conversion.
ok, import into a database... I think I can figure that one out or can find someone who can.
emulate the config files??? Sorry, but I'm not sure I follow you on that one... I'll search around the forum and google it some more and see what I can find.
in IPB there is a file called "conf_global.php".
THis file contains most of your configuration settings for connecting to the mysql server
You could emulate this file by creating one and putting
<?php
$INFO['sql_database'] = '';
$INFO['sql_tbl_prefix'] = '';
?>
And then specify the IPB database and its prefix (A common word before all the tables).
Thanks SleePy! I'll try once I get the database imported. I'm running into trouble now because the sql file exceeds the max size allowed for importing. I'm going to try to get around that somehow. If I can't I'm going to try installing sql locally where such restrictions shouldn't be an issue.
Thanks again, now go get some rest.
If the database is large, ask your host to import it.
They can use command line methods to import the file that would get around this :)
Quote from: SleePy on June 29, 2008, 12:33:25 AM
If the database is large, ask your host to import it.
They can use command line methods to import the file that would get around this :)
I installed apache, php, mysql, and SMF on my desktop machine. It had the same size restrictions as a default, but I was able to get around it. I now have the old forum sql imported into a database. Yay! The converter is now choking on something. I did it late last night and didn't save the output. When I do it again I'll post the sql error if I can't find a local guru.
This is my plan, tell me if I'm missing something. I want to get the whole enchelada set up locally and then back up the smf database. Shouldn't I then be able to put that backup on the server and restore it? Would that have me in business?
thanks for being patient and helping out a noob
The error would help me know what is going wrong :)
Here ya go, sleepmeister. I hope its something simple...
Converting...
Converting members...
Notice: Undefined index: admin_group in /var/www/convert.php(725) : eval()'d code on line 4
Unsuccessful!
This query:
SELECT
id AS ID_MEMBER, SUBSTRING(name, 1, 80) AS memberName,
joined AS dateRegistered, posts,
IF(mgroup = , 1, IF(mgroup > 5, mgroup + 3, 0)) AS ID_GROUP,
last_visit AS lastLogin, SUBSTRING(name, 1, 255) AS realName,
msg_total AS instantMessages, SUBSTRING(password, 1, 64) AS passwd,
SUBSTRING(email, 1, 255) AS emailAddress,
SUBSTRING(website, 1, 255) AS websiteTitle,
SUBSTRING(website, 1, 255) AS websiteUrl,
SUBSTRING(location, 1, 255) AS location,
SUBSTRING(icq_number, 1, 255) AS ICQ, signature,
IF (bday_year = 0 AND bday_month != 0 AND bday_day != 0, CONCAT('0004-', bday_month, '-', bday_day), CONCAT_WS('-', IF(bday_year <= 4, 1, bday_year), IF(bday_month = 0, 1, bday_month), IF(bday_day = 0, 1, bday_day))) AS birthdate,
SUBSTRING(aim_name, 1, 16) AS AIM, SUBSTRING(yahoo, 1, 32) AS YIM,
SUBSTRING(msnname, 1, 255) AS MSN, hide_email AS hideEmail,
SUBSTRING(IF(avatar = 'noavatar' OR INSTR(avatar, 'upload') > 0, '', avatar), 1, 255) AS avatar,
email_pm AS pm_email_notify, '' AS lngfile, '' AS buddy_list,
'' AS pm_ignore_list, '' AS messageLabels, '' AS personalText,
'' AS timeFormat, '' AS usertitle, '' AS memberIP, '' AS secretQuestion,
'' AS secretAnswer, '' AS validation_code, '' AS additionalGroups,
'' AS smileySet, '' AS passwordSalt, '' AS memberIP
FROM `oldforumdb`.ibf_members
WHERE id != 0
LIMIT 0, 500;
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 ' 1, IF(mgroup > 5, mgroup + 3, 0)) AS ID_GROUP,
last_visit AS lastLogin, SUBSTR' at line 4
Hmm, ok well you don't have a admin group id defined..
Do you know the ID of the admin group on your IPB board?
Quote from: SleePy on June 30, 2008, 12:00:23 AM
Hmm, ok well you don't have a admin group id defined..
Do you know the ID of the admin group on your IPB board?
No I didn't, but I found another post that had a more definitive conf_global.php. I used it and had some success. Now we're getting somewhere!
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... Unsuccessful!
This query:
INSERT INTO `smf`.smf_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (1, SUBSTRING('0', 1, 255), 'Avon AV45/46', 1, 255), '7'),
(1, SUBSTRING('1', 1, 255), 'Meztler Z6', 1, 255), '4'),
(1, SUBSTRING('2', 1, 255), 'Bridgestone BT-45', 1, 255), '4'),
(1, SUBSTRING('3', 1, 255), 'Metzler ME33/55A or 330/550', 1, 255), '3'),
(1, SUBSTRING('4', 1, 255), 'Dunlop D205', 1, 255), '4'),
(1, SUBSTRING('5', 1, 255), 'Dunlop 491 (rear only)', 1, 255), '2'),
(1, SUBSTRING('6', 1, 255), 'Bridgestone BT-020', 1, 255), '4'),
(1, SUBSTRING('7', 1, 255), 'Pirelli Sport Demon', 1, 255), '1'),
(1, SUBSTRING('8', 1, 255), 'Michellin Macadam M50', 1, 255), '1'),
(1, SUBSTRING('9', 1, 255), 'Michellin Road Pilot', 1, 255), '0'),
(2, SUBSTRING('0', 1, 255), 'Black - as stock frame', 1, 255), '2'),
(2, SUBSTRING('1', 1, 255), 'Red - same colour as tank/bodywork', 1, 255), '1'),
(2, SUBSTRING('2', 1, 255), 'Grey/silver - bit like a Ducatti monster', 1, 255), '2'),
(2, SUBSTRING('3', 1, 255), 'Other - suggestions and reasons please', 1, 255), '0'),
(3, SUBSTRING('0', 1, 255), 'Pirelli Sport Demons', 1, 255), '2'),
(3, SUBSTRING('1', 1, 255), 'Michelin Pilot Active', 1, 255), '2');
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 ''7'),
(1, SUBSTRING('1', 1, 255), 'Meztler Z6', 1, 255), '4'),
(' at line 3I'm not terribly concerned about polls... Is there more converting to do after that or is it just about done?
Now I have another problem. I wasn't an admin on the old forum so when I log in now to the new smf forum I have no admin rights.
I wanted to try to do a backup and restore on the "real" server.
What's a guy to do now?
ok, I found the table smf_membergroups. Now if I can find out how to add myself to that group I'll be in the money ;)
sure wish I knew more about this database stuff!
woo-hoo! I'm getting further. I discovered I was not using the most recent invision_to_smf.sql.
here's where I'm at now:
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 permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Unsuccessful!
This query:
ALTER TABLE `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
gonna keep plugging along...
I made it past the poll problem all the way to "conversion complete", but now permissions seem screwed. As a guest I can browse all over the board. When I log in as a user everything is off limits. Grrrr.... more research to be done!
it works! locally, at least. I was able to edit the db to make myself an admin. I did have to change permissions on each board to allow users to access them. initially, only guests and regular members were checked. Since everyone is a 'full member' I had to check that too.
Anyhow, thanks to all of the informative posts and help from sleepy it looks like I might be nearly ready to go live!
If I have any trouble with that I'll come crying again :P
Which file did you find that was updated?
Quote from: SleePy on June 30, 2008, 05:50:30 PM
Which file did you find that was updated?
I'm pretty sure I initially was using an older copy of invision_to_smf.sql
Now if I can just remember what I did when I get a more recent ipb backup to go live with....
thanks for all the help!
hi i am trying to convert my ipb 1.3.1 to smf 1.1.5 but as soon as i started converting this error always displays...
Converting members... Unsuccessful!
This query:
(query here...)
Caused the error:
Duplicate entry '6777' for key 1
please help me on this... thanks in advance for those who can help me...
have you tried to restart the conversion from the beginning?
Sometimes clicking "continue" will cause errors and cause a double submission of the form. try to restart. convert.php should continue it's work without clicking the "continue" button.
Trying to convert a fairly big (few hundred thousand posts) and active (would like to minimize off time) forum.
Topic conversion is very slow, taking hours now, and ongoing.
Any advice on speeding it up? (Dual Xeon 2.8, single IDE disk).
You can change the block size of the sections it is converting.
Such as if it was converting topics at the moment.
You could open the .sql
Find:
---* {$to_prefix}topics
and Replace that with:
---* {$to_prefix}topics 200
Note that 200 added after it is the only change.
The 200 will change the block size of how many topics it is converting at once. So you can play with this and use bigger or smaller numbers, depending on what your server will allow.
Thanks, will recheck.
It did it (500 at a time), took several hours (like 15+, unclear).
Another issue:
Converting posts (this may take some time)...
Successful.
Converting polls...
Successful.
Converting poll options...
Unsuccessful!
This query:
INSERT INTO `smf`.smf115_poll_choices
(ID_POLL, ID_CHOICE, label, votes)
VALUES (1, SUBSTRING('1', 1, 255), '8 boards', 1, 255), '15'),
.......... more data .............
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 ''15'),
(1, SUBSTRING('2', 1, 255), '12 boards', 1, 255), '35'),
' at line 3
where (1, 1, '8 boards', 15) looks more appropiate.
Maybe I'm using an outdated .sql?
the invision_to_smf.sql from the first post of this topic should be up to date?!?! maybe it is not, try the version from this post:
http://www.simplemachines.org/community/index.php?topic=146211.msg1522935#msg1522935
My fault, was using an old one, taken from smf_1-1-5_invision_converter.tar.gz.
Maybe it can be updated?
Also solved the slow topics conversion issue:
Replaced
SELECT
t.tid AS ID_TOPIC, t.pinned AS isSticky, t.forum_id AS ID_BOARD,
t.starter_id AS ID_MEMBER_STARTED, t.last_poster_id AS ID_MEMBER_UPDATED
,
pl.pid AS ID_POLL, t.posts AS numReplies, t.views AS numViews,
MIN(p.pid) AS ID_FIRST_MSG, MAX(p.pid) AS ID_LAST_MSG,
t.state = 'closed' AS locked
FROM ({$from_prefix}topics AS t, {$from_prefix}posts AS p)
LEFT JOIN {$from_prefix}polls AS pl ON (pl.tid = t.tid)
WHERE p.topic_id = t.tid
GROUP BY t.tid
HAVING ID_FIRST_MSG != 0
AND ID_LAST_MSG != 0;
with
SELECT
ID_TOPIC, isSticky, ID_BOARD, ID_MEMBER_STARTED, ID_MEMBER_UPDATED,
pl.pid AS ID_POLL, numReplies, numViews, ID_FIRST_MSG, ID_LAST_MSG,
locked
FROM ( SELECT
t.tid AS ID_TOPIC, t.pinned AS isSticky,
t.forum_id AS ID_BOARD, t.starter_id AS ID_MEMBER_STARTED,
t.last_poster_id AS ID_MEMBER_UPDATED, t.posts AS numReplies,
t.views AS numViews, MIN(p.pid) AS ID_FIRST_MSG,
MAX(p.pid) AS ID_LAST_MSG, t.state = 'closed' AS locked
FROM ({$from_prefix}topics AS t, {$from_prefix}posts AS p)
WHERE p.topic_id = t.tid
GROUP BY t.tid
HAVING ID_FIRST_MSG != 0 AND ID_LAST_MSG != 0) res
LEFT JOIN {$from_prefix}polls AS pl ON (pl.tid = res.ID_TOPIC);
Idea from http://www.mysqlperformanceblog.com/2007/04/06/using-delayed-join-to-optimize-count-and-limit-queries (http://www.mysqlperformanceblog.com/2007/04/06/using-delayed-join-to-optimize-count-and-limit-queries).
Makes a LOT of sense in this case, to delay the JOIN till after we get the trimmed list, rather than do a BIG JOIN, then try to filter that.
VERY fast now. 26107 rows in less than 2 mins.
Partitioned in 10000 to avoid the max packet limit.
Success (at first glance, checking further).
Thanks all.
I need help. Is their anyway I can change my SMF to IPB v1.3? Is their any file or attachment? can you please give me intstructions? :-[
Our converters support converting from IPB to SMF, not from SMF to IPB. If you are looking for a converter to IPB you should ask for support in the IPB Homepage...
Hy I would like to convert my IPB 1.3.1 to smf 1.1.8
but after executing the conversion process an error occurred in the members table.
Everything works fine till the 7500 entry. Why did that happened? I've used the attached .sql file and the convert.php from the download section.
was it an error like "duplicate entry" or similar? can you post the exact error message please?
Yes it was a "duplicate entry" error. But it seems that I have been able to solve this problem by limiting the blocksize for new entry's.
Damn it just seemed to be a proper solution. From 59,918 Post are just 30200 converted and from 10,616 Topics just 10,110. But no error message or something. *help*
Now I tried to convert a 2nd time and these error messages occured after a couple of seconds:
Converting...
Notice: Undefined index: convert_script in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 810
Warning: Invalid argument supplied for foreach() in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 813
Notice: Undefined index: convert_script in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 825
Notice: Undefined index: convert_script in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 721
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1211
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1221
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1229
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1252
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1265
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1311
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1313
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1319
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1325
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1336
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1337
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1345
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1347
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1353
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1354
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1360
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1361
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1385
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1387
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1393
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1405
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1430
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1432
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1476
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1491
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1520
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1522
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1535
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1557
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1562
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1623
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1625
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1661
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1680
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1703
Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 1704
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2411
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2411
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2239
Notice: Undefined variable: result in /var/www/vhosts/help.homepage.eu/subdomains/smf/httpdocs/convert.php on line 2240
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.
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the installation.
We hope you had a smooth transition!
the new error was a broken session, this is often host related. Try to restart the conversion.
for the "duplicate entry": do you know the step? (topics, PMs, Messages?)
the duplicate entry error isn't the problem (I limited the blocksize to 20) but he occured in topics, members, and poll log. The new problem is that from 59,918 Post are just 30200 converted and from 10,616 Topics just 10,110. But no error message or something.
Thanks in advance for your help.
any chance to test an offline conversion with XAMPP or similar products (www.apachefriends.org)? I think this is an host related issue or your IPB database is corrupted?
I can't really imagine that the IPB is corrupted. But I will try the XAMPP thing.
worstl,
Any luck?
Hi, I encounter this error while converting from IPB1.3.1 using the converter, can anyone help? Many thanks in advance!
Converting members... Unsuccessful!
This query:
Caused the error:
Duplicate entry '731' for key 1
Quotehave you tried to restart the conversion from the beginning?
Sometimes clicking "continue" will cause errors and cause a double submission of the form. try to restart. convert.php should continue it's work without clicking the "continue" button.
This seems like a solution but can someone explains how to restart the conversion w/o clicking on the "continue" button?
I managed to resolved the Converting members error by deleting that particular member (seem to be corrupted coz can't trace back to his posts).
Now I got a new error, appreciate if anyone can enlighten me how to resolve it, many thanks in advance.
Converting topics... Unsuccessful!
This query:
INSERT INTO `tyrone_smf`.smf_topics
(ID_TOPIC, isSticky, ID_BOARD, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_POLL, numReplies, numViews, ID_FIRST_MSG, ID_LAST_MSG, locked)
VALUES ('1084', '0', '13', '5', '5', '', '0', '8', '16201', '16201', '0'),
...
Caused the error:
Duplicate entry '1084' for key 1
I managed to solve the Converting topics... Unsuccessful! error by changing part of the URL and end with step=1084 (since it says duplicate entry "1084"). Now it says conversion completed by it throws out some error msgs. Can someone enlighten me if it's ok? If yes, I will do the conversion on the real forum (I'm testing with a test forum).
Million thanks in advance!
Converting...
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 permissions... Successful.
Converting board permissions... Successful.
Converting smileys... Successful.
Converting settings... Successful.
Converting attachments...
Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059122411.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059122427.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059653504.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059747800.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059810224.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059822310.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1059822703.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-15-1061832124.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-13-1061522502.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-15-1061645338.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-15-1061645375.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-15-1061704896.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-15-1061742834.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Warning: copy(/home/tyrone/public_html/forum/uploads/post-12-1066788277.ibf) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 6
Successful.
Converting avatars...
Warning: copy(/home/tyrone/public_html/forum/uploads/av-2.gif) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7
Warning: copy(/home/tyrone/public_html/forum/uploads/img1.imageuploader.net/558/patty_avatar_64.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7
Warning: copy(/home/tyrone/public_html/forum/uploads/www.eng.buffalo.edu/~tinchin/Uploaded/Hyori%201.gif) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7
Warning: copy(/home/tyrone/public_html/forum/uploads/daturax.fireywind.com/uploader/nov/bast_small.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7
Warning: copy(/home/tyrone/public_html/forum/uploads/av-59.gif) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7
Warning: copy(/home/tyrone/public_html/forum/uploads/av-145.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7
Warning: copy(/home/tyrone/public_html/forum/uploads/av-182.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7
Warning: copy(/home/tyrone/public_html/forum/uploads/funimg.pchome.com.tw/img_upload/FUNNY/g/u/20040112_gunxxx_230921.gif) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7
Warning: copy(/home/tyrone/public_html/forum/uploads/server2.uploadit.org/files/chuanxiong-naruto.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7
Warning: copy(/home/tyrone/public_html/forum/uploads/blogs.kpbs.org/images/uploads/WallE04.jpg) [function.copy]: failed to open stream: No such file or directory in /home/tyrone/public_html/smf/convert.php(1097) : eval()'d code on line 7
Successful.
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.
the warning messages are from avatars and attachments conversion. Our converter can't find those files (directory: /home/tyrone/public_html/forum/uploads/).
Quote from: TE on April 24, 2009, 01:24:42 PM
the warning messages are from avatars and attachments conversion. Our converter can't find those files (directory: /home/tyrone/public_html/forum/uploads/).
Thanks for answering.
I didn't allow users to upload attachments and avatars in my forum so as to minimise the space used. If that's the case I guess the conversion is successful. ;)
Everything works fine till the 7500 entry. Why did that happened? I've used the attached .sql file and the convert.php from the download section.
24 hour call out emergency plumber sydney Emergency plumber sydney (http://www.emergencyplumbersydney.com)
craccdemo,
any errors during the conversion? please copy & paste them here.
Will this converter work for IPB 1.2? I probably already know the answer because I get the following error:
Converting members... Unsuccessful!
This query:
INSERT INTO `smf_testdb`.smf_members
(ID_MEMBER, memberName, dateRegistered, ...
...
...
Caused the error:
Field 'memberIP2' doesn't have a default value
I'd appreciate any help or recommendations you guys can offer. I'm trying to convert an IPB 1.2 based board to SMF 1.1.10.
Well that is a error related to MySQL strict mode.
Via phpMyAdmin you can fix this.
Simply go into your SMF database, then the members table. Click the structure tab and scroll down looking for "memberIP2". Once you find it, click edit. Then change default to as defined and leave the input box for it empty. Save and then try to run the converter again :)
Long post incoming. I'm documenting what I went through here so that I can find it again later, and maybe help someone else lol.
Quote from: SleePy on September 02, 2009, 01:10:00 AM
Well that is a error related to MySQL strict mode.
Via phpMyAdmin you can fix this.
Simply go into your SMF database, then the members table. Click the structure tab and scroll down looking for "memberIP2". Once you find it, click edit. Then change default to as defined and leave the input box for it empty. Save and then try to run the converter again :)
That was it, thank you very much! I don't have phpMyAdmin installed, personal taste, I'd just rather not have it running. So I tried to add a default manually:
mysql> ALTER TABLE smf_members MODIFY memberIP2 tinytext Default '';
ERROR 1101 (42000): BLOB/TEXT column 'memberIP2' can't have a default valueSince that didn't work I just disabled strict mode (removed STRICT_TRANS_TABLES setting) and the process worked. I ran into a couple other little issues along the way.
Are there any concerns that I should be aware of when disabling strict mode? Can I re-enable it after the conversion and not have any issues with SMF?
Apparently I had a duplicate entry in the polls data:
mysql> select count(*) as num, tid, member_id from ibf_voters group by member_id
,tid having count(*) > 1;
+-----+------+-----------+
| num | tid | member_id |
+-----+------+-----------+
| 2 | 1804 | 2863 |
+-----+------+-----------+
1 row in set (0.01 sec)
mysql> select * from ibf_voters where tid = '1804' and member_id = '2863';
+------+---------------+------------+------+-----------+----------+
| vid | ip_address | vote_date | tid | member_id | forum_id |
+------+---------------+------------+------+-----------+----------+
| 3434 | 70.115.215.19 | 1230587380 | 1804 | 2863 | 4 |
| 3435 | 70.115.215.19 | 1230587380 | 1804 | 2863 | 4 |
+------+---------------+------------+------+-----------+----------+
2 rows in set (0.00 sec)
mysql> select * from ibf_voters where vid = '3435';
+------+---------------+------------+------+-----------+----------+
| vid | ip_address | vote_date | tid | member_id | forum_id |
+------+---------------+------------+------+-----------+----------+
| 3435 | 70.115.215.19 | 1230587380 | 1804 | 2863 | 4 |
+------+---------------+------------+------+-----------+----------+
1 row in set (0.00 sec)
mysql> DELETE from ibf_voters where vid = '3435';
Query OK, 1 row affected (0.00 sec)Deleting the offending record fixed that problem. So FYI to the script developer, apparently dupes can happen in ibf_voters.
The next error I ran into was:
Converting smileys... Unsuccessful!
This query:
ALTER TABLE `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 '(code) DESC' at line 2After some research I found this topic (http://docs.simplemachines.org/index.php?topic=1079.0). Indeed I am on MySQL 5.1 on my test system. I made the appropriate chages and it worked.
Next I got this error:
Converting attachments...
Fatal error: Call to undefined function getAttachmentFilename() in C:\xampp\htdocs\convert.php(1109) : eval()'d code on line 5I found the getAttachmentFilename reference in invision_to_smf.sql. I am using the second version of this file, found in this thread. When I compared these lines to the original version posted in the original post I found that it was referencing a function call getLegacyAttachmentFilename. I changed both references (found in the attachments and avatars blocks) to the original function name "getLegacyAttachmentFilename" and got it to work.
Lastly I got this error:
Recalculating forum statistics... Successful.
Notice: Undefined variable: to_prefix in C:\xampp\htdocs\convert.php on line 1821
Unsuccessful!
This query:
REPLACE INTO settings (variable, value)
VALUES ('conversion_time', 1251918779),
('conversion_from', 'invision_to_smf.sql');
Caused the error:
No database selectedAt this point I was tired of debugging, since this was the last part of the script and didn't have any real effect on the forum I just commented out the lines in convert.php and ran the query manually.
I'm still testing the results but it looks like the script does work on IBP 1.2.
Running without strict mode is fine. Now that you got things converted you can run queries to give it a default values and try to enable strict mode again. More information is on mysqls documentation website: http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#sqlmode_strict_all_tables
Which sql file where you using? The change to using getLegacyAttachmentFilename() occurred a while back due to a major overhaul of the attachment system to enhance its security. All of our converters just use the legacy version until we have time to properly update them to use the newer method of creating attachments.
As for the last error, it isn't something important. It is something we are planning on using in the future and doesn't harm you if you don't have it.
Yeah, I've got it all sorted out now. The new forums are running great with a little love. Had some permissions issues with the converted groups and for some reason nearly a quarter of the 3000 members had "http://" in their website url/name. These members didn't have any website in their original profiles.
I used the sql file from here (http://www.simplemachines.org/community/index.php?topic=146211.msg1522935#msg1522935).
What is the plan for the conversion_time and conversion_from values? I can't see this actually being used for anything after data has been converted.
At this point there isn't much planned for it. But we could use it in things like our smfinfo.php support script to know if the forum was converted and when. We could also possibly use in SMF such as our login page to disable the compatibility login methods, reducing cpu cycles.
Hi! Will you help me with this problem?
IPB 1.3 to SMF 1.1.12
In addition to Morphium's post, do you know if the converter is updated to 1.1.12 ?
(I have to convert my database from IPB 1.3.1 to SMF 1.1.12)
Is the link to the converter in the 1st post the right link ?
SMF 1.1.12 was a security update, the database wasn't touched.. The converter should work for the entire SMF 1.1.x series..
Many thanks "TE" 8)
Ugh, why does the convert.php link in the initial post lead me in a damn circle?
Quote from: zushiba on November 01, 2011, 06:42:15 PM
Ugh, why does the convert.php link in the initial post lead me in a damn circle?
It's doing the same thing to me - where's the file?
convert.php file is added as attachment in this topic (linked in first post): http://www.simplemachines.org/community/index.php?topic=140741.0
Quote from: phantomm on February 18, 2012, 08:50:48 AM
convert.php file is added as attachment in this topic (linked in first post): http://www.simplemachines.org/community/index.php?topic=140741.0
yep, but IIRC that file is for SMF 1.1.x .. The 2.x version is part of the converter files from the downloads page:
http://download.simplemachines.org/?converters
Quote from: phantomm on February 18, 2012, 08:50:48 AM
convert.php file is added as attachment in this topic (linked in first post): http://www.simplemachines.org/community/index.php?topic=140741.0
Sorry but it is not. If you click on the link, you will be taken to a page for the converters for IPB 2.x and not the converter listed in this thread. I need the converter for IPB 1.3. Does anyone know where the correct converter is? The link in the original post in this thread does not help locate it - it goes to a page that lists a converter for IPB 1.3 - clicking on that link, takes you back to this thread - it's an endless loop with no file!
Quote from: AUser on February 18, 2012, 12:24:45 PM
Sorry but it is not.
Believe me, it is ;) scroll down to the end of that topic, just before the text "« Last Edit: October 12, 2010, 08:52:56 PM by Nibogo »
"
Okay, I found it but it's not clearly marked (in fact, if you hadn't mentioned it, I would have never known what it was). Now I've got to figure out what to do with it!
Quote from: TE on February 18, 2012, 12:44:27 PM
Quote from: AUser on February 18, 2012, 12:24:45 PM
Sorry but it is not.
Believe me, it is ;) scroll down to the end of that topic, just before the text "« Last Edit: October 12, 2010, 08:52:56 PM by Nibogo »
"
Thanks, that did it - I would have NEVER found the file otherwise (someone needs to change that thread so that the file can be found). As I mentioned in post above, the link that we're supposed to click on doesn't work. Anyway, I've got things up and running and have already upgraded to SMF 2.0.2
I'm trying to use SMF 1.1 but I can't install it because of these errors:
QuoteLine #39: 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 'TYPE=MyISAM' at line 13
Ton of those. I am trying t oconvert IPB 1.3 to SMF, but I can't start at sMF 2.0 and the 1.1.x series says this.
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Hi! When you try to convert I get the message . What should I do?
Hello, is the tool still active and is it the better way to migrate from ipb 1.3 to SMF? Thank you
Hello everybody
i try to convert my old ipb1.3 forum to smf
i look for a converter scrip
where to find the last version of script ipb1.3 to smf ?
regards
Hello all,
I appreciate that this thread is over 15 years old. However, I am still in need of some help. I am trying to convert an old IPB 1.3.1 final forum to a current SMF forum. Steps taken so far:
I have chaged the PHP version on cPanel to PHP 7.0
I have installed SMF in a temporary folder called smf2 (when it is all up and running properly, I will move it to its permanent home)
I have copied the convert.php and invision_to_smf.sql files to the root of the public_html/smf2 folder
I have executed convert.php
The configuration screen asks for 5 items of information as follows:
Path to SMF: Set to public_html/smf2
Path to Invision Power Board: Set to public_html/forum
SMF database password: Where do I find this? I can see the automatically generated database username in cPanel. I can change the password (big mistake. Ask me how I know!) but I cannot see the password. Which password goes in this box?
Set SMF's default character set to: ISO8859-1
I have not checked the box to clear the log.
The convert.php script finishes and says completed successfully. However, no data was transferred from the old database to the new one.
Questions:
Where do I find the database password for the smf installation?
Why does the converter not need to know the username which accompanies the aforementioned password?
Why does the converter not need to know the user name and password for the old Invision installation/database?
I appreciate I am asking questions about a very old and very out of date Invision installation. However, it is what it is. Any help or guidance very much appreciated.
Cheers
Norrie
Quote from: norrie on April 06, 2022, 01:57:49 PMWhere do I find the database password for the smf installation?
Hello and welcome to Smf. You can find the password for Smf in the Settings.php file which can be located in the root of your forum folder.
Quote from: norrie on April 06, 2022, 01:57:49 PMWhy does the converter not need to know the username which accompanies the aforementioned password?
Why does the converter not need to know the user name and password for the old Invision installation/database?
Did you install Smf in the same database as that of your Ipb forum? What Smf version did you install?
Hi Doug,
Thanks very much for getting back to me. Much appreciated.
Quote from: Doug Heffernan on April 06, 2022, 02:36:52 PMYou can find the password for Smf in the Settings.php file which can be located in the root of your forum folder.
I see that now. I tried it in the converter but it made no difference.
Quote from: Doug Heffernan on April 06, 2022, 02:36:52 PMDid you install Smf in the same database as that of your Ipb forum?
My guess is that I did not. During the install, there is an opportunity to configure the database and backups under the "Advanced" section. I tried entering the name of an existing database but the installation script threw an error telling me that the database already exists and to choose a new one. I gave in and accepted the default installation which created a new database automatically. If I was going to add the SMF forum to the existing IPB database, how exactly would I achieve that? I don't recall seeing any options to use an existing database.
Quote from: Doug Heffernan on April 06, 2022, 02:36:52 PMWhat Smf version did you install?
I installed the latest version 2.1.1
Kind regards,
Norrie
Quote from: norrie on April 07, 2022, 03:08:22 AMHi Doug,
Thanks very much for getting back to me. Much appreciated.
You are welcome :)
Quote from: norrie on April 07, 2022, 03:08:22 AMMy guess is that I did not. During the install, there is an opportunity to configure the database and backups under the "Advanced" section. I tried entering the name of an existing database but the installation script threw an error telling me that the database already exists and to choose a new one. I gave in and accepted the default installation which created a new database automatically. If I was going to add the SMF forum to the existing IPB database, how exactly would I achieve that? I don't recall seeing any options to use an existing database.
When you install the smf forum, you can use the database details for the database where you have installed your Ipb forum. Or you can use another database but assign the new database the same user/password of your Ipb forum.
Quote from: norrie on April 07, 2022, 03:08:22 AMI installed the latest version 2.1.1
I noticed that you have a very old version of Ipb and from what I saw at the converters page, the converter did not seem to support Smf 2.1. So you might want to install smf 2.0.19 instead and after the conversion is finished, you can upgrade to smf 2.1.x.
Hope it helps.
Hi Doug,
Thanks again for your continued support.
Here's what I've done so far:
Downloaded a copy of the 2.0.19 installation files.
Uploaded installation files to new folder on server.
Ran the install from a browser.
Set the database to the old IPB database
Set the database user and password to the old IPB database user and password.
I created an admin user account with password
I entered the database password for the smf database ( same as database password for the old IPB database)
The install finished without issue.
I checked the SMF forum via my browser and it all looked fine.
I checked the database using pHpMyAdmin and I could see all the entries prefixed with smf_
I copied the convert.php and invision_to_smf.sql files to the root of the smf installation (smf folder).
I ran the convert.php from a browser.
I entered the path to the smf forum and the old ipb forum.
I entred the smf database password (same as old IPB database password).
The converter says that everything went fine.
If I look at the smf forum or the database via pHpMyAdmin none of the IPB data has migrated across. Here is a copy of the contents of the error_log:
[07-Apr-2022 13:41:24 UTC] PHP Notice: Undefined index: convert_script in /home/xxxxxxxx/public_html/smf/convert.php on line 987
[07-Apr-2022 13:41:24 UTC] PHP Warning: Invalid argument supplied for foreach() in /home/xxxxxxxx/public_html/smf/convert.php on line 990
[07-Apr-2022 13:41:24 UTC] PHP Notice: Undefined index: convert_script in /home/xxxxxxxx/public_html/smf/convert.php on line 1002
[07-Apr-2022 13:41:24 UTC] PHP Notice: Undefined variable: result in /home/xxxxxxxx/public_html/smf/convert.php on line 2510
[07-Apr-2022 13:41:24 UTC] PHP Notice: Undefined variable: result in /home/xxxxxxxx/public_html/smf/convert.php on line 2511
[07-Apr-2022 13:41:24 UTC] PHP Notice: Undefined index: db_fetch_assoc in /home/xxxxxxxx/public_html/smf/convert.php on line 1401
[07-Apr-2022 13:41:24 UTC] PHP Fatal error: Uncaught Error: Function name must be a string in /home/xxxxxxxx/public_html/smf/convert.php:1401
Stack trace:
#0 /home/xxxxxxxx/public_html/smf/convert.php(1341): doStep2()
#1 /home/xxxxxxxx/public_html/smf/convert.php(51): doStep1()
#2 {main}
thrown in /home/xxxxxxxx/public_html/smf/convert.php on line 1401
Can I trouble you for some more advice on where to look next?
Kind regards,
Norrie
Quote from: norrie on April 07, 2022, 09:55:29 AMCan I trouble you for some more advice on where to look next?
It is no trouble at all. I am happy to help whenever I can.
Quote from: norrie on April 07, 2022, 09:55:29 AMThe converter says that everything went fine.
So the conversion finished without any errors? Can you log in at your Smf forum, then go to the Maintenance area there and run the Recount all forum totals and statistics? You can run the other tools listed there too.
Regarding those errors, that you lsited, what php version do you have?
P.s. Can you clcik the smf_topics table in the phpmyadmin and post a screenshot of its contents btw?
Hi Doug,
Thanks for the speedy response.
Quote from: Doug Heffernan on April 07, 2022, 10:16:11 AMSo the conversion finished without any errors?
Correct. Finished with no on-screen errors. The only errors are the ones listed in the error_log.
Quote from: Doug Heffernan on April 07, 2022, 10:16:11 AMrun the Recount all forum totals and statistics?
I can do that but if I look at the database via pHpMyAdmin, I can see that for example there is only one member and one message. Therefore, there is nothing to count. However, I did as you suggested and it made no difference.
Quote from: Doug Heffernan on April 07, 2022, 10:16:11 AMRegarding those errors, that you lsited, what php version do you have?
The original setting for the pHp version was somehting like 4 or 5 (I can't quite recall). SMF would not allow the installation to continue until I met the minimum version. Therefore, I set it to 7.0. I have the choice to go back as far as 5.2 or as new as 8.1 as required.
Quote from: Doug Heffernan on April 07, 2022, 10:16:11 AMCan you clcik the smf_topics table in the phpmyadmin and post a screenshot of its contents btw?
I don't know how to attach an image to this post. I have uploaded a copy of the screenshot to the root of the smf folder but it cannot be seen externally. Is there another way?
Kind regards,
Norrie
Quote from: norrie on April 07, 2022, 11:05:46 AMI can do that but if I look at the database via pHpMyAdmin, I can see that for example there is only one member and one message. Therefore, there is nothing to count. However, I did as you suggested and it made no difference.
Strange. If the converter ran till the end without any errors, the content should have been converted over to the Smf forum in theory.
Quote from: norrie on April 07, 2022, 11:05:46 AMI don't know how to attach an image to this post.
When replying, click the Attachments and other options section and go from there. You have to click the Reply button as the Quick Reply form does not support the upload of attachments. Please see the attached screenshot.
P.s. Can you please make a screenshot of the database as a whole, with all the tables and post it as well?
Hi Doug,
Please find attached a printout of the tables in the database. The tables span over four pages and are longer than my screen. Therefore a screenshot wouldn't really work.
Update: I see from your screenshot that you have an "Attachment and other options" link below the posting box. However, I do not have that link on my screen. Could it be that I am too new a member to have posting priveleges?
Kind regards,
Norrie
Sorry, my bad. I now see the difference between a full reply and a quick reply. It wasn't obvious before. PLease find attached a printout of the database tables.
Kind regards,
Norriexxxxxxx_forum _ phpMyAdmin 4.9.pdf
Quote from: norrie on April 08, 2022, 04:06:29 AMPLease find attached a printout of the database tables.
It was not very clear to me from that pdf if the content was converted to smf or not. Can you click one of these tables in phpmyadmin, smf_members, smf_messages, smf_topics, and make a screesnhot of the inside page, i.e. the content, and post it here?
Hi Doug,
Please find attached the three screenshots as requested.
When you say " if the content was converted to smf or not", I'm not sure what you mean. To be clear, the old IPB foum was stored in a folder called "forum". I have installed a brand new version 2.0.19 smf forum in a folder called smf. The database in which the old IPB forum was installed was called xxxxx_forum. I installed the new smf installation in the same database with the same user and password. As it happens, there is a third forum stored in that same database called "mkportal" This was an old experiment from years ago and can be ingored unless it is impinging on the conversion process.
I uploaded the convert.php and invision_to_smf.sql files to the root of the smf folder and executed the convert.php file. (Was that correct or should I upload them to the root of the old forum folder?) Should I expect to see the IPB tables physically converted to smf tables? Or should I be looking for data transferred from the old IPB tables to the equivalent new smf tables? In other words, if the process had happened perfectly, what should I see when I look at the tables and their contents?
smf_members table screenshot.JPG
smf_messages table screenshot.JPG
smf_topics table screenshot.JPG
Quote from: norrie on April 10, 2022, 05:09:19 AMWhen you say " if the content was converted to smf or not", I'm not sure what you mean.
What I meant by this is if the data from your Ipb forum was converted over/added to the Smf forum.
Quote from: norrie on April 10, 2022, 05:09:19 AMI have installed a brand new version 2.0.19 smf forum in a folder called smf. The database in which the old IPB forum was installed was called xxxxx_forum. I installed the new smf installation in the same database with the same user and password. As it happens, there is a third forum stored in that same database called "mkportal" This was an old experiment from years ago and can be ingored unless it is impinging on the conversion process.
I uploaded the convert.php and invision_to_smf.sql files to the root of the smf folder and executed the convert.php file. (Was that correct or should I upload them to the root of the old forum folder?)
That is the correct procedure as far as I can tell.
Quote from: norrie on April 10, 2022, 05:09:19 AMShould I expect to see the IPB tables physically converted to smf tables? Or should I be looking for data transferred from the old IPB tables to the equivalent new smf tables?
The converter will not alter the source forum database at all, i.e. the ipb forum in this case.
The data of the source forum should be inserted to the relevant tables of the Smf forum. Hence why I asked for the screenshots.
You said that you ran the Recount all forum totals and statistics tool in the Maintenance area btw, right?
I am perplaxed as to why the conversion is not working. You have done it correctly and in theory it should have worked.
Quote from: norrie on April 10, 2022, 05:09:19 AMAs it happens, there is a third forum stored in that same database called "mkportal" This was an old experiment from years ago and can be ingored unless it is impinging on the conversion process.
That has no bearing at all as far as the conversion process goes.
Doug,
As a quick thought, given the IPB forum is so old, could the problem be that the php verson required for the conversion to work properly is very much older than the minimumm php version requied to run smf, even the 2.0.19 version? Would I need to go back to a much older version of both php and smf to get the data transferered and then upgrade the php and smf to the current version, maybe even transitioning through multiple intermediate steps?
Kind regards,
Norrie
Doug et al,
Is there someone I can pay to have the forum upgraded to smf on my behalf?
Kind regards,
Norrie
You should've got error message if there was a problem with some of the functions from converter I guess. But anyway, you can try to alter php version before using convert tool, can't hurt to try with different versions.
Other than that, is your forum public, if so can you post a link to it so we can see it?
Hi Dzonny,
No error messaages. The converter said it was successful.
The forum is public but since I updated the php version to 7.0, it no longer works. The page is blank when you navigate to the forum index.
Club XM (http://www.club-xm.com/forum/)
However, to demonstrate the old forum exists and works, I have temporarily reverted the php version to 5.2 so you can see it.
Thanks,
Norrie
Dzonny,
I reverted the version of php back to 5.2. I uploaded a copy of convert.php and invision_to_smf.sql to the root of the smf folder. I tried to start the smf/convert.php process from a browser but all I got was a blank page and the address bar changed to "/convert.php?step=1".
Therefore, it seems that there could be a (maximum) php version needed to get the convert.php to work but a different minimum version to get smf to work. If those two do not overlap then I can't convert the existing forum to smf along this path.
Presumably this all worked fine 10+ years ago? When the converter was written back in 2007, what version of php and what version of smf was current at that time? Maybe I need to go back to even earlier versions of both to get the converter to work and then slowly update them both a step at a time to the current versions.
For example, I see from the convert.php file that the minimum version of php is stated as 4.1.0 and the minimum version of mysql is 4.0.18. My ISP does not give me the option to go back further than 5.2 for php. I have no idea what the mySQL version is.
Kind regards,
Norrie
I just realized that this convertor is supposed to work with smf 1.1 versions. In that case you should convert to smf 1.1 branch and then once that is working you may easily convert to 2.0 branch and 2.1 branch.
I'd suggest to try with smf 1.1 branch and see where to go from there.
Quote from: Dzonny on April 11, 2022, 06:21:48 AMI just realized that this convertor is supposed to work with smf 1.1 versions. In that case you should convert to smf 1.1 branch and then once that is working you may easily convert to 2.0 branch and 2.1 branch.
I'd suggest to try with smf 1.1 branch and see where to go from there.
I missed the Smf compatibility with the converter. I assumed that it was for Smf 2.0.x. Good catch :)
@norrie, is upgrading your Ipb forum to version 4 or at the very least, 3.x not an option btw?
@DougIt never really dawned on me to consider it. I've just been to Invision's website to have a look. If I am reading it correctly, they want a minimum subscription of $49/m for their baselinepackage. The forum does not create any income and therefore there is no way of paying for a subscription.
@Dzonny,
No problem. It costs me nothing to give it a try. Presumably to uninstall the current smf installation I should just delete the entire smf folder and then delete every line in the database with an smf_ prefix? Is there another way?
Kind regards,
Norrie
Quote from: norrie on April 11, 2022, 06:47:20 AMI should just delete the entire smf folder and then delete every line in the database with an smf_ prefix? Is there another way?
That is the best way to completely uninstall smf 2.0.19 and install smf 1.1.x.
Yeah, I'd suggest to give it a try and let us know about the results. 8)
Hi Dzonny/Doug,
Here's what I did:
I deleted all the files in the smf folder (smf 2.0.19 installation)
I deleted all the tables and data from the database with prefix smf_
I downloaded a copy of smf version 1.1.21
I uploaded a copy of all the 1.1.21 files to the empty smf folder
I confirmed the php version setting as 5.2
I ran the install.php and selected the existing IPB database and the IPB database user
I used the sql password I found in the config_global.php file
The install finished successfully.
I browsed to the new forum to ensure it was working correctly, which it was.
I uploaded the convert.php and invision_to_smf.sql files to the root of the smf folder.
I ran the convert.php from a browser.
The converter said it completed successfully.
I browsed to the forum but found that it only had 1 user and 1 post (i.e. the introductory post)
I checked phpMyAdmin and confirmed none of the data migrated from the old IPB forum to the new smf forum.
Is there anything I am missing about this process?
Here is the contents of the error_log
[11-Apr-2022 11:09:31] PHP Notice: Undefined index: convert_script in /home/clubxmco/public_html/smf/convert.php on line 987
[11-Apr-2022 11:09:31] PHP Warning: Invalid argument supplied for foreach() in /home/clubxmco/public_html/smf/convert.php on line 990
[11-Apr-2022 11:09:31] PHP Notice: Undefined index: convert_script in /home/clubxmco/public_html/smf/convert.php on line 1002
[11-Apr-2022 11:09:31] PHP Notice: Undefined variable: result in /home/clubxmco/public_html/smf/convert.php on line 2510
[11-Apr-2022 11:09:31] PHP Notice: Undefined variable: result in /home/clubxmco/public_html/smf/convert.php on line 2511
[11-Apr-2022 11:09:31] PHP Notice: Undefined index: db_fetch_assoc in /home/clubxmco/public_html/smf/convert.php on line 1401
[11-Apr-2022 11:09:31] PHP Fatal error: Function name must be a string in /home/clubxmco/public_html/smf/convert.php on line 1401
Any ideas greatly welcomed.
Kind regards,
Norrie
Can you try with PHP version 5.4?
Hi Dzonny,
I changed the php version using cPanel to 5.4.
I ran the convert.php file again.
I entered the old and new forum folders
I entered the old/new database password
The converter said it completed successfully.
I checked both the forum and the database. No data was copied over to the smf tables.
Here are the new entries in the error_log
[11-Apr-2022 11:43:35 UTC] PHP Notice: Undefined index: convert_script in /home/clubxmco/public_html/smf/convert.php on line 987
[11-Apr-2022 11:43:35 UTC] PHP Warning: Invalid argument supplied for foreach() in /home/clubxmco/public_html/smf/convert.php on line 990
[11-Apr-2022 11:43:35 UTC] PHP Notice: Undefined index: convert_script in /home/clubxmco/public_html/smf/convert.php on line 1002
[11-Apr-2022 11:43:35 UTC] PHP Notice: Undefined variable: result in /home/clubxmco/public_html/smf/convert.php on line 2510
[11-Apr-2022 11:43:35 UTC] PHP Notice: Undefined variable: result in /home/clubxmco/public_html/smf/convert.php on line 2511
[11-Apr-2022 11:43:35 UTC] PHP Notice: Undefined index: db_fetch_assoc in /home/clubxmco/public_html/smf/convert.php on line 1401
[11-Apr-2022 11:43:35 UTC] PHP Fatal error: Function name must be a string in /home/clubxmco/public_html/smf/convert.php on line 1401
Kind regards,
Norrie
Please note that I have been through every page of this thread from the beginning. There are at least two versions of convert.php and possibly three versions of invision_to_smf.sql attached to various posts. How can I tell that I am using the right versions and the right combination of versions?
For example, the version of the convert.php I have been using all along says it is Version 2.0 on line 12. The other version I downloaded does not have a version stated. It does however state that it is for smf v 1.1. The previous file mentioned does not state which version of smf it is suitable for. Given the task in hand, which one is correct file to use?
Regards,
Norrie
Thanks for your quick response.
Are you sure the PHP version is changed? Have you checked it with phpinfo(); function?
Also, do you have .htaccess file in smf directory, and if so, can you temporarily rename it to something like .htaccess-temp while you're trying to perform the conversion.
I would at last suggest to also try to run converter with another browser, just to be sure it's not browser related, though I doubt it.
QuoteFor example, the version of the convert.php I have been using all along says it is Version 2.0 on line 12. The other version I downloaded does not have a version stated. It does however state that it is for smf v 1.1. The previous file mentioned does not state which version of smf it is suitable for. Given the task in hand, which one is correct file to use?
That is just file version, not smf version, I assume.
File from the first post in this tipic should do the trick.
Hi Dzonny,
Quote from: Dzonny on April 11, 2022, 08:20:11 AMAre you sure the PHP version is changed? Have you checked it with phpinfo(); function?
Sorry, my IT skills are reasonable but not advanced. How would I go about doing that?
Quote from: Dzonny on April 11, 2022, 08:20:11 AMdo you have .htaccess file in smf directory
No, there is no htaccess file
Quote from: Dzonny on April 11, 2022, 08:20:11 AMtry to run converter with another browser
I might try that this evening using another machine. I only have Firefox installed on this machine.
Regards,
Norrie
Sure, take a look at this:
What is a phpinfo() file? (https://wiki.simplemachines.org/smf/What_is_a_phpinfo()_file)
Found it
Let's see if someone else has another idea, but looks like it's realted to php version, at least to me..
If I were you I'd try to alter php version multuple times until I find the one that works. Also double-check if covert php and sql files are in SMF root folder, and that DB user has permissions to modify selected database.
Success ! Here are the steps I took:
I changed the php version back to 5.2.
I tried the conversion again and this time I got an error which is a step further forward than I achieved before.
The error warned me that a line in convert.php was trying to execute a command containing "sql_max_join_size" and failed. I searched for that error and the advice was to delete the "sql_" from the command. Therefore I searched the convert.php file for all instances containing "sql_max_join" and deleted the "sql_" string.
I uploaded a copy to the root of the smf folder and ran it again.
This time, there was a pause as something happened in the background (previously the response was instantaneous).
A screen appeared to tell me that several tables had been converted and that the messages table was currently being converted but may take a long time to save overloading the server. It took about 2min.
The process finished with only one error about not being able to convert smileys. I could chase that down to fix it but it hardly seems worthwhile.
I tried to log in with my newly created smf admin account but the account was not recognised. I looked at phpmyadmin and realised that the conversion process had overwritten the members table with the old IPB members including the admin account. Therefore, I logged in with the old IPB credentials and I got back in.
Once in the Admin cernter, I ran some maintenance which found a few errors but gave me the chance to reapir them. All errors repaired successfully.
The next step is to get the smf board up from the current version 1.1.21 to the newest version 2.1. I also need to get the php version updated from 5.2 to something above 7.0. Do you know how many intermediate steps I need to go through? Is there a preferred sequence?
Thanks for all your help. It is greatly appreciated.
Kind regards,
Norrie
Glad that it worked at last! :)
Now, again, you should firstly make a backup, just to be sure you have it saved, and then change php version to 7.3 (or higher), upload large upgrade pack for 2.1 and run upgrade.php file.
You can find upgrade pack here:
https://download.simplemachines.org/
More info about upgrading:
Upgrading SMF (https://wiki.simplemachines.org/smf/Upgrading)
Quote from: norrie on April 12, 2022, 04:16:18 AMThe next step is to get the smf board up from the current version 1.1.21 to the newest version 2.1. I also need to get the php version updated from 5.2 to something above 7.0. Do you know how many intermediate steps I need to go through? Is there a preferred sequence?
Glad to see that you managed to convert to Smf. Regarding the upgrade, you can upgrade your php to 7.4.x as both smf versions, 2.0.19 and 2.1.x support it. As far as upgrading your forum goes, you can do a direct upgrade to 2.1.x or you can upgrade first to 2.0.19 and then to 2.1.x. PersonallY i would recommend, if I may, to do the upgrade in steps. i.e. first to 2.0.19 and then to 2.1.1.
Quote from: Doug Heffernan on April 12, 2022, 08:10:36 AMPersonallY i would recommend, if I may, to do the upgrade in steps. i.e. first to 2.0.19 and then to 2.1.1.
Is there any particular reason why you would recommend that,
@Doug Heffernan? If there is some sort of issue upgrading directly, the dev team wants to know about it. If there isn't, then I recommend upgrading directly to 2.1.1.
Quote from: Sesquipedalian on April 12, 2022, 11:43:33 AMQuote from: Doug Heffernan on April 12, 2022, 08:10:36 AMPersonallY i would recommend, if I may, to do the upgrade in steps. i.e. first to 2.0.19 and then to 2.1.1.
Is there any particular reason why you would recommend that, @Doug Heffernan? If there is some sort of issue upgrading directly, the dev team wants to know about it. If there isn't, then I recommend upgrading directly to 2.1.1.
No issues that I am aware of as I have never upgraded a smf 1.1.x myself. The reason that I recommend upgrading to 2.0.19 first is based on my experience with another forum software, Ipb, that I did last year. I tried to upgrade a 3.4. forum to 4.6 for a client of mine, and the upgrader threw a lot of errors as it was looking for db stuff that were added in Ipb 4, but were not present in the 3.4 version. I rolled back to 3.4, upgraded the forum to Ipb 4 first and then to Ipb 4.6. without any issues.
Anyways, I thought that this might happen here too while upgrading such an old version to 2.1.1 and wanted to throw it out there as an alternative for norrie should they run into the same situation I did, while doing a direct upgrade to 2.1.1.
Sorry gents, spoke too soon.
None of the attachments for any of the posts have been transferred from the old to new forum. Is there an easy way to make this happen? Should I re-run the convert.php file? Is there an sql command that would target just the attachments and transfer them over?
Kind regards,
Norrie
Gents,
I think I have worked out why the attachments did not transfer. The conversion progress hit an error when converting the smileys and stopped the conversion script at that point.
ipb_to_smf conversion error.JPG
The transfer of attachments happens after the smileys and therefore it was never executed.
I have fixed the smiley conversion script by changing:
Code: [Select]
ALTER TABLE {$db_prefix}smileys
ORDER BY LENGTH(code) DESC;To
Code: [Select]
ALTER TABLE {$db_prefix}smileys
ORDER BY code DESC;
Therefore, it should not get stuck on that section again.
Can I safely run the convert.php file again? Will it create duplicates of all the table entries if I do this?
Kind regards,
Norrie
Quote from: norrie on April 13, 2022, 05:22:59 AMI have fixed the smiley conversion script by changing:
Code Select Expand
Code: [Select]
ALTER TABLE {$db_prefix}smileys
ORDER BY LENGTH(code) DESC;To
Code Select Expand
Code: [Select]
ALTER TABLE {$db_prefix}smileys
ORDER BY code DESC;
Therefore, it should not get stuck on that section again.
Thank you for providing the fix. ;) I will help other users in the future who might run into this issue as well.
Quote from: norrie on April 13, 2022, 05:22:59 AMCan I safely run the convert.php file again? Will it create duplicates of all the table entries if I do this?
I think that you can.
I wouldn't say so.
Try: ORDER BY CHAR_LENGTH(code) DESC;
Though order is not that important at all in this case. You have backup ready anyway, so I'd try with that.
Please bear with me. Its holiday weekend and work commitments are pressing.It might be a few days before I can respond.
Thanks
Norrie
I reinstall SMF (after deleting all SMF tables) every time I have an error on the conversion. Then I restart the conversion from the beginning.
Quote from: argosinmpuinufx on June 08, 2022, 11:28:14 AMI reinstall SMF (after deleting all SMF tables) every time I have an error on the conversion. Then I restart the conversion from the beginning.
What errors do you get with the conversion? Uninstalling and re installing SMf after each error is not necessary.