Forums Sign Up Reply Search Statistics
G-Dating GraFX Software Solutions - Forum / G-Dating /

MySQL error: SELECT command denied to user

 
Author smloftus
Forums Member
#1 Posted: 7 Oct 2009 22:28:14 Edited by: smloftus
Reply 
I have installed the demo version of G-Dating and I'm experiencing the following error. I had issued using the automated process so I did a manual install (I think) of the software. I did install into a subdirectory of my site (http://www.datsite.com/gdating/) as I'm testing several other dating products that all work fine with SQL so I'm guessing that I need to configure something else in the .php files somewhere? I looked at your documentation and it was not much help... Its a test site on a VM so you can't look at it, I need replies to this with helpful things to try please.

1, created mysql database and user (logs in fine on mysql)
2, Tried to use automated install (didn't work)
3, Using the phpmyadmin tool I imported the following .sql files from the installer directory to populate the DB. - mysql_5.sql - mysql_insert_5.sql - mysql_insert_demo_5.sql
4, renamed the installer directory
5, Edited config.inc.php with proper DB, user and password
6, I get the error below on both site and admin index.php files

--------------------------------------------
Below error is from - http://www.datsite.com/gdating/index.php

Invalid query
Select value from dating_config Where paramname='DEFAULT_LANGUAGE'
MySQL error: SELECT command denied to user 'gdating'@'localhost' for table 'dating_config'
---------------------------------------------
---------------------------------------------
Below error from - http://www.datsite.com/gdating/admintool/index.php

Invalid query
Select value from dating_config Where paramname='DEFAULT_LANGUAGE'
MySQL error: SELECT command denied to user 'gdating'@'localhost' for table 'dating_config'
---------------------------------------------
Author smloftus
Forums Member
#2 Posted: 7 Oct 2009 22:51:45 Edited by: smloftus
Reply 
I figured it out already...

For some reason the user I created was not granted any priveledges on the DB I created, even though when I tried to add them it said the account already had them!

I deleted the account and left the database, then I created a new account with all priveleges and it works fine for now.
Author software
Admin
#3 Posted: 9 Oct 2009 21:47:34
Reply 
OK, we are happy, it was strange why you got the error.
Author smloftus
Forums Member
#4 Posted: 10 Oct 2009 17:51:05
Reply 
Yes, it was strange but deleting the user and recreating it with proper rights fixed it.

The automated install still doesn't work though.
Author software
Admin
#5 Posted: 10 Oct 2009 19:37:40
Reply 
Automatic installer should work, really we tested in many places and all of our software is based on that and work, could be that you do somthing wrong.
If you want, we can install it for you, send to us (through contact page) the details of the server and database.
 
Your Reply

» Username  » Password 
Only registered users are allowed to post here. Please enter your login/password details upon posting a message, or sign up first.