Advertisement:

Author Topic: [WIP - Converter] IPB 3.2/3.3/3.4  (Read 144394 times)

Offline EricGagne

  • Newbie
  • *
  • Posts: 4
Re: [WIP - Converter] IPB 3.2/3.3/3.4
« Reply #260 on: July 02, 2015, 11:14:34 AM »
Hello,

I am having issues with a conversion.

First, the environment.  I am moving from IPB Hosted community to SMF on my own VPS.   Not having access to phpMyAdmin on Invision's side, I had to use the "SQL Backup" option in the admin control panel which creates a SQL file.

I created a database on my server and ran the SQL file to import the data.  This seems to have worked but I cannot check its validity because I can't install IPB on this server to "test" the database.

I created a local version of conf_global.php with the correct information for the converter to get the IPB database connection info. 

First time I ran the converter, I received Unknown system variable 'SQL_MAX_JOIN_SIZE' errors.  It seems to be related to the version of mysql so I edited the conver.php file and changed all those to MAX_JOIN_SIZE.

That seems to have fixed this problem but now, right at the start, the converter gives me

Converting members...Field 'buddy_list' doesn't have a default value

and stops there.  I searched this topic for "buddy_list" but I seem to be the first one reporting such a problem.   

I would appreciate any help.


Edit:  And now I just realized the converter title says IPB 3.2 to SMF Converter.  I am converting from 3.4.7.   I downloaded the files from the first post in this topic, is there a newer version ?

Offline allpar

  • Semi-Newbie
  • *
  • Posts: 32
Re: [WIP - Converter] IPB 3.2/3.3/3.4
« Reply #261 on: July 02, 2015, 01:35:55 PM »
If there is not a newer version, can you use PHPMySQL? It';s standard in CPanel installations. You could use that to give buddy_list a default value. Or you could go into the converter, and comment out any references to buddy_list. I don't think your members will object to its loss or reset.

Offline EricGagne

  • Newbie
  • *
  • Posts: 4
Re: [WIP - Converter] IPB 3.2/3.3/3.4
« Reply #262 on: July 02, 2015, 06:19:14 PM »
Problem fixed.  It has to do with the way MySQL 5.x handles TEXT columns with no default values.   I only needed to disable strict mode.

Offline CrazyTech

  • Semi-Newbie
  • *
  • Posts: 52
  • Gender: Male
  • Proud Member
    • Christianity Board
Re: [WIP - Converter] IPB 3.2/3.3/3.4
« Reply #263 on: July 24, 2015, 04:09:32 PM »
Nevermind. Think I got it, thanks!
« Last Edit: July 24, 2015, 04:20:19 PM by CrazyTech »

Offline CrazyTech

  • Semi-Newbie
  • *
  • Posts: 52
  • Gender: Male
  • Proud Member
    • Christianity Board
Re: [WIP - Converter] IPB 3.2/3.3/3.4
« Reply #264 on: July 24, 2015, 05:36:42 PM »
Well, I got past my earlier error, but there were so many errors with this conversion that I don't know where to start. All accounts came over as guests and topics didn't make it. I'm now unable to login so I don't see me having the knowledge to get this converted over. SMF was worth a shot, but oh well.

This is with IPB 3.4.8.

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [WIP - Converter] IPB 3.2/3.3/3.4
« Reply #265 on: July 25, 2015, 08:52:16 AM »
Several people already used this with much success so I would guess that we should try again?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline CrazyTech

  • Semi-Newbie
  • *
  • Posts: 52
  • Gender: Male
  • Proud Member
    • Christianity Board
Re: [WIP - Converter] IPB 3.2/3.3/3.4
« Reply #266 on: July 28, 2015, 03:15:06 PM »
Quote
Fatal error: Call to undefined function getAttachmentFilename() in /home/adonai/public_html/smf/convert.php on line 2339

That's the first error, because the usernames aren't coming over. It looks like the actual topics have, but none of the accompanying data linking them to the individual forums, etc. I tried to work through a couple of the errors, but I saw stuff like this on almost every page.

I can delete everything out and start afresh I suppose, but it seems like a lot of issues that might be a bit beyond my coding knowledge.

Offline Bigdesaster

  • Newbie
  • *
  • Posts: 2
Re: [WIP - Converter] IPB 3.2/3.3/3.4
« Reply #267 on: January 30, 2016, 05:02:38 PM »
Hello everybody,

I tried to convert my board from IPB3.4.7 to SMF2.0.11

Just got an errror converting  personal messagess but i can skip this error by increasing start in URL
Quote
Converting personal messages (step 2)...Duplicate entry '555-4' for key 1
.

The real problem i got is that the most boards are moved to "general caterory"
Some categorys were created but empty, others were even not created.
What could be the reason for this and how to fix?

thank you

Offline Bigdesaster

  • Newbie
  • *
  • Posts: 2
Re: [WIP - Converter] IPB 3.2/3.3/3.4
« Reply #268 on: January 31, 2016, 11:05:19 AM »
Hello again,
i was able to fix it myself

Just open ipb3_to_smf.sql and search for:
Code: [Select]
/******************************************************************************/
--- Converting boards...
/******************************************************************************/
Replace
Code: [Select]
SELECT
b.id AS id_board, SUBSTRING(b.name, 1, 255) AS name,
SUBSTRING(b.description, 1, 65534) AS description, b.position AS board_order,
b.posts AS num_posts, IF (p.parent_id = -1, 0, p.parent_id) AS id_parent, b.inc_postcount AS count_posts,
        '-1,0' AS member_groups
FROM {$from_prefix}forums AS b
        LEFT JOIN {$from_prefix}forums AS p ON (b.parent_id = p.id)
WHERE b.parent_id != -1;
---*

i replaced it with:
Code: [Select]
SELECT
b.id AS id_board, SUBSTRING(b.name, 1, 255) AS name,
SUBSTRING(b.description, 1, 65534) AS description, b.position AS board_order,
b.posts AS num_posts, IF (b.parent_id = -1, 0, b.parent_id) AS id_parent, b.inc_postcount AS count_posts,
        '-1,0' AS member_groups
FROM {$from_prefix}forums AS b
        LEFT JOIN {$from_prefix}forums AS p ON (b.parent_id = p.id)
WHERE b.parent_id != -1;
---*

Offline Immort

  • Newbie
  • *
  • Posts: 1
Re: [WIP - Converter] IPB 3.2/3.3/3.4
« Reply #269 on: July 26, 2016, 03:16:48 AM »
Hi,

I would like to know if this project is still ongoing, and if newer versions of this converter will be coming up?

I am very interested to convert an IPB 3.4.3 into Simple Machines. 3.4.x is the latest IPB board that is available for people with perpetual licences, so there are many of us already who are interested in another good forum software.

Many thanks,

Offline jack208

  • Newbie
  • *
  • Posts: 1
Re: [WIP - Converter] IPB 3.2/3.3/3.4
« Reply #270 on: August 27, 2017, 04:11:47 AM »
I am looking to convert IPB 3.4.5. Is this still active or no further progress? Thanks in advance.

Offline d3vcho(void)

  • On Hiatus
  • SMF Hero
  • *
  • Posts: 2,245
  • Gender: Male
  • Be prepared for hell
    • d3vcho on GitHub
    • @SMF_ES on Twitter
Re: [WIP - Converter] IPB 3.2/3.3/3.4
« Reply #271 on: August 27, 2017, 09:38:30 AM »
I believe there has been no progress on this for too long.