UBB.Developers Forums UBB.threads 6 Bug Reports 5.5 - Edit Titles bug

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

I just did as you instructed with my site and I didn't get any errors.. something else causing this?

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?

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.

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[/]