Thread wurde in "Allgemeine Konfiguration" neu gepostet. Ich habe das originale Gambio CSV template heruntergeladen und wie im Handbuch beschrieben, meine Artikel eingefuegt. Dies funktioniert nach wie vor nicht und ich bin mit meinem Latein am Ende. Langsam wird es wirklich laecherlich wenn man bedenkt das ich nun schon seit Mitte Dezember an dieser Webseite herum mache und es noch immer nicht voran geht.. Habe auch langsam den Eindruck das etwas mit meinem Installierten Gambio Shop nicht stimmt. Es sind alle Kategorien fuer diese CSV Datei mit Unterordner im Shop angelegt. Bin fuer jeden Tip dankbar und siehe SQL und Pics below.. Error: Den Anhang 21207 betrachten Log: 2018-02-05 12:57:20 (8eeca860b2caa10e7eb33e968b500b32) SQL ERROR(1054): "Unknown column 'M7.JC1042_2507' in 'where clause'" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:23 (Details) #7 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:23 #6 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_query.inc.php:78 #5 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVSource.php:2416 #4 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVSource.php:2144 #3 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVControl.inc.php:642 #2 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVAjaxHandler.inc.php:330 #1 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/core/RequestRouter.inc.php:93 #0 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/request_port.php:70 Request: POST /request_port.php?module=CSV&action=import (Details) Post: (Details) Get: (Details) Information: Query: SELECT p.products_id AS products_exists, pic.products_id AS products_item_codes_exists, pgc.products_google_categories_id AS products_google_categories_exists, s.specials_id AS specials_exists, pqu.products_id AS products_quantity_unit_exists FROM products p LEFT JOIN products_item_codes AS pic ON (p.products_id = pic.products_id) LEFT JOIN products_google_categories AS pgc ON (p.products_id = pgc.products_id) LEFT JOIN specials AS s ON (p.products_id = s.products_id) LEFT JOIN products_quantity_unit AS pqu ON (p.products_id = pqu.products_id) WHERE p.products_id = M7.JC1042_2507 LIMIT 1 2018-02-05 12:57:20 (8eeca860b2caa10e7eb33e968b500b32) USER ERROR(256): "SQL Error" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:24 (Details) 2018-02-05 13:05:35 (8eeca860b2caa10e7eb33e968b500b32) SQL ERROR(1054): "Unknown column 'M7.JC1042_2507' in 'where clause'" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:23 (Details) #7 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:23 #6 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_query.inc.php:78 #5 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVSource.php:2416 #4 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVSource.php:2144 #3 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVControl.inc.php:642 #2 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVAjaxHandler.inc.php:330 #1 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/core/RequestRouter.inc.php:93 #0 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/request_port.php:70 Request: POST /request_port.php?module=CSV&action=import (Details) Post: (Details) Get: (Details) Information: Query: SELECT p.products_id AS products_exists, pic.products_id AS products_item_codes_exists, pgc.products_google_categories_id AS products_google_categories_exists, s.specials_id AS specials_exists, pqu.products_id AS products_quantity_unit_exists FROM products p LEFT JOIN products_item_codes AS pic ON (p.products_id = pic.products_id) LEFT JOIN products_google_categories AS pgc ON (p.products_id = pgc.products_id) LEFT JOIN specials AS s ON (p.products_id = s.products_id) LEFT JOIN products_quantity_unit AS pqu ON (p.products_id = pqu.products_id) WHERE p.products_id = M7.JC1042_2507 LIMIT 1 2018-02-05 13:05:35 (8eeca860b2caa10e7eb33e968b500b32) USER ERROR(256): "SQL Error" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:24 (Details) 2018-02-05 13:34:14 (8eeca860b2caa10e7eb33e968b500b32) SQL ERROR(1054): "Unknown column 'M7.JC1042_2507' in 'where clause'" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:23 (Details) #7 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:23 #6 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_query.inc.php:78 #5 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVSource.php:2416 #4 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVSource.php:2144 #3 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVControl.inc.php:642 #2 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVAjaxHandler.inc.php:330 #1 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/core/RequestRouter.inc.php:93 #0 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/request_port.php:70 Request: POST /request_port.php?module=CSV&action=import (Details) Post: (Details) Get: (Details) Information: Query: SELECT p.products_id AS products_exists, pic.products_id AS products_item_codes_exists, pgc.products_google_categories_id AS products_google_categories_exists, s.specials_id AS specials_exists, pqu.products_id AS products_quantity_unit_exists FROM products p LEFT JOIN products_item_codes AS pic ON (p.products_id = pic.products_id) LEFT JOIN products_google_categories AS pgc ON (p.products_id = pgc.products_id) LEFT JOIN specials AS s ON (p.products_id = s.products_id) LEFT JOIN products_quantity_unit AS pqu ON (p.products_id = pqu.products_id) WHERE p.products_id = M7.JC1042_2507 LIMIT 1 2018-02-05 13:34:14 (8eeca860b2caa10e7eb33e968b500b32) USER ERROR(256): "SQL Error" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:24 (Details) 2018-02-05 13:50:38 (654bd21287a3e298b975977a6cfdbe93) SQL ERROR(1054): "Unknown column 'M7.JC1042_2507' in 'where clause'" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:23 (Details) #7 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:23 #6 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_query.inc.php:78 #5 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVSource.php:2416 #4 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVSource.php:2144 #3 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVControl.inc.php:642 #2 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVAjaxHandler.inc.php:330 #1 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/core/RequestRouter.inc.php:93 #0 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/request_port.php:70 Request: POST /request_port.php?module=CSV&action=import (Details) Post: (Details) Get: (Details) Information: Query: SELECT p.products_id AS products_exists, pic.products_id AS products_item_codes_exists, pgc.products_google_categories_id AS products_google_categories_exists, s.specials_id AS specials_exists, pqu.products_id AS products_quantity_unit_exists FROM products p LEFT JOIN products_item_codes AS pic ON (p.products_id = pic.products_id) LEFT JOIN products_google_categories AS pgc ON (p.products_id = pgc.products_id) LEFT JOIN specials AS s ON (p.products_id = s.products_id) LEFT JOIN products_quantity_unit AS pqu ON (p.products_id = pqu.products_id) WHERE p.products_id = M7.JC1042_2507 LIMIT 1 2018-02-05 13:50:38 (654bd21287a3e298b975977a6cfdbe93) USER ERROR(256): "SQL Error" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:24 (Details) #7 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:24 (Details) #6 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_query.inc.php:78 (Details) #5 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVSource.php:2416 (Details) #4 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVSource.php:2144 (Details) #3 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVControl.inc.php:642 (Details) #2 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/classes/csv/CSVAjaxHandler.inc.php:330 (Details) #1 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/system/core/RequestRouter.inc.php:93 (Details) #0 File: /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/request_port.php:70 (Details) Request: POST /request_port.php?module=CSV&action=import (Details) Session: (Details) - tpl: Honeygrid - MOBILE_ACTIVE: false - language: german - languages_id: 2 - language_charset: utf-8 - language_code: de - currency: EUR - customers_status: [...] - cart: [...] - wishList: [...] - customer_id: 1 - payment: ### Session entry not present ### - shipping: ### Session entry not present ### - cartID: ### Session entry not present ### - sendto: ### Session entry not present ### - billto: ### Session entry not present ### Post: (Details) - select_import_file: landmaschinen_original_gambio_excel_template3.csv - import_field_separator: | - import_field_quotes: \" - progress: 0 Get: (Details) - module: CSV - action: import Wie gesagt bin dankbar fuer jeden Tip. Andy
Ich habe das originale Gambio CSV template heruntergeladen und wie im Handbuch beschrieben, meine Artikel eingefuegt. Dies funktioniert nach wie vor nicht und ich bin mit meinem Latein am Ende. Langsam wird es wirklich laecherlich wenn man bedenkt das ich nun schon seit Mitte Dezember an dieser Webseite herum mache und es noch immer nicht voran geht.. Habe auch langsam den Eindruck das etwas mit meinem Installierten Gambio Shop nicht stimmt. Es sind alle Kategorien fuer diese CSV Datei mit Unterordner im Shop angelegt. Bin fuer jeden Tip dankbar und siehe SQL und Pics below.. Error: Code: 2018-02-05 12:57:20 (8eeca860b2caa10e7eb33e968b500b32) SQL ERROR(1054): "Unknown column 'M7.JC1042_2507' in 'where clause'" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:23 (Details) 2018-02-05 12:57:20 (8eeca860b2caa10e7eb33e968b500b32) USER ERROR(256): "SQL Error" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:24 (Details) 2018-02-05 13:05:35 (8eeca860b2caa10e7eb33e968b500b32) SQL ERROR(1054): "Unknown column 'M7.JC1042_2507' in 'where clause'" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:23 (Details) 2018-02-05 13:05:35 (8eeca860b2caa10e7eb33e968b500b32) USER ERROR(256): "SQL Error" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:24 (Details) 2018-02-05 13:34:14 (8eeca860b2caa10e7eb33e968b500b32) SQL ERROR(1054): "Unknown column 'M7.JC1042_2507' in 'where clause'" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:23 (Details) 2018-02-05 13:34:14 (8eeca860b2caa10e7eb33e968b500b32) USER ERROR(256): "SQL Error" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:24 (Details) 2018-02-05 13:50:38 (654bd21287a3e298b975977a6cfdbe93) SQL ERROR(1054): "Unknown column 'M7.JC1042_2507' in 'where clause'" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:23 (Details) 2018-02-05 13:50:38 (654bd21287a3e298b975977a6cfdbe93) USER ERROR(256): "SQL Error" in /var/www/vhosts/acltuning.www85.hostkraft.de/httpdocs/GX3/inc/xtc_db_error.inc.php:24 (Details) Wie gesagt bin dankbar fuer jeden Tip. Andy
Das M7.JC1042_2507 LIMIT 1 ist vielleicht eine Artikelnummer, aber kein products_id die p_ID wird von Gambio vergeben, muss einzigartig sein, besteht nur aus Zahlen und sorgt für die korrekte Verbindung der einzelnen Datenbank-Tabellen.
Danke dir Barbara hat funktioniert. Nun noch die Bilder ueber FileZilla und alles sollte ok sein fuer die ersten paar Artikel..