Error on registration...

[Tim Wheatley]

<!-- Database error in vBulletin 2.2.1:

Invalid SQL: INSERT INTO user (userid,username,password,email,parentemail,coppau ser,homepage,icq,aim,yahoo,signature,adminemail,sh owemail,invisible,usertitle,joindate,cookieuser,da ysprune,lastvisit,lastactivity,usergroupid,timezon eoffset,emailnotification,receivepm,emailonpm,opti ons,birthday,maxposts,startofweek,ipaddress,pmpopu p,referrerid,nosessionhash,country,avatarid) VALUES (NULL,'1111111','af1fa7390ad48ba0c44f63e33280bdff' ,'nascar@lineone.net','','0','http://','','','','','1','1','0','Junior Member','1012213826','1','-1','1012213826','1012213826','3','0','1','1','0',' 15','0','-1','1','IP-REMOVED','0','0','1','American%20Samoa','0','0')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Monday 28th of January 2002 11:30:26 AM
Script: http://forum.racesimcentral.com/register.php
Referer: http://forum.racesimcentral.com/register.php
-->

[Tim Wheatley]

I have just installed this:
https://vborg.vbsupport.ru/showthread.php?s=&threadid=34361

Which is no doubt the problem.

[Tim Wheatley]

Ok... I got it going further, now it says this:

<!-- Database error in vBulletin 2.2.1:

Invalid SQL: INSERT INTO user (userid,username,password,email,parentemail,coppau ser,homepage,icq,aim,yahoo,signature,adminemail,sh owemail,invisible,usertitle,joindate,cookieuser,da ysprune,lastvisit,lastactivity,usergroupid,timezon eoffset,emailnotification,receivepm,emailonpm,opti ons,birthday,maxposts,startofweek,ipaddress,pmpopu p,referrerid,nosessionhash,country,avatarid) VALUES (NULL,'Tim Wheatley2','c94b955e5fb7bd7ba1973cac1d6425c9','nas car@lineone.net','','0','http://www.this.com','','','','236','1','0','0','Junior Member','1012217686','1','-1','1012217686','1012217686','3','0','1','1','0',' 15','1970-1-1','-1','1','xxxxxxxxxxxIPRemovedxxxxxxxxxx','0','177', '1','Afghanistan','11','0')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Monday 28th of January 2002 12:34:46 PM
Script: http://forum.racesimcentral.com/register.php
Referer: http://forum.racesimcentral.com/register.php
-->

[Tim Wheatley]

Ok I found what it was, and it was nothing to do with what I thought... I think I'm actually beginning to get this!

I installed the hack by Bira also which allows posts you've read to be minimised, and because I'd previously installed hacks, I didn't just 'replace' as he asked - but when carefully picking out what he's put in newly, I missed the section on the left side I think, so had a different number of entries as I had places for them to go!

Phew! :D