Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Sequencial Numbering of Category ID's

Quote Reply
Sequencial Numbering of Category ID's
Alex (et. al.):

I have one concern regarding the upgrade process. In the course of building my site, I have deleted a few categories. If someone has deleted even a single category, there may be problems in an upgrade.

Here is why: let us suppose you delete from CATEGORY, the one with ID = 55, you now have ID's 53, 54, 56, 57, etc. Now when you upgrade and import, these will be sequencially numbered.... ID 56 will become 55, 57 to 56, and so on. Yet the CategoryID refernced in the LINKS table will NOT be readjusted... or at least that is my worry.

Will this be addressed to simplify the upgrade process, or is there a work around I just do not know about that would solve this problem. Or is this just not a problem at all.

Other than that, really looking forward to the new Links!

dave

Quote Reply
Re: Sequencial Numbering of Category ID's In reply to
The upgrade will take care of this, and will use the same ID numbers..

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: Sequencial Numbering of Category ID's In reply to
I'm pretty sure the upgrade will just ALTER the databases, and if so, will keep everything the same, just add tables and fields to tables (or alter data within each table record by record).

In doing so, you'd keep the current ID's.

I'm sure this has been a consideration in the upgrade planning, since many ID's and things are hard coded (over time) and might be on other people's sites, and in search engines, etc.



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Quote Reply
Re: Sequencial Numbering of Category ID's In reply to
pugdog/Alex:

Thanks- big sigh of relief!

Dave