Hallo,
wir haben seit kurzem das Problem, dass in JTL neu angelegte Artikel nicht mehr im Shopware-Backend erscheinen und somit auch nicht im Onlineshop angezeigt werden.
Die Artikel werden zwar in die Datenbank in die Tabelle "s_articles" geschrieben, aber nicht in die "s_articles_detail". Der Error- Log des Connectors spuckt folgende Fehlermeldung aus:
DATABASE-2019-XX-XX.log
LINKER-2019-XX-XX.log
GLOBAL-2019-XX-XX.og
Auf dem Server werden drei Shopware-Shops betrieben, das Problem tritt jedoch nur bei einem auf.
wir haben seit kurzem das Problem, dass in JTL neu angelegte Artikel nicht mehr im Shopware-Backend erscheinen und somit auch nicht im Onlineshop angezeigt werden.
Die Artikel werden zwar in die Datenbank in die Tabelle "s_articles" geschrieben, aber nicht in die "s_articles_detail". Der Error- Log des Connectors spuckt folgende Fehlermeldung aus:
DATABASE-2019-XX-XX.log
Code:
[2019-01-17 17:23:55] database.ERROR: Exception from Product (, 33402) [] []
[2019-01-17 17:23:55] database.ERROR: Exception 'Doctrine\ORM\ORMException' (Code: 0) with message 'The EntityManager is closed.' in /var/www/clients/client3/webXX/web/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php:144 [] []
[2019-01-17 17:34:27] database.ERROR: Exception from Product (, 33401) [] []
[2019-01-17 17:34:27] database.ERROR: Exception 'Doctrine\DBAL\DBALException' (Code: 0) with message 'An exception occurred while executing 'INSERT INTO s_articles_attributes (articleID, articledetailsID, attr1, attr2, attr3, attr4, attr5, attr6, attr7, attr8, attr9, attr10, attr11, attr12, attr13, attr14, attr15, attr16, attr17, attr18, attr19, attr20, viison_country_of_origin, viison_customs_tariff_number, ship, ship2, ship3, heptacom_youtube, iw_contact, bibu_spracharticles, dreisc_seo_url, dreisc_seo_title, dreisc_seo_title_replace, dreisc_seo_breadcrumb, dreisc_canonical_link, dreisc_robots_tag, dreisc_facebook_description, dreisc_twitter_description, dreisc_facebook_image, dreisc_twitter_image, connect_product_description, connect_article_shipping, connect_reference, connect_property_group, connect_mapped_category, connect_remote_unit, mag_helpful, mag_unhelpful, imnxx_variant_table_activ, pickware_incoming_stock, pickware_physical_stock_for_sale, pickware_stock_management_disabled, pickware_stock_initialized, pickware_stock_initialization_time) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [252, 720, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'pickware_incoming_stock' cannot be null' in /var/www/clients/client3/webXX/web/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:131 [] []
[2019-01-17 17:34:27] database.ERROR: Exception from Product (, 33402) [] []
[2019-01-17 17:34:27] database.ERROR: Exception 'Doctrine\ORM\ORMException' (Code: 0) with message 'The EntityManager is closed.' in /var/www/clients/client3/webXX/web/vendor/doctrine/orm/lib/Doctrine/ORM/ORMException.php:144 [] []LINKER-2019-XX-XX.log
Code:
[2019-01-23 00:01:07] linker.DEBUG: Trying to get hostId with endpointId (1) and type (12) ... hostId: () [] []
[2019-01-23 00:01:07] linker.DEBUG: SaveCache (endpointId: 1, hostId: , type: 12, cacheType: e) [] []
[2019-01-23 00:01:07] linker.DEBUG: Checkcache (id: 1, type: 12, cacheType: e) with result true [] []
[2019-01-23 00:01:07] linker.DEBUG: LoadCache (id: 1, type: 12, cacheType: e) with result [] []
[2019-01-23 00:01:07] linker.DEBUG: Checkcache (id: 1, type: 14, cacheType: e) with result false [] []GLOBAL-2019-XX-XX.og
Code:
[2019-01-23 07:46:10] global.ERROR: (E_RECOVERABLE_ERROR) File (phar:///var/www/clients/client3/webXX/web/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Controller/CustomerOrder.php, 260): Object of class DateTime could not be converted to string [] []
[2019-01-23 07:49:42] global.WARNING: (E_WARNING) File (/var/www/clients/client3/webXX/web/engine/Shopware/Components/HttpCache/Store.php, 341): unlink(/var/www/clients/client3/webXX/web/var/cache/production_201806131541/html/md/53/e6/bdbe2c8abf53af8b12dbd7f21bd7e3ad5cccdd37a24e03b56f64de5181ff): No such file or directory [] []
[2019-01-23 08:34:12] global.NOTICE: (E_NOTICE) File (phar:///var/www/clients/client3/webXX/web/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/vendor/jtl/connector/src/jtl/Connector/Result/Action.php, 45): Undefined property: jtl\Connector\Result\Action::$_isHandled [] []
[2019-01-23 09:19:17] global.ERROR: (E_RECOVERABLE_ERROR) File (phar:///var/www/clients/client3/webXX/web/engine/Shopware/Plugins/Community/Frontend/jtlconnector/connector.phar/src/jtl/Connector/Shopware/Controller/CustomerOrder.php, 260): Object of class DateTime could not be converted to string [] []
[2019-01-23 09:33:21] global.WARNING: (E_WARNING) File (/var/www/clients/client3/webXX/web/engine/Shopware/Components/HttpCache/Store.php, 341): unlink(/var/www/clients/client3/webXX/web/var/cache/production_201806131541/html/md/f4/23/29dd9ce6d8f601b960869c8e2e5d02015ca9afa65d9f9f8d31b9df97557c): No such file or directory [] []
[2019-01-23 09:47:08] global.NOTICE: (E_NOTICE) File (/var/www/clients/client3/webXX/web/engine/Shopware/Models/Document/Order.php, 518): Undefined index: 19.00 [] []
[2019-01-23 10:49:17] global.NOTICE: (E_NOTICE) File (/var/www/clients/client3/webXX/web/engine/Shopware/Models/Document/Order.php, 518): Undefined index: 19.00 [] []
[2019-01-23 12:30:47] global.WARNING: (E_WARNING) File (/var/www/clients/client3/webXX/web/engine/Shopware/Components/HttpCache/Store.php, 341): unlink(/var/www/clients/client3/webXX/web/var/cache/production_201806131541/html/md/1f/8d/fb7afdf9fbf0d5eb03b21cd9eab0a93721a8447f9069a333d888c38b7fd2): No such file or directoryAuf dem Server werden drei Shopware-Shops betrieben, das Problem tritt jedoch nur bei einem auf.
