View Single Post
  #1  
Old 02-14-2011, 04:03 PM
sbatson sbatson is offline
 
Join Date: Jan 2007
Posts: 8
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Getting Database Error Emails...

I'm getting a number of database errors emailed to me. I have not done any upgrades or changed anything on my forum. This seems to have started a few days after I had to have my ISP reboot the database server because the forum wasn't running and was reporting a database error. After the reboot, all seems to be working fine, I have no issues accessing the forum or doing anything, but keep getting errors emailed to me. I backed up the database and when through several of the database maintenance tools and those all seemed to run fine too.

I'm at a loss at this point. Does anyone have suggestions to check and clean up the database? I don't want to try and post all the errors I'm getting so I just post a couple different ones as examples:

Most of the recent ones seem to be like this first one. Perhaps something changed after some of the maintenance tools were run. Any suggestions would be great!


Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT *
FROM vb_session
WHERE userid = 0
AND host = '66.249.68.202'
AND idhash = 'b7a7a78a0f0ab05079e72c6a96628b62'
LIMIT 1;

MySQL Error : Can't find file: '.\dpzone\vb_session.frm' (errno: 24)
Error Number : 1017
Date : Monday, February 14th 2011 @ 09:28:19 AM
Script : http://www.batsonphotography.com/dpz...eek=1029628800
Referrer :
IP Address : 66.249.68.202
Username :
Classname : vb_database



Database error in vBulletin :

mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061)
C:\Domains\batsonphotography.com\wwwroot\DPZone\fo rums\includes\class_core.php on line 274

MySQL Error :
Error Number :
Date : Monday, February 14th 2011 @ 08:00:11 AM
Script : http://dpzone.batsonphotography.com/...splay.php?f=43
Referrer : http://dpzone.batsonphotography.com/...splay.php?f=43
IP Address : 46.109.193.26
Username :
Classname : vb_database
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02068 seconds
  • Memory Usage 1,764KB
  • 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