PDA

View Full Version : Database Error when trying to edit a forum.


mharmon
03-28-2003, 08:37 PM
When I try to edit the properties of a particular forum, I am getting the following error:

Database error in vBulletin Control Panel 2.3.0:

Invalid SQL: UPDATE forum
SET
styleid='1', title='Test', description='Test',
active='1', displayorder='1', parentid='288', parentlist='292,288,-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',
WHERE forumid='292'
mysql error: You have an error in your SQL syntax near 'WHERE forumid='292'' at line 11

mysql error number: 1064

Can anyone help?

g-force2k2
03-28-2003, 08:39 PM
did you edit the file at all? if so you can either upload an unhacked forum.php

or if you can find that line see where the moderateattach= is? the comma i believe is causing the issue...

regards,
g-force2k2

mharmon
03-28-2003, 08:43 PM
That fixed it. Thanks brother.

I took out the comma.

You da man! :)

g-force2k2
03-28-2003, 08:43 PM
hey no problem mharmon glad to be of assistance :)

regards,
g-force2k2