help me about this message : Database error

[pdiscus]

hi

help me about this message : Database error :

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

[borbole]

hi

help me about this message : Database error :

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:

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.

[pdiscus]

Hi . .
Thank You . . .

Please give me more explanation if possible . Where should I go to Cpanel ? Where is the ( GRANT ) ?

[borbole]

Hi . .
Thank You . . .

Please give me more explanation if possible . Where should I go to Cpanel ? Where is the ( GRANT ) ?

You should go at the MySQL area and there you can assign the db user the permissions and access to the db that he is assigned to.

[pdiscus]

Sorry . . .

get into the PHPmyadmin but I do not know where to go . . . Please give me more explanation if possible .

Thanak you

[Videx]

A quick search on vb.com on 'cpsession' leads me to ask if you have any mods like vbseo installed. If so, you need to take the problem over there.

[compwhizii]

A quick search on vb.com on 'cpsession' leads me to ask if you have any mods like vbseo installed. If so, you need to take the problem over there.

It's clearly a permissions error.