Simple Machines Community Forum

SMF Support => Converting to SMF => IPB => Topic started by: JayBachatero on January 28, 2007, 02:56:33 PM

Title: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on January 28, 2007, 02:56:33 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Puc conDoin on February 04, 2007, 12:51:05 PM
Hi, I have a problem with the converter.

I have the following error:

Quote
Converting 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:

Quote
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 ''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:

Quote
INSERT 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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: 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:

Quote
Caused the error:

    Duplicate entry '12-0' for key 1
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on February 05, 2007, 04:11:36 PM
I've tried Sarke's solution: http://www.simplemachines.org/community/index.php?topic=137630.msg903435#msg903435

But now I get this error:

Quote
Caused the error:

    Duplicate entry '12-0' for key 1

Ok what table did you get this error on?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Puc conDoin on February 05, 2007, 04:15:44 PM
Still the same table: `forzona`.smf_poll_choices
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on February 05, 2007, 04:51:00 PM
Truncate the table and try again.  I just reuploaded the file.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Puc conDoin on February 05, 2007, 05:17:10 PM
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  
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Puc conDoin on February 07, 2007, 04:50:07 PM
Even when I remove entry 12 from the original database, I still get the "Duplicate entry"-error. On the next database row that follows.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on February 08, 2007, 11:40:58 AM
Try this one.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Puc conDoin on February 08, 2007, 05:12:09 PM
Thanx! The error on the poll choices table didn't show up anymore!  ;D

But unfortunately, another error has come up:

Quote
Converting personal messages (step 1)... Unsuccessful!
This query:

    INSERT IGNORE INTO `forzona`.smf_personal_messages
    (ID_PM, ID_MEMBER_FROM, msgtime, fromName, subject, body)

and

Quote
Caused the error:

    Got a packet bigger than 'max_allowed_packet' bytes
Title: Re: [SMF Converter] IPB 1.3.x
Post by: 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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Puc conDoin on February 09, 2007, 12:13:58 PM
Quote
Caused 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:

Quote
Converting personal messages (step 1)... Unsuccessful!
This query:

    INSERT INTO `forzona_nl`.smf_personal_messages
    (ID_PM, ID_MEMBER_FROM, msgtime, fromName, subject, body)

and

Quote
Caused 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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on February 09, 2007, 01:21:14 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Puc conDoin on February 09, 2007, 01:43:26 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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on February 10, 2007, 01:59:05 PM
If I'm correct the limit is 200 or 500.  One of the two.  You can try limiting it to just 100.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Puc conDoin on February 11, 2007, 07:10:14 AM
Where do I find this? Can I change that in this code in convert.php?

Code: [Select]
$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;
}
Title: Re: [SMF Converter] IPB 1.3.x
Post by: 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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Puc conDoin on February 12, 2007, 03:26:23 AM
Ok, thanx! I will try this today and let you know how this works out.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Puc conDoin on February 12, 2007, 02:17:51 PM
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!
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Puc conDoin on February 14, 2007, 06:59:47 AM
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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on February 14, 2007, 12:05:09 PM
I believe that I fixed this in the new file that I put up.  I guess yours stayed there from the previous conversion.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: 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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: vincent1982 on February 23, 2007, 05:17:53 AM
Code: [Select]
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on February 28, 2007, 10:34:29 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.

Code: [Select]
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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: mikev on March 07, 2007, 10:24:41 AM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on March 07, 2007, 12:41:09 PM
Hit me up today on AIM.  I'm going to have to debug the converter.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: mikev on March 07, 2007, 02:10:06 PM
Thanks, will do.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SlashDash on March 11, 2007, 12:31:05 AM
i downloaded the converter and the file but what next? i want to convert my invisionfree 1.3 to smf
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on March 11, 2007, 02:18:13 PM
Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: LastMohican on April 08, 2007, 01:19:59 PM
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)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Pranav on April 26, 2007, 10:33:26 PM
Ok.The conversion was successful but after sometime i got error in the whole forum.It is this -
Quote
Parse error: syntax error, unexpected T_STRING in /home/ulgaming/public_html/forum/Settings.php on line 32
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on May 17, 2007, 02:10:08 AM
Did you get this fixed?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Buk on June 05, 2007, 10:51:25 PM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: satchownz on June 07, 2007, 02:30:44 PM
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!
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Lothy on June 08, 2007, 10:56:22 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: theonetruebix on July 12, 2007, 05:45:01 PM
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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on August 08, 2007, 01:45:28 AM
ATM the converters on the converter pare are not up to date.  Use the one on this topic.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: chucara on August 09, 2007, 10:49:15 AM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on August 09, 2007, 09:04:39 PM
Open the sql file

