IPB 3.4.1 to Simple Machines?

[Sal Collaziano]

Hey all,

Just wondering if there's a working conversion script for the version of IPB that I'm using. Please let me know.

Thank you,

Sal C.

[emanuele]

Hello Sal and welcome to sm.org.

The script you can find in this topic has been reported to work with IPB 3.4 too.

[Sal Collaziano]

Hello Sal and welcome to hxxp:sm.org [nonactive].

The script you can find in this topic has been reported to work with IPB 3.4 too.

Thank you for the welcome! I did give that a shot and get the following error:
SELECT command denied to user 'blabla_blabla'@'localhost' for table 'members'

Is there a fix for that? When you get a moment, please let me know.

Thank you!

Sal C.

[emanuele]

Are you using different databases?
Is the mysql user the same?
The message means the mysql user cannot perform some actions on the IPB database.

[Sal Collaziano]

Yes, I'm using a different database for the IPB install and SMF install. Both have their own specific user. So the error is on my end. That's good. What should I change on my end?

Thank you!

[PhuriousGeorge]

I'm assuming you're using the converter with a database user that has access to your new smf database? If so, you'd want to give that user access to read & query your old ipb database.

[Sal Collaziano]

I'm assuming you're using the converter with a database user that has access to your new smf database? If so, you'd want to give that user access to read & query your old ipb database.

Got ya! Let me go try that right now...

Thank you!

edit: It's working... I'll post about how it goes when finished...

My goodness. How many posts do I need to avoid the "verification" for each post? I suck at it. :p

[Sal Collaziano]

Well, I'm not getting anywhere because of this:

Got a packet bigger than 'max_allowed_packet' bytes

Any quick and easy solutions to that?

[emanuele]

At what step did you get the error?
That problem is due to some query that tries to "push" too many things at one time.

In order to avoid it you have to limit the queries in the converter.
In particular, in ipb_to_smf.sql, you have to find the step that fails, there you will see something like:

Code Select Expand

/******************************************************************************/
--- Converting topics...
/******************************************************************************/

TRUNCATE {$to_prefix}topics;
TRUNCATE {$to_prefix}log_topics;
TRUNCATE {$to_prefix}log_boards;
TRUNCATE {$to_prefix}log_mark_read;

---* {$to_prefix}topics


The part you need to touch is the last line:

Code Select Expand

---* {$to_prefix}topics
if it appears like that, just add a space and a number, 20 for example:

Code Select Expand

---* {$to_prefix}topics 20
if there is already a number change it to something smaller.

[Sal Collaziano]

Thank you! It's happening while converting posts... Should I still look for something in the sql file?
How about:
---* {$to_prefix}messages 20

At what step did you get the error?
That problem is due to some query that tries to "push" too many things at one time.

In order to avoid it you have to limit the queries in the converter.
In particular, in ipb_to_smf.sql, you have to find the step that fails, there you will see something like:

Code Select Expand

/******************************************************************************/
--- Converting topics...
/******************************************************************************/

TRUNCATE {$to_prefix}topics;
TRUNCATE {$to_prefix}log_topics;
TRUNCATE {$to_prefix}log_boards;
TRUNCATE {$to_prefix}log_mark_read;

---* {$to_prefix}topics


The part you need to touch is the last line:

Code Select Expand

---* {$to_prefix}topics
if it appears like that, just add a space and a number, 20 for example:

Code Select Expand

---* {$to_prefix}topics 20
if there is already a number change it to something smaller.

[emanuele]

Yep, try it.

[Sal Collaziano]

Okay, I got stuck by a crashed table, fixed it and continued - but the page doesn't seem to be loading here:
convert.php?step=1&substep=19&start=0

Is there a way to get this working again? The page loads for a second or two and then just stops...

[emanuele]

It may be a timeout, check the last step the converter is doing (the last message should tell you) and try the same as above limiting the amount of work at times.

[Sal Collaziano]

All done. Thank you very much for the assistance!