azgunner
02-21-2016, 12:45 PM
Hi,
I am running vB 4.2.3. Is there a sql command I can run to re-learn or re-calculate the dates a thread was posted? After using Impex to import from phpBB 3.1.7=pl1 the index of my forum in vB shows 1-1-1070 as the dates, however when I open the threads the date time stamps appear correctly. I know this is likely an Impex specific issue but I would think this can be solved with running a couple database commands, I'm just not sure what. 1/1/1970 is the start of what Unix time calculates from, so I'm sure there is some kind of command I can run to resolve this. There is something in the database that is just reading funny. I've spent hours and hours searching Impex threads and documents without finding much help. I have a post in the Impex section, but the section doesn't seem very active. I don't know if anyone actually looks at it anymore? lol
An alternative workaround I have found is that when I reply to any of these threads (it happens with all of them on the forum, also the replies aren't counted in the total posts on the index but you can see the actual replies in the threads) and the latest post will start to display in the index along with the proper timestamp. I would like to avoid having to go through and reply to every thread though to fix it. There has got to be some kind of command to run.
Thank you for the help!
--------------- Added 1456082172 at 1456082172 ---------------
Here is a bit better of a description of my issue that I wrote out on another forum.
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.
I am running vB 4.2.3. Is there a sql command I can run to re-learn or re-calculate the dates a thread was posted? After using Impex to import from phpBB 3.1.7=pl1 the index of my forum in vB shows 1-1-1070 as the dates, however when I open the threads the date time stamps appear correctly. I know this is likely an Impex specific issue but I would think this can be solved with running a couple database commands, I'm just not sure what. 1/1/1970 is the start of what Unix time calculates from, so I'm sure there is some kind of command I can run to resolve this. There is something in the database that is just reading funny. I've spent hours and hours searching Impex threads and documents without finding much help. I have a post in the Impex section, but the section doesn't seem very active. I don't know if anyone actually looks at it anymore? lol
An alternative workaround I have found is that when I reply to any of these threads (it happens with all of them on the forum, also the replies aren't counted in the total posts on the index but you can see the actual replies in the threads) and the latest post will start to display in the index along with the proper timestamp. I would like to avoid having to go through and reply to every thread though to fix it. There has got to be some kind of command to run.
Thank you for the help!
--------------- Added 1456082172 at 1456082172 ---------------
Here is a bit better of a description of my issue that I wrote out on another forum.
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.