Go Back   vb.org Archive > Community Discussions > Forum and Server Management
Prev Previous Post   Next Post Next
  #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
 

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:11 AM.


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.04665 seconds
  • Memory Usage 2,326KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (5)post_thanks_box
  • (5)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (5)post_thanks_postbit_info
  • (5)postbit
  • (5)postbit_onlinestatus
  • (5)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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_threadedmode.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete