# Afterbuy Connector: An exception occurred while executing 'SELECT t0.id AS id\_1, t0.articleID AS art **URL:** \ **Category:** Plugins\ **Tags:** drittanbieter-plugin\ **Created:** [28. Juli 2020 um 18:43 UTC](https://forum.shopware.com/t/afterbuy-connector-an-exception-occurred-while-executing-select-t0-id-as-id-1-t0-articleid-as-art/68652 "2020-07-28T18:43:43Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Discover](https://avatars.discourse-cdn.com/v4/letter/d/77aa72/32.png) [@Discover](https://forum.shopware.com/u/Discover)\ **Post date:** [28. Juli 2020 um 18:43 UTC](https://forum.shopware.com/t/afterbuy-connector-an-exception-occurred-while-executing-select-t0-id-as-id-1-t0-articleid-as-art/68652/1 "2020-07-28T18:43:43Z")
> 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 ---
**Author:** ![Discover](https://avatars.discourse-cdn.com/v4/letter/d/77aa72/32.png) [@Discover](https://forum.shopware.com/u/Discover)\ **Post date:** [29. Juli 2020 um 08:30 UTC](https://forum.shopware.com/t/afterbuy-connector-an-exception-occurred-while-executing-select-t0-id-as-id-1-t0-articleid-as-art/68652/2 "2020-07-29T08:30:32Z")
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); >    ---
**Author:** ![Sukrams](https://avatars.discourse-cdn.com/v4/letter/s/58956e/32.png) [@Sukrams](https://forum.shopware.com/u/Sukrams)\ **Post date:** [22. Februar 2021 um 13:35 UTC](https://forum.shopware.com/t/afterbuy-connector-an-exception-occurred-while-executing-select-t0-id-as-id-1-t0-articleid-as-art/68652/3 "2021-02-22T13:35:10Z")
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…