Advertisement:

Author Topic: [SMF Converter] IPB 1.3.x  (Read 236132 times)

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 1.3.x
« Reply #40 on: October 19, 2007, 01:13:56 AM »
Try reuploading the files again.  Seems like they got corrupt.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline WriteOn

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 1.3.x
« Reply #41 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! 

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 1.3.x
« Reply #42 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 :(.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline DeusEx

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 1.3.x
« Reply #43 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

Offline DeusEx

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 1.3.x
« Reply #44 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.

Offline tinatoth

  • Jr. Member
  • **
  • Posts: 209
Re: [SMF Converter] IPB 1.3.x
« Reply #45 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?
« Last Edit: January 23, 2008, 08:02:28 PM by tinatoth »

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 1.3.x
« Reply #46 on: January 23, 2008, 10:49:22 PM »
Use the file in this topic.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline tinatoth

  • Jr. Member
  • **
  • Posts: 209
Re: [SMF Converter] IPB 1.3.x
« Reply #47 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 which then links back to this one, though.
« Last Edit: January 24, 2008, 06:06:39 AM by tinatoth »

Offline tinatoth

  • Jr. Member
  • **
  • Posts: 209
Re: [SMF Converter] IPB 1.3.x
« Reply #48 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!

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 1.3.x
« Reply #49 on: January 24, 2008, 11:31:52 AM »
Use the updated convert.php file.  Updated Converters List & Support Topics
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline tinatoth

  • Jr. Member
  • **
  • Posts: 209
Re: [SMF Converter] IPB 1.3.x
« Reply #50 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! :)

Offline KapsiaoGina

  • Semi-Newbie
  • *
  • Posts: 17
Re: [SMF Converter] IPB 1.3.x
« Reply #51 on: February 11, 2008, 05:49:30 AM »
Hi what should i do to convert my IPB to SMF???
Thanks in advanced...

Offline Michael-inc

  • Newbie
  • *
  • Posts: 6
    • Michael-Inc.
Re: [SMF Converter] IPB 1.3.x
« Reply #52 on: February 22, 2008, 03:00:02 AM »
**edit

Nevermind.  :)
« Last Edit: February 22, 2008, 03:53:54 AM by Michael-inc »

Offline Michael-inc

  • Newbie
  • *
  • Posts: 6
    • Michael-Inc.
Re: [SMF Converter] IPB 1.3.x
« Reply #53 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!

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 1.3.x
« Reply #54 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.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline JayBachatero

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,562
  • Gender: Male
    • @jaycreations on Twitter
    • JayBachatero.com
Re: [SMF Converter] IPB 1.3.x
« Reply #55 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
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Offline xmariox

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] IPB 1.3.x
« Reply #56 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

« Last Edit: March 07, 2008, 05:59:46 PM by xmariox »

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,941
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 1.3.x
« Reply #57 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.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline DJ Omnimaga

  • Jr. Member
  • **
  • Posts: 160
  • Gender: Male
  • CodeWalrus founder & retired Omnimaga founder
    • DJOmnimaga.Music on Facebook
    • @DJOmnimaga on Twitter
    • CodeWalrus
Re: [SMF Converter] IPB 1.3.x
« Reply #58 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:



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
« Last Edit: April 14, 2008, 02:44:04 AM by DJ Omnimaga »

Bandcamp|Reverbnation|Facebook|Youtube|Twitter
Retired Omnimaga admin (2001-11) and editor (2012-14)

Offline vwchris

  • Semi-Newbie
  • *
  • Posts: 13
Re: [SMF Converter] IPB 1.3.x
« Reply #59 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