Fix for the dreaded ImpEx white screen timeout error. ImpEx is a utility to import various forum mysql databases into the VBulletin format. This timeout error happens most common when importing the POSTS with a count over 400,000. This is probably the largest part of your database. The timeout error around 400,000 posts imported results in a blank white screen that you can’t navigate away from (and an incomplete database transfer).<\/p>\n
<\/p>\n
It took me 12 hours to figure this out. And if you’re here, you’ve probably already spent 2-4 hours pulling your hair out. So if it works, please drop a comment.<\/p>\n
Fixes I saw posted online included changing server settings to increase MySql and PHP timeout settings. But that didn’t make much sense to me because I have a really beefy server. I also saw a fix that suggested you go through all your posts one by one and look for errors. 700,000 posts? No thank you. One fix actually said I should build my own local server, upload ImpEx to it locally and process, then upload the complete database to the server. Build a server for this? Yikes!
\nSo here it is. The solution.<\/p>\n
Problem:<\/strong> ImpEx times out with blank screen when importing database posts into Vbulletin.<\/p>\n Fix: <\/strong>Upload your impex folder into your root directory and access it directly there (www.yourwebsite.com\/impex). The timeout error was seemingly caused by the VBulletin control panel.<\/p>\n *Note*<\/strong> – I also increased post imports to 5,000 per page. Don’t know if this was part of the fix.<\/p>\n I imported over 600,000 posts from a PhpBB2 database into VBulletin 3.7.0 using ImpEx 1.89 uploaded to it’s own root directory. Time for this conversion was about 75 minutes.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":" Fix for the dreaded ImpEx white screen timeout error. ImpEx is a utility to import various forum mysql databases into the VBulletin format. This timeout error happens most common when importing the POSTS with a count over 400,000. This is probably the largest part of your database. The timeout error around 400,000 posts imported results […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[6],"tags":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3C0LX-KD","_links":{"self":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts\/2891"}],"collection":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/comments?post=2891"}],"version-history":[{"count":0,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/posts\/2891\/revisions"}],"wp:attachment":[{"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/media?parent=2891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/categories?post=2891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/conradaskland.com\/blog\/wp-json\/wp\/v2\/tags?post=2891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}