Previous Thread
Next Thread
Print Thread
Hop To
Joined: Oct 2006
Posts: 358
enthusiast
enthusiast
Joined: Oct 2006
Posts: 358
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
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
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

Joined: Oct 2006
Posts: 358
enthusiast
enthusiast
Joined: Oct 2006
Posts: 358
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.


--BIll B
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
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.


Joined: Oct 2006
Posts: 358
enthusiast
enthusiast
Joined: Oct 2006
Posts: 358
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?


--BIll B
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
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

Joined: Oct 2006
Posts: 358
enthusiast
enthusiast
Joined: Oct 2006
Posts: 358
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.


--BIll B
Joined: Oct 2006
Posts: 358
enthusiast
enthusiast
Joined: Oct 2006
Posts: 358
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.


--BIll B
Joined: Oct 2006
Posts: 358
enthusiast
enthusiast
Joined: Oct 2006
Posts: 358
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.


--BIll B
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
just to be clear. it wasn't mysql 5.5 that was the issue.

ubbthreads running under php 5.4 was

2c

Joined: Oct 2006
Posts: 358
enthusiast
enthusiast
Joined: Oct 2006
Posts: 358
Yes, sorry... I misquoted... it WAS the PHP upgrade that caused the problem...



--BIll B

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
3 members (rootman, Gizmo, Nightcrawler), 562 guests, and 186 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)