The Arcive of vBulletin Modifications Site.

Any idea what this means? · **Released**: 03-02-2003

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:

PHP Code:


			$DB_site->query("INSERT INTO forum
                      (forumid,styleid,title,description,active,displayorder,parentid,
                       parentlist,allowposting,cancontainthreads,daysprune,newpostemail,newthreademail,
                       moderatenew,allowhtml,allowbbcode,allowimages,allowsmilies,allowicons,
                       styleoverride,allowratings,countposts,moderateattach,storereply,storethread,allowguestpostview))
                   VALUES
                      (NULL,'$styleset','".addslashes($title)."','".addslashes($description)."','$isactive','$displayorder','$parentid',
                       '','$allowposting','$cancontainthreads','$daysprune','".addslashes($newpostemail)."','".addslashes($newthreademail)."',
                       '$moderatenew','$aallowhtmlcode','$aallowbbcode','$aallowimgcode','$aallowsmilies','$aallowicons',
                       '$styleoverride','$allowratings','$countposts','$moderateattach', '$storereply','$storethread','$allowguestpostview')");

What looks wrong?

Kars10 · #2 03-02-2003, 08:15 AM

Hmm, i can?t find

PHP Code:


			'test title','test description'

there...

Xenon · #3 03-02-2003, 10:19 AM

Code:

allowguestpostview))

you see the double ) at the end?

remove one

Erwin · #4 03-02-2003, 06:29 PM

And the winner is... Stefan!!! Good spot...

Xenon · #5 03-02-2003, 08:01 PM

*ggg*

Thanx erwin

007 · #6 03-14-2003, 09:37 PM

Thanks. I just noticed that you guys replied.

I had just reverted to my original one temporarily while I made the new forum back when I first posted this, but I just added another forum a few minutes ago and it happened again. Then I remembered this post.

Thanks, that was it Xenon.