timo.dtimo.d MemberComments: 5 Received thanks: 0 Member since: November 2015 edited December 2015
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:
Es sind Fehler aufgetreten. Meldung vom Server: 
<h2><span class="frontend_error_exception">Ups! Ein Fehler ist aufgetreten!</span></h2>

    <p>
        <span class="frontend_error_exception">Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.</span>
    </p>

    <h3>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</h3>

    <h3>Stack trace:</h3>
    <div style="overflow:auto;">
        <pre>#0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), &#039;SELECT s0_.id A...&#039;, Array)
#1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery(&#039;SELECT s0_.id A...&#039;, 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(&#039;createOrderActi...&#039;)
#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}</pre>
    </div>
<div class="doublespace"> </div>
Stimmt hier vielleicht etwas mit der Datenbankstruktur nicht?
SW Version ist 5.1.1 und alle Plugins sind auf dem aktuellen Patchstand.

Comments

  • Moritz NaczenskiMoritz Naczenski AdministratorsComments: 9280 Received thanks: 2775 Member since: September 2013
    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
Sign In or Register to comment.