Ok, vielleicht mach ich dass dann noch heute abend. Das ganze nervt, wenn man ständig aufs speichern warten muss.
Bis später!
Ok, vielleicht mach ich dass dann noch heute abend. Das ganze nervt, wenn man ständig aufs speichern warten muss.
Bis später!
Ich persönlich bin ja voreingenommen weil Kunde (und zufrieden) mit Netcup - ich denke aber jeder vServer Anbieter hat eine Zufriedenheitsgarantie und wenn du es innerhalb von zwei Wochen nicht hinbekommst kriegste dein Geld zurück. Probier aber einen kleinen Anbieter (php-friends, netcup, …) zu nehmen. Die Leistung von Strato und 1&1 ist oft unterirdisch schleicht weil hoffnungslos überbucht!
So, nun der fehlerbericht, kam per Mail, ich habe gekürzt:
DOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 't68.mittwald_lastlockedaccountmail' in 'field list' in /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:828
Stack trace:
#0 /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(828): PDOStatement->execute()
#1 /html/shopware/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(742): Doctrine\DBAL\Connection->executeQuery('SELECT t0.custo...', Array, Array)
#2 /html/shopware/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(760): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL)
#3 /html/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/EntityManager.php(462): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById(Array)
#4 /html/shopware/engine/Shopware/Core/sAdmin.php(3658): Doctrine\ORM\EntityManager->find('Shopware\\Models...', Array)
#5 /html/shopware/engine/Shopware/Core/sAdmin.php(1439): sAdmin->getUserBillingData('1', Array)
#6 /html/shopware/engine/Shopware/C......tdation\Request), true)
#18 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#19 /html/shopware/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#20 {main}
Next Doctrine\DBAL\DBALException: An exception occurred while executing 'SELECT t0.customernumber AS customernumber_1, t0.id AS id_2, t0.paymentID AS paymentID_3, t0.customergroup AS customergroup_4, t0.subshopID AS subshopID_5, t0.pricegroupID AS pricegroupID_6, t0.encoder AS encoder_7, t0.password AS password_8, t0.active AS active_9, t0.email AS email_10, t0.firstlogin AS firstlogin_11, t0.lastlogin AS lastlogin_12, t0.accountmode AS accountmode_13, t0.confirmationkey AS confirmationkey_14, t0.sessionID AS sessionID_15, t0.newsletter AS newsletter_16, t0.validation AS validation_17, t0.affiliate AS affiliate_18, t0.paymentpreset AS paymentpreset_19, t0.language AS language_20, t0.referer AS referer_21, t0.int...ne1_46, t30.additional_address_line2 AS additional_address_line2_47, t30.userID AS userID_48, t49.title AS title_50, t49.stateID AS stateID_51, t49.additional_address_line1 AS additional_address_line1_52, t49.additional_address_line2 AS additional_address_line2_53, t49.id AS id_54, t.........
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't68.mittwald_lastlockedaccountmail' in 'field list' in /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:119
Stack trace:
#0 /html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'SELECT t0.custo...ersisters/Entity/BasicEntityPersister.php(760): Doctrine\ORM\Persisters\..........rtpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Enlight_Controller_Request_RequestHttp), 1, true)
#13 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#14 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#15 /html/shopware/vend......Cache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#19 /html/shopware/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#20 {main}
Time:
2017-05-03T11:03:58.396313+0200
Channel:
core
request:
{
"uri": "/checkout/cart",
"method": "GET",
"query": {
"module": "frontend",
"controller": "checkout",
"action": "cart"
},
"post": []
}
session:
No session data available
Da fehlt eine Spalte in einer Tabelle.
Die Spalte heißt ‚mittwald_lastlockedaccountmail‘ - den Namen der Tabelle kann man leider nicht sehen da in der Fehlermeldung der SQL Query gekürzt wird.
Sagt dir die Spalte was? Scheint etwas von Mittwald zu sein - eventuell die mal fragen? Ist das vielleicht eine fertige Shopware Installation von Mittwald wo die selbst noch dran rumgebaut haben?
Evtl. Mittwald Security Tools Plugin!?
Dem Feldnamen nach klingt das passend
Ah, ok, das Plugin habe ich rausgenommen, dachte, ist nicht aktiv. Probiere ich gleich mal aus.
DOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'erfolgt Montag bis Donnerstag.)) GROUP BY [d.id](http://d.id) ORDER BY' at line 83 in /html/shopware/engine/Library/Zend/Db/Statement/Pdo.php:228 Stack trace: #0 /html/shopware/engine/Library/Zend/Db/Statement/Pdo.php(228): PDOStatement-\>execute(Array) #1 /html/shopware/engine/Library/Zend/Db/Statement.php(303): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #2 /html/shopware/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend\_Db\_Statement-\>execute(Array) #3 /html/shopware/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('\n SE...', Array) #4 /html/shopware/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('\n SE...', Array) #5 /html/shopware/engine/Library/Zend/Db/Adapter/Abstract.php(776): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query('\n SE...', Array) #6 /html/shopware/engine/Shopware/Core/sAdmin.php(2733): Zend\_Db\_Adapter\_Abstract-\>fetchAssoc('\n SE...', Array) #7 /html/shopware/engine/Shopware/Controllers/Frontend/Checkout.php(1342): sAdmin-\>sGetPremiumDispatches('2', NULL, '7') #8 /html/shopware/engine/Shopware/Controllers/Frontend/Checkout.php(121): Shopware\_Controllers\_Frontend\_Checkout-\>getSelectedDispatch() #9 /html/shopware/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_Checkout-\>cartAction() #10 /html/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch('cartAction') #11 /html/shopware/engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #12 /html/shopware/engine/Shopware/Kernel.php(182): Enlight\_Controller\_Front-\>dispatch() #13 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel-\>handle(Object(Enlight\_Controller\_Request\_RequestHttp), 1, true) #14 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #15 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #17 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(187): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #18 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #20 /html/shopware/shopware.php(117): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #21 {main} Next Zend\_Db\_Statement\_Exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'erfolgt Montag bis Donnerstag.)) GROUP BY [d.id](http://d.id) ORDER BY' at line 83 in /html/shopware/engine/Library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /html/shopware/engine/Library/Zend/Db/Statement.php(303): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 /html/shopware/engine/Library/Zend/Db/Adapter/Abstract.php(480): Zend\_Db\_Statement-\>execute(Array) #2 /html/shopware/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('\n SE...', Array) #3 /html/shopware/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('\n SE...', Array) #4 /html/shopware/engine/Library/Zend/Db/Adapter/Abstract.php(776): Enlight\_Components\_Db\_Adapter\_Pdo\_Mysql-\>query('\n SE...', Array) #5 /html/shopware/engine/Shopware/Core/sAdmin.php(2733): Zend\_Db\_Adapter\_Abstract-\>fetchAssoc('\n SE...', Array) #6 /html/shopware/engine/Shopware/Controllers/Frontend/Checkout.php(1342): sAdmin-\>sGetPremiumDispatches('2', NULL, '7') #7 /html/shopware/engine/Shopware/Controllers/Frontend/Checkout.php(121): Shopware\_Controllers\_Frontend\_Checkout-\>getSelectedDispatch() #8 /html/shopware/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_Checkout-\>cartAction() #9 /html/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch('cartAction') #10 /html/shopware/engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #11 /html/shopware/engine/Shopware/Kernel.php(182): Enlight\_Controller\_Front-\>dispatch() #12 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel-\>handle(Object(Enlight\_Controller\_Request\_RequestHttp), 1, true) #13 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #15 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #16 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(187): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #17 /html/shopware/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #18 /html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #19 /html/shopware/shopware.php(117): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #20 {main}
Time:
2017-05-03T16:38:45.894425+0200
Channel:
core
request:
{ "uri": "/checkout/cart", "method": "GET", "query": { "module": "frontend", "controller": "checkout", "action": "cart" }, "post": [] }
Hallo @Nedea,
die Fehlermeldung schaut so aus, als hättest du da eine Versandkosten-Art ein wenig misskonfiguriert.
Du könntest die Versandkosten mal Schritt für Schritt deaktivieren und schauen, ob es dann wieder geht.
So dürftest du relativ fix die defekte Versandart finden.
Gruß,
Patrick
Danke allen!