I reindexed threads before converting but ubb inserts blank lines from time to time. The fix is to open the forumX.threads file and manually delete them. Also, this converter doesn't like missing member files (that have been deleted from the hdd). The fix was to download a good member file, and replace the good name with "unknown1", "unknown2" etc for each missing file, then save using the correct file name and reupload.
Lastly, I'm not one hundred percent sure, but I think the converter touched a few posts files and set them to zero bytes. I have no way to check or test, but it looks suspiciously like it does. This is a problem because following the "converting forums" page (very near the beginning) where it says
Successfully converted forums 1 - 16
you get this message
Code: Select all
Converting Messages Unsuccessfully added index on username column DB Error: unknown error DROP INDEX username ON users [nativecode=1091 ** Can't DROP 'username'. Check that column/key exists] Unsuccessfully opened /home/forum/public_html/pages/Forum1/000260.cgi
That's it. I saved almost twelve thousand posts. I'm happy.