Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
3 registered (Gizmo, zurih, 1 invisible), 24 Guests and 21 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/10/06
Posts: 39
Top Posters (30 Days)
Ruben Rocha 155
Rick 122
Gizmo 110
Thelockman 62
driv 55
phoebe 39
ScriptKeeper 38
AllenAyres 35
Ian 31
Mark S 30
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Topic Options
Rate This Topic
#176356 - 01/31/07 03:37 PM A "Just-In-Case" Question before installing Version 7.
24hourcampfire Offline
journeyman

Registered: 11/02/06
Posts: 56
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
#176364 - 01/31/07 04:07 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: 24hourcampfire]
David Dreezer Offline
Pooh-Bah

Registered: 07/21/06
Posts: 1781
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. \:\)
_________________________
What do you mean "You're the bomb, run away?"

Top
#176375 - 01/31/07 04:38 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: David Dreezer]
Gizmo Moderator Online   sleepy

***

Registered: 06/04/06
Posts: 11967
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.
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#176379 - 01/31/07 04:43 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: Gizmo]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7880
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.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#176388 - 01/31/07 04:54 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: Rick]
David Dreezer Offline
Pooh-Bah

Registered: 07/21/06
Posts: 1781
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.
_________________________
What do you mean "You're the bomb, run away?"

Top
#176390 - 01/31/07 04:55 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: David Dreezer]
Gizmo Moderator Online   sleepy

***

Registered: 06/04/06
Posts: 11967
Loc: Portland, OR; USA
ahh i remember this one now; the table kept getting currupted after a couple of days...
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#176428 - 01/31/07 06:03 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: Gizmo]
24hourcampfire Offline
journeyman

Registered: 11/02/06
Posts: 56
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 08:52 PM Re: A "Just-In-Case" Question before installing Version 7. [Re: 24hourcampfire]
Gizmo Moderator Online   sleepy

***

Registered: 06/04/06
Posts: 11967
Loc: Portland, OR; USA
Lol good luck and check back often ;\)
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top


Shout Box

Today's Birthdays
Neptin
Recent Topics
Pruning Messages
by EMG
11/18/08 06:57 PM
7.4.1 Advanced Search - Default to Referer Forum?
by Jim
11/18/08 01:32 AM
Move charset out of language files?
by Gizmo
11/17/08 09:33 PM
Where is Moderation Queue?
by luket
11/17/08 08:27 PM
Custom Page or Content
by FordDoctor
11/17/08 05:28 PM
Forum Stats
4244 Members
33 Forums
30478 Topics
154602 Posts

Max Online: 978 @ 06/24/07 08:19 PM