Maxi
24. April 2018 um 08:36
1
Hallo zusammen,
ich habe neuerdings das Problem, dass ein Login im Frontend auf einen Fehler läuft. Folgender Fehler tritt auf:
SQLSTATE[42S22]: Column not found: 1054 Unknown column '95€' in 'field list'
Mir ist klar, das da eine Spalte in der DB gesucht wird, die nicht existiert. Allerdings verstehe ich nicht warum. Dieser Fehler tritt auf, seitdem ich die Domain geändert habe und ein SSL Zertifikat installiert habe. Außdem hatte ich zuvor ein Artikelimport durchgeführt (Vorlage von Shopware). Es sind diverse Plugins im Einsatz, welche aber nicht die Ursache sein können, da das Problem auch auftritt wenn ich deaktiviere. Ich hoffe es gibt findige Member, die mir weiterhelfen können
Hi,
wie sieht der StackTrace dazu aus?
Gruß Heiner
1 „Gefällt mir“
Maxi
24. April 2018 um 10:30
3
Hi Heiner,
hier bitte und vielen Dank schonmal:
exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column '95€' in 'field list'' in /var/www/clients/client3030/web6395/web/engine/Library/Zend/Db/Statement/Pdo.php:219 Stack trace: #0 /var/www/clients/client3030/web6395/web/engine/Library/Zend/Db/Statement/Pdo.php(219): PDOStatement-\>execute(Array) #1 /var/www/clients/client3030/web6395/web/engine/Library/Zend/Db/Statement.php(297): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #2 /var/www/clients/client3030/web6395/web/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend\_Db\_Statement-\>execute(Array) #3 /var/www/clients/client3030/web6395/web/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend\_Db\_Adapter\_Abstract-\>query('\n SE...', Array) #4 /var/www/clients/client3030/web6395/web/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('\n SE...', Array) #5 /var/www/clients/client3030/web6395/web/engine/Library/Zend/Db/Adapter/Abstract.php(744): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query('\n SE...', Array) #6 /var/www/clients/client3030/web6395/web/engine/Shopware/Core/sAdmin.php(2547): Zend\_Db\_Adapter\_Abstract-\>fetchRow('\n SE...', Array) #7 /var/www/clients/client3030/web6395/web/engine/Shopware/Core/sAdmin.php(2973): sAdmin-\>sGetDispatchBasket(NULL) #8 /var/www/clients/client3030/web6395/web/engine/Shopware/Core/sBasket.php(1712): sAdmin-\>sGetPremiumShippingcosts() #9 /var/www/clients/client3030/web6395/web/engine/Shopware/Controllers/Frontend/Account.php(695): sBasket-\>sRefreshBasket() #10 /var/www/clients/client3030/web6395/web/engine/Shopware/Controllers/Frontend/Account.php(259): Shopware\_Controllers\_Frontend\_Account-\>refreshBasket() #11 /var/www/clients/client3030/web6395/web/custom/plugins/SwagBusinessEssentials/Controllers/Frontend/PrivateLogin.php(80): Shopware\_Controllers\_Frontend\_Account-\>loginAction() #12 /var/www/clients/client3030/web6395/web/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_PrivateLogin-\>loginAction() #13 /var/www/clients/client3030/web6395/web/engine/Library/Enlight/Controller/Dispatcher/Default.php(530): Enlight\_Controller\_Action-\>dispatch('loginAction') #14 /var/www/clients/client3030/web6395/web/engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #15 /var/www/clients/client3030/web6395/web/engine/Shopware/Kernel.php(191): Enlight\_Controller\_Front-\>dispatch() #16 /var/www/clients/client3030/web6395/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(484): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #17 /var/www/clients/client3030/web6395/web/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #18 /var/www/clients/client3030/web6395/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(251): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #19 /var/www/clients/client3030/web6395/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #20 /var/www/clients/client3030/web6395/web/engine/Shopware/Components/HttpCache/AppCache.php(143): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #21 /var/www/clients/client3030/web6395/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(199): Shopware\Components\HttpCache\AppCache-\>invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #22 /var/www/clients/client3030/web6395/web/engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #23 /var/www/clients/client3030/web6395/web/shopware.php(118): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #24 {main} Next exception 'Zend\_Db\_Statement\_Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column '95€' in 'field list'' in /var/www/clients/client3030/web6395/web/engine/Library/Zend/Db/Statement/Pdo.php:224 Stack trace: #0 /var/www/clients/client3030/web6395/web/engine/Library/Zend/Db/Statement.php(297): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 /var/www/clients/client3030/web6395/web/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend\_Db\_Statement-\>execute(Array) #2 /var/www/clients/client3030/web6395/web/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend\_Db\_Adapter\_Abstract-\>query('\n SE...', Array) #3 /var/www/clients/client3030/web6395/web/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('\n SE...', Array) #4 /var/www/clients/client3030/web6395/web/engine/Library/Zend/Db/Adapter/Abstract.php(744): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query('\n SE...', Array) #5 /var/www/clients/client3030/web6395/web/engine/Shopware/Core/sAdmin.php(2547): Zend\_Db\_Adapter\_Abstract-\>fetchRow('\n SE...', Array) #6 /var/www/clients/client3030/web6395/web/engine/Shopware/Core/sAdmin.php(2973): sAdmin-\>sGetDispatchBasket(NULL) #7 /var/www/clients/client3030/web6395/web/engine/Shopware/Core/sBasket.php(1712): sAdmin-\>sGetPremiumShippingcosts() #8 /var/www/clients/client3030/web6395/web/engine/Shopware/Controllers/Frontend/Account.php(695): sBasket-\>sRefreshBasket() #9 /var/www/clients/client3030/web6395/web/engine/Shopware/Controllers/Frontend/Account.php(259): Shopware\_Controllers\_Frontend\_Account-\>refreshBasket() #10 /var/www/clients/client3030/web6395/web/custom/plugins/SwagBusinessEssentials/Controllers/Frontend/PrivateLogin.php(80): Shopware\_Controllers\_Frontend\_Account-\>loginAction() #11 /var/www/clients/client3030/web6395/web/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_PrivateLogin-\>loginAction() #12 /var/www/clients/client3030/web6395/web/engine/Library/Enlight/Controller/Dispatcher/Default.php(530): Enlight\_Controller\_Action-\>dispatch('loginAction') #13 /var/www/clients/client3030/web6395/web/engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #14 /var/www/clients/client3030/web6395/web/engine/Shopware/Kernel.php(191): Enlight\_Controller\_Front-\>dispatch() #15 /var/www/clients/client3030/web6395/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(484): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 /var/www/clients/client3030/web6395/web/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #17 /var/www/clients/client3030/web6395/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(251): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #18 /var/www/clients/client3030/web6395/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #19 /var/www/clients/client3030/web6395/web/engine/Shopware/Components/HttpCache/AppCache.php(143): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #20 /var/www/clients/client3030/web6395/web/vendor/symfony/http-kernel/HttpCache/HttpCache.php(199): Shopware\Components\HttpCache\AppCache-\>invalidate(Object(Symfony\Component\HttpFoundation\Request), true) #21 /var/www/clients/client3030/web6395/web/engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #22 /var/www/clients/client3030/web6395/web/shopware.php(118): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #23 {main}
Beste Grüße
Hi,
der Fehler kommt aus den Versandkosten. Überprüfe mal was bei dir in den Versandkosten als „Eigene Berechung“ steht:
SELECT id, calculation\_sql FROM s\_premium\_dispatch WHERE active = 1 AND calculation = 3
Dort könnte das „95€“ herkommen.
Gruß Heiner
1 „Gefällt mir“
Maxi
25. April 2018 um 09:02
5
Hi Heiner,
besten Dank, du hattest Recht. Die zusätzliche Aufschlags-Versandart war das Problem bzw. die eigene Berechnung.War mein eigener Fehler…
Danke für die schnelle Hilfe!
Gruß Maxi
