what does this mean??

[scsa20]

can someone help tell me what the following means and how to fix it??


Database error in vBulletin 2.2.5:

Invalid SQL: INSERT INTO user (userid,username,password,email,styleid,parentemai l,coppauser,homepage,icq,aim,yahoo,signature,admin email,showemail,invisible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotification,receivepm,emailo npm,options,birthday,maxposts,startofweek,ipaddres s,pmpopup,referrerid,nosessionhash,country,avatari d,hideposts) VALUES (NULL,'test','098f6bcd4621d373cade4e832627b4f6','t est@test.com','2','','0','http://','','','','','1','1','0','Junior Member','1020482575','1','-1','1020482575','1020482575','3','0','1','1','0',' 15','0','-1','1','12.232.111.114','0','0','1','US%20Virgin%2 0Islands','0')
mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

Date: Friday 03rd of May 2002 11:22:55 PM
Script: http://forums.simon-soft.com/register.php
Referer: http://forums.simon-soft.com/register.php


I got that error when I was trying to make a test user

[FWC]

You are missing at least one value. I looks like either avatarid or hideposts isn't there.

[scsa20]

I'll look it up then, thanks

[scsa20]

never mind, I found it, both avatarid and hidepost. what else could it be :( (once again, I'm stupid :()

[scsa20]

okey, I found out what the problem was, I forgot to re-add $hideposts at the end of a line in the register.php file....but now when I go edit someone's account in the admin cp, I get this error:


Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: UPDATE user SET away='0',awaydate='',retruedate='0000-00-00',awayreason='',birthday='0000-00-00',options='15',usergroupid='6',username='test',e mail='test@test.com',styleid='2',parentemail='',co ppauser=0,homepage='http://',icq='',aim='',yahoo='',signature='',adminemail=1 ,showemail=1,invisible=0,usertitle='test account',customtitle=1,joindate=UNIX_TIMESTAMP('20 02-05-04 17:45:40'),cookieuser=1,nosessionhash=1,daysprune= '-1',lastvisit=UNIX_TIMESTAMP('2002-05-04 17:45:40'),lastactivity=UNIX_TIMESTAMP('2002-05-04 17:47:05'),lastpost=UNIX_TIMESTAMP('1969-12-31 19:00:00'),posts='0',timezoneoffset='0',country='U nited%20States',emailnotification=0,receivepm='1', emailonpm='0',ipaddress='12.232.111.114',pmpopup=I F(pmpopup=2 AND 0=1,pmpopup,'0') WHERE userid=28
mysql error: Unknown column 'retruedate' in 'field list'

mysql error number: 1054

Date: Saturday 04th of May 2002 05:48:03 PM
Script: http://forums.simon-soft.com/admin/user.php
Referer: http://forums.simon-soft.com/admin/user.php?action=edit&userid=28


once agian, what does this mean :( ??

[FWC]

If you look at your update query you have returndate misspelled as retruedate. There is no "retruedate" field in the user table so you get that error message. Assuming there is a returndate field, it should work after you fix the spelling error.

[scsa20]

found it....just a little spelling error can do all that troble :(

thank you

[FWC]

You're welcome. :)