Database Errors?
 

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:
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.

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

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

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

(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. :(

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.

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.

You need to repair the user Table