Announcement

Collapse
No announcement yet.

Last Post column showing wrong information in the home page

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Last Post column showing wrong information in the home page

    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.

    Click image for larger version

Name:	Capture1.JPG
Views:	11
Size:	39.0 KB
ID:	4218211


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

    Click image for larger version

Name:	Capture3.JPG
Views:	12
Size:	50.0 KB
ID:	4218212
    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

  • #2
    Can anyone help me here?

    Comment


    • #3
      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.


      Comment


      • #4
        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.

        Comment


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

          Please don't PM or VM me for support - I only help out in the threads.
          vBulletin Manual & vBulletin 4.0 Code Documentation (API)
          Want help modifying your vbulletin forum? Head on over to vbulletin.org
          If I post CSS and you don't know where it goes, throw it into the additional.css template.

          W3Schools <- awesome site for html/css help

          Comment


          • #6
            Originally posted by Lynne View Post
            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

            Comment


            • #7
              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.

              Please don't PM or VM me for support - I only help out in the threads.
              vBulletin Manual & vBulletin 4.0 Code Documentation (API)
              Want help modifying your vbulletin forum? Head on over to vbulletin.org
              If I post CSS and you don't know where it goes, throw it into the additional.css template.

              W3Schools <- awesome site for html/css help

              Comment

              Related Topics

              Collapse

              Working...
              X