When trying to edit a forum that has the 'Forum Enabled' box unchecked, an error results:

Code
UPDATE ubbt_FORUMS SET FORUM_TITLE = 'Notices' , FORUM_DESCRIPTION = '' , FORUM_ALLOW_HTML = '0' , FORUM_ALLOW_MARKUP = '1' , FORUM_IS_MODERATED = '0' , FORUM_DEFAULT_TOPIC_AGE = '0' , FORUM_CUSTOM_HEADER = '0' , FORUM_STYLE = 0 , FORUM_IMAGE = '' , FORUM_IS_ACTIVE = '' , FORUM_PARENT = '0' , FORUM_ALLOW_ATTACHMENTS = 0 , FORUM_ALLOW_POLLS = 0 , FORUM_POLLS_ANYWHERE = 0 , FORUM_ISLAND_INSERT = 0 , FORUM_IS_RSS = 0 , FORUM_RSS_TITLE = 'RSS Feed for Notices' , FORUM_SHOW_INTRO = '1' , FORUM_INTRO_TITLE = 'Board Notices and News' , FORUM_STYLE = '0' , FORUM_GUEST_CAPTCHA = '' ,CATEGORY_ID = '2' WHERE FORUM_ID = '17' 

Incorrect integer value: '' for column 'FORUM_IS_ACTIVE' at row 1

Last edited by Rick; 05/31/2007 12:29 PM.
RnJpZW5kc2hpcCB3aXRoIHRoZSB3b3JsZCBpcyBob3N0aWxpdH
kgdG93YXJkcyBHb2QuICBKYW1lcyA0OjQ=