Trouble importing PHPBB3
I am having a heck of a time importing a PHPBB that I have been administering since 2004. It has over 100k replies and I am having trouble getting the replies to process over 24k before failing to a point where it stops processing for longer then 30 minutes and will not continue after hitting stop and start again. So far I have tried various combinations of query size and delay with no luck. 10 x 1sec, 100 x 1 sec, 1000 x 1 sec, 10 x 2 sec etc.
Any suggestions? Is there any way to make the migration continue even if you have to refresh the page?
I appreciate any feedback. Thanks.
This sadly is not easily solved, details are in the following codex article:
I took my host out of the equation and installed XAMPP, migrated both sites to my local PC and setup configs as shared in that post. Thank you for the forward!
Is there a place to submit phpbb feature requests? I have been working this migration for a bit now and have a few updates that may improved the migration experience for others. For example, a small alert when you attempt to close the import tab. I have accidentally closed an import in progress two or three times over the last 4 days. Also, a big red warning message on the screen that says “MIGRATION IN PROGRESS!”. My wife has shut down my PC twice during a migration!
What does it mean when it is in the process of migrating replies and it starts updating with dashes
-----is caused when WordPress has dropped it’s authentication session with MySQL.
As to further improvements, that is cool and would be great, using the same username and password here if you can create a a new ticket on Trac, our bug tracker here that would be great, if your familiar with SVN you can check out the source and upload a patch.
Sounds good, thanks! I will post what I can once I get my site moved.
So I have followed the steps on https://codex.bbpress.org/import-forums/import-troubleshooting/ and have isolated the first failure when moving reply 102607. I have no idea how to map 102607 to the phpbb post. Any ideas?
Presuming your doing this on a copy of your phpBB database, delete that row and continue on until your import completes, typically I haven’t had an import need more than 10 of these and depending on if it is a topic or reply and the context of the post I have either not worried about it or I have manually recreated in bbPress and assigned it to that user after the import has finished.
I found it by comparing content of the last post in bbpress against the PHPBB posts and found the next one. Deleted it and restarted the migration and it continued. I should find out what was in post ID 67939 that stalled the migration.
Hello Stephen Edgar! Good news, the migration of my site was successful. Thanks for all of your help!
I had to continue to search for the posts causing issues and delete them. I looked at the content of each and found no reason for them to error out.
And I agree, I hate that I can’t ‘fix’ this yet, I’ve manually replaced the data in affected rows to no avail, as @JJJ pointed out, it is most likely an encoding issue 😉
I just noticed that a ton of posts are associated with Anonymous. Is this a common issue? Might it be related to stopping the migration to delete rogue posts and then restarting it? I appreciate any additional direction you can provide. Thanks.
Trying to run a conversion to fix the Anonymous posts. Ran it all day and came home and it was stuck again. I did the same thing I did before where I looked at the last row created in bbpress and found the same post in phpbb by comparing content, then deleted the next one. When I do this the import continues. I would think that since I did this and complete the import this second run of the conversion would run error free but that is not the case. It is near the end and appears to be hung again. I suspect it is no coincidence that it hung twice, just like before. Guess I am not deleting the corrupt posts. Not sure why it keeps going after I delete them. If I delete another random post it still hangs until I delete the right one.
If I wanted to have it print more debug information where would I need to edit? The only information I need is the bbpress post ID and wordpress post id about to be queried and a confirmation right after the query completes. This should let me find the corrupt post.
In the instructions on https://codex.bbpress.org/import-forums/import-troubleshooting/ I am not sure how to take the information printed on the screen now and map it to the database.
Now drop all the rows in the database that are not in the range of rows that failed during import
I am not sure how the “Range of rows” maps to the database tables.
I will include a request to include a debug option for conversions.
Thanks again for your help.
My second run fixed the anonymous issue. I suspect because it never disconnected. The first import I had to refresh the page which I guess somehow unsynced the posts with the users.
Thanks again for your help!
So my migration is complete and I moved my site back to my server and built everything as I want it. I recently started hearing my phone notification every couple of minutes. When I picked up the phone I found that my site is again spamming registrants with notification emails from posts made years ago. What would cause this?
I do have buddy press enabled but the notification feature is disabled.
I appreciate any support you can provide here. I am sure my members are not appreciating the torrent of forum spam I am hitting them with now. I have reenabled the stop email plugin but am unsure if it is working and members cant register when that is up.
It appears the error has nothing to do with buddy press since it is still sending notifications with the buddypress plugin turned off.
The email blocker is also not working as I just received an email from one of the notifications.
This is horrible. Hundreds of emails have been sent. I would highly recommend a disable email function in the future or use the wp_mail() function to send email so that plugins like stop email can stop.
I appreciate any suggestions to stop this email. Thanks.
I opened a ticket with Buddypress and they believe that it is a bbpress issue.
- You must be logged in to reply to this topic.