Hi, I've been battling this vB install / import for a couple days now. I purchased vB with the intention of using it to upgrade my already existing phpBB 3.1.7-pl1 install.
I am using Impex to import everything to vB and following the steps for after importing (like resetting the counters and running cleaner.php)
Everything seems to import over but I am running into a few big problems.
1. On the main forum index and the sub forum index the last post shows as never
2. On the indexes the number of replies to each thread is 0
3. On the main forum index at the bottom statistics, it shows the thread count properly but the total posts count is not correct. It shows the same as thread count.
4. The post dates on the indexs of the main page and sub forums show 1/1/1970, but when you open a specific thread the dates inside the thread appear correct.
When I reply to an existing thread it seems to change everything back to normal. The bottom statistics on the main forum will increase by 1 for total posts and it will show the latest reply in the indexes. The indexes however still show 0 replies on that specific post. If I create a new thread, then everything acts as normal on that thread only, replies are counted and everything.
There is obviously an issue with either a vB setting that I'm missing or the dates in the database that has been transferred over. I'm thinking there might be a sql command I can run to fix this, I just don't know what it would be. There might also be something I can tweak in the Impex scripts to solve this problem? I've tried importing to both vB4 and vB3, both versions give the same results.
Thank you in advanced for any help you can provide. I'm at a loss here. I've been fighting this for 2 days and I've got nowhere with it. If I haven't figured it out by now, I'm not going to. I just need help. I've tried searching the internet high and low and searched on both vbulletin.com and vbulletin.org without much luck.
EDIT :
After doing some digging I found a couple of things.
phpBB3 has a table for TOPICS
phpBB3.1 has a table for TOPICS and POSTS.
The info for what user made the last reply in a topic is stored in POSTS on 3.1, a whole separate table than it is on 3 where everything is just under TOPICS
The Impex file that pulls the TOPICS information is 006.php. I can see how to add additional items to it if they are in the same table, but how can I have 006.php pull from both TOPICS and POSTS?
I am using Impex to import everything to vB and following the steps for after importing (like resetting the counters and running cleaner.php)
Everything seems to import over but I am running into a few big problems.
1. On the main forum index and the sub forum index the last post shows as never
2. On the indexes the number of replies to each thread is 0
3. On the main forum index at the bottom statistics, it shows the thread count properly but the total posts count is not correct. It shows the same as thread count.
4. The post dates on the indexs of the main page and sub forums show 1/1/1970, but when you open a specific thread the dates inside the thread appear correct.
When I reply to an existing thread it seems to change everything back to normal. The bottom statistics on the main forum will increase by 1 for total posts and it will show the latest reply in the indexes. The indexes however still show 0 replies on that specific post. If I create a new thread, then everything acts as normal on that thread only, replies are counted and everything.
There is obviously an issue with either a vB setting that I'm missing or the dates in the database that has been transferred over. I'm thinking there might be a sql command I can run to fix this, I just don't know what it would be. There might also be something I can tweak in the Impex scripts to solve this problem? I've tried importing to both vB4 and vB3, both versions give the same results.
Thank you in advanced for any help you can provide. I'm at a loss here. I've been fighting this for 2 days and I've got nowhere with it. If I haven't figured it out by now, I'm not going to. I just need help. I've tried searching the internet high and low and searched on both vbulletin.com and vbulletin.org without much luck.
EDIT :
After doing some digging I found a couple of things.
phpBB3 has a table for TOPICS
phpBB3.1 has a table for TOPICS and POSTS.
The info for what user made the last reply in a topic is stored in POSTS on 3.1, a whole separate table than it is on 3 where everything is just under TOPICS
The Impex file that pulls the TOPICS information is 006.php. I can see how to add additional items to it if they are in the same table, but how can I have 006.php pull from both TOPICS and POSTS?
Comment