Skat Posted June 2, 2005 Report Share Posted June 2, 2005 hallo zusammen, wie bekomme ich die alten Shop Artikel von 2.0 version auf die 3.0 r?berkopiert mit fotos usw..... dank? Skat Link to comment Share on other sites More sharing options...
polkhigh33 Posted June 2, 2005 Report Share Posted June 2, 2005 es gibt entsprechende updatescripte v2 auf v3.0.2. und dann auf 3.0.3, erh?ltlich im sponsorenbereich. Link to comment Share on other sites More sharing options...
Skat Posted June 2, 2005 Author Report Share Posted June 2, 2005 seh ich nix nur v 3.0 bis zu v 3.3 aber nix mit update v 2 to 3.0 Link to comment Share on other sites More sharing options...
chpohl Posted June 2, 2005 Report Share Posted June 2, 2005 erh?ltlich im sponsorenbereich ... Link to comment Share on other sites More sharing options...
Skat Posted June 2, 2005 Author Report Share Posted June 2, 2005 ich binn drin aber ich seh nix mit QUOTE ??? nur downloads zu v 3.0 Link to comment Share on other sites More sharing options...
Skat Posted June 2, 2005 Author Report Share Posted June 2, 2005 Hilfe :bounce: Link to comment Share on other sites More sharing options...
polkhigh33 Posted June 2, 2005 Report Share Posted June 2, 2005 sorry, aber da du kein sponsor bist ( erkennbar an dem tollen gr?nen zeichen bei mir und anderen) hast du keinen zugang dahin. Link to comment Share on other sites More sharing options...
Skat Posted June 2, 2005 Author Report Share Posted June 2, 2005 mein chef ist sponsor ich nicht ich hab mich nur hir reg sonst h?tte ich ja nicht v.3.0 odeR? also wo ist das zum updaten von 2.0 - 3.0 oder wie kopiere ich die alten daten auf 3.0 Link to comment Share on other sites More sharing options...
s04-freak Posted June 2, 2005 Report Share Posted June 2, 2005 ?hm.. Dann sollte dein Chef das hier mit diesem Chef regeln, dass du den Zugang bekommst Gr??e Link to comment Share on other sites More sharing options...
joschneider Posted June 2, 2005 Report Share Posted June 2, 2005 so ich Skat = joschneider also binn sponsor aber im sponsor bereich sehe ich nur v 3.0 bis zu v 3.3 aber nix mit update v 2 to 3.0 und jetzt? Link to comment Share on other sites More sharing options...
chpohl Posted June 2, 2005 Report Share Posted June 2, 2005 guckst du hier: http://www.xt-commerce.com/modules/wfsecti...dossier-66.html Link to comment Share on other sites More sharing options...
joschneider Posted June 3, 2005 Report Share Posted June 3, 2005 wenn ich das Update k?nnen da die Artikel verloren gehn ? also von 2.0 auf 2.0.2 per Ftp ?berschreiben Fertig ja? dann das update von 2.0. auf 3.0.3 auch dr?ber kopieren ? dann habe ich alles upgedatet und Artikel und bilder sind noch da? Link to comment Share on other sites More sharing options...
polkhigh33 Posted June 3, 2005 Report Share Posted June 3, 2005 du hast die datenbankupdates komplett vergessen. wenn du es richtig machst, sind hinterher auch noch alle artikel und daten da. vor dem update -> SICHERUNG ! und dann so, wie es in den anleitungen steht. im zweifel: -> dienstleister beauftragen. gruss thomas Link to comment Share on other sites More sharing options...
joschneider Posted June 3, 2005 Report Share Posted June 3, 2005 so update habe ich gemacht und alles so wie in der anleitung so wenn ich jetzt ins Admin menue reingehe ist schon mal alles bunter heist ja update hat geklappt aber wenn ich artikel ?ndern will oder anschauen siehe selbst : http://www.design-magazin.com/shop/index.php auf K?chenutensilien kommt das: 1054 - Unknown column 'p.products_ean' in 'field list' select p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, pd.products_short_description, pd.products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_discount_allowed, p.products_tax_class_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '5' ORDER BY pd.products_name ASC limit 0, 20 [XT SQL Error] Link to comment Share on other sites More sharing options...
joschneider Posted June 3, 2005 Report Share Posted June 3, 2005 jetzt hab ich die configs ersetzt und alles ist down :wall: jetzt kommt : Warning: main(D:/xampp/htdocs/XTC/xtcommerce/includes/filenames.php): failed to open stream: No such file or directory in /homepages/2/d102014771/htdocs/shop/includes/application_top.php on line 55 Fatal error: main(): Failed opening required 'D:/xampp/htdocs/XTC/xtcommerce/includes/filenames.php' (include_path='.:/usr/local/lib/php') in /homepages/2/d102014771/htdocs/shop/includes/application_top.php on line 55 Link to comment Share on other sites More sharing options...
chpohl Posted June 3, 2005 Report Share Posted June 3, 2005 :grml: dein Link f?hrt zu einer ?ffentlichen Seite .... die Fehlermeldung aus der configure aber auf eine lokale Seite .... D:/xampp/htdocs/XTC/xtcommerce Link to comment Share on other sites More sharing options...
polkhigh33 Posted June 3, 2005 Report Share Posted June 3, 2005 warum hast du welche configs ersetzt ? die fehlermeldung 1054 - Unknown column 'p.products_ean' in 'field list' kommt wahrscheinlich von einem vergessenen db-update. Link to comment Share on other sites More sharing options...
joschneider Posted June 3, 2005 Report Share Posted June 3, 2005 puh habs wieder hinbekommen aber habe immer noch die fehler meldung beim artikel ankucken, und im admin breich kann ich die einzelen produkte nicht bearbeiten im Admin bereich steh bei mir oben dr?ber : Warning: main(includes/classes/IMAGE_MANIPULATOR): failed to open stream: No such file or directory in /homepages/2/d102014771/htdocs/shop/admin/categories.php on line 27 Warning: main(): Failed opening 'includes/classes/IMAGE_MANIPULATOR' for inclusion (include_path='.:/usr/local/lib/php') in /homepages/2/d102014771/htdocs/shop/admin/categories.php on line 27 Link to comment Share on other sites More sharing options...
joschneider Posted June 3, 2005 Report Share Posted June 3, 2005 ich habe das laut anleitung in die datenbank eingef?gt: ALTER TABLE admin_access add orders_edit int(1) not null DEFAULT '0' AFTER blacklist;ALTER TABLE customers add customers_vat_id varchar (20) AFTER customers_cid;ALTER TABLE customers add customers_vat_id_status int(2) DEFAULT '0' not null AFTERcustomers_vat_id;ALTER TABLE customers add password_request_key varchar(32) not null AFTER account_type;ALTER TABLE orders add customers_vat_id varchar(20) AFTER customers_cid;ALTER TABLE products add products_ean varchar(128) AFTER products_id;ALTER TABLE specials add specials_quantity int(4) not null AFTER products_id;ALTER TABLE content_manager add group_ids text AFTER parent_id;ALTER TABLE content_manager add sort_order int(4) AFTER content_text;ALTER TABLE products_content add group_ids text AFTER products_id;CREATE TABLE newsletter_recipients (mail_id int(11) NOT NULL auto_increment,customers_email_address varchar(96) NOT NULL default '',customers_id int(11) NOT NULL default '0',customers_status int(5) NOT NULL default '0',customers_firstname varchar(32) NOT NULL default '',customers_lastname varchar(32) NOT NULL default '',mail_status int(1) NOT NULL default '0',mail_key varchar(32) NOT NULL default '',date_added datetime NOT NULL default '0000-00-00 00:00:00',PRIMARY KEY (mail_id));DROP TABLE IF EXISTS orders_recalculate;CREATE TABLE orders_recalculate (orders_recalculate_id int(11) NOT NULL auto_increment,orders_id int(11) NOT NULL default '0',n_price decimal(15,4) NOT NULL default '0.0000',b_price decimal(15,4) NOT NULL default '0.0000',tax decimal(15,4) NOT NULL default '0.0000',tax_rate decimal(7,4) NOT NULL default '0.0000',class varchar(32) NOT NULL default '',PRIMARY KEY (orders_recalculate_id));DROP TABLE IF EXISTS products_images;CREATE TABLE products_images (image_id INT NOT NULL auto_increment,products_id INT NOT NULL ,image_nr SMALLINT NOT NULL ,image_name VARCHAR( 254 ) NOT NULL ,PRIMARY KEY ( image_id ));Drop TABLE if exists payment_qenta;CREATE TABLE payment_qenta (q_TRID varchar(255) NOT NULL default '',q_DATE datetime NOT NULL default '0000-00-00 00:00:00',q_QTID bigint(18) unsigned NOT NULL default '0',q_ORDERDESC varchar(255) NOT NULL default '',q_STATUS tinyint(1) NOT NULL default '0',q_ORDERID int(11) unsigned NOT NULL default '0',PRIMARY KEY (q_TRID));INSERT INTO `content_manager` VALUES (99998, 0, 0, '', 1, 'Sitemap','', '', 0, 0, 'sitemap.php', 1, 8, 0);INSERT INTO `content_manager` VALUES (99999, 0, 0, '', 2, 'Sitemap','', '', 0, 0, 'sitemap.php', 1, 8, 0);INSERT INTO configuration (configuration_id, configuration_key, configuration_value,configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'MAX_DISPLAY_NEW_PRODUCTS_DAYS', '30', 3, 22, '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 ('', 'MO_PICS', '0', '4', '3', '','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 ('', 'IMAGE_MANIPULATOR', 'image_manipulator_GD2.php', '4','3', '', '0000-00-00 00:00:00', NULL ,'xtc_cfg_select_option(array(\'image_manipulator_GD2.php\',\'image_manipulator_GD1.php\'),');INSERT INTO configuration (configuration_id, configuration_key, configuration_value,configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'DB_CACHE', 'false', 11, 5, NULL, '', 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 ('', 'DB_CACHE_EXPIRE', '3600', 11, 6, 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 ('', 'DOWNLOAD_UNALLOWED_PAYMENT','banktransfer,cod,invoice,moneyorder', 13, 5, 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 ('', 'DOWNLOAD_MIN_ORDERS_STATUS', '1', 13, 5, 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 ('', 'ACCOUNT_COMPANY_VAT_CHECK', 'true', 18, 4, '','', 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 ('', 'STORE_OWNER_VAT_ID', '', 18, 3, '', '',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 ('', 'DEFAULT_CUSTOMERS_VAT_STATUS_ID', '1', 18, 23, '','', 'xtc_get_customers_status_name','xtc_cfg_pull_down_customers_status_list(');INSERT INTO configuration (configuration_id, configuration_key, configuration_value,configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'ACCOUNT_COMPANY_VAT_LIVE_CHECK', 'true', 18, 4, '','', 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 ('', 'ACCOUNT_COMPANY_VAT_GROUP', 'true', 18, 4, '','', 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 ('', 'ACCOUNT_VAT_BLOCK_ERROR', 'true', 18, 4, '','', 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 ('', 'GOOGLE_CONVERSION_ID', '', '19', '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 ('', 'GOOGLE_LANG', 'de', '19', '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 ('', 'GOOGLE_CONVERSION', 'false', '19', '0', NULL, '0000-00-00 00:00:00', NULL , 'xtc_cfg_select_option(array(\'true\',\'false\'),');INSERT INTO configuration_group VALUES ('18', 'Vat ID', 'Vat ID','18', '1');INSERT INTO configuration_group VALUES ('19', 'Google Conversion', 'GoogleConversion-Tracking', '19', '1');DELETE FROM configuration WHERE configuration_key = 'DOWNLOAD_MAX_DAYS';DELETE FROM configuration WHERE configuration_key = 'DOWNLOAD_MAX_COUNT';UPDATE zones_to_geo_zones SET geo_zone_id='5' WHERE zone_country_id='56';UPDATE zones_to_geo_zones SET geo_zone_id='5' WHERE zone_country_id='189';UPDATE zones_to_geo_zones SET geo_zone_id='5' WHERE zone_country_id='170';UPDATE zones_to_geo_zones SET geo_zone_id='5' WHERE zone_country_id='97';INSERT INTO `configuration` ( `configuration_id` , `configuration_key` , `configuration_value` ,`configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` ,`set_function` )VALUES ('', 'DEFAULT_CUSTOMERS_VAT_STATUS_ID_LOCAL', '3', '18','24', NULL , '0000-00-00 00:00:00', 'xtc_get_customers_status_name','xtc_cfg_pull_down_customers_status_list(');DELETE FROM configuration WHERE configuration_key='SESSION_BLOCK_SPIDERS'; dann kommt Fehlermeldung: Server: db321.1und1.de Datenbank: db124685744 Fehler SQL-Befehl: ALTER TABLE admin_access ADD orders_edit int( 1 ) NOT NULL DEFAULT '0' AFTER blacklist MySQL meldet: #1060 - Duplicate column name 'orders_edit' [ Zur?ck ] Link to comment Share on other sites More sharing options...
polkhigh33 Posted June 3, 2005 Report Share Posted June 3, 2005 admin - konfiguration - bild optionen - image_manipulator_GD2.php w?hlen. Link to comment Share on other sites More sharing options...
joschneider Posted June 3, 2005 Report Share Posted June 3, 2005 find ich nicht ich update mal auf 3.0.3 mal sehn Link to comment Share on other sites More sharing options...
joschneider Posted June 3, 2005 Report Share Posted June 3, 2005 so hab upgedatet aber kommt fehler: http://www.design-magazin.com/shop/index.php Warning: main(/homepages/2/d102014771/htdocs/shop/includes/classes/Smarty_2.6.6/core/core.load_plugins.php): failed to open stream: No such file or directory in /homepages/2/d102014771/htdocs/shop/templates_c/%%A5^A5A^A5A7611E%%box_categories.html.php on line 3 Fatal error: main(): Failed opening required '/homepages/2/d102014771/htdocs/shop/includes/classes/Smarty_2.6.6/core/core.load_plugins.php' (include_path='.:/usr/local/lib/php') in /homepages/2/d102014771/htdocs/shop/templates_c/%%A5^A5A^A5A7611E%%box_categories.html.php on line 3 ich denke liegt am template wie kann ich es ?ber ftp einstellen das er standart layout nimmt Link to comment Share on other sites More sharing options...
polkhigh33 Posted June 3, 2005 Report Share Posted June 3, 2005 templates_c leeren auf deinem server, das sind noch die alten cachedatein die da rumspuken. Link to comment Share on other sites More sharing options...
joschneider Posted June 3, 2005 Report Share Posted June 3, 2005 so habe immer noch den Fehler: 1054 - Unknown column 'p.products_ean' in 'field list' select p.products_fsk18, p.products_shippingtime, p.products_model, p.products_ean, pd.products_name, m.manufacturers_name, p.products_quantity, p.products_image, p.products_weight, pd.products_short_description, pd.products_description, p.products_id, p.manufacturers_id, p.products_price, p.products_discount_allowed, p.products_tax_class_id from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '2' and p2c.categories_id = '5' ORDER BY pd.products_name ASC [XT SQL Error] Link to comment Share on other sites More sharing options...
chpohl Posted June 3, 2005 Report Share Posted June 3, 2005 Versuch mal, diesen Befehl aus dem Update nochmal in der Datenbank einzulesen: ALTER TABLE products add products_ean varchar(128) AFTER products_id; mehr als sagen, dass es das schon gibt, kann nicht passieren. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.