pgowder |
08-18-2003 10:26 PM |
I installed last night and something isn't working. I'm on version 2.2.8. It must be that my insert was different than the one in the instructions. Here is the error I am getting:
Quote:
Invalid SQL: INSERT INTO user (userid,username,password,email,coppauser,homepage ,icq,aim,yahoo,signature,adminemail,showemail,invi sible,usertitle,joindate,cookieuser,daysprune,last visit,lastactivity,usergroupid,timezoneoffset,emai lnotification,receivepm,emailonpm,options,birthday ,maxposts,startofweek,ipaddress,pmpopup,referrerid ,nosessionhash,avatarid,gender) VALUES (NULL,'guest1','f93d443d830d46e8f62da123ee607c09', 'calendar@powwows.com','','0','http://www.powwows.com','','aol','yahoo','','1','1','0',' Pow Wow Visitor','1061249068','1','-1','1061249068','1061249068','3','0','1','1','0',' 15','1970-1-1','-1','1','65.87.136.80','0','0','1','0','2')
mysql error: Column count doesn't match value count at row 1
|
Here is the part where the insert is done in register.php:
Quote:
$DB_site->query("INSERT INTO user (userid,username,password,email".$newstylefield."p arentemail,coppauser,homepage,icq,aim,yahoo,signat ure,adminemail,showemail,invisible,usertitle,joind ate,cookieuser,daysprune,lastvisit,lastactivity,us ergroupid,timezoneoffset,emailnotification,receive pm,emailonpm,options,birthday,maxposts,startofweek ,ipaddress,pmpopup,referrerid,nosessionhash,avatar id,gender) VALUES (NULL,'".addslashes(htmlspecialchars($username))." ','".addslashes(md5($password))."','".addslashes(h tmlspecialchars($email))."',".$newstyleval."'".add slashes(htmlspecialchars($parentemail))."','$coppa user','".addslashes(htmlspecialchars($homepage))." ','".addslashes(htmlspecialchars($icq))."','".adds lashes(htmlspecialchars($aim))."','".addslashes(ht mlspecialchars($yahoo))."','".addslashes($signatur e)."','$adminemail','$showemail','$invisible','".a ddslashes($usertitle)."','".time()."','$cookieuser ','".addslashes($prunedays)."','".time()."','".tim e()."','$newusergroupid','".addslashes($timezoneof fset)."','$emailnotification','$receivepm','$email onpm','$options','".addslashes($birthday)."','".ad dslashes($umaxposts)."','".addslashes($startofweek )."','".addslashes($ipaddress)."','$pmpopup','".ad dslashes($testreferrerid['userid'])."','$nosessionhash','$avatarid','$gender')");
$userid=$DB_site->insert_id();
|
Thanks
|