Fehler Login - Frontend

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 :wink:

Hi,

wie sieht der StackTrace dazu aus?

Gruß Heiner

1 Like

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 Like

 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