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.
Hello Sal and welcome to sm.org.
The script you can find in this topic (http://www.simplemachines.org/community/index.php?topic=477019.0) has been reported to work with IPB 3.4 too. ;)
Quote from: emanuele on February 20, 2013, 03:59:24 PM
Hello Sal and welcome to sm.org.
The script you can find in this topic (http://www.simplemachines.org/community/index.php?topic=477019.0) 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.
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.
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!
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.
Quote from: Phuriousgeorge on February 21, 2013, 12:20:32 PM
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
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?
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:
/******************************************************************************/
--- 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:
---* {$to_prefix}topics
if it appears like that, just add a space and a number, 20 for example:
---* {$to_prefix}topics 20
if there is already a number change it to something smaller.
Thank you! It's happening while converting posts... Should I still look for something in the sql file?
How about:
---* {$to_prefix}messages 20
Quote from: emanuele on February 21, 2013, 04:28:05 PM
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:
/******************************************************************************/
--- 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:
---* {$to_prefix}topics
if it appears like that, just add a space and a number, 20 for example:
---* {$to_prefix}topics 20
if there is already a number change it to something smaller.
Yep, try it.
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...
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.
All done. Thank you very much for the assistance!