Database Errors?

[King Justice]

Hi.

I am receiving database error messages all of a sudden and now cannot access my forum. This is in the middle of transferring from my old server to my new one...both databases have all of a sudden been showing errors for the forum index page.

At the time of SQL backup, there was no error - database/forum was working perfectly. I am not sure why it is giving error now, even on new server.

How do I fix it? The message is really queer:

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.egamingsupply.com home page, then try to open another page.
* Click the Back button to try another link.

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

We apologise for any inconvenience.

Please help me fix this problem. The board was also closed for maintenance during time of backup. Not sure how I can put it back on to active in phpMyAdmin since I can't access the admincp of vBulletin because of this database error.

[DieselMinded]

you need to go to your admin email and post the error that was sent to you

[King Justice]

Database error in vBulletin :

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'admin_agentegs'@'localhost' (using password: YES)
/home/admin/domains/egamingsupply.com/public_html/forum/includes/class_core.php on line 274

MySQL Error :
Error Number :
Date : Sunday, August 19th 2007 @ 11:00:56 PM
Script : http://www.egamingsupply.com/forum/
Referrer :
IP Address : xxx
Username :
Classname : vb_database

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT COUNT(*) AS count FROM user WHERE usergroupid = 4;

MySQL Error : Can't open file: 'user.MYI' (errno: 145)
Error Number : 1016
Date : Sunday, August 19th 2007 @ 11:55:00 AM
Script : http://www.egamingsupply.com/forum/
Referrer :
IP Address : xxx
Username : Unregistered
Classname : vb_database

[Lynne]

Have you tried a repair/optimize on your tables - in particular your user table?

[DieselMinded]

(errno: 145)
Error Number : 1016

is the table death code ,

Log into your phpmyadmin

click the center icon on the left hand collum called query and type

REPAIR TABLE user

And hit go

[King Justice]

Originally Posted by DiesellMinded

(errno: 145)
Error Number : 1016

is the table death code ,

Log into your phpmyadmin

click the center icon on the left hand collum called query and type

REPAIR TABLE user

And hit go

That didn't help. Please help me.

[DieselMinded]

PM Sending

Looks like you need to chmod 777 this file ?

Text Link Ads script error: local_95956.xml is not writable. Please set write permissions on local_95956.xml.

[King Justice]

This is now the only database error I am receiving. I have updated to vB version 3.6.8 on the new server, so I guess this error is still coming from people who have not had updated cache to the new server?

I hope so.

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT COUNT(*) AS count FROM user WHERE usergroupid = 4;

MySQL Error : Can't open file: 'user.MYI' (errno: 145)
Error Number : 1016
Date : Sunday, August 19th 2007 @ 06:45:48 PM
Script : http://www.egamingsupply.com/forum/
Referrer :
IP Address : [edited out]
Username : Unregistered
Classname : vb_database

[DieselMinded]

You need to repair the user Table