SemperFidelis
07-10-2003, 06:18 AM
Here is the error im getting when trying to add a user via the Admin CP :
Database error in vBulletin Control Panel 2.3.0:
Invalid SQL: INSERT INTO user (userid,usergroupid,username,password,email,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,receivebulletin,receivebulletin_ type,showemail,invisible,usertitle,customtitle,joi ndate,cookieuser,daysprune,lastvisit,lastactivity, lastpost,posts,timezoneoffset,emailnotification,re ceivepm,emailonpm,ipaddress,pmpopup,options,birthd ay) VALUES (NULL,'2','Steve','5f4dcc3b5aa765d61d8327deb882cf9 9','test@test.com,'3','','0','http://www.','','','','','1','1','1','0','Junior Member','0',1057820314,'1','-1',1057820314,1057820314,1057820314,'0','0','1','1 ','1','','1','15','birthday')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Date: Thursday 10th of July 2003 02:58:34 AM
Script: http://boardaddresshere/admin/user.php
Referer: http://boardaddresshere/admin/user.php?action=add&s=
All fields in the query are in the table.
There are additional fields in the user table compared to what the query is trying to insert but that shouldnt matter right ?
I can still register a user via the forums, just not thru the Admin CP.
Any ideas ?
Database error in vBulletin Control Panel 2.3.0:
Invalid SQL: INSERT INTO user (userid,usergroupid,username,password,email,stylei d,parentemail,coppauser,homepage,icq,aim,yahoo,sig nature,adminemail,receivebulletin,receivebulletin_ type,showemail,invisible,usertitle,customtitle,joi ndate,cookieuser,daysprune,lastvisit,lastactivity, lastpost,posts,timezoneoffset,emailnotification,re ceivepm,emailonpm,ipaddress,pmpopup,options,birthd ay) VALUES (NULL,'2','Steve','5f4dcc3b5aa765d61d8327deb882cf9 9','test@test.com,'3','','0','http://www.','','','','','1','1','1','0','Junior Member','0',1057820314,'1','-1',1057820314,1057820314,1057820314,'0','0','1','1 ','1','','1','15','birthday')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Date: Thursday 10th of July 2003 02:58:34 AM
Script: http://boardaddresshere/admin/user.php
Referer: http://boardaddresshere/admin/user.php?action=add&s=
All fields in the query are in the table.
There are additional fields in the user table compared to what the query is trying to insert but that shouldnt matter right ?
I can still register a user via the forums, just not thru the Admin CP.
Any ideas ?