007
03-02-2003, 07:46 AM
Database error in vBulletin Control Panel 2.2.9:
Invalid SQL: INSERT INTO forum
(forumid,styleid,title,description,active,displayo rder,parentid,
parentlist,allowposting,cancontainthreads,daysprun e,newpostemail,newthreademail,
moderatenew,allowhtml,allowbbcode,allowimages,allo wsmilies,allowicons,
styleoverride,allowratings,countposts,moderateatta ch,storereply,storethread,allowguestpostview))
VALUES
(NULL,'1','test title','test description','1','1','33',
'','1','1','30','','',
'0','0','1','0','1','1',
'0','1','1','0', '','','1')
mysql error: You have an error in your SQL syntax near ')
VALUES
(NULL,'1','test title','test d' at line 5
mysql error number: 1064
:(
I have this:
$DB_site->query("INSERT INTO forum
(forumid,styleid,title,description,active,displayo rder,parentid,
parentlist,allowposting,cancontainthreads,daysprun e,newpostemail,newthreademail,
moderatenew,allowhtml,allowbbcode,allowimages,allo wsmilies,allowicons,
styleoverride,allowratings,countposts,moderateatta ch,storereply,storethread,allowguestpostview))
VALUES
(NULL,'$styleset','".addslashes($title)."','".addslashes($description)."','$isactive','$displayorder','$parentid',
'','$allowposting','$cancontainthreads','$daysprun e','".addslashes($newpostemail)."','".addslashes($newthreademail)."',
'$moderatenew','$aallowhtmlcode','$aallowbbcode',' $aallowimgcode','$aallowsmilies','$aallowicons',
'$styleoverride','$allowratings','$countposts','$m oderateattach', '$storereply','$storethread','$allowguestpostview' )");
What looks wrong?
Invalid SQL: INSERT INTO forum
(forumid,styleid,title,description,active,displayo rder,parentid,
parentlist,allowposting,cancontainthreads,daysprun e,newpostemail,newthreademail,
moderatenew,allowhtml,allowbbcode,allowimages,allo wsmilies,allowicons,
styleoverride,allowratings,countposts,moderateatta ch,storereply,storethread,allowguestpostview))
VALUES
(NULL,'1','test title','test description','1','1','33',
'','1','1','30','','',
'0','0','1','0','1','1',
'0','1','1','0', '','','1')
mysql error: You have an error in your SQL syntax near ')
VALUES
(NULL,'1','test title','test d' at line 5
mysql error number: 1064
:(
I have this:
$DB_site->query("INSERT INTO forum
(forumid,styleid,title,description,active,displayo rder,parentid,
parentlist,allowposting,cancontainthreads,daysprun e,newpostemail,newthreademail,
moderatenew,allowhtml,allowbbcode,allowimages,allo wsmilies,allowicons,
styleoverride,allowratings,countposts,moderateatta ch,storereply,storethread,allowguestpostview))
VALUES
(NULL,'$styleset','".addslashes($title)."','".addslashes($description)."','$isactive','$displayorder','$parentid',
'','$allowposting','$cancontainthreads','$daysprun e','".addslashes($newpostemail)."','".addslashes($newthreademail)."',
'$moderatenew','$aallowhtmlcode','$aallowbbcode',' $aallowimgcode','$aallowsmilies','$aallowicons',
'$styleoverride','$allowratings','$countposts','$m oderateattach', '$storereply','$storethread','$allowguestpostview' )");
What looks wrong?