SMF 1.1.x to phpBB3

Topics deleted after conversion - SMF 1.1.x to phpBB3

Topics deleted after conversion

by HoodedMan » Wed Sep 07, 2011 4:11 pm

So, I have an odd issue that perhaps you can shed some light on. First of all, let me thank you for providing this converter; the converter framework as a whole is quite elegant, and I'm sure this converter works quite well (as it has for other people) and I'm just doing something wrong.

When I run the converter, it completes successfully (I did have 500 Internal Server Errors, but I resolved those by changing PHP settings as recommended). When I check the database during the conversion, the phpbb3_topics table has 1,146 rows, as does the smf1_topics table.

However, by the time the conversion is completed, for some reason all but 8 of those rows are deleted! (As evidence, I exported the table before accessing the forum, in case we can compare rows to see why some are deleted; also, there's table overhead which indicates a good amount of deletion).

What could cause this? :o
HoodedMan
Registered User
Posts: 2
Joined: Wed Sep 07, 2011 3:52 pm

Re: Topics deleted after conversion

by HoodedMan » Wed Sep 07, 2011 10:25 pm

So, it seems I was able to answer my own question (after fiddling with the converter all day). Turns out somehow the auto_increment value on smf_messages was changed, so after a certain point post IDs were suddenly way over 16777215. This means they fit into id_msg int(10), but not post_id mediumint(8). Just wrote a script to remap id_msg all over the database then had quite the successful conversion. It'll break links, but then that's the least of breaking changes caused by a conversion to a new forum platform.

Leave it to me to have the really ridiculous environment that breaks everything (though it'd be nice if the converter framework logged somewhere exactly what it got from the MySQL server, which would catch most of the post body too large/long issues I've seen elsewhere).

Edit: Oh, and the topics were being deleted because since only about 4,000 posts were converted most of them were orphaned.
HoodedMan
Registered User
Posts: 2
Joined: Wed Sep 07, 2011 3:52 pm

Re: Topics deleted after conversion

by D¡cky » Wed Sep 07, 2011 10:40 pm

-- Deleted --
Have you hugged someone today?
User avatar
D¡cky
Former Team Member
Posts: 11812
Joined: Tue Jan 25, 2005 8:38 pm
Location: New Hampshire, USA
Name: Richard Foote