vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   help me about this message : Database error (https://vborg.vbsupport.ru/showthread.php?t=250303)

pdiscus 09-11-2010 10:31 AM
help me about this message : Database error
 
hi

help me about this message : Database error :

Code:
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 09-11-2010 11:13 AM
Quote:
Originally Posted by pdiscus (Post 2096630)
hi

help me about this message : Database error :

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

pdiscus 09-11-2010 11:34 AM
Hi . .
Thank You . . .

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

borbole 09-11-2010 11:36 AM
Quote:
Originally Posted by pdiscus (Post 2096647)
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 09-11-2010 11:56 AM
Sorry . . .

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

Thanak you

Videx 09-13-2010 02:14 AM
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 09-15-2010 01:43 AM
Quote:
Originally Posted by Videx (Post 2097386)
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.


All times are GMT. The time now is 11:45 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01034 seconds
  • Memory Usage 1,726KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete