how to upgrade instructions

where can i find the instructions on how to upgrade.

and info on upgrading ie what upgrading will kill and what ill need to fix/reinstall after upgrade, payment moduals etc etc etc

would like some instructions and info so i know roughly how long it will take and how long my site wil be offline for etc!

Pretty good instructions are here:

https://www.zen-cart.com/tutorials/index.php?article=98

You would also do well to make sure that over-ride files in your custom template system are compatible with the core files in the new version. You may need to do some edits - but you must check these - use WINMERGE to compare the files.

Remember that your DEFINED pages need to be backed up as well, as you will need to re-import these to the upgraded version.

Hi
I'm trying to install Ty Package Tracker version 2.3a - in ZenChart - but the enclosed sql-file for database give me a ERROR - on line 8 - not a leagel value for INTEGER

Here is the sql-file

SET @tyid=7878;
SELECT (@tyid:=configuration_group_id) as tyid
FROM configuration_group
WHERE configuration_group_title= 'Ty Package Tracker';
DELETE FROM configuration WHERE configuration_group_id = @tyid;
DELETE FROM configuration_group WHERE configuration_group_id = @tyid;

INSERT INTO configuration_group VALUES ('', 'Ty Package Tracker', 'Ty Package Tracker Settings', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SET @tyid=7878;
SELECT (@tyid:=configuration_group_id) as tyid
FROM configuration_group
WHERE configuration_group_title= 'Ty Package Tracker';
INSERT INTO configuration VALUES ('', 'Carrier 1 Name', 'CARRIER_NAME_1', 'FedEx', 'Enter name of Carrier 1 <br />Example: FedEx, UPS, Canada Post, etc...<br />(default: FedEx)', @tyid, '11', now(), now(), NULL, NULL),
('', 'Carrier 1 Tracking Link', 'CARRIER_LINK_1', 'http://www.fedex.com/Tracking?action=track&tracknumbers=', 'Enter the tracking link of Carrier 1<br /> Example: http://www.fedex.com/Tracking?action=track&tracknumbers=', @tyid, '12', now(), now(), NULL, NULL),
('', 'Carrier 1 Status', 'CARRIER_STATUS_1', 'True', 'Enable Tracking for Carrier 1<br />Set to false if you do NOT want Carrier 1 to be display on Admin and Customer page.', @tyid, '13', now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),"),
('', 'Carrier 2 Name', 'CARRIER_NAME_2', 'UPS', 'Enter name of Carrier 2 <br />Example: FedEx, UPS, Canada Post, etc...<br />(default: UPS)', @tyid, '21', now(), now(), NULL, NULL),
('', 'Carrier 2 Tracking Link', 'CARRIER_LINK_2', 'http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displayed=1&TypeOfInquiryNumber=T&loc=en_US&InquiryNumber1=', 'Enter the tracking link of Carrier 1<br /> Example: http://www.fedex.com/Tracking?action=track&tracknumbers=', @tyid, '22', now(), now(), NULL, NULL),
('', 'Carrier 2 Status', 'CARRIER_STATUS_2', 'True', 'Enable Tracking for Carrier 1<br />Set to false if you do NOT want Carrier 2 to be display on Admin and Customer page.', @tyid, '23', now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),"),
('', 'Carrier 3 Name', 'CARRIER_NAME_3', 'USPS', 'Enter name of Carrier 3 <br />Example: FedEx, UPS, Canada Post, etc...<br />(default: USPS)', @tyid, '31', now(), now(), NULL, NULL),
('', 'Carrier 3 Tracking Link', 'CARRIER_LINK_3', 'http://trkcnfrm1.smi.usps.com/PTSInternetWeb/InterLabelInquiry.do?origTrackNum=', 'Enter the tracking link of Carrier 1<br /> Example: http://www.fedex.com/Tracking?action=track&tracknumbers=', @tyid, '32', now(), now(), NULL, NULL),
('', 'Carrier 3 Status', 'CARRIER_STATUS_3', 'True', 'Enable Tracking for Carrier 1<br />Set to false if you do NOT want Carrier 3 to be display on Admin and Customer page.', @tyid, '33', now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),"),
('', 'Carrier 4 Name', 'CARRIER_NAME_4', 'DHL', 'Enter name of Carrier 4 <br />Example: FedEx, UPS, Canada Post, etc...<br />(default: DHL)', @tyid, '41', now(), now(), NULL, NULL),
('', 'Carrier 4 Tracking Link', 'CARRIER_LINK_4', 'http://track.dhl-usa.com/TrackByNbr.asp?ShipmentNumber=', 'Enter the tracking link of Carrier 1<br /> Example: http://www.fedex.com/Tracking?action=track&tracknumbers=', @tyid, '42', now(), now(), NULL, NULL),
('', 'Carrier 4 Status', 'CARRIER_STATUS_4', 'True', 'Enable Tracking for Carrier 1<br />Set to false if you do NOT want Carrier 4 to be display on Admin and Customer page.', @tyid, '43', now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),"),
('', 'Carrier 5 Name', 'CARRIER_NAME_5', '', 'Enter name of Carrier 5 <br />Example: FedEx, UPS, Canada Post, etc...<br />(default: blank)', @tyid, '51', now(), now(), NULL, NULL),
('', 'Carrier 5 Tracking Link', 'CARRIER_LINK_5', '', 'Enter the tracking link of Carrier 1<br /> Example: http://www.fedex.com/Tracking?action=track&tracknumbers=', @tyid, '52', now(), now(), NULL, NULL),
('', 'Carrier 5 Status', 'CARRIER_STATUS_5', 'False', 'Enable Tracking for Carrier 1<br />Set to false if you do NOT want Carrier 5 to be display on Admin and Customer page.', @tyid, '53', now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),"),
('', 'Max display for Track Order Sidebox', 'MAX_DISPLAY_PRODUCTS_IN_TRACK_ORDERS_BOX', '3', 'Max number of Orders to display on Track Order sidebox ', @tyid, '60', now(), now(), NULL, NULL),
('', 'Is Super Orders Module Installed?', 'SUPER_ORDERS_MOD_STATUS', 'False', 'If installed, a link to the Super Orders module will be added to the Tracking Page.', @tyid, '70', now(), now(), NULL, "zen_cfg_select_option(array('True', 'False'),");

ALTER TABLE orders_status_history
ADD track_id1 TEXT,
ADD track_id2 TEXT,
ADD track_id3 TEXT,
ADD track_id4 TEXT,
ADD track_id5 TEXT;

I allso get a ERROR on the statement ALTER TABLE
What is wrong?

I'm running a Mysql version: Mysql version 5.0.45 - community-nt VIA TCP/IP and Mysql client version: 5.1.11

Thanks for any help.
Best regards from Norway
T. Sandberg

Sorry about my poor english

Please: E-mail me on my private e-post: [email protected]

Thanks in advance