# Fehlermeldung bei Abo Commerce **URL:** \ **Category:** Plugins\ **Tags:** offizielle-shopware-\ **Created:** [23. Juni 2016 um 08:34 UTC](https://forum.shopware.com/t/fehlermeldung-bei-abo-commerce/37651 "2016-06-23T08:34:27Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![zorc68](https://avatars.discourse-cdn.com/v4/letter/z/e9a140/32.png) [@zorc68](https://forum.shopware.com/u/zorc68)\ **Post date:** [23. Juni 2016 um 08:34 UTC](https://forum.shopware.com/t/fehlermeldung-bei-abo-commerce/37651/1 "2016-06-23T08:34:27Z")
Hallo, ich habe gerade die Mietversion von ABO Commerce instaliert und erst schien auch alles soweit o.k. Wenn ich dann eine Zahlungsrat für Abo Commerce festlegen will kommt folgende Fehlermeldung? **Weis jemand wie man da weiter vorgeht.** **Danke Marc**   **503 - Service Unavailable** Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‘SELECT s0\_.id AS id\_0, s0\_.sharing\_twitter AS sharing\_twitter\_1, s0\_.sharing\_facebook AS sharing\_facebook\_2, s0\_.sharing\_google AS sharing\_google\_3, s0\_.sharing\_mail AS sharing\_mail\_4, s0\_.sidebar\_headline AS sidebar\_headline\_5, s0\_.sidebar\_text AS sidebar\_text\_6, s0\_.banner\_headline AS banner\_headline\_7, s0\_.banner\_subheadline AS banner\_subheadline\_8, s0\_.allow\_voucher\_usage AS allow\_voucher\_usage\_9, s0\_.use\_actual\_product\_price AS use\_actual\_product\_price\_10, s1\_.id AS id\_11, s1\_.name AS name\_12, s1\_.description AS description\_13, s1\_.template AS template\_14, s1\_.class AS class\_15, s1\_.`table` AS table\_16, s1\_.hide AS hide\_17, s1\_.additionaldescription AS additionaldescription\_18, s1\_.debit\_percent AS debit\_percent\_19, s1\_.surcharge AS surcharge\_20, s1\_.surchargestring AS surchargestring\_21, s1\_.position AS position\_22, s1\_.active AS active\_23, s1\_.esdactive AS esdactive\_24, s1\_.mobile\_inactive AS mobile\_inactive\_25, s1\_.embediframe AS embediframe\_26, s1\_.hideprospect AS hideprospect\_27, s1\_.action AS action\_28, s1\_.pluginID AS pluginID\_29, s1\_.source AS source\_30 FROM s\_plugin\_swag\_abo\_commerce\_settings s0\_ LEFT JOIN s\_plugin\_swag\_abo\_commerce\_settings\_paymentmeans s2\_ ON s0\_.id = s2\_.settings\_id LEFT JOIN s\_core\_paymentmeans s1\_ ON s1\_.id = s2\_.payment\_id’: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s0\_.use\_actual\_product\_price’ in ‘field list’ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 119 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‘SELECT s0\_.id A…’, Array) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery(‘SELECT s0\_.id A…’, Array, Array, NULL) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(321): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(969): Doctrine\ORM\Query-\>\_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(924): Doctrine\ORM\AbstractQuery-\>executeIgnoreQueryCache(NULL, 2) #5 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(766): Doctrine\ORM\AbstractQuery-\>execute(NULL, 2) #6 Shopware/Plugins/Community/Frontend/SwagAboCommerce/Controllers/Backend/AboCommerce.php(194): Doctrine\ORM\AbstractQuery-\>getOneOrNullResult() #7 Shopware/Plugins/Community/Frontend/SwagAboCommerce/Controllers/Backend/AboCommerce.php(181): Shopware\_Controllers\_Backend\_AboCommerce-\>getSettings() #8 Enlight/Controller/Action.php(158): Shopware\_Controllers\_Backend\_AboCommerce-\>getSettingsAction() #9 Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‘getSettingsActi…’) #10 Enlight/Controller/Front.php(226): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 Shopware/Kernel.php(153): Enlight\_Controller\_Front-\>dispatch() #12 vendor/symfony/http-kernel/HttpCache/HttpCache.php(492): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 vendor/symfony/http-kernel/HttpCache/HttpCache.php(263): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #16 shopware.php(101): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #17 {main}   ---
**Author:** ![Michael\_Telgmann](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/michael_telgmann/32/20289_2.png) [@Michael\_Telgmann](https://forum.shopware.com/u/Michael_Telgmann)\ **Post date:** [23. Juni 2016 um 08:58 UTC](https://forum.shopware.com/t/fehlermeldung-bei-abo-commerce/37651/2 "2016-06-23T08:58:41Z")
Hi Marc, kannst du mal in deiner Datenbank schauen ob in der Tabelle `s_plugin_swag_abo_commerce_settings` die Spalte `use_actual_product_price` existiert? Falls nicht kannst du mal versuchen, folgende Query auszuführen:  ``` ALTER TABLE `s_plugin_swag_abo_commerce_settings` ADD `use_actual_product_price` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0; UPDATE `s_plugin_swag_abo_commerce_settings` SET use_actual_product_price = 1; ``` Ansonsten hilft vielleicht schon eine komplette Neuinstallation des Plugins. Viele Grüße aus Schöppingen ![cool](http://forum.shopware.com/plugins/CKEditor/plugins/smiley/images/shopware.png "cool") Michael Telgmann ---
**Author:** ![zorc68](https://avatars.discourse-cdn.com/v4/letter/z/e9a140/32.png) [@zorc68](https://forum.shopware.com/u/zorc68)\ **Post date:** [23. Juni 2016 um 11:24 UTC](https://forum.shopware.com/t/fehlermeldung-bei-abo-commerce/37651/3 "2016-06-23T11:24:07Z")
Hallo Danke für den Tipp. in der Datenbank gibt es nur Felder für  id shop\_id sidebar\_headline sidebar\_text banner\_headline banner\_subheadline sharing\_twitter sharing\_facebook sharing\_google sharing\_mail allow\_voucher\_usage   Eine Neuinstallalation hat leider nichts gebracht. In Datenbanken kenne ich mich leider nicht genug aus, so dass ich micht nicht traue die Query einfach so auszuführen. Wo muss ich da was machen? Viele Grüße Marc Prinz ---
**Author:** ![Michael\_Telgmann](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/michael_telgmann/32/20289_2.png) [@Michael\_Telgmann](https://forum.shopware.com/u/Michael_Telgmann)\ **Post date:** [23. Juni 2016 um 13:17 UTC](https://forum.shopware.com/t/fehlermeldung-bei-abo-commerce/37651/4 "2016-06-23T13:17:24Z")
Hi Marc, welche Shopware Verison und welche AboCommerce Version nutzt du denn? Viele Grüße aus Schöppingen ![cool](http://forum.shopware.com/plugins/CKEditor/plugins/smiley/images/shopware.png "cool") Michael Telgmann ---
**Author:** ![zorc68](https://avatars.discourse-cdn.com/v4/letter/z/e9a140/32.png) [@zorc68](https://forum.shopware.com/u/zorc68)\ **Post date:** [23. Juni 2016 um 14:09 UTC](https://forum.shopware.com/t/fehlermeldung-bei-abo-commerce/37651/5 "2016-06-23T14:09:08Z")
Shopware 5.1.6 und AboCommerce 1.3.0 ---
**Author:** ![Michael\_Telgmann](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/michael_telgmann/32/20289_2.png) [@Michael\_Telgmann](https://forum.shopware.com/u/Michael_Telgmann)\ **Post date:** [23. Juni 2016 um 14:22 UTC](https://forum.shopware.com/t/fehlermeldung-bei-abo-commerce/37651/6 "2016-06-23T14:22:14Z")
Hi Marc, Hastest du früher schon mal eine Version von AboCommerce installiert? Ich sehe gerade keinen Grund warum ausgerechnet diese Spalte nicht in der Datenbank vorhanden ist.  Wenn du einen Datenbank Zugriff hast, z.B. über phpMyAdmin oder so was, würde ich als erstes alle Tabellen löschen, die “s\_plugin\_swag\_abo\_commerce” im Namen haben. Danach noch einmal das Plugin neuinstallieren. Oder eben alternativ den oben genannten Query über die Admin Oberfläche deiner Datenbank ausführen. Viele Grüße aus Schöppingen ![cool](https://europe1.discourse-cdn.com/flex013/uploads/shopware/original/1X/86c57fbace799dd4eb1f1b8a2d3bdc1733f0aea1.png "cool") Michael Telgmann ---
**Author:** ![zorc68](https://avatars.discourse-cdn.com/v4/letter/z/e9a140/32.png) [@zorc68](https://forum.shopware.com/u/zorc68)\ **Post date:** [27. Juni 2016 um 15:00 UTC](https://forum.shopware.com/t/fehlermeldung-bei-abo-commerce/37651/7 "2016-06-27T15:00:09Z")
Hallo, vieleln Dank…so konnte ich es lösen.  Viele Grüße Marc Prinz