vBulletin Modifications

Database problem

Welcome to vBHackers.com! - vBHackers Updates:

Go Back   vBulletin Modifications > General vBulletin Section > General vBulletin Support

Reply
 
LinkBack Thread Tools
Old 01-07-2006, 05:47 PM   #1
Junior Member
Join Date: Jan 2006
Key-Hack is on a distinguished road

Question Database problem

Hi all !

i have got a question.

when somebody register in my site and when i want to logg me in my admincp, then comes this problem:

You must first be a registered member to view any code.
and this problem comes:

Database error in vBulletin 3.5.0:

Invalid SQL:

INSERT INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass)
VALUES
('49cf367338bb1f6460fa4e62b1499428', 1, '84.59.1.155', '6a1d93cfdcc271d15b38a393d28e1a26', 1136671964, '/forum/login.php?do=login', 3, 0, 1, 0, 0, 0, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)', 1);

MySQL Error : Access denied for user: 'keyhack_web@67.19.214.226' to database 'keyhack_web'
Error Number : 1044
Date : Sunday, January 8th 2006 @ 12:12:45 AM
Script : http://www.mysite.com/forum/login.php
Referrer : http://www.mysite.com/forum/admincp/index.php?
IP Address : 84.59.1.155
Username : Key-Hack
Classname : vb_database

Last edited by Key-Hack; 01-07-2006 at 06:11 PM.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Old 01-08-2006, 04:50 AM   #2
Niels
Support Staff
Niels's Avatar
Join Date: Jun 2004
Real Name: Niels
Location: NL
Niels is on a distinguished road

Default

Look's clear to me, your mysql account info is bad or doesn't have the right to use INSERT.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-08-2006, 01:28 PM   #3
zen
Junior Member
Join Date: Jul 2005
zen is on a distinguished road

Default

Ye its a mysql account problem. Check your user and pass in the config.php and check the rights of your mysql account in your web control panel. You could also create a new sql account with r/w access rights.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-08-2006, 03:06 PM   #4
Junior Member
Join Date: Jan 2006
Key-Hack is on a distinguished road

Default

Quote:
Originally Posted by zen
Ye its a mysql account problem. Check your user and pass in the config.php and check the rights of your mysql account in your web control panel. You could also create a new sql account with r/w access rights.

sorry but what is r/w access `?




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 01-08-2006, 03:25 PM   #5
zen
Junior Member
Join Date: Jul 2005
zen is on a distinguished road

Default

I ment u should create a user that has ALL PRIVILEGES. Creating,deleting,moving, etc. tables




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
little problem with vb3.5.3 Senna General vBulletin Support 8 02-06-2006 05:49 PM
[Realy Need Help] Database Error AnoxiA General vBulletin Support 8 02-04-2006 06:33 PM
Problem populating a table Vitesse General vBulletin Support 0 08-06-2005 05:45 AM
custom array problem Mousee General vBulletin Support 3 05-26-2005 12:55 PM
Database backup script cLord vBulletin Modification Requests 2 04-30-2004 05:53 PM


All times are GMT -3. The time now is 05:47 PM.


SEO by vBSEO 3.2.0 ©2008, Crawlability, Inc. (Patent Pending)