Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (capnbob, GregK), 37 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/05/06
Posts: 88
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 18
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#176356 - 01/31/07 06:37 PM A "Just-In-Case" Question before installing Version 7.
24hourcampfire Offline
journeyman
Registered: 11/02/06
Posts: 91
Hi Guys:

I'm going to be upgrading from 6.5 to 7.02 tomorrow, and I have a couple of questions.

1] In 6.5, my Posts table was starting to corrupt on my old server, and Rick changed it from MyIsam to HEAP. WIll this affect the upgrade? Should I "unHEAP" it?

2] I have a few hacks on 6.5. Can I disregard, or are there some I should watch out for (and undo). I got all the hacks from threadsdev, and I don't know if I can remember (or undo) them all!

3] Where can I see/test my skins?

Thanks all. Really looking forward to getting this installed!!

Rick
_________________________
Rick Bin
24hourcampfire.com

http://www.24hourcampfire.com/ubbthreads/ubbthreads.php
Top
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."
#176364 - 01/31/07 07:07 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: 24hourcampfire]
David Dreezer Offline

Pooh-Bah
Registered: 07/21/06
Posts: 2199
Are you sure it's HEAP? HEAP tables do not support fields of the type text or blob. Being the posts table I have to think you would see one of them.

Do you mean INNODB? If so, leave it. That'll be fine. \:\)
_________________________
This thread for sale. Click here!
Top
#176375 - 01/31/07 07:38 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: David Dreezer]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
I think he means innodb, and you should be fine.

As for mods; the importer just reads data, so you should be fine there as well.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#176379 - 01/31/07 07:43 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: Gizmo]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
It wasn't the posts table that we changed to heap, only the Online table. That won't cause any issues with the update.
Top
#176388 - 01/31/07 07:54 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: Rick]
David Dreezer Offline

Pooh-Bah
Registered: 07/21/06
Posts: 2199
Online table using HEAP isn't a bad idea at all. It's transient, so If MySQL dies and loses it who cares? Good idea, Rick.
_________________________
This thread for sale. Click here!
Top
#176390 - 01/31/07 07:55 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: David Dreezer]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
ahh i remember this one now; the table kept getting currupted after a couple of days...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#176428 - 01/31/07 09:03 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: Gizmo]
24hourcampfire Offline
journeyman
Registered: 11/02/06
Posts: 91
This place rocks.

Thanks guys.

Wish me luck.

Rick
_________________________
Rick Bin
24hourcampfire.com

http://www.24hourcampfire.com/ubbthreads/ubbthreads.php
Top
#176436 - 01/31/07 11:52 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: 24hourcampfire]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
Lol good luck and check back often ;\)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181698 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image