|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
A user had a copyrighted image in their avatar, so I edited their profile and hit the 'no avatar' button. It said -
UPDATE ubbt_USER_PROFILE SET USER_EXTRA_FIELD_1 = '' , USER_EXTRA_FIELD_2 = '', USER_EXTRA_FIELD_3 = '' , USER_EXTRA_FIELD_4 = '' , USER_EXTRA_FIELD_5 = '' , USER_CUSTOM_TITLE = '' , USER_NAME_COLOR = '' , USER_REAL_EMAIL = 'user@domain.com' , USER_DISPLAY_EMAIL = 'user@domain.com' , USER_LOCATION = 'Pittsburgh, PA' , USER_OCCUPATION = 'Gamer' , USER_HOBBIES = '' , USER_HOMEPAGE = '' , USER_SIGNATURE = '' , USER_DEFAULT_SIGNATURE = '' , USER_ICQ = '' , USER_YAHOO = '' , USER_MSN = '' , USER_AIM = 'Rumi x Kon' , USER_PUBLIC_BIRTHDAY = 1 , USER_TIME_FORMAT = 'm/d/y | h:i A' , USER_TIME_OFFSET = 0 , USER_TOPIC_VIEW_TYPE = 'flat' , USER_TOPICS_PER_PAGE = 10 , USER_POSTS_PER_TOPIC = 10 , USER_SHOW_SIGNATURES = 'yes' , USER_VISIBLE_ONLINE_STATUS = 'yes' , USER_ACCEPT_PM = 'yes' , USER_NOTIFY_ON_PM = 'On' , USER_FLOOD_CONTROL_OVERRIDE = -1 , USER_AVATAR = '',USER_AVATAR_WIDTH= '' ,USER_AVATAR_HEIGHT= '' WHERE USER_ID = 4090
Out of range value adjusted for column 'USER_AVATAR_WIDTH' at row 1
This is on my lisashea.com forum which I just upgraded a few days ago.
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
I then went into the control pane to edit this same user, on the page that has the banned button (which is not checked). It says when I try to save -
update ubbt_USERS set USER_IS_BANNED = '' , USER_IS_UNDERAGE = 0 where USER_ID = 4090
Out of range value adjusted for column 'USER_IS_BANNED' at row 1
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
It sounds like your version of mysql is running in strict mode. In the next update I'll alter the queries to specify a default value, however you should be able to get rid of the error by running the following sql command:
SET GLOBAL SQL_MODE=”;
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
Rick, is there some reason you're using Instead of: MySQL should spew an error with what you provided
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Guess it got messed up in the copy/paste from my notes. Yeah, it should just be
SET GLOBAL SQL_MODE='';
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
I did that in the SQL Command window and it replied
SET GLOBAL SQL_MODE='';
Access denied; you need the SUPER privilege for this operation
I'll look for other ways to run it ...
|
|
|
|
Joined: Jun 2006
Posts: 693
Addict
|
Addict
Joined: Jun 2006
Posts: 693 |
I've done it in DOS-prompt SQL and we'll see how it fixes my various issues
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Have this fixed for 7.1.1 for those that do run in strict mode.
|
|
|
|
Joined: Jun 2006
Posts: 16,292 Likes: 116
|
Joined: Jun 2006
Posts: 16,292 Likes: 116 |
Glad to hear it, I've had it pop up with several client machine's
|
|
|
0 members (),
396
guests, and
110
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|