Hallo zusammen, ich brauche dringend Hilfe. Wenn ich im backend das versandkostenmodul öffnen möchte bekomme ich folgenden Fehler: Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‘SELECT s0_.id AS id0, s0_.name AS name1, s0_.type AS type2, s0_.description AS description3, s0_.comment AS comment4, s0_.active AS active5, s0_.position AS position6, s0_.calculation AS calculation7, s0_.surcharge_calculation AS surcharge_calculation8, s0_.tax_calculation AS tax_calculation9, s0_.shippingfree AS shippingfree10, s0_.multishopID AS multishopID11, s0_.customergroupID AS customergroupID12, s0_.bind_shippingFree AS bind_shippingFree13, s0_.bind_time_from AS bind_time_from14, s0_.bind_time_to AS bind_time_to15, s0_.bind_instock AS bind_instock16, s0_.bind_laststock AS bind_laststock17, s0_.bind_weekday_from AS bind_weekday_from18, s0_.bind_weekday_to AS bind_weekday_to19, s0_.bind_weight_from AS bind_weight_from20, s0_.bind_weight_to AS bind_weight_to21, s0_.bind_price_from AS bind_price_from22, s0_.bind_price_to AS bind_price_to23, s0_.bind_sql AS bind_sql24, s0_.status_link AS status_link25, s0_.calculation_sql AS calculation_sql26, s1_.id AS id27, s1_.countryname AS countryname28, s1_.countryiso AS countryiso29, s1_.countryen AS countryen30, s1_.position AS position31, s1_.notice AS notice32, s1_.shippingfree AS shippingfree33, s1_.taxfree AS taxfree34, s1_.taxfree_ustid AS taxfree_ustid35, s1_.taxfree_ustid_checked AS taxfree_ustid_checked36, s1_.active AS active37, s1_.iso3 AS iso338, s1_.display_state_in_registration AS display_state_in_registration39, s1_.force_state_in_registration AS force_state_in_registration40, s1_.areaID AS areaID41, s2_.id AS id42, s2_.parent AS parent43, s2_.description AS description44, s2_.position AS position45, s2_.metakeywords AS metakeywords46, s2_.metadescription AS metadescription47, s2_.cmsheadline AS cmsheadline48, s2_.cmstext AS cmstext49, s2_.active AS active50, s2_.template AS template51, s2_.blog AS blog52, s2_.path AS path53, s2_.showfiltergroups AS showfiltergroups54, s2_.external AS external55, s2_.hidefilter AS hidefilter56, s2_.hidetop AS hidetop57, s2_.noviewselect AS noviewselect58, s2_.changed AS changed59, s2_.added AS added60, s3_.id AS id61, s3_.name AS name62, s3_.calculation AS calculation63, s3_.date AS date64, s4_.id AS id65, s4_.dispatchID AS dispatchID66, s4_.swag_dhl_dispatch AS swag_dhl_dispatch67, s4_.swag_dhl_new_installation AS swag_dhl_new_installation68, s5_.id AS id69, s5_.name AS name70, s5_.description AS description71, s5_.template AS template72, s5_.class AS class73, s5_.table
AS table74, s5_.hide AS hide75, s5_.additionaldescription AS additionaldescription76, s5_.debit_percent AS debit_percent77, s5_.surcharge AS surcharge78, s5_.surchargestring AS surchargestring79, s5_.position AS position80, s5_.active AS active81, s5_.esdactive AS esdactive82, s5_.embediframe AS embediframe83, s5_.hideprospect AS hideprospect84, s5_.action AS action85, s5_.pluginID AS pluginID86, s5_.source AS source87 FROM s_premium_dispatch s0_ LEFT JOIN s_premium_dispatch_countries s6_ ON s0_.id = s6_.dispatchID LEFT JOIN s_core_countries s1_ ON s1_.id = s6_.countryID LEFT JOIN s_premium_dispatch_categories s7_ ON s0_.id = s7_.dispatchID LEFT JOIN s_categories s2_ ON s2_.id = s7_.categoryID LEFT JOIN s_premium_dispatch_holidays s8_ ON s0_.id = s8_.dispatchID LEFT JOIN s_premium_holidays s3_ ON s3_.id = s8_.holidayID LEFT JOIN s_premium_dispatch_attributes s4_ ON s0_.id = s4_.dispatchID LEFT JOIN s_premium_dispatch_paymentmeans s9_ ON s0_.id = s9_.dispatchID LEFT JOIN s_core_paymentmeans s5_ ON s5_.id = s9_.paymentID WHERE s0_.id IN (?) ORDER BY s0_.name ASC’ with params [“9”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s4_.swag_dhl_dispatch’ in ‘field list’ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 91 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(701): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(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(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query->_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(574): Doctrine\ORM\AbstractQuery->execute(NULL, 2) #5 vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(186): Doctrine\ORM\AbstractQuery->getResult(2) #6 Shopware/Controllers/Backend/Shipping.php(247): Do Leider verzweifle ich langsam daran. Ich kann auch im Frontend das Kundenkonto nicht mehr öffnen. Auch da bekomme ich dann eine Fehlermeldung. Ich hoffe hier kann mir jemand helfen. -------------- Wenn man ein Kudnenkonto erstellt kommt folgender Fehler: Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‘SELECT s0_.id AS id0, s0_.shippingID AS shippingID1, s0_.text1 AS text12, s0_.text2 AS text23, s0_.text3 AS text34, s0_.text4 AS text45, s0_.text5 AS text56, s0_.text6 AS text67, s0_.swag_dhl_packstation AS swag_dhl_packstation8, s0_.swag_dhl_postoffice AS swag_dhl_postoffice9, s0_.swag_dhl_postnumber AS swag_dhl_postnumber10 FROM s_user_shippingaddress_attributes s0_ INNER JOIN s_user_shippingaddress s1_ ON s0_.shippingID = s1_.id WHERE s1_.userID = ? LIMIT 1 OFFSET 0’ with params [“2”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s0_.swag_dhl_packstation’ in ‘field list’ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 91 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(701): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(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(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query->_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(612): Doctrine\ORM\AbstractQuery->execute(NULL, 2) #5 engine/core/class/sAdmin.php(2703): Doctrine\ORM\AbstractQuery->getOneOrNullResult(2) #6 engine/core/class/sAdmin.php(4577): sAdmin->getUserShippingAddressAttributes(‘2’) #7 engine/core/class/sAdmin.php(2656): sAdmin->getUserShippingData(‘2’, Array, ‘SELECT c.*, a.n…’) #8 Shopware/Controllers/Frontend/Checkout.php(483): sAdmin->sGetUserData() #9 Shopware/Controllers/Frontend/Checkout.php(73): Shopware_Controllers_Frontend_Checkout->getUserData() #10 Enlight/Controller/Action.php(150): Shopware_Controllers_Frontend_Checkout->preDispatch() #11 Enlight/Controller/Dispatcher/Default.php(528): Enlight_Controller_Action->dispatch(‘cartAction’) #12 Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #13 Shopware/Kernel.php(141): Enlight_Controller_Front->dispatch() #14 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(429): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(329): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #18 Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(193): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 shopware.php(109): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #22 {main} Das Konto wird trotzdem erstellt, auch wenn der Kunde das nicht sieht. Nur bestellen kann er nicht.