Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
SQL Signup Error
#1
When a user tries signing up for the service, it comes to this error

Quote://///////////////THT ERROR
Error: mySQL Query Failed
Function: query
mySQL Error: MySQL server has gone away
/////////////////
/////////////////THT ERROR
Error: mySQL Query Failed
Function: query
mySQL Error: MySQL server has gone away
/////////////////

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/noland/public_html/orderup/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!

Not sure whats causing it but if you want to give it a shot go here: http://crutix.com/orderup

I'm running the latest THT.

Line 54 is
PHP Code:
$n++; 
and the surrounding lines are
PHP Code:
$array2['NAME'] = $data['name'];
        
$array2['DESCRIPTION'] = $data['description'];
        
$array2['ID'] = $data['id'];
        
$array['PACKAGES'] .= $style->replaceVar("tpl/orderpackages.tpl"$array2);    
        
$n++;
        if(
$n == 1) {
            
$array['PACKAGES'] .= '<td width="2%"></td>';    
        }
        if(
$n == 2) {
            
$array['PACKAGES'] .= "</tr>";    
            
$n 0;    
        }
    } 

Thanks.
Reply
#2
please use the quik paste form.

i believe this is a mySQL server error. try rebooting the server
Nick - TheHostingTool Staff Coordinator

[Image: standard.png]

Reply
#3
Your mySQL server is timing out. It's your server.
Jonny H - THT Main Developer & Founder


Reply
#4
-Bump-

I have this problem too Sad

I searched around the internet and found that you can solve this by putting "mysql_reconnect" before all queries.

How can i do this to all the queries in THT? I'm unexperienced in MySQL and I'd appreciate if someone could help me.

Thanks in advance,
-Jonathan
Reply
#5
Jonathan, your server configuration really must be locked down. Honestly, it would be best just to recompile everything.
Jonny H - THT Main Developer & Founder


Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)