Portal Forums Calendar Active Threads
Previous Thread
Next Thread
Print Thread
Hop To
[FIXED for 7.1.1] Updating user profile gives me USER_IS_BANNED DB error
#179779 03/01/2007 5:42 PM
Joined: Mar 2007
Posts: 26
A
ajwharton
Offline
journeyman
ajwharton
journeyman
A Offline
Joined: Mar 2007
Posts: 26
Control panel message
update ubbt_USERS set USER_IS_BANNED = '' , USER_IS_UNDERAGE = 0 where USER_ID = 15

Out of range value adjusted for column 'USER_IS_BANNED' at row 1

I upgraded from 7.01 -> 7.1
Re: Updating user profile gives me USER_IS_BANNED DB error
ajwharton #179811 03/01/2007 11:32 PM
Joined: Jun 2006
Posts: 16,301
Likes: 116
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo
UBB.threads Developer
Offline
Joined: Jun 2006
Posts: 16,301
Likes: 116
Portland, OR; USA
This could be the same issue as your other post, please read my comment there and see if it clears up.

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!
Re: Updating user profile gives me USER_IS_BANNED DB error
Gizmo #179831 03/02/2007 1:36 AM
Joined: Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
R
Rick Offline
Former Developer
Rick
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
Explained here
Re: Updating user profile gives me USER_IS_BANNED DB error
Rick #181135 03/20/2007 3:53 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
R
Rick Offline
Former Developer
Rick
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Aberdeen, WA
Modified to make sure that it always set a default value of 1 or 0 in the query.

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Version 7.7.5 Images suddenly not displaying
by Stovebolt - 05/04/2024 11:19 AM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
Who's Online Now
1 members (TBolley), 567 guests, and 203 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
Forum Rules · Mark All Read Contact Us · Forum Help · UBBCentral
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)