Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 63 guests, and 388 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Morgan
Morgan
Sweden
Posts: 518
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 17
M4TT 12
FREAK 8
Ruben 8
mmkk 4
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
Final Support for MySQL upgrade #254204
12/01/13 07:48 PM
12/01/13 07:48 PM
Joined: Oct 2006
Posts: 370
Issaquah, WA
Bill B Offline OP

enthusiast
Bill B  Offline OP

enthusiast
Joined: Oct 2006
Posts: 370
Issaquah, WA
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
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Final Support for MySQL upgrade [Re: Bill B] #254205
12/01/13 08:02 PM
12/01/13 08:02 PM
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
Joined: Apr 2007
Posts: 4,313
SoCal, USA
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

Re: Final Support for MySQL upgrade [Re: SD] #254206
12/01/13 09:38 PM
12/01/13 09:38 PM
Joined: Oct 2006
Posts: 370
Issaquah, WA
Bill B Offline OP

enthusiast
Bill B  Offline OP

enthusiast
Joined: Oct 2006
Posts: 370
Issaquah, WA
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
Re: Final Support for MySQL upgrade [Re: Bill B] #254207
12/01/13 09:42 PM
12/01/13 09:42 PM
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
Joined: Apr 2007
Posts: 4,313
SoCal, USA
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.


Re: Final Support for MySQL upgrade [Re: SD] #254208
12/01/13 09:49 PM
12/01/13 09:49 PM
Joined: Oct 2006
Posts: 370
Issaquah, WA
Bill B Offline OP

enthusiast
Bill B  Offline OP

enthusiast
Joined: Oct 2006
Posts: 370
Issaquah, WA
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
Re: Final Support for MySQL upgrade [Re: Bill B] #254209
12/01/13 09:51 PM
12/01/13 09:51 PM
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
Joined: Apr 2007
Posts: 4,313
SoCal, USA
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

Re: Final Support for MySQL upgrade [Re: SD] #254210
12/01/13 10:15 PM
12/01/13 10:15 PM
Joined: Oct 2006
Posts: 370
Issaquah, WA
Bill B Offline OP

enthusiast
Bill B  Offline OP

enthusiast
Joined: Oct 2006
Posts: 370
Issaquah, WA
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
Re: Final Support for MySQL upgrade [Re: Bill B] #254211
12/01/13 10:32 PM
12/01/13 10:32 PM
Joined: Oct 2006
Posts: 370
Issaquah, WA
Bill B Offline OP

enthusiast
Bill B  Offline OP

enthusiast
Joined: Oct 2006
Posts: 370
Issaquah, WA
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
Re: Final Support for MySQL upgrade [Re: Bill B] #254218
12/02/13 01:26 PM
12/02/13 01:26 PM
Joined: Oct 2006
Posts: 370
Issaquah, WA
Bill B Offline OP

enthusiast
Bill B  Offline OP

enthusiast
Joined: Oct 2006
Posts: 370
Issaquah, WA
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
Re: Final Support for MySQL upgrade [Re: Bill B] #254219
12/02/13 01:30 PM
12/02/13 01:30 PM
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
Joined: Apr 2007
Posts: 4,313
SoCal, USA
just to be clear. it wasn't mysql 5.5 that was the issue.

ubbthreads running under php 5.4 was

2c

Re: Final Support for MySQL upgrade [Re: Bill B] #254222
12/02/13 01:48 PM
12/02/13 01:48 PM
Joined: Oct 2006
Posts: 370
Issaquah, WA
Bill B Offline OP

enthusiast
Bill B  Offline OP

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



--BIll B

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar [Not a Bug]
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,544
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)