Registration Error - Please Help!

[Jake Bunce]

Try downloading the latest zip file from the member's area and doing the clean install again. Something is wrong with the files you used.

[tjmaxwell]

Sorry, didn't realize that was a problem (attaching VB files).

Anyway, this wasn't an upgrade, it was a clean install of 2.3.0. Any other suggestions?

[Jake Bunce]

Please don't attach vBulletin files to your posts.

You need to upload the 2.3.0 php files to fix that problem. It looks like you ran the upgrade script but didn't upload the new files.

[tjmaxwell]

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:

 [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]

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:

$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();

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.