Database error in vBulletin 4.0.6:
Invalid SQL:
INSERT INTO cpsession (userid, hash, dateline) VALUES (1, '51904b545819a51ecf1f9932e06883dc', 1284204182);
MySQL Error : INSERT command denied to user '************' for table 'cpsession'
Error Number : 1142
Request Date : Saturday, September 11th 2010 @ 07:23:02 AM
Error Date : Saturday, September 11th 2010 @ 07:23:02 AM
Script : http://www.mysite.com/login.php?do=login
Referrer : http://www.mysite.com/admincp/
IP Address : 89.165.19.78
Username : admin
Classname : vB_Database
MySQL Version : 5.1.49-1
Database error in vBulletin 4.0.6:
Invalid SQL:
INSERT INTO cpsession (userid, hash, dateline) VALUES (1, '51904b545819a51ecf1f9932e06883dc', 1284204182);
MySQL Error : INSERT command denied to user '************' for table 'cpsession'
Error Number : 1142
Request Date : Saturday, September 11th 2010 @ 07:23:02 AM
Error Date : Saturday, September 11th 2010 @ 07:23:02 AM
Script : http://www.mysite.com/login.php?do=login
Referrer : http://www.mysite.com/admincp/
IP Address : 89.165.19.78
Username : admin
Classname : vB_Database
MySQL Version : 5.1.49-1
Thanks
It looks like your db user hasn''t the permission to execute the INSERT command at the db that he is assigned to. You can change that at the MySQL area at the CP of your host by granting the db user full permissions/access to the db. Failed that you can run this query to do it manually:
Code:
GRANT *
ON dbname.*
TO dbuser@"%"
identified by "dbpassword";
And replace the dbname, dbuser and dbpassword according with your own db name, db user and db password. The asteric appended tot eh db name will replace the entire list of tables where the sql command can take affect and the % symbol replaces the list of all hosts in the known world. That will work 100%. I have used in on several occasions and it has never failed me. Hope it helps you as well.
09-11-2010, 10:31 AM
help me about this message : Database error
Linear Mode
