Previous Thread
Next Thread
Print Thread
Hop To
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.


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
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


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Rick, is there some reason you're using

Code
SET GLOBAL SQL_MODE=”;

Instead of:
Code
SET GLOBAL SQL_MODE='';

MySQL should spew an error with what you provided


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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 ...


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
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 smile


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
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
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Glad to hear it, I've had it pop up with several client machine's


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 396 guests, and 110 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)