# Abo-Commerce führt keine Bestellungen aus

**URL:** https://forum.shopware.com/t/abo-commerce-fuhrt-keine-bestellungen-aus/32663
**Category:** Plugins
**Tags:** offizielle-shopware-
**Created:** [1. Dezember 2015 um 10:16 UTC](https://forum.shopware.com/t/abo-commerce-fuhrt-keine-bestellungen-aus/32663 "2015-12-01T10:16:21Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![timo.d](https://avatars.discourse-cdn.com/v4/letter/t/e0b2c6/32.png) [@timo.d](https://forum.shopware.com/u/timo.d)
#### Post date: [1. Dezember 2015 um 10:16 UTC](https://forum.shopware.com/t/abo-commerce-fuhrt-keine-bestellungen-aus/32663/1 "2015-12-01T10:16:21Z")

</div>

Hallo, ich habe noch ein Problem mit dem Abo-Commerce Plugin. Sobald ich bei einem Kunden auf „Bestellung ausführen“ klicke, bekomme ich folgenden Fehler: [code]Es sind Fehler aufgetreten. Meldung vom Server:

## 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 FROM s\_plugin\_swag\_abo\_commerce\_settings s0\_ LIMIT 1‘: 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/Components/AboCommerce.php(733): Doctrine\ORM\AbstractQuery-\>getOneOrNullResult(2) #7 Shopware/Plugins/Community/Frontend/SwagAboCommerce/Components/AboCommerce.php(977): Shopware\_Components\_AboCommerce-\>getBasketData(Array, Array) #8 Shopware/Plugins/Community/Frontend/SwagAboCommerce/Controllers/Backend/AboCommerce.php(524): Shopware\_Components\_AboCommerce-\>registerOrder() #9 Shopware/Plugins/Community/Frontend/SwagAboCommerce/Controllers/Backend/AboCommerce.php(489): Shopware\_Controllers\_Backend\_AboCommerce-\>createOrder() #10 Enlight/Controller/Action.php(158): Shopware\_Controllers\_Backend\_AboCommerce-\>createOrderAction() #11 Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch('createOrderActi...') #12 Enlight/Controller/Front.php(227): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #13 Shopware/Kernel.php(148): Enlight\_Controller\_Front-\>dispatch() #14 vendor/symfony/http-kernel/HttpCache/HttpCache.php(492): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 vendor/symfony/http-kernel/HttpCache/HttpCache.php(263): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #18 shopware.php(101): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main}

```

&nbsp;  
[/code] Stimmt hier vielleicht etwas mit der Datenbankstruktur nicht? SW Version ist 5.1.1 und alle Plugins sind auf dem aktuellen Patchstand.

---

<div class="post-metadata">

### Author: ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)
#### Post date: [1. Dezember 2015 um 10:24 UTC](https://forum.shopware.com/t/abo-commerce-fuhrt-keine-bestellungen-aus/32663/2 "2015-12-01T10:24:10Z")

</div>

Hallo, wahrscheinlich ist da was beim Update schief gelaufen. Führe das hier mal manuell aus: ` 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; ` Moritz