Find:
Code: [Select]
ALTER TABLE {$to_prefix}smileys
ORDER BY LENGTH(code) DESC;

Replace:
Code: [Select]
ALTER TABLE {$to_prefix}smileys
ORDER BY code DESC;

Title: Re: [SMF Converter] IPB 1.3.x
Post by: nyagi on October 17, 2007, 11:32:39 AM
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!
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on October 19, 2007, 01:13:56 AM
Try reuploading the files again.  Seems like they got corrupt.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: WriteOn on November 10, 2007, 11:18:49 AM
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! 
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on November 13, 2007, 02:05:43 AM
I haven't tried converting the calendars but it can  be done but it will require some work :(.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DeusEx on December 02, 2007, 03:43:35 AM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DeusEx on December 03, 2007, 11:27:35 AM
i had problems using apache, mysql and php on windows (Denwer emulator). When i copied converter and forums to hoster convertion proceed fine.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: tinatoth on January 23, 2008, 07:41:57 PM
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)

Code: [Select]
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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on January 23, 2008, 10:49:22 PM
Use the file in this topic.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: tinatoth on January 24, 2008, 06:04:36 AM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: tinatoth on January 24, 2008, 06:21:54 AM
Ok the new sql file worked for the poll choices table problem, thankyou! :)

But now I have a new one. This showed up next:

