Afterbuy Connector: An exception occurred while executing 'SELECT t0.id AS id_1, t0.articleID AS art

Ups! Ein Fehler ist aufgetreten!

Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.

An exception occurred while executing ‘SELECT t0.id AS id_1, t0.articleID AS articleID_2, t0.article_detail_id AS article_detail_id_3, t0.description AS description_4, t0.img AS img_5, t0.main AS main_6, t0.position AS position_7, t0.width AS width_8, t0.height AS height_9, t0.relations AS relations_10, t0.extension AS extension_11, t0.parent_id AS parent_id_12, t0.media_id AS media_id_13, t0.articleID AS articleID_14, t15.id AS id_16, t15.imageID AS imageID_17, t15.attribute1 AS attribute1_18, t15.attribute2 AS attribute2_19, t15.attribute3 AS attribute3_20, t15.tbeafterbuy_abid AS tbeafterbuy_abid_21, t15.imageID AS imageID_22, t0.article_detail_id AS article_detail_id_23, t0.media_id AS media_id_24, t0.parent_id AS parent_id_25 FROM s_articles_img t0 LEFT JOIN s_articles_img_attributes t15 ON t15.imageID = t0.id WHERE t0.media_id = ? AND t0.articleID = ?’ with params [2862, 1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t15.tbeafterbuy_abid’ in ‘field list’ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 179

Stack trace:

#0 vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(150): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‘An exception oc…’) #1 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(915): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‘SELECT t0.id AS…’, Array) #2 engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(558): Doctrine\DBAL\Connection->executeQuery(‘SELECT t0.id AS…’, Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(178): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(Array, NULL, NULL, NULL) #4 custom/plugins/viaebShopwareAfterbuy/Services/Helper/ShopwareArticleHelper.php(1353): Doctrine\ORM\EntityRepository->findBy(Array) #5 custom/plugins/viaebShopwareAfterbuy/Services/Helper/ShopwareArticleHelper.php(1314): viaebShopwareAfterbuy\Services\Helper\ShopwareArticleHelper->associateImage(Object(viaebShopwareAfterbuy\ValueObjects\Article), Object(viaebShopwareAfterbuy\ValueObjects\ProductPicture), Object(Shopware\Proxies__CG__\Shopware\Models\Article\Detail)) #6 custom/plugins/viaebShopwareAfterbuy/Services/WriteData/Internal/WriteProductsService.php(58): viaebShopwareAfterbuy\Services\Helper\ShopwareArticleHelper->associateImages(Array) #7 custom/plugins/viaebShopwareAfterbuy/Services/WriteData/Internal/WriteProductsService.php(24): viaebShopwareAfterbuy\Services\WriteData\Internal\WriteProductsService->transform(Array) #8 custom/plugins/viaebShopwareAfterbuy/Subscriber/Cron.php(151): viaebShopwareAfterbuy\Services\WriteData\Internal\WriteProductsService->put(Array) #9 engine/Library/Enlight/Event/Handler/Default.php(87): viaebShopwareAfterbuy\Subscriber\Cron->updateProducts(Object(Shopware_Components_Cron_CronJob)) #10 engine/Library/Enlight/Event/EventManager.php(251): Enlight_Event_Handler_Default->execute(Object(Shopware_Components_Cron_CronJob)) #11 engine/Library/Enlight/Components/Cron/Manager.php(275): Enlight_Event_EventManager->notifyUntil(‘Shopware_CronJo…’, Object(Shopware_Components_Cron_CronJob)) #12 engine/Shopware/Plugins/Default/Core/Cron/Cron.php(53): Enlight_Components_Cron_Manager->runJob(Object(Enlight_Components_Cron_Job)) #13 engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_Cron->indexAction() #14 engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch(‘indexAction’) #15 engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #16 engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch() #17 vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #20 vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #21 engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #22 shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #23 {main}

Hi, ich versuche den Afterbuy Shopware Connector zum laufen zu bringen und bekomme diese Fehlermeldung.

Leider hangel ich mich bei der Installation derzeit von einer Fehlermeldung zur nächsten. Bei dieser bin ich überfragt.

Hat jemand eine Idee, wie ich dieses Problem löse bzw. was das Problem überhaupt ist?

Bin kein Entwickler, nur ein leidenschaftlicher Online-Händler mit etwas technischem Verständnis.

Ggf fehlt eine Spalete namens “tbeafterbuy_abid” in s_articles_img_attributes? ist das so? Ich habe versucht in der Tabelle via phpmyadmin eine Spalte hinzuzufügen. ohne Erfolg. Dann habe ich einfach attribut3 in tbeafterbuy_abid umbenannt, hat dann nur den Shop zerlegt, also rückgängig gemacht…

Bin über jede Hilfe Dankbar!!

VG

Discover

Habe es selbst lösen können, unter Anpassung der Freitextfelder im Backend in der entsprechenden Tabelle konnte ich die Spalte hinzufügen. dann ging es weiter.

jedoch habe ich hier nun die nächste Fehlermeldung, danach bricht die synchronisierung wieder ab und der cronjob stellt sich inaktiv:

 

array (
  ‚error‘ => ‚Argument 3 passed to viaebShopwareAfterbuy\Services\Helper\ShopwareArticleHelper::associateImage() must be an instance of Shopware\Models\Article\Detail, null given, called in /www/htdocs/w013b4f3/folder/custom/plugins/viaebShopwareAfterbuy/Services/Helper/ShopwareArticleHelper.php on line 1314‘,
)

 

Zeile 1313 und 1314 in der shopwarearticlehelper.php ist:

            foreach ($valueArticle->getProductPictures() as $productPicture) {
                $this->associateImage($valueArticle, $productPicture, $mainDetail);
  

Hallo!

Habe dasselbe Problem. Hattest du zufällig vorher auch das TBE-Afterbuy Plugin drin?

Konntest du das fixen? Eigentlich sollte der Afterbuy Connector da ja nichts mehr von TBE erwarten, daher irritiert mich der Fehler etwas…