Re-learn Thread Dates

[azgunner]

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 [DATE]1456082172[/DATE] at [TIME]1456082172[/TIME] ---------------

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.

[mokujin]

Can you yook at table "forumdisplay" on field "lastposttime" (or something similar) and print a screen and post it here?

[cellarius]

Have you tried rebuilding chaches and indexes from maintenance in AdminCP?

[Zylantex]

I have the same issue migrating from phpBB 3.1.9 to vB 4.2.2

One other issue not mentioned above is that the thread is not obeying the "posts per page" parameter. Ever thread has only one page with all the posts on it.

I am blue in the face running all the rebuilds, clearing caches etc in the Maintenance section in the AdminCP.

Any ideas out there? Thanks.

[TheLastSuperman]

Originally Posted by Zylantex

I have the same issue migrating from phpBB 3.1.9 to vB 4.2.2

One other issue not mentioned above is that the thread is not obeying the "posts per page" parameter. Ever thread has only one page with all the posts on it.

I am blue in the face running all the rebuilds, clearing caches etc in the Maintenance section in the AdminCP.

Any ideas out there? Thanks.

How long ago did you impex (import) from phpBB to vB4? Reason I ask is, if you're testing and have not actually converted the live site yet you should impex to vB3 first then upgrade vB3 to vB4 and it will help avoid odd issues and errors.

Edit: Added today, please see - https://vborg.vbsupport.ru/showthread.php?t=323562

[Zylantex]

Thanks TLS I've being doing this over the last few days and the old system is still live so the situation is not critical.

That's very good advice to go the 3.8 route, I'll give it a go and report back later.

--------------- Added 04 Oct 2016 at 15:14 ---------------

I installed 3.8.9 and did the import. Strangely all forums were imported as categories but I manually changed them before proceeding.

I then installed and upgraded to 4.2.2 without any failures during the process.
Embedded images and attachments seem fine.
All the video links are weird, the text after the video: seems to vary for every item.

[video:346bwfqo]https://www.youtube.com/watch?v=5Njp-NeuZ6M&spfre[/video:346bwfqo]
[video:1ts98nqh]https://www.youtube.com/watch?v=yYcCbR1q5UY[/video:1ts98nqh]
[video:2v94fly3]https://youtu.be/7soLnMj4VjM[/video:2v94fly3]

I only see the text not the video.

When viewing a thread the dates in the postbits are showing correctly but at a forum level all dates are 31/12/1960 11:00pm so no posts show as active.

The posts per page parameter is still being ignored.

Would it help if I use a higher PHP Rev after the upgrade say PHP 5.6?

--------------- Added 04 Oct 2016 at 15:38 ---------------

I've looked at some of the tables in MySQL and I note the following:

Table: post
Field: postid - looks correct
Field: threadid - looks correct
Field: userid -looks correct

Table: thread
Field: firstpostid - all zeroes
Field: lastpostid - all zeroes
Field: lastpost - all zeroes
Field: forumid - looks correct

Table: forum
Field: lastpost - all zeroes
Field: lastpostid - all zeroes
Field: lastthreadid - looks normal
Field: lastposter - all zeroes

I think the missing links are the issue but my php/MySQL isn't up to correcting it.

[Lynne]

What do you have entered in AdminCP > Settings > Options > Date & Time Options > Format for Date and Format for Time

And did you run Maintenance > General Update Tools > Rebuild Topic Information and then Rebuild Forum Information (must be done in that order)?

[Zylantex]

Those options only control how the date is formatted for display afaik all the dates seem to be in Unix format in the tables.

I've tried that. When I examine the tables afterwards I'm seeing all the zeroes mentioned in my last post. The forum looks the same.