The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Database error on registering... Details »» | |||||||||||||||||||||||||
Ok, I installed a couple hacks, and, suspiciously, no one registered. So, I log out and try to register.... After entering all the details, I hit the submit button and get a database error. So, I chaecked my mail, and this is the contents of the message...
Code:
Invalid SQL: INSERT INTO user (userid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,showemail,invisible,usertitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotification,receivepm,emailonpm,options,birthday,maxposts,startofweek,ipaddress,pmpopup,newsfader,referrerid,nosessionhash,avatarid,country) VALUES (NULL,'test','098f6bcd4621d373cade4e832627b4f6','test@test.com','1','','0','http://','','','','','1','1','0','VGGMN Jabroni','1025061775','1','-1','1025061775','1025061775','2','0','1','1','0','15','0','-1','1','24.216.255.181','0','0,'0','1','460','Bouvet%20Island') mysql error: You have an error in your SQL syntax near '0','1','460','Bouvet%20Island')' at line 1 mysql error number: 1064 Date: Wednesday 26th of June 2002 04:22:55 AM Script: http://mb.vggmn.com//register.php Referer: http://mb.vggmn.com/register.php Show Your Support
|
Comments |
#2
|
||||
|
||||
Copy the line from register.php that starts with:
Code:
$DB_site->query("INSERT INTO user |
#3
|
||||
|
||||
Code:
$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield."parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,showemail,invisible,usertitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotification,receivepm,emailonpm,options,birthday,maxposts,startofweek,ipaddress,pmpopup,newsfader,referrerid,nosessionhash,avatarid,country) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes(md5($password))."','".addslashes(htmlspecialchars($email))."',".$newstyleval."'".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','".time()."','$cookieuser','".addslashes($prunedays)."','".time()."','".time()."','$newusergroupid','".addslashes($timezoneoffset)."','$emailnotification','$receivepm','$emailonpm','$options','".addslashes($birthday)."','".addslashes($umaxposts)."','".addslashes($startofweek)."','".addslashes($ipaddress)."','$pmpopup','$newsfader,'".addslashes($testreferrerid['userid'])."','$nosessionhash','$avatarid','".addslashes($country)."')"); |
#4
|
||||
|
||||
Code:
$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield."parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,showemail,invisible,usertitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotification,receivepm,emailonpm,options,birthday,maxposts,startofweek,ipaddress,pmpopup,newsfader,referrerid,nosessionhash,avatarid,country) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes(md5($password))."','".addslashes(htmlspecialchars($email))."',".$newstyleval."'".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','".time()."','$cookieuser','".addslashes($prunedays)."','".time()."','".time()."','$newusergroupid','".addslashes($timezoneoffset)."','$emailnotification','$receivepm','$emailonpm','$options','".addslashes($birthday)."','".addslashes($umaxposts)."','".addslashes($startofweek)."','".addslashes($ipaddress)."','$pmpopup','$newsfader','".addslashes($testreferrerid['userid'])."','$nosessionhash','$avatarid','".addslashes($country)."')"); |
#5
|
||||
|
||||
Thanks, Firefly!
(YAY! IT WORKS! ) |
#6
|
||||
|
||||
You're welcome!
|
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|