Seem to have database corruption - threads not displaying

[Mosh]

Hi all,

Hope someone can help.

I ran a normal Repair/Optimize Tables in the AdminCP - and after that I seem to have lost the ability to view posts and threads back to at least July this year, they show up when browsing forums and doing searches but when you open a thread there is not content and when you click on the last poster then you get this error message:

No Thread specified. If you followed a valid link, please notify the administrator

When you try to reply to a stuffed thread then you get this error:

Sorry! This forum is not accepting new posts.

When looking at the Table Status, everything seems to be OK.

Is there any query I can run to recover the threads/posts? I am desperate.

Thanks in advance.

[Marco van Herwaarden]

Run repair a few times more.
Test with a default style.
Run the rebuild thread information etc from AdminCP -> Maintenance -> Update Counters.

[Mosh]

Thanks for the reply Marco.

I physically lost the posts in the end, the indexes where there, but the posts were physically not there.

I have restored my forums from a backup. I lost 10 days, but that was better than months

[exyuteam]

It seems that I have a same problem.... same error!? SOME of my threats disapear!? My thread is normally in list with all of pages, and when I try to view it, I got page without any posts - simmilar like new opened thread! And if I try to post here I got same error:
Sorry! This forum is not accepting new posts.


It seems that posts are somehow removed from database?! When I look into POST table, there not exsist posts for that threadid...?!?!


Can you tell me what I can do and how to check whats happends with my forum? Maybee I can view does is vBulletin have some strange bug or someone has hack forum? But, if someone hack forum why it would delete posts from database and only from one thread??? I have vBulletin version - 3.8.1


Thanks in advace for any suggestions... and explanations.


P.S. Sorry for my bad english, but I hope so that you understand me... If something you not understand, please ask for explanations I can attach some screenshots of that thread if that can help

[Marco van Herwaarden]

To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem.
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

If this doesn't solve your problem, please open a support ticket.

[exyuteam]

I checking my database, and I see that mesages is no in database (table vB_post). So, I think that my messages are gone. But it's still in list and topic(s) and post(s). Now, I need to reindex all posts (I guess ) to fix list of topics and posts.

I just wondering, how it could this happened? Post is on forum (on list) but it's not in database? Maybee my ISP was database crash, and maybee it's restore backups? Did somebody findout my username and pass for database and delete it remotly or...???

Thanks.