14.09.2006: xtCommerce: Update von 3.0.2 auf 3.0.3

Update xtCommerce von 3.0.2 auf 3.0.3

Sie benötigen für dieses Update folgendes:

• Installierte xtCommerce Version 3.0.2
• Updatepaket xtCommerce 3.0.3

Update durchführen:

1. Sicherung des bestehenden Installation (Datenbank, Files am Server)
2. Entpacken des Updatepakets von Version 3.0.3 (falls noch nicht geschehen)
3. Alle Dateien im Ordner xtCommerce_3.0.3_update über die bestehenden Files der alten Installation kopieren.
4. Datenbank mit folgenden Querystring updaten:

   ALTER TABLE admin_access add popup_image int(1) NOT NULL default '0' AFTER orders_edit;
   ALTER TABLE admin_access add csv_backend int(1) NOT NULL default '0' AFTER popup_image;
   ALTER TABLE admin_access add products_vpe int(1) NOT NULL default '0' AFTER csv_backend;
   UPDATE admin_access SET popup_image = '1', csv_backend ='1', products_vpe = '1' WHERE customers_id = 1;
   UPDATE admin_access SET popup_image = '2', csv_backend ='2', products_vpe = '2' WHERE customers_id ='groups';
   ALTER TABLE orders add afterbuy_success INT(1) DEFAULT'0' NOT NULL AFTER language;
   ALTER TABLE orders add afterbuy_id INT(32) DEFAULT '0' NOT NULL AFTER afterbuy_success;
   
   ALTER TABLE products add products_vpe int(11) NOT NULL AFTER products_fsk18;
   ALTER TABLE products add products_vpe_status int(1) NOT NULL DEFAULT '0' AFTER products_vpe;
   ALTER TABLE products add products_vpe_value decimal(15,4) NOT NULL AFTER products_vpe_status;
   
   DROP TABLE IF EXISTS products_vpe;
   CREATE TABLE products_vpe (
   products_vpe_id int(11) NOT NULL default '0',
   language_id int(11) NOT NULL default '0',
   products_vpe_name varchar(32) NOT NULL default ''
   );
   
   DELETE FROM configuration WHERE configuration_key='ALLOW_GUEST_TO_TELL_A_FRIEND';
   
   
   INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'DEFAULT_PRODUCTS_VPE_ID', '', 6, 0, NULL, '', NULL, NULL);
   INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'CSV_TEXTSIGN', '"', '20', '1', NULL , '0000-00-00 00:00:00', NULL , NULL);
   INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'CSV_SEPERATOR', ';', '20', '2', NULL , '0000-00-00 00:00:00', NULL , NULL);
   INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'COMPRESS_EXPORT', 'false', '20', '3', NULL , '0000-00-00 00:00:00', NULL , 'xtc_cfg_select_option(array(''true'', ''false''),');
   
   
   INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'AFTERBUY_PARTNERID', '', '21', '2', NULL , '0000-00-00 00:00:00', NULL , NULL);
   INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'AFTERBUY_PARTNERPASS', '', '21', '3', NULL , '0000-00-00 00:00:00', NULL , NULL);
   INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'AFTERBUY_USERID', '', '21', '4', NULL , '0000-00-00 00:00:00', NULL , NULL);
   INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'AFTERBUY_ORDERSTATUS', '0', '21', '5', NULL , '0000-00-00 00:00:00', 'xtc_get_order_status_name' , 'xtc_cfg_pull_down_order_statuses(');
   INSERT INTO configuration (configuration_id, configuration_key, configuration_value, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'AFTERBUY_ACTIVATED', 'false', '21', '6', NULL , '0000-00-00 00:00:00', NULL , 'xtc_cfg_select_option(array(''true'', ''false''),');
   
   INSERT INTO configuration_group VALUES ('20', 'Import/Export', 'Import/Export', '20', '1');
   INSERT INTO configuration_group VALUES ('21', 'Afterbuy', 'Afterbuy.de', '21', '1');

5. Im Ordner templates_c den Cache löschen (alle Dateien bis auf die.htacces und die index.html).
6. Im Adminbereich müssen Sie nun eventuell das Template umstellen.
7. Jetzt nur noch den aktualisierten Shop testen - fertig.

 

Wichtig: Das Update erfolgt auf eigene Gefahr!! Es kann sein, dass zusätzliche Module in der Version 3.x nicht mehr funktionieren.

---