Previous Thread
Next Thread
Print Thread
Hop To
Joined: Feb 2004
Posts: 138
T
member
member
T Offline
Joined: Feb 2004
Posts: 138
When chaning the profile settings and applying the changes to existing members, I receive this error:

UPDATE ubbt_USER_PROFILE SET USER_TITLE = 'Member' WHERE

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3.

Can someone point me in the right direction to fix this?

Regards,

Travis

Last edited by Rick; 05/31/2007 12:34 PM.
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
This looks like something reported recently. Do you have just a single title assigned to the user titles? If so, you'll want to create a second one as well. If you only want one title, you can use the same title, it's just that it currently requires there to be at least 2 titles.

Joined: Feb 2004
Posts: 138
T
member
member
T Offline
Joined: Feb 2004
Posts: 138
Ah...yes that is correct. I removed all of them and made them all the same title.

Thanks,
Travis

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Have the fixed for 7.2.


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
0 members (), 834 guests, and 246 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)