vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Site down due to database error???? (https://vborg.vbsupport.ru/showthread.php?t=242864)

TradingApples 05-19-2010 09:48 AM

Site down due to database error????
 
Hi,

My forum just stopped working a few hours ago and I'm getting 600 emails an hour all of them vb database errors. I have no idea how to fix this or if my site is just fubar. Before my whole site went down some spammer posted over 3,000 porn posts as a guest that went into the moderation queue (FHL). When I tried to delete them all I started to get database errors saying a table was broken try to fix it. Now my whole site doesn't even load and the errors now say so and so marked as crashed and needs repair. Here is what the errors say:

Quote:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT IF(visible = 2, 1, 0) AS isdeleted,



thread.*


FROM thread AS thread






WHERE thread.threadid = 57582;

MySQL Error : Table './trading1_database/thread' is marked as crashed and should be repaired
Error Number : 145
Request Date : Wednesday, May 19th 2010 @ 05:38:18 AM
Error Date : Wednesday, May 19th 2010 @ 05:38:18 AM
Script : http://www.TradingApples.com/showthread.php?t=57582
Referrer :
IP Address : 142.166.170.103
Username : Unregistered
Classname : vB_Database
MySQL Version :

borbole 05-19-2010 09:53 AM

Try to repair the thread table.

legacy123 05-19-2010 09:53 AM

You should go to the database level and delete those spam posts and then repair your database this is very simple also you might want to think upgrading your server.

If you could provide more server specs that would be helpful


All times are GMT. The time now is 08:00 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04168 seconds
  • Memory Usage 1,719KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete