View Single Post
  #3  
Old 09-29-2008, 07:45 PM
dimples dimples is offline
 
Join Date: Dec 2007
Posts: 8
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I am getting numerous errors but they are all relating to the post table being corrupt.

example:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT COUNT(*) AS count
FROM ****_forumsinfraction AS infraction
LEFT JOIN *****_forumspost AS post ON (infraction.postid = post.postid)
LEFT JOIN *****_forumsthread AS thread ON (post.threadid = thread.threadid)
WHERE infraction.userid = 1;

MySQL Error : Table 'post' is marked as crashed and last (automatic?) repair failed
Error Number : 1195
Date : Monday, September 29th 2008 @ 04:24:31 PM
Script : **********************
Referrer : ****************
IP Address : *********
Username : *******
Classname : vB_Database

--------------- Added [DATE]1222730715[/DATE] at [TIME]1222730715[/TIME] ---------------

Ok, my host has helped me out with repairing the table.....phew!

Now, what started this whole thing was a message from them stating we are overloading the server and need to optimize it. Thay have put a limit on the site therefore i am getting all kinds of the following server errors

This error means that the web server is currently unable to handle your request due to a temporary overload.
Please try to reload the webpage in a few seconds.

They also stated my database was too big at 419Mb in size.

So I have optimized the tables....I have disabled all of the mods I had installed (probably about 15 or so)

So what next? Why is m y database so big? I don't have that big of a forum I didn't think. We average about 40-60 members visiting a day and have around 100 active members, ect. It;s not that big.

Does anyone have any suggestions on what to do next so my server will lift the restriction? I'm not so sure where to go from here now that I have disabled all the mods.

Thank you in advance.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01654 seconds
  • Memory Usage 1,765KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete