Hallo zusammen
Bei uns bricht der Bilderimport mit der Meldung: "Empty foreign key (Artikel-Bild ohne Besitzer)" ab. Außerdem haben wir zwei Fehlermeldungen:
[QUOTE]Exception: An exception occurred while executing 'SELECT DISTINCT id0 FROM (SELECT s0_.id AS id0, s0_.articleID AS articleID1, s0_.unitID AS unitID2, s0_.ordernumber AS ordernumber3, s0_.suppliernumber AS suppliernumber4, s0_.kind AS kind5, s0_.additionaltext AS additionaltext6, s0_.active AS active7, s0_.instock AS instock8, s0_.stockmin AS stockmin9, s0_.weight AS weight10, s0_.width AS width11, s0_.length AS length12, s0_.height AS height13, s0_.ean AS ean14, s0_.position AS position15, s0_.minpurchase AS minpurchase16, s0_.purchasesteps AS purchasesteps17, s0_.maxpurchase AS maxpurchase18, s0_.purchaseunit AS purchaseunit19, s0_.referenceunit AS referenceunit20, s0_.packunit AS packunit21, s0_.shippingfree AS shippingfree22, s0_.releasedate AS releasedate23, s0_.shippingtime AS shippingtime24, s1_.id AS id25, s1_.main_detail_id AS main_detail_id26, s1_.supplierID AS supplierID27, s1_.taxID AS taxID28, s1_.pricegroupID AS pricegroupID29, s1_.filtergroupID AS filtergroupID30, s1_.configurator_set_id AS configurator_set_id31, s1_.name AS name32, s1_.description AS description33, s1_.description_long AS description_long34, s1_.datum AS datum35, s1_.active AS active36, s1_.pseudosales AS pseudosales37, s1_.topseller AS topseller38, s1_.keywords AS keywords39, s1_.metaTitle AS metaTitle40, s1_.changetime AS changetime41, s1_.pricegroupActive AS pricegroupActive42, s1_.laststock AS laststock43, s1_.crossbundlelook AS crossbundlelook44, s1_.notification AS notification45, s1_.template AS template46, s1_.mode AS mode47, s1_.available_from AS available_from48, s1_.available_to AS available_to49, s2_.id AS id50, s2_.articleID AS articleID51, s2_.articledetailsID AS articledetailsID52, s2_.pricegroup AS pricegroup53, s2_.`from` AS from54, s2_.`to` AS to55, s2_.price AS price56,...
SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/var/tmp/mysql/#sql64b_d2e4e2_0.MYI'; try to repair it
Artikel-Empfangen-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der Wawi notwendig sind!
An exception occurred while executing 'SELECT DISTINCT id0 FROM (SELECT s0_.id AS id0, s0_.articleID AS articleID1, s0_.unitID AS unitID2, s0_.ordernumber AS ordernumber3, s0_.suppliernumber AS suppliernumber4, s0_.kind AS kind5, s0_.additionaltext AS additionaltext6, s0_.active AS active7, s0_.instock AS instock8, s0_.stockmin AS stockmin9, s0_.weight AS weight10, s0_.width AS width11, s0_.length AS length12, s0_.height AS height13, s0_.ean AS ean14, s0_.position AS position15, s0_.minpurchase AS minpurchase16, s0_.purchasesteps AS purchasesteps17, s0_.maxpurchase AS maxpurchase18, s0_.purchaseunit AS purchaseunit19, s0_.referenceunit AS referenceunit20, s0_.packunit AS packunit21, s0_.shippingfree AS shippingfree22, s0_.releasedate AS releasedate23, s0_.shippingtime AS shippingtime24, s1_.id AS id25, s1_.main_detail_id AS main_detail_id26, s1_.supplierID AS supplierID27, s1_.taxID AS taxID28, s1_.pricegroupID AS pricegroupID29, s1_.filtergroupID AS filtergroupID30, s1_.configurator_set_id AS configurator_set_id31, s1_.name AS name32, s1_.description AS description33, s1_.description_long AS description_long34,...
SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/var/tmp/mysql/#sql64b_d2e4e2_0.MYI'; try to repair it
Exception: An exception occurred while executing 'SELECT DISTINCT id0 FROM (SELECT s0_.id AS id0, s0_.articleID AS articleID1, s0_.unitID AS unitID2, s0_.ordernumber AS ordernumber3, s0_.suppliernumber AS suppliernumber4, s0_.kind AS kind5, s0_.additionaltext AS additionaltext6, s0_.active AS active7, s0_.instock AS instock8, s0_.stockmin AS stockmin9, s0_.weight AS weight10, s0_.width AS width11, s0_.length AS length12, s0_.height AS height13, s0_.ean AS ean14, s0_.position AS position15, s0_.minpurchase AS minpurchase16, s0_.purchasesteps AS purchasesteps17, s0_.maxpurchase AS maxpurchase18, s0_.purchaseunit AS purchaseunit19, s0_.referenceunit AS referenceunit20, s0_.packunit AS packunit21, s0_.shippingfree AS shippingfree22, s0_.releasedate AS releasedate23, s0_.shippingtime AS shippingtime24, s1_.id AS id25, s1_.main_detail_id AS main_detail_id26, s1_.supplierID AS supplierID27, s1_.taxID AS taxID28, ...
SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/var/tmp/mysql/#sql64b_d2e4e2_0.MYI'; try to repair it
Response: {"result":null,"error":{"code":0,"message":"An exception occurred while executing 'SELECT DISTINCT id0 FROM (SELECT s0_.id AS id0, s0_.articleID AS articleID1, s0_.unitID AS unitID2, s0_.ordernumber AS ordernumber3, s0_.suppliernumber AS suppliernumber4, s0_.kind AS kind5, s0_.additionaltext AS additionaltext6, s0_.active AS active7, s0_.instock AS instock8, s0_.stockmin AS stockmin9, s0_.weight AS weight10, s0_.width AS width11, s0_.length AS length12, s0_.height AS height13, s0_.ean AS ean14, s0_.position AS position15, s0_.minpurchase AS minpurchase16, s0_.purchasesteps AS purchasesteps17, s0_.maxpurchase AS maxpurchase18, s0_.purchaseunit AS purchaseunit19, s0_.referenceunit AS referenceunit20, s0_.packunit AS packunit21, s0_.shippingfree AS shippingfree22, s0_.releasedate AS releasedate23, s0_.shippingtime AS shippingtime24, s1_.id AS id25, s1_.main_detail_id AS main_detail_id26, s1_.supplierID AS supplierID27, s1_.taxID AS taxID28, s1_.pricegroupID AS pricegroupID29, s1_.filtergroupID AS filtergroupID30, s1_.configurator_set_id AS configurator_set_id31, s1_.name AS name32, s1_.description AS description33, s1_.description_long AS description_long34, ... s16_.id = s23_.groupID LEFT JOIN s_filter_options s17_ ON s17_.id = s23_.optionID LEFT JOIN s_filter_values s18_ ON s17_.id = s18_.optionID WHERE j19_.host_id IS NULL ORDER BY s0_.kind ASC) dctrn_result LIMIT 50 OFFSET 0':\n\nSQLSTATE[HY000]: General error: 126 Incorrect key file for table '\/var\/tmp\/mysql\/#sql64b_d2e4e2_0.MYI'; try to repair it","data":null},"jtlrpc":"2.0","id":"cd6b940ed0ea4078b78b6ff3c1d3573a"}
at jtlCore.ControllerClasses.Connector.Abgleich.Connector.fFhgSTfS2S(String , Object , Boolean , NetworkCredential )[/QUOTE]
Könnte es sein, dass das daran liegt, dass wir im Shopware Medienmanager Unterordner nach Herstellern erstellt haben und dort die Bilder liegen?
Kategorien, Aufträge, etc. wurden alle korrekt übertragen.
Danke Andy
Bei uns bricht der Bilderimport mit der Meldung: "Empty foreign key (Artikel-Bild ohne Besitzer)" ab. Außerdem haben wir zwei Fehlermeldungen:
[QUOTE]Exception: An exception occurred while executing 'SELECT DISTINCT id0 FROM (SELECT s0_.id AS id0, s0_.articleID AS articleID1, s0_.unitID AS unitID2, s0_.ordernumber AS ordernumber3, s0_.suppliernumber AS suppliernumber4, s0_.kind AS kind5, s0_.additionaltext AS additionaltext6, s0_.active AS active7, s0_.instock AS instock8, s0_.stockmin AS stockmin9, s0_.weight AS weight10, s0_.width AS width11, s0_.length AS length12, s0_.height AS height13, s0_.ean AS ean14, s0_.position AS position15, s0_.minpurchase AS minpurchase16, s0_.purchasesteps AS purchasesteps17, s0_.maxpurchase AS maxpurchase18, s0_.purchaseunit AS purchaseunit19, s0_.referenceunit AS referenceunit20, s0_.packunit AS packunit21, s0_.shippingfree AS shippingfree22, s0_.releasedate AS releasedate23, s0_.shippingtime AS shippingtime24, s1_.id AS id25, s1_.main_detail_id AS main_detail_id26, s1_.supplierID AS supplierID27, s1_.taxID AS taxID28, s1_.pricegroupID AS pricegroupID29, s1_.filtergroupID AS filtergroupID30, s1_.configurator_set_id AS configurator_set_id31, s1_.name AS name32, s1_.description AS description33, s1_.description_long AS description_long34, s1_.datum AS datum35, s1_.active AS active36, s1_.pseudosales AS pseudosales37, s1_.topseller AS topseller38, s1_.keywords AS keywords39, s1_.metaTitle AS metaTitle40, s1_.changetime AS changetime41, s1_.pricegroupActive AS pricegroupActive42, s1_.laststock AS laststock43, s1_.crossbundlelook AS crossbundlelook44, s1_.notification AS notification45, s1_.template AS template46, s1_.mode AS mode47, s1_.available_from AS available_from48, s1_.available_to AS available_to49, s2_.id AS id50, s2_.articleID AS articleID51, s2_.articledetailsID AS articledetailsID52, s2_.pricegroup AS pricegroup53, s2_.`from` AS from54, s2_.`to` AS to55, s2_.price AS price56,...
SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/var/tmp/mysql/#sql64b_d2e4e2_0.MYI'; try to repair it
Artikel-Empfangen-Fehler: Bitte beachten Sie, dass zur Fehler-Diagnose ebenfalls die Log-Datei des Servers und das Abgleich-Log der Wawi notwendig sind!
An exception occurred while executing 'SELECT DISTINCT id0 FROM (SELECT s0_.id AS id0, s0_.articleID AS articleID1, s0_.unitID AS unitID2, s0_.ordernumber AS ordernumber3, s0_.suppliernumber AS suppliernumber4, s0_.kind AS kind5, s0_.additionaltext AS additionaltext6, s0_.active AS active7, s0_.instock AS instock8, s0_.stockmin AS stockmin9, s0_.weight AS weight10, s0_.width AS width11, s0_.length AS length12, s0_.height AS height13, s0_.ean AS ean14, s0_.position AS position15, s0_.minpurchase AS minpurchase16, s0_.purchasesteps AS purchasesteps17, s0_.maxpurchase AS maxpurchase18, s0_.purchaseunit AS purchaseunit19, s0_.referenceunit AS referenceunit20, s0_.packunit AS packunit21, s0_.shippingfree AS shippingfree22, s0_.releasedate AS releasedate23, s0_.shippingtime AS shippingtime24, s1_.id AS id25, s1_.main_detail_id AS main_detail_id26, s1_.supplierID AS supplierID27, s1_.taxID AS taxID28, s1_.pricegroupID AS pricegroupID29, s1_.filtergroupID AS filtergroupID30, s1_.configurator_set_id AS configurator_set_id31, s1_.name AS name32, s1_.description AS description33, s1_.description_long AS description_long34,...
SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/var/tmp/mysql/#sql64b_d2e4e2_0.MYI'; try to repair it
Exception: An exception occurred while executing 'SELECT DISTINCT id0 FROM (SELECT s0_.id AS id0, s0_.articleID AS articleID1, s0_.unitID AS unitID2, s0_.ordernumber AS ordernumber3, s0_.suppliernumber AS suppliernumber4, s0_.kind AS kind5, s0_.additionaltext AS additionaltext6, s0_.active AS active7, s0_.instock AS instock8, s0_.stockmin AS stockmin9, s0_.weight AS weight10, s0_.width AS width11, s0_.length AS length12, s0_.height AS height13, s0_.ean AS ean14, s0_.position AS position15, s0_.minpurchase AS minpurchase16, s0_.purchasesteps AS purchasesteps17, s0_.maxpurchase AS maxpurchase18, s0_.purchaseunit AS purchaseunit19, s0_.referenceunit AS referenceunit20, s0_.packunit AS packunit21, s0_.shippingfree AS shippingfree22, s0_.releasedate AS releasedate23, s0_.shippingtime AS shippingtime24, s1_.id AS id25, s1_.main_detail_id AS main_detail_id26, s1_.supplierID AS supplierID27, s1_.taxID AS taxID28, ...
SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/var/tmp/mysql/#sql64b_d2e4e2_0.MYI'; try to repair it
Response: {"result":null,"error":{"code":0,"message":"An exception occurred while executing 'SELECT DISTINCT id0 FROM (SELECT s0_.id AS id0, s0_.articleID AS articleID1, s0_.unitID AS unitID2, s0_.ordernumber AS ordernumber3, s0_.suppliernumber AS suppliernumber4, s0_.kind AS kind5, s0_.additionaltext AS additionaltext6, s0_.active AS active7, s0_.instock AS instock8, s0_.stockmin AS stockmin9, s0_.weight AS weight10, s0_.width AS width11, s0_.length AS length12, s0_.height AS height13, s0_.ean AS ean14, s0_.position AS position15, s0_.minpurchase AS minpurchase16, s0_.purchasesteps AS purchasesteps17, s0_.maxpurchase AS maxpurchase18, s0_.purchaseunit AS purchaseunit19, s0_.referenceunit AS referenceunit20, s0_.packunit AS packunit21, s0_.shippingfree AS shippingfree22, s0_.releasedate AS releasedate23, s0_.shippingtime AS shippingtime24, s1_.id AS id25, s1_.main_detail_id AS main_detail_id26, s1_.supplierID AS supplierID27, s1_.taxID AS taxID28, s1_.pricegroupID AS pricegroupID29, s1_.filtergroupID AS filtergroupID30, s1_.configurator_set_id AS configurator_set_id31, s1_.name AS name32, s1_.description AS description33, s1_.description_long AS description_long34, ... s16_.id = s23_.groupID LEFT JOIN s_filter_options s17_ ON s17_.id = s23_.optionID LEFT JOIN s_filter_values s18_ ON s17_.id = s18_.optionID WHERE j19_.host_id IS NULL ORDER BY s0_.kind ASC) dctrn_result LIMIT 50 OFFSET 0':\n\nSQLSTATE[HY000]: General error: 126 Incorrect key file for table '\/var\/tmp\/mysql\/#sql64b_d2e4e2_0.MYI'; try to repair it","data":null},"jtlrpc":"2.0","id":"cd6b940ed0ea4078b78b6ff3c1d3573a"}
at jtlCore.ControllerClasses.Connector.Abgleich.Connector.fFhgSTfS2S(String , Object , Boolean , NetworkCredential )[/QUOTE]
Könnte es sein, dass das daran liegt, dass wir im Shopware Medienmanager Unterordner nach Herstellern erstellt haben und dort die Bilder liegen?
Kategorien, Aufträge, etc. wurden alle korrekt übertragen.
Danke Andy