Quote
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 `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:

Open the sql file

Find:
Code: [Select]
ALTER TABLE {$to_prefix}smileys
ORDER BY LENGTH(code) DESC;

Replace:
Code: [Select]
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:


Quote
Recalculating 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!
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on January 24, 2008, 11:31:52 AM
Use the updated convert.php file.  Updated Converters List & Support Topics (http://www.simplemachines.org/community/index.php?topic=140741.0)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: tinatoth on January 24, 2008, 12:59:10 PM
oh god, I'm so silly! I never noticed a file attached to that topic! Thanks a lot, that worked! WOohoooOoO! :)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: KapsiaoGina on February 11, 2008, 05:49:30 AM
Hi what should i do to convert my IPB to SMF???
Thanks in advanced...
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Michael-inc on February 22, 2008, 03:00:02 AM
**edit

Nevermind.  :)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Michael-inc on February 23, 2008, 12:17:16 AM
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!
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on February 26, 2008, 10:31:05 PM
I suggest you make a new topic for this issue.  It's not related to the conversion.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: JayBachatero on February 26, 2008, 10:31:18 PM
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)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: xmariox on March 07, 2008, 04:43:56 PM
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:

Quote
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...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:

Quote
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...Duplicate entry '9' for key 1

Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 12, 2008, 11:34:04 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 14, 2008, 02:32:04 AM
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=0fe0d1fe66e8becf6568e47e0bfa0318)

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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: vwchris on April 17, 2008, 07:19:06 PM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: 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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: vwchris on April 17, 2008, 07:29:33 PM
Yes.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: vwchris on April 17, 2008, 07:31:25 PM
It fails trying to build topics and convert posts
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 17, 2008, 07:50:07 PM
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)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: vwchris on April 17, 2008, 08:10:28 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 17, 2008, 09:22:47 PM
Don't hit continue. It is working on the conversion and you may have double submitted the data which resulted in the duplicate key.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: vwchris on April 17, 2008, 10:35:40 PM
figured that out, thanks for the help.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 21, 2008, 03:57:51 AM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 21, 2008, 12:34:08 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 21, 2008, 03:42:03 PM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 21, 2008, 10:49:39 PM
phpmyadmin comes with a search feature.
Just search the "posts" table by "pid" of "66640"

There should be two of them, remove one.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 21, 2008, 11:08:52 PM
as I said in my previous post. I did used the search feature, and i found no results:

Quote
MySQL 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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 22, 2008, 01:09:47 AM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 22, 2008, 02:30:32 AM
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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 22, 2008, 12:06:27 PM
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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 22, 2008, 12:58:56 PM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 22, 2008, 01:04:40 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 26, 2008, 10:59:55 AM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 26, 2008, 12:49:32 PM
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)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 26, 2008, 03:06:42 PM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 26, 2008, 04:42:21 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 26, 2008, 04:59:46 PM
here is it
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 26, 2008, 05:31:26 PM
Ok, lets try this attached script..
I bumped the id group it was using, so it should be doing it. Hopefully :|
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 26, 2008, 05:55:18 PM
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"
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 26, 2008, 06:10:10 PM
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...
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 26, 2008, 06:28:17 PM
ok this is what I got now:

Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 26, 2008, 08:13:31 PM
I am going to have to let jay look at this, I am not sure what is up now..
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 28, 2008, 01:11:20 AM
DJ Omnimaga,

Can you try the attached file?
It should hopefully ignore the duplicate errors and help with this.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 28, 2008, 01:32:00 AM
nope, still getting the same error, with ?debug=1 or not :(
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 28, 2008, 01:43:53 AM
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 :)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 28, 2008, 02:48:32 AM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 28, 2008, 10:45:52 AM
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 :)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 28, 2008, 02:26:37 PM
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:

Quote
Warning: 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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 28, 2008, 03:53:01 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: DJ Omnimaga on April 28, 2008, 04:46:17 PM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on April 28, 2008, 07:05:26 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: MaNaRa on June 06, 2008, 07:26:29 PM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: MaNaRa on June 07, 2008, 12:06:08 PM
any help?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on June 07, 2008, 07:08:33 PM
What doesn't make it?

Do you get any errors?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: MaNaRa on June 07, 2008, 07:47:10 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on June 07, 2008, 07:56:41 PM
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 :)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: MaNaRa on June 07, 2008, 08:31:08 PM
ok thanks, im create a new directory en my ftp with the name: ipb but the message is =
Title: Re: [SMF Converter] IPB 1.3.x
Post by: jaeason on June 27, 2008, 10:50:36 AM
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  :)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on June 27, 2008, 01:17:06 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: jaeason on June 28, 2008, 11:08:04 AM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on June 28, 2008, 01:29:12 PM
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

Code: [Select]
<?php
$INFO
['sql_database'] = '';
$INFO['sql_tbl_prefix'] = '';
?>

And then specify the IPB database and its prefix (A common word before all the tables).
Title: Re: [SMF Converter] IPB 1.3.x
Post by: jaeason on June 28, 2008, 05:52:09 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: 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 :)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: jaeason on June 29, 2008, 01:28:06 PM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on June 29, 2008, 05:10:02 PM
The error would help me know what is going wrong :)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: jaeason on June 29, 2008, 11:25:34 PM
Here ya go, sleepmeister.  I hope its something simple...

Code: [Select]
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: 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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: jaeason on June 30, 2008, 01:03:56 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!

Code: [Select]
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 3

I'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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: jaeason on June 30, 2008, 01:11:56 AM
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!
Title: Re: [SMF Converter] IPB 1.3.x
Post by: jaeason on June 30, 2008, 02:26:11 AM
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:

Code: [Select]
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...
Title: Re: [SMF Converter] IPB 1.3.x
Post by: jaeason on June 30, 2008, 02:42:49 AM

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!
Title: Re: [SMF Converter] IPB 1.3.x
Post by: jaeason on June 30, 2008, 03:37:10 AM
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 
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on June 30, 2008, 05:50:30 PM
Which file did you find that was updated?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: jaeason on July 01, 2008, 06:01:10 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!
Title: Re: [SMF Converter] IPB 1.3.x
Post by: jamesg on August 04, 2008, 04:24:40 AM
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...
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ThorstenE on August 04, 2008, 04:56:23 AM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: GerMalaz on August 13, 2008, 06:17:51 PM
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).
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on August 14, 2008, 01:29:39 AM
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:
Code: [Select]
---* {$to_prefix}topics
and Replace that with:
Code: [Select]
---* {$to_prefix}topics 200Note 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.

Title: Re: [SMF Converter] IPB 1.3.x
Post by: GerMalaz on August 14, 2008, 01:54:01 AM
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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ThorstenE on August 14, 2008, 02:20:41 AM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: GerMalaz on August 14, 2008, 07:30:53 AM
My fault, was using an old one, taken from smf_1-1-5_invision_converter.tar.gz.

Maybe it can be updated?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: GerMalaz on August 14, 2008, 08:26:41 AM
Also solved the slow topics conversion issue:

Replaced
Code: [Select]
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
Code: [Select]
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: GerMalaz on August 15, 2008, 02:01:33 AM
Success (at first glance, checking further).

Thanks all.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: dantheman1 on October 06, 2008, 11:39:25 AM
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?  :-[
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ThorstenE on October 06, 2008, 02:16:09 PM
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...
Title: Re: [SMF Converter] IPB 1.3.x
Post by: worstl on March 04, 2009, 10:11:20 AM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ThorstenE on March 04, 2009, 12:41:21 PM
was it an error like "duplicate entry" or similar? can you post the exact error message please?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: worstl on March 05, 2009, 04:55:54 AM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: worstl on March 05, 2009, 06:59:11 AM
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*
Title: Re: [SMF Converter] IPB 1.3.x
Post by: worstl on March 05, 2009, 07:28:26 AM
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!
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ThorstenE on March 05, 2009, 09:43:14 AM
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?)

Title: Re: [SMF Converter] IPB 1.3.x
Post by: worstl on March 06, 2009, 06:58:02 AM
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. 
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ThorstenE on March 06, 2009, 01:27:55 PM
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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: worstl on March 12, 2009, 05:39:03 AM
I can't really imagine that the IPB is corrupted. But I will try the XAMPP thing.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on March 20, 2009, 05:53:44 PM
worstl,

Any luck?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: lkw888 on April 24, 2009, 09:02:17 AM
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

Quote
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.

This seems like a solution but can someone explains how to restart the conversion w/o clicking on the "continue" button?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: lkw888 on April 24, 2009, 12:31:34 PM
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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: lkw888 on April 24, 2009, 12:52:59 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ThorstenE 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/).
Title: Re: [SMF Converter] IPB 1.3.x
Post by: lkw888 on April 25, 2009, 12:02:51 AM
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.  ;)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: craccdemo on May 05, 2009, 02:48:16 AM
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)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ThorstenE on May 05, 2009, 03:06:16 AM
craccdemo,
any errors during the conversion? please copy & paste them here.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Xeoz on September 01, 2009, 07:23:30 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: 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 :)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Xeoz on September 02, 2009, 03:43:11 PM
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.

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:

Code: [Select]
mysql> ALTER TABLE smf_members MODIFY memberIP2 tinytext Default '';
ERROR 1101 (42000): BLOB/TEXT column 'memberIP2' can't have a default value

Since 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:

Code: [Select]
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:

Code: [Select]
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 2

After 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:

Code: [Select]
Converting attachments...
Fatal error: Call to undefined function getAttachmentFilename() in C:\xampp\htdocs\convert.php(1109) : eval()'d code on line 5

I 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:

Code: [Select]
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 selected

At 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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on September 16, 2009, 06:22:00 PM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: Xeoz on September 22, 2009, 05:53:53 AM
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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: SleePy on September 29, 2009, 05:09:16 AM
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.

Title: Re: [SMF Converter] IPB 1.3.x
Post by: Morphium on December 13, 2010, 08:32:55 AM
Hi! Will you help me with this problem?

IPB 1.3 to SMF 1.1.12


Title: Re: [SMF Converter] IPB 1.3.x
Post by: apnart on January 13, 2011, 08:38:17 AM
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 ?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ThorstenE on January 13, 2011, 01:49:59 PM
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..
Title: Re: [SMF Converter] IPB 1.3.x
Post by: apnart on January 13, 2011, 02:12:08 PM
Many thanks "TE"  8)
Title: Re: [SMF Converter] IPB 1.3.x
Post by: 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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: AUser on February 18, 2012, 03:57:40 AM
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?
Title: Re: [SMF Converter] IPB 1.3.x
Post by: 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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ThorstenE on February 18, 2012, 09:03:31 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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: AUser on February 18, 2012, 12:24:45 PM
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!
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ThorstenE on February 18, 2012, 12:44:27 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 »
"
Title: Re: [SMF Converter] IPB 1.3.x
Post by: AUser on February 18, 2012, 01:49:16 PM
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!
Title: Re: [SMF Converter] IPB 1.3.x
Post by: AUser on February 18, 2012, 02:56:37 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
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ashkir on January 10, 2013, 03:07:08 AM
I'm trying to use SMF 1.1 but I can't install it because of these errors:

Quote
Line #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.
Title: Re: [SMF Converter] IPB 1.3.x
Post by: ellipsoid on August 08, 2015, 04:20:20 PM
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?