Hello There, Guest! Register

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MySQL error when creating account
04-21-2009, 08:22 PM,
#1
MySQL error when creating account
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
04-22-2009, 03:33 AM, (This post was last modified: 04-22-2009, 03:35 AM by Rich.)
#2
RE: MySQL error when creating account
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
Rich - Ex lead developer
04-22-2009, 03:37 AM,
#3
RE: MySQL error when creating account
Here is the file again sorry about that, uploaded the wrong file to start with Big Grin


Attached Files
.zip   richtestuser.zip (Size: 448 bytes / Downloads: 371)
Rich - Ex lead developer
04-22-2009, 01:33 PM,
#4
RE: MySQL error when creating account
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
04-22-2009, 06:32 PM,
#5
RE: MySQL error when creating account
Its because your forum prefix is wrong.
Jonny H - THT Main Developer & Founder


04-22-2009, 08:26 PM,
#6
RE: MySQL error when creating account
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
04-22-2009, 09:30 PM,
#7
RE: MySQL error when creating account
or from what I can tell, your forum database name is incorrect.
Rich - Ex lead developer
04-23-2009, 04:36 AM,
#8
RE: MySQL error when creating account
Something is wrong in those settings, I've seen it many times before and it's the forum prefix.
Jonny H - THT Main Developer & Founder


04-23-2009, 12:59 PM, (This post was last modified: 04-23-2009, 01:22 PM by ThePro.)
#9
RE: MySQL error when creating account
the forum mysql info is fine, i checked.

EDIT: i tryed changing the forum settings, and get the same error
04-23-2009, 03:43 PM,
#10
RE: MySQL error when creating account
(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.
Rich - Ex lead developer


Forum Jump:


Users browsing this thread: 1 Guest(s)