After upgrading from version 6.7.3 to version 7.1 and importing all of the posts successfully we are having a minor problem with users updating their preferences when they click on MY STUFF / MY PREFERENCES.
If a User tries to save their preferences the following error is logged in the MYSQL Error log and they receive a message that only Administrators can see the error message, however if a user who IS AN ADMINISTRATOR saves their preferences, there is no error and nothing is logged in the MYSQL error log.
The MYSQL Error is:
[ERROR][Mon, Mar 26 2007 01:00:46 -0400] [/forums/ubbthreads.php] [Dan] Script: D:\.........\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 = 'no',
USER_POSTS_PER_TOPIC = 20,
USER_TOPICS_PER_PAGE = 20,
USER_ACCEPT_PM = 'yes',
USER_TIME_FORMAT = 'm/d/y | 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 = 0
WHERE USER_ID = 3
- Incorrect integer value: '' for column 'USER_REPORT_POST_NOTIFY' at row 1
My guess is that the USER_REPORT_POST_NOTIFY field in the database is the wrong type (or the script is incorrect) because in the error above it is trying to store a quoted string
USER_REPORT_POST_NOTIFY = '' ,
and the database field appears to be an integer.
"show fields from ubbt_USER_PROFILE" SQL command shows the following for USER_REPORT_POST_NOTIFY:
USER_REPORT_POST_NOTIFY tinyint(1) NO 0
Last edited by ECNet; 03/26/2007 1:41 AM. Reason: additional info