Database Error
 

Right now our Forum has been down for most of today. When try to reach our forum at http://www.dairylandbjd.com/forum/index.php you get the following:

Database error
The database has encountered a problem.
Please try the following:

* Load the page again by clicking the Refresh button in your web browser.
* Open the www.dairylandbjd.com home page, then try to open another page.
* Click the Back button to try another link.

The www.dairylandbjd.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.


There is no other information on the page....it might be some SQL error but there's no other information.

I can't even get our the admin page at http://www.dairylandbjd.com/forum/admincp/index.php


I'd like to take the forum down but I can't even do that.

I need some help in figuring out what the problem is and how I can resolve it. Right now, I'm sure where to look for the right information. We are using vBullentin 3.7

<!--
Database error in vBulletin :

mysql_connect(): Access denied for user 'kyle18'@'localhost' (using password: YES)
/forum/includes/class_core.php on line 311

MySQL Error :
Error Number :
Request Date : Thursday, November 13th 2008 @ 03:14:58 AM
Error Date : Thursday, November 13th 2008 @ 03:14:58 AM
Script : http://www.dairylandbjd.com/forum/index.php
Referrer : https://vborg.vbsupport.ru/showthread.php?t=196130
IP Address : 67.142.130.37
Username :
Classname : vb_database
MySQL Version :
-->


Make sure your MySQL details in config.php are correct.

Got that one solved, but now I'm getting THIS error message:

<!--
Database error in vBulletin 3.7.0:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_holiday AS phrasegroup_holiday,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 2;

MySQL Error : Can't open file: 'user.MYI' (errno: 145)
Error Number : 1016
Request Date : Thursday, November 13th 2008 @ 04:15:14 AM
Error Date : Thursday, November 13th 2008 @ 04:15:14 AM
Script : http://www.dairylandbjd.com/forum/index.php
Referrer :
IP Address : 216.180.210.134
Username :
Classname : vb_database
MySQL Version :
-->

Are you sure your config.php file is correct and pointing to the correct database? You could try doing a repair/optimize on your user table.

Can't open file: 'user.MYI' (errno: 145)

I had this problem when i exceeded mysql database size

Log in to your server admin cp and view your database limit

I logged in to my server admin cp, and just for the heck of it clicked VIEW on the forum's index.php file and there I was, on the forum. I'm not sure why that worked, but I was able to get to the Admin Control Panel and repair the tables.

Thanks for the help everyone. :)

user.MYI is one of the last Tables in your database , you may of been able to repair and optimize this time but i bet its a matter of time before this happens again because your database is full and it loaded all the tables up to the users.myi then stopped

Been there done that