Yeah, I know... shame on me for waiting so long to upgrade...

Anyway, question is: What kind of time & resources does the upgrade process take, server-wise? Does it matter the amount of records in any of the Links tables? (Say, for example, if I had 200,000+ categories?)

We have about a half dozen other sites on our server and I'm loathe to jeopardize performance for any sustained amount of time.

Also, if I run this from shell, can I expect prompts with further instructions, or does one need to do this right from the command line? And if the latter, what would be the proper command line entry (for an upgrade)?

Thanks


Matt G

*bump*
(was hoping to give this a shot this weekend... any help is appreciated!)

--
Matt G

Hi Matt,

The upgrade from 2.0.3 to 2.0.4 does:

- Add Contact_Name and Contact_Email columns to the Links table
- Add Category_Template column to the Category table.
- Add messageformat column to the MailingIndex table.

The first part can take some time if you have a lot of links. I would recommend running it from shell. However, if your original install was done from the web, you may not be able to run it from shell due to permissions.

To run from shell, simply type:

perl install.cgi

and that's it!

Cheers,

Alex
--
Gossamer Threads Inc.

Thanks Alex.

I ran the install.cgi from shell, and it took under a minute. I figured it would take a lot longer, due to the 200,000+ cateogies in Links_Category.

However, neither the Contact_Name nor Contact_Email columns were added to the Links table, and Category_Template was not added to the Category table. The MailingIndex table WAS updated with the messageformat column.

I received a message that the upgrade was completed successfully, and my templates have changed, etc.

Here is the install.cgi output I rec'd:

...
Unarchiving (666) /path/to/images/fileman/toolbar/underline.gif
Unarchiving (666) /path/to/images/fileman/toolbar/undo.gif

Congratulations! Your copy of Links SQL has now been
updated to version 2.0.5. The install files have
been removed.

If you need to re-run the install, please unarchive the
original file again.
Gossamer Threads Inc.

Should I just add these columns manually, or should I be worried about other areas not being upgraded? If manually, what are the column properties?
Contact_Name
Contact_Email
Category_Template

Thanks!

--
Matt G

Hi,

Yes, just add them manually. Goto Database->Links->Properties and select Add Column and add:

Name: Contact_Name
Type: CHAR
Size: 255

and then

Name: Contact_Email
Type: CHAR
Size: 255

and for the Category table add:

Name: Category_Template
Type: CHAR
Size: 50

Cheers,

Alex
--
Gossamer Threads Inc.

Thanks, Alex.

How about the:

- Column Index
- Not Null
- etc

properties?

Leave everything as default?

Thanks again.

--
Matt G