Tweet
First off, I know there have been similar threads to this, but I simply can't figure out how to fix this even after reading the solutions in others' threads. If someone can help me, I'd appreciate it. When someone registers, it says:
I have the country flag hack as well as the gender hack installed and they seem to work fine if you're already registered. Here is what I think is the affected portion of user.php:
The only changes I've made is to add the little "gender" bit to the end. By my count, all the options seem to match up. Any suggestions? Thanks.
Edit: Sorry the text didn't wrap. My full user.php file is attached. I think the problem is somewhere around line 171.
Code:
[size=2]Database error in vBulletin 2.3.0: 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,referrerid,nosessionhash,avatarid,country) VALUES (NULL,'Test','098f6bcd4621d373cade4e832627b4f6','[email protected]','1','','0','http://www.dung.com','','','','','1','1','0','Junior Member','1052430508','1','-1','1052430508','1052430508','2','0','1','1','0','15','1960-3-4','-1','1','12.211.227.114','0','0','1','0','United%20Kingdom','2') mysql error: Column count doesn't match value count at row 1 mysql error number: 1136 [/size]
Code:
$DB_site->query("INSERT INTO user (userid,usergroupid,username,password,email,styleid,parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,showemail,invisible,usertitle,customtitle,joindate,cookieuser,nosessionhash,daysprune,lastvisit,lastactivity,lastpost,posts,timezoneoffset,emailnotification,receivepm,emailonpm,ipaddress,pmpopup,options,birthday,gender) VALUES (NULL,'$usergroupid','".addslashes(htmlspecialchars($ausername))."','".addslashes(md5($apassword))."','".addslashes(htmlspecialchars($email))."','$userstyleid','".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','$customtitle',$joindate,'$cookieuser','$nosessionhash','$daysprune',$lastvisit,$lastactivity,$lastpost,'$posts','$timezoneoffset','$emailnotification','$receivepm','$emailonpm','".addslashes($aipaddress)."','$pmpopup','$options','$birthday','$gender')");
$userid=$DB_site->insert_id();
Edit: Sorry the text didn't wrap. My full user.php file is attached. I think the problem is somewhere around line 171.
Comment