Last Post column showing wrong information in the home page

[sauloon]

Hi,

I am running 5.1.3. My upgrade path was 3.8.2 -> 5.1.1 -> 5.1.2 -> 5.1.3.

One of my forums is very old (the guidelines and rules). This forum was set so that it is read only and no one can post.

This is what it looks like.




On the forum page itself, the Last Post information is correct. However, on the home page, the Last Post information is wrong.


May I know how I may correct this so that the home page shows the correct information? I am OK with making direct changes to the DB if necessary.

Thanks!

regards,
sl

[sauloon]

Can anyone help me here?

[Replicant]

When I look at the tables these are the two dates that look to be what you're looking for. I'm no expert. Backup your database before making changes.
Check the lastcontent column in node table and the publishdate in closure table. Dates are unix timestamp.

[TLMD]

I remember a JIRA that was about time formatting and upgrades from earlier versions of vB. I can't find it though right now, but maybe this is the same issue.

[Lynne]

Did you run Maintenance > Rebuild Thread Information and then Rebuild Forum Information after you did the upgrade?

[sauloon]

Did you run Maintenance > Rebuild Thread Information and then Rebuild Forum Information after you did the upgrade?

Hi Lynne,

I believe I did but cannot be sure as it was a while back. Would it be a problem if I run it now, several upgrades later?

regards,
sl

[Lynne]

That is fine to run it now. If you have a lot of threads then it could take a while to run. Make sure to run the Rebuild Forum Info *after* running Rebuild Thread Info.