So, now that the 7.5.8 "fix" has been installed, does anybody have an idea on how I can "automatically" fix all of my "long posts" that didn't save properly after I upgraded to MySQL 5.5.34 ?? This was the BIG ISSUE that I have been fighting for the past 3 weeks.

The result appears to be easily explained.

After I upgraded to MySQL 5.5, all "Long Postings" that users made, saved to the POST_DEFAULT_BODY field, but left the POST_BODY field BLANK. As a result, nothing shows up in the Forum.

So, would a query like this do the trick?

UPDATE ubbt_POSTS
set POST_DEFAULT_BODY = POST_BODY
WHERE POST_BODY = ''

(Last line is ' and ', not ")


--BIll B