THT Community
MySQL error when creating account - Printable Version

+- THT Community (https://thehostingtool.com/forum)
+-- Forum: THT Support (https://thehostingtool.com/forum/forum-7.html)
+--- Forum: THT General Support (https://thehostingtool.com/forum/forum-8.html)
+--- Thread: MySQL error when creating account (/thread-230.html)

Pages: 1 2 3 4


MySQL error when creating account - ThePro - 04-21-2009

After moving my reseller to a new reseller, and changing all the mysql info manualy from conf.inc.php and setting everything up, i get this error when creating accounts:
Quote://///////////////THT ERROR
Error: mySQL Query Failed
Function: query
mySQL Error:
/////////////////
/////////////////THT ERROR
Error: mySQL Query Failed
Function: query
mySQL Error:
/////////////////

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/z307co/public_html/tht/includes/class_db.php on line 54
Your username doesn't exist in the DB meaning the query failed or it exists more than once!

the account gets created, but doesn't get saved in tht's database


RE: MySQL error when creating account - Rich - 04-22-2009

Hello,

I am looking into this now.

Please upload the unrared attached file to /admin/pages/testuser.php and then go to:

http://yourdomain.ext/tht/admin/?page=testuser

and copy & paste the error or output.

- Rich

EDIT: Opps. Hold on one sec. Will reup the file in 2 mins


RE: MySQL error when creating account - Rich - 04-22-2009

Here is the file again sorry about that, uploaded the wrong file to start with Big Grin


RE: MySQL error when creating account - ThePro - 04-22-2009

Quote:Testing User Database
The total records: 0

i don't have any users tho, i deleted one user that was not transfered with whm


RE: MySQL error when creating account - Jonny - 04-22-2009

Its because your forum prefix is wrong.


RE: MySQL error when creating account - ThePro - 04-22-2009

that's odd, cause if it put an invalid username in, i will get the normal wrong username error, but if i put the right one i get the main error


RE: MySQL error when creating account - Rich - 04-22-2009

or from what I can tell, your forum database name is incorrect.


RE: MySQL error when creating account - Jonny - 04-23-2009

Something is wrong in those settings, I've seen it many times before and it's the forum prefix.


RE: MySQL error when creating account - ThePro - 04-23-2009

the forum mysql info is fine, i checked.

EDIT: i tryed changing the forum settings, and get the same error


RE: MySQL error when creating account - Rich - 04-23-2009

(04-22-2009, 06:32 PM)Jonny Wrote: Its because your forum prefix is wrong.

(04-23-2009, 12:59 PM)ThePro Wrote: the forum mysql info is fine, i checked.

EDIT: i tryed changing the forum settings, and get the same error

Hello,

Double check the user name and that the user has access to the database. If 100% a problem with the settings, you might have to update it via phpmyadmin.