I am trying to migrate from phpBB 3.1.9 to vBulletin and the process has been somewhat successful. I first migrated to vB 3.8.9 then upgraded to vB 4.2.2
However there are outstanding issues that I am sure others have encountered and overcome and I would be grateful for any help you can offer.
My primary concern is that all threads are lacking dates. Naturally this means the latest posts in forums are also dateless with the result that all forums show no recent content. Zero dates all show as 31 Dec 1969 11:00pm. If I expand the forum search to show threads from the beginning all threads show up. Albeit with the wrong date and wrong number of replies/views. The number of post per page parameter is also being ignored but that might resolve itself if the previously mentioned issues are fixed.
The good news every post has a date and valid thread so it must be possible to rebuild the thread and forum information from them.
I have almost zero SQL experience so the chances of me re-writing the tables without help is almost nil.
I have tried to step through the post table and rewrite the thread table but without knowledge of how to use indexes properly I'm picking up the wrong values.
Basically what is required is a block of code to rewrite chunks of the thread and forum tables from the post table. Does an utility such as this exist already?
How such an glaring gap in data could have arisen is beyond me!
I have run all possible combinations of rebuilding reindexing etc in the AdminCP > Maintenance area to no avail.
Comment