No posts showing!

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • jl255
    Member
    • May 2007
    • 81

    No posts showing!

    Just tried to export the DB (via SSH and forums were turned off) but somehow when forums were turned back on, all threads displayed NO posts. When i click on any thread from forumhome, with links like this: http://forums.aaaaaaa.com/showthread...wpost&t=529896, it tells me: No Thread specified.

    And when i enter any subforum and click on the threads with links like this: http://forums.aaaaaa.com/showthread....31#post5081931, It just shows the thread title, but not even the first post is displayed.

    Doing a db scan for corruption using mysqlcheck showed no errors.

    Any ideas what might be wrong????

    And just found out that the posts show for very old threads, not sure how far back, but threads that are many years back show the posts. Latest threads don't.
    Last edited by jl255; Mon 27 Apr '15, 6:10pm.
  • jl255
    Member
    • May 2007
    • 81

    #2
    after an entire night of investigation, found that there are thousands of posts missing from vb_post table. Not sure how and why, but almost all the latest posts are missing but not all. Tried searching for the posts via threadid and even postid, or username, but they are just not there. It's very strange. Older threads retained their posts. Wonder if anyone has encountered similar situation and i've read quite a few ppl complaining about the same issue of seeing no posts in a thread. Desperate.

    Comment

    • Trevor Hannant
      vBulletin Support
      • Aug 2002
      • 24326
      • 5.7.X

      #3
      Have you checked with your host to see if:

      - they've had a database rollback
      - there's been any access to run queries against the database manually in the past XX hours
      Vote for:

      - Admin Settable Paid Subscription Reminder Timeframe (vB6)
      - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

      Comment

      • wda2015
        Senior Member
        • May 2001
        • 1135

        #4
        Did you run the right commands in SSH maybe you deleted some posts content as you say you tried to export the database.
        Simple Straight Forward EU cPanel vBulletin Web Hosting Provider.

        Comment

        • jl255
          Member
          • May 2007
          • 81

          #5
          the posts deleted from vb_posts are almost random and its not like all posts newer than a certain date are deleted. Many posts are deleted by some still remain. That's the strange part and so i don't think any command cld have done that. The export was done by the server administrators who i believe shld have no problems issuing a simple export command and not mix that up with an 'update' or 'delete' command. But cld running an export on a db cause it to become corrupt?

          Comment

          Related Topics

          Collapse

          • Cfleet1
            Geting Rid Of Unpublished Posts
            by Cfleet1
            I have a bunch in a few threads. Some threads that are 125 pages long. I go through these and delete the posts that were deleted by members and the dont get rid of the yellow yield sign.

            ...
            Fri 19 May '17, 3:17pm
          • Archetribe
            Forum quirks.
            by Archetribe
            Most new threads show up in the "Latest Activity" stream, but there are certain older threads (only about a month old, as we opened the forum on Oct. 19).... these threads don't show up on Latest...
            Mon 2 Dec '19, 9:15pm
          Working...