PDA

Shop Support News Archive - Shopbetreiber News -> Forum : xt eCommerce Templates Module SEO Support: GPL Shop: Update Von Xtc 3.01 Auf 3.04sp1 !


Baby
16.03.2006, 21:18
Hallo !

Kann ich ein update von 3.01 auf 3.04sp1 machen ???
Wenn ja wie geht das ??? Eine Anleitung wäre gut !!!

MFG
Baby

bluemoon
16.03.2006, 23:04
es gibt ne Möglichkeit nach dem Motto Dirty Mod ...

den nun folgenden Tip habe ich selbst schon bei Updates von 3.02 und 3.03 auf die V 3.04SP1 angewendet - ein Update von 3.01 habe ich noch nicht gemacht ;-) , sollte aber auch funktionieren

sichere alle Daten , Shop und Datenbank

Installiere die Version 3.04SP1 übertrage Deine Bilder etc.

Leere Deine Datenbank und spiele die alte Datenbank ein ;
jetzt mache das Datenbank Update für 3.03 -> 3.04SP1 und hoffe dass alles läuft


Hoffe ich hab nichts vergessen



ergänzend schau mal hier : http://www.ecombase.de/forum/index.php?showtopic=67

Oliver F.
17.03.2006, 08:34
das funktioniert so nicht, du must vorher noch folgendes in der db ausführen:

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_FR IEND';


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');