Topic: [SMF Converter] IPB 1.3.x

[JayBachatero]

Try reuploading the files again.  Seems like they got corrupt.

[WriteOn]

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! 

[JayBachatero]

I haven't tried converting the calendars but it can  be done but it will require some work .

[DeusEx]

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

[DeusEx]

i had problems using apache, mysql and php on windows (Denwer emulator). When i copied converter and forums to hoster convertion proceed fine.

[tinatoth]

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?

[JayBachatero]

Use the file in this topic.

[tinatoth]

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 which then links back to this one, though.

[tinatoth]

Ok the new sql file worked for the poll choices table problem, thankyou!

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

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:

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!

[JayBachatero]

Use the updated convert.php file.  Updated Converters List & Support Topics

[tinatoth]

oh god, I'm so silly! I never noticed a file attached to that topic! Thanks a lot, that worked! WOohoooOoO!

[KapsiaoGina]

Hi what should i do to convert my IPB to SMF???
Thanks in advanced...

[Michael-inc]

**edit

Nevermind. 

[Michael-inc]

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!

[JayBachatero]

I suggest you make a new topic for this issue.  It's not related to the conversion.

[JayBachatero]

Hi what should i do to convert my IPB to SMF???
Thanks in advanced...

Converting to SMF

[xmariox]

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:

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:

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

[SleePy]

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.

[DJ Omnimaga]

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:



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

[vwchris]

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