Andrew,

When trying to change my preferences (for example, to set the # posts per page to 99) I get the following error:

UBB Error
We encountered a problem. The reason reported was

Database error only visible to forum administrators

Please use your back button to return to the previous page.
THE ERROR IS:

Database error only visible to forum administrators

[ERROR][Fri, Apr 13 2007 16:15:36 -0400] [/forums/ubbthreads.php] [Rob Cauduro] Script: C:\Inetpub\ca.dsm.org\forums\scripts\changedisplay.inc.php - Line: 141
UPDATE ubbt_USER_PROFILE
SET
USER_START_VIEW = 'cfrm',
USER_FAVORITES_TAB = 'forums',
USER_FAVORITES_SORT = 'reply',
USER_TOPIC_VIEW_TYPE = 'flat',
USER_SHOW_AVATARS = 1,
USER_NOTIFY_ON_PM = 'yes',
USER_POSTS_PER_TOPIC = 40,
USER_TOPICS_PER_PAGE = 40,
USER_ACCEPT_PM = 'yes',
USER_TIME_FORMAT = 'Y m d | h:i a',
USER_TIME_OFFSET = 0,
USER_VISIBLE_ONLINE_STATUS = 'yes',
USER_SHOW_SIGNATURES = 'yes',
USER_STYLE = 0,
USER_UNAPPROVED_POST_NOTIFY = 0 ,
USER_HIDE_LEFT_COLUMN = 0 ,
USER_HIDE_RIGHT_COLUMN = 0 ,
USER_EMAIL_WATCHLISTS = 0 ,
USER_LANGUAGE = 'english' ,
USER_REPORT_POST_NOTIFY = '' ,
USER_RELATIVE_TIME = 1
WHERE USER_ID = 821
- Incorrect integer value: '' for column 'USER_REPORT_POST_NOTIFY' at row 1
[ERROR][Fri, Apr 13 2007 16:16:56 -0400] [/forums/ubbthreads.php] [Rob Cauduro] Script: C:\Inetpub\ca.dsm.org\forums\scripts\changedisplay.inc.php - Line: 141
UPDATE ubbt_USER_PROFILE
SET
USER_START_VIEW = 'cfrm',
USER_FAVORITES_TAB = 'forums',
USER_FAVORITES_SORT = 'reply',
USER_TOPIC_VIEW_TYPE = 'flat',
USER_SHOW_AVATARS = 1,
USER_NOTIFY_ON_PM = 'yes',
USER_POSTS_PER_TOPIC = 10,
USER_TOPICS_PER_PAGE = 10,
USER_ACCEPT_PM = 'yes',
USER_TIME_FORMAT = 'Y m d | h:i a',
USER_TIME_OFFSET = 0,
USER_VISIBLE_ONLINE_STATUS = 'no',
USER_SHOW_SIGNATURES = 'yes',
USER_STYLE = 0,
USER_UNAPPROVED_POST_NOTIFY = 0 ,
USER_HIDE_LEFT_COLUMN = 0 ,
USER_HIDE_RIGHT_COLUMN = 0 ,
USER_EMAIL_WATCHLISTS = 0 ,
USER_LANGUAGE = 'english' ,
USER_REPORT_POST_NOTIFY = '' ,
USER_RELATIVE_TIME = 1
WHERE USER_ID = 821
- Incorrect integer value: '' for column 'USER_REPORT_POST_NOTIFY' at row 1
[ERROR][Fri, Apr 13 2007 16:17:03 -0400] [/forums/ubbthreads.php] [Rob Cauduro] Script: C:\Inetpub\ca.dsm.org\forums\scripts\changedisplay.inc.php - Line: 141
UPDATE ubbt_USER_PROFILE
SET
USER_START_VIEW = 'cfrm',
USER_FAVORITES_TAB = 'forums',
USER_FAVORITES_SORT = 'reply',
USER_TOPIC_VIEW_TYPE = 'flat',
USER_SHOW_AVATARS = 1,
USER_NOTIFY_ON_PM = 'yes',
USER_POSTS_PER_TOPIC = 10,
USER_TOPICS_PER_PAGE = 10,
USER_ACCEPT_PM = 'yes',
USER_TIME_FORMAT = 'Y m d | h:i a',
USER_TIME_OFFSET = 0,
USER_VISIBLE_ONLINE_STATUS = 'yes',
USER_SHOW_SIGNATURES = 'yes',
USER_STYLE = 0,
USER_UNAPPROVED_POST_NOTIFY = 0 ,
USER_HIDE_LEFT_COLUMN = 0 ,
USER_HIDE_RIGHT_COLUMN = 0 ,
USER_EMAIL_WATCHLISTS = 0 ,
USER_LANGUAGE = 'english' ,
USER_REPORT_POST_NOTIFY = '' ,
USER_RELATIVE_TIME = 1
WHERE USER_ID = 821
- Incorrect integer value: '' for column 'USER_REPORT_POST_NOTIFY' at row 1
[ERROR][Fri, Apr 13 2007 16:17:16 -0400] [/forums/ubbthreads.php] [Rob Cauduro] Script: C:\Inetpub\ca.dsm.org\forums\scripts\changedisplay.inc.php - Line: 141
UPDATE ubbt_USER_PROFILE
SET
USER_START_VIEW = 'cfrm',
USER_FAVORITES_TAB = 'forums',
USER_FAVORITES_SORT = 'reply',
USER_TOPIC_VIEW_TYPE = 'flat',
USER_SHOW_AVATARS = 1,
USER_NOTIFY_ON_PM = 'yes',
USER_POSTS_PER_TOPIC = 10,
USER_TOPICS_PER_PAGE = 10,
USER_ACCEPT_PM = 'yes',
USER_TIME_FORMAT = 'Y m d | h:i a',
USER_TIME_OFFSET = 0,
USER_VISIBLE_ONLINE_STATUS = 'yes',
USER_SHOW_SIGNATURES = 'yes',
USER_STYLE = 0,
USER_UNAPPROVED_POST_NOTIFY = 0 ,
USER_HIDE_LEFT_COLUMN = 0 ,
USER_HIDE_RIGHT_COLUMN = 0 ,
USER_EMAIL_WATCHLISTS = 0 ,
USER_LANGUAGE = 'english' ,
USER_REPORT_POST_NOTIFY = '' ,
USER_RELATIVE_TIME = 1
WHERE USER_ID = 821
- Incorrect integer value: '' for column 'USER_REPORT_POST_NOTIFY' at row 1
[ERROR][Fri, Apr 13 2007 16:20:37 -0400] [/forums/ubbthreads.php] [Rob Cauduro] Script: C:\Inetpub\ca.dsm.org\forums\scripts\modifypost.inc.php - Line: 455
update ubbt_POSTS
set POST_SUBJECT = 'Re: New Forum Program....' ,
POST_BODY = ' <img src=\"http://www.fox-obel.com/images/cheese.jpg\" alt=\"\" /> <br /><br />There ya go Strelecki <img src=\"/forums/images/graemlins/default/smile.gif\" alt=\"\\:\\)\" title=\"smile\" height=\"15\" width=\"15\" />' ,
POST_DEFAULT_BODY = ' \r\n\r\nThere ya go Strelecki :)',
POST_ICON = 'book.gif' ,
POST_LAST_EDITED_TIME= '' ,
POST_LAST_EDIT_REASON = '' ,
POST_LAST_EDITED_BY = 'Rob Cauduro' ,
POST_ADD_SIGNATURE = 1 ,
POST_HAS_FILE = 0

where POST_ID = 228217
- Incorrect integer value: '' for column 'POST_LAST_EDITED_TIME' at row 1
[ERROR][Fri, Apr 13 2007 16:20:43 -0400] [/forums/ubbthreads.php] [Rob Cauduro] Script: C:\Inetpub\ca.dsm.org\forums\scripts\modifypost.inc.php - Line: 455
update ubbt_POSTS
set POST_SUBJECT = 'Re: New Forum Program....' ,
POST_BODY = ' <img src=\"http://www.fox-obel.com/images/cheese.jpg\" alt=\"\" /> <br /><br />There ya go Strelecki <img src=\"/forums/images/graemlins/default/smile.gif\" alt=\"\\:\\)\" title=\"smile\" height=\"15\" width=\"15\" />' ,
POST_DEFAULT_BODY = ' \r\n\r\nThere ya go Strelecki :)',
POST_ICON = 'book.gif' ,
POST_LAST_EDITED_TIME= '' ,
POST_LAST_EDIT_REASON = '' ,
POST_LAST_EDITED_BY = 'Rob Cauduro' ,
POST_ADD_SIGNATURE = 1 ,
POST_HAS_FILE = 0

where POST_ID = 228217
- Incorrect integer value: '' for column 'POST_LAST_EDITED_TIME' at row 1