UBBCentral

Final Support for MySQL upgrade

Posted By: Bill B

Final Support for MySQL upgrade - 12/02/2013 12:48 AM

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 ")
Posted By: SD

Re: Final Support for MySQL upgrade - 12/02/2013 1:02 AM

that'll work, but it won't convert any ubb codes like [b] or whatever, for example...

you could rebuild all posts, which is automatic, but that can take a VERY long time, if you have quite a few
Posted By: Bill B

Re: Final Support for MySQL upgrade - 12/02/2013 2:38 AM

Yes, I saw that they don't "format" properly. The one that I used for a test, I had to open it up as an EDIT and then re-SAVED it... that brought the formatting back.

i didn't think about REBUILD. Would that also copy the topics back into the right field AND reformat it???

I think I only have about 50 long-posts that were messed up.

I'm willing to sacrafice a 5 hour offline in order to do the rebuild. I've spent way too much on this over the past 3 weeks.
Posted By: SD

Re: Final Support for MySQL upgrade - 12/02/2013 2:42 AM

rebuild is an automatic way to : open, edit, save EVERY post

but for 50 posts, is it worth it? that has to be your call.

if you do it, i'd suggest a pre-backup, then fire it off, watch Monday nite football.. come back..

note: you can always kill it in the middle, if you see it taking too much longer than anticipated too..

bummer is, that it starts the rebuild from lower post numbers ( older ) and finishes with the higher ones ( most recent ), so you really won't be doing anything of value until the last maybe 5% of your posts, where those blanks exist.

you'll have to decide for yourself.

Posted By: Bill B

Re: Final Support for MySQL upgrade - 12/02/2013 2:49 AM

Ha... great minds think... you know.

I just logged back on to ask if there was a way to get it to begin at a high number!!! I only need the last 2,000 postings rebuilt....

I have about 250,000 posts. And I only need to rebuild the last three weeks.

Is the query (for Rebuild) in the code or is it too much to mess with?
Posted By: SD

Re: Final Support for MySQL upgrade - 12/02/2013 2:51 AM

yah, content rebuilder can be hacked to do that query, but it would be a mod to stock.

you would essentially modify admin/dorebuildcontent.php and manipulate $start to some POST_ID that is large, so it is fooled into starting later in the DB.

would be nice feature to have, where you can select: which forums and what timeframe..

for now.. it's ALL or nada
Posted By: Bill B

Re: Final Support for MySQL upgrade - 12/02/2013 3:15 AM

Thanks Dude!!

I might take a look at it... a temporary hack would be useful if I can do it in less time than manually modifying 50 records.

Yes, that would be a great (and simple) addition to the Admin features.
Posted By: Bill B

Re: Final Support for MySQL upgrade - 12/02/2013 3:32 AM

I queried and found missing posts throughout my entire database, not just within the last 3 weeks.

But -- I found that if I just OPEN a blank post as EDIT, and then RE-SAVE it, that it comes back -- LIKE MAGIC!!

See this as an example
http://vcca.org/forum/ubbthreads.php/topics/285796#Post285796

Wow... i'm so glad NOT to lose that first posting. Based upon this, I'm going to rebuild the entire database.

Thanks for the ideas and tips.
Posted By: Bill B

Re: Final Support for MySQL upgrade - 12/02/2013 6:26 PM

FINAL RESOLUTION: I ran the REBUILD ALL POSTs function last night. For 275,000 postings it took about 2.5 hours. When done, over 3,000 missing "long posts" were restored.

So that completes all fixes for my MySQL upgrade to 5.5.
Posted By: SD

Re: Final Support for MySQL upgrade - 12/02/2013 6:30 PM

just to be clear. it wasn't mysql 5.5 that was the issue.

ubbthreads running under php 5.4 was

2c
Posted By: Bill B

Re: Final Support for MySQL upgrade - 12/02/2013 6:48 PM

Yes, sorry... I misquoted... it WAS the PHP upgrade that caused the problem...

© 2019 UBB.threads PHP Forum Software Community