|
|
Joined: Sep 2001
Posts: 17
Newbie
|
Newbie
Joined: Sep 2001
Posts: 17 |
Put a check in 'Check this box if you want to update existing users with these new titles. (WARNING! Any custom titles will be overwritten by doing this.)'
Click 'Update Titles'.
Then you get: SQL ERROR: Unable to do_query: UPDATE w3t_Users SET U_Title = '' WHERE U_TotalPosts >= You have an error in your SQL syntax near '' at line 5
tia
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
I just did as you instructed with my site and I didn't get any errors.. something else causing this?
|
|
|
|
Joined: Sep 2001
Posts: 17
Newbie
|
Newbie
Joined: Sep 2001
Posts: 17 |
In reply to:
I just did as you instructed with my site and I didn't get any errors.. something else causing this?
Really? Your using 5.5, right?
|
|
|
|
Joined: Sep 2001
Posts: 17
Newbie
|
Newbie
Joined: Sep 2001
Posts: 17 |
Thanks for the reply Dave.
Since I got the error and you did not, it made me think maybe something was corrupt on my end.
I 'optimized' the tables. The message went by to quick, but it looked like it fixed something with the users tables.
I then went back and did not get the error.
Looks like something had got corrupted.
|
|
|
|
Joined: Jun 2001
Posts: 3,273
That 70's Guy
|
That 70's Guy
Joined: Jun 2001
Posts: 3,273 |
Yeah I set up a test site using a current copy of my main database this morning. I didn't get any errors with 5.5 when updating titles. Glad yours worked this time. [] https://www.ubbdev.com/threads/php/images/icons/smile.gif[/]
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 69
Joined: January 2001
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|