Hallo Zusammen,
wenn wir einen Artikel bearbeiten wollen, erscheint folgender Fehler:
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‘SELECT s0_.id AS id_0, s0_.main_detail_id AS main_detail_id_1, s0_.supplierID AS supplierID_2, s0_.taxID AS taxID_3, s0_.pricegroupID AS pricegroupID_4, s0_.filtergroupID AS filtergroupID_5, s0_.configurator_set_id AS configurator_set_id_6, s0_.name AS name_7, s0_.description AS description_8, s0_.description_long AS description_long_9, s0_.datum AS datum_10, s0_.active AS active_11, s0_.pseudosales AS pseudosales_12, s0_.topseller AS topseller_13, s0_.keywords AS keywords_14, s0_.metaTitle AS metaTitle_15, s0_.changetime AS changetime_16, s0_.pricegroupActive AS pricegroupActive_17, s0_.laststock AS laststock_18, s0_.crossbundlelook AS crossbundlelook_19, s0_.notification AS notification_20, s0_.template AS template_21, s0_.mode AS mode_22, s0_.available_from AS available_from_23, s0_.available_to AS available_to_24, s1_.id AS id_25, s1_.articleID AS articleID_26, s1_.unitID AS unitID_27, s1_.ordernumber AS ordernumber_28, s1_.suppliernumber AS suppliernumber_29, s1_.kind AS kind_30, s1_.additionaltext AS additionaltext_31, s1_.active AS active_32, s1_.instock AS instock_33, s1_.stockmin AS stockmin_34, s1_.weight AS weight_35, s1_.width AS width_36, s1_.length AS length_37, s1_.height AS height_38, s1_.ean AS ean_39, s1_.purchaseprice AS purchaseprice_40, s1_.position AS position_41, s1_.minpurchase AS minpurchase_42, s1_.purchasesteps AS purchasesteps_43, s1_.maxpurchase AS maxpurchase_44, s1_.purchaseunit AS purchaseunit_45, s1_.referenceunit AS referenceunit_46, s1_.packunit AS packunit_47, s1_.shippingfree AS shippingfree_48, s1_.releasedate AS releasedate_49, s1_.shippingtime AS shippingtime_50, s2_.id AS id_51, s2_.tax AS tax_52, s2_.description AS description_53, s3_.id AS id_54, s3_.articleID AS articleID_55, s3_.articledetailsID AS articledetailsID_56, s3_.attr1 AS attr1_57, s3_.attr2 AS attr2_58, s3_.attr3 AS attr3_59, s3_.attr4 AS attr4_60, s3_.attr5 AS attr5_61, s3_.attr6 AS attr6_62, s3_.attr7 AS attr7_63, s3_.attr8 AS attr8_64, s3_.attr9 AS attr9_65, s3_.attr10 AS attr10_66, s3_.attr11 AS attr11_67, s3_.attr12 AS attr12_68, s3_.attr13 AS attr13_69, s3_.attr14 AS attr14_70, s3_.attr15 AS attr15_71, s3_.attr16 AS attr16_72, s3_.attr17 AS attr17_73, s3_.attr18 AS attr18_74, s3_.attr19 AS attr19_75, s3_.attr20 AS attr20_76, s3_.motion_article_name AS motion_article_name_77, s3_.viison_storage_location AS viison_storage_location_78, s3_.viison_incoming_stock AS viison_incoming_stock_79, s3_.viison_physical_stock AS viison_physical_stock_80, s3_.viison_not_relevant_for_stock_manager AS viison_not_relevant_for_stock_manager_81, s3_.viison_not_relevant_for_picking AS viison_not_relevant_for_picking_82, s3_.viison_required_information_upon_picking AS viison_required_information_upon_picking_83 FROM s_articles s0_ LEFT JOIN s_articles_details s1_ ON s0_.main_detail_id = s1_.id LEFT JOIN s_core_tax s2_ ON s0_.taxID = s2_.id LEFT JOIN s_articles_attributes s3_ ON s1_.id = s3_.articledetailsID WHERE s0_.id = ?’ with params [“1364”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s3_.motion_article_name’ in ‘field list’ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 119 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), 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(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(739): Doctrine\ORM\AbstractQuery->execute(NULL, 2) #6 engine/Shopware/Controllers/Backend/Article.php(1665): Doctrine\ORM\AbstractQuery->getArrayResult() #7 [internal function]: Shopware_Controllers_Backend_Article->getArticleData(‘1364’) #8 var/cache/production_201607251359/proxies/ShopwareControllersBackendArticleProxy.php(6): call_user_func_array(Array, Array) #9 engine/Library/Enlight/Hook/HookManager.php(187): Shopware_Proxies_ShopwareControllersBackendArticleProxy->executeParent(‘getArticleData’, Array) #10 var/cache/production_201607251359/proxies/ShopwareControllersBackendArticleProxy.php(39): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_ShopwareControllersBackendArticleProxy), ‘getArticleData’, Array) #11 engine/Shopware/Controllers/Backend/Article.php(1968): Shopware_Proxies_ShopwareControllersBackendArticleProxy->getArticleData(‘1364’) #12 engine/Shopware/Controllers/Backend/Article.php(1426): Shopware_Controllers_Backend_Article->getArticle(‘1364’) #13 engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Article->loadStoresAction() #14 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‘loadStoresActio…’) #15 engine/Library/Enlight/Controller/Front.php(226): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #16 engine/Shopware/Kernel.php(176): Enlight_Controller_Front->dispatch() #17 vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #18 engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #19 vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #20 engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #21 shopware.php(101): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #22 {main}
Kann mir da jemand weiter helfen?
Vielen Dank schonmal