PDA

View Full Version : SQL Error :(


KelteN
11-17-2002, 02:24 AM
I am getting this error when I try to edit a forum via the ACP.

When I finish editing the certain forum, I click submit and it gives me this sql error:

Invalid SQL: UPDATE forum
SET
styleid='1', title='Music', description='Music Talk',
active='1', displayorder='6', parentid='5', parentlist='16,5,-1',
allowposting='1', cancontainthreads='1', daysprune='30',
newpostemail='', newthreademail='',
moderatenew='0', allowhtml='0', allowbbcode='1',
allowimages='0', allowsmilies='1', allowicons='1',
styleoverride='0', allowratings='1', countposts='1',
moderateattach='0', storereply='0', storethread='0''
WHERE forumid='16'
mysql error: You have an error in your SQL syntax near '16'' at line 10

mysql error number: 1064

Does anyone know how to fix this???

FWC
11-17-2002, 03:43 AM
Originally posted by ReveX
storethread='0''That should be storethread='0'

KelteN
11-17-2002, 03:46 AM
What file do I fix so it does it correctly?

N!ck
11-17-2002, 03:47 AM
forum.php

FWC
11-17-2002, 03:48 AM
/admin/forum.php

N!ck
11-17-2002, 03:57 AM
:angry:

KelteN
11-17-2002, 04:06 AM
YAY! It works! Thanks alot dudes!

FWC
11-17-2002, 04:09 AM
Cool. :)