Hallo, leider erhalte ich die folgende Fehlermeldung wenn ich im Backend die Artikeldetails aufrufen möchte?
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‘SELECT s0_.id AS id_0, s0_.article_id AS article_id_1, s0_.unit_id AS unit_id_2, s0_.order_number AS order_number_3, s0_.suppliernumber AS suppliernumber_4, s0_.additionaltext AS additionaltext_5, s0_.active AS active_6, s0_.instock AS instock_7, s0_.stockmin AS stockmin_8, s0_.weight AS weight_9, s0_.width AS width_10, s0_.length AS length_11, s0_.height AS height_12, s0_.ean AS ean_13, s0_.purchaseprice AS purchaseprice_14, s0_.position AS position_15, s0_.minpurchase AS minpurchase_16, s0_.purchasesteps AS purchasesteps_17, s0_.maxpurchase AS maxpurchase_18, s0_.purchaseunit AS purchaseunit_19, s0_.referenceunit AS referenceunit_20, s0_.packunit AS packunit_21, s0_.shippingfree AS shippingfree_22, s0_.releasedate AS releasedate_23, s0_.shippingtime AS shippingtime_24, s1_.id AS id_25, s1_.template_id AS template_id_26, s1_.customer_group_key AS customer_group_key_27, s1_.from AS from_28, s1_.to AS to_29, s1_.price AS price_30, s1_.pseudoprice AS pseudoprice_31, s1_.percent AS percent_32, s2_.id AS id_33, s2_.groupkey AS groupkey_34, s2_.description AS description_35, s2_.tax AS tax_36, s2_.taxinput AS taxinput_37, s2_.mode AS mode_38, s2_.discount AS discount_39, s2_.minimumorder AS minimumorder_40, s2_.minimumordersurcharge AS minimumordersurcharge_41, s3_.id AS id_42, s3_.template_id AS template_id_43, s3_.attr1 AS attr1_44, s3_.attr2 AS attr2_45, s3_.attr3 AS attr3_46, s3_.attr4 AS attr4_47, s3_.attr5 AS attr5_48, s3_.attr6 AS attr6_49, s3_.attr7 AS attr7_50, s3_.attr8 AS attr8_51, s3_.attr9 AS attr9_52, s3_.attr10 AS attr10_53, s3_.attr11 AS attr11_54, s3_.attr12 AS attr12_55, s3_.attr13 AS attr13_56, s3_.attr14 AS attr14_57, s3_.attr15 AS attr15_58, s3_.attr16 AS attr16_59, s3_.attr17 AS attr17_60, s3_.attr18 AS attr18_61, s3_.attr19 AS attr19_62, s3_.attr20 AS attr20_63, s4_.id AS id_64, s4_.template_price_id AS template_price_id_65 FROM s_article_configurator_templates s0_ LEFT JOIN s_article_configurator_template_prices s1_ ON s0_.id = s1_.template_id LEFT JOIN s_core_customergroups s2_ ON s1_.customer_group_key = s2_.groupkey LEFT JOIN s_article_configurator_templates_attributes s3_ ON s0_.id = s3_.template_id LEFT JOIN s_article_configurator_template_prices_attributes s4_ ON s1_.id = s4_.template_price_id WHERE s0_.article_id = ?’ with params [“4270”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s0_.purchaseprice’ 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(1934): Doctrine\ORM\AbstractQuery->getArrayResult() #7 engine/Shopware/Controllers/Backend/Article.php(1992): Shopware_Controllers_Backend_Article->getArticleConfiguratorTemplate(‘4270’, Array) #8 engine/Shopware/Controllers/Backend/Article.php(1426): Shopware_Controllers_Backend_Article->getArticle(‘4270’) #9 engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_Article->loadStoresAction() #10 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‘loadStoresActio…’) #11 engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #12 engine/Shopware/Kernel.php(179): Enlight_Controller_Front->dispatch() #13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #15 vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #17 shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #18 {main}
Und wenn ich einen neuen Artikel anlegen/speichern möchte komm diese Fehlermeldung:
Fehlgeschlagen
Während des Speicherns ist ein Fehler aufgetreten:An exception occurred while executing ‘SELECT s0_.id AS id_0, s0_.article_id AS article_id_1, s0_.unit_id AS unit_id_2, s0_.order_number AS order_number_3, s0_.suppliernumber AS suppliernumber_4, s0_.additionaltext AS additionaltext_5, s0_.active AS active_6, s0_.instock AS instock_7, s0_.stockmin AS stockmin_8, s0_.weight AS weight_9, s0_.width AS width_10, s0_.length AS length_11, s0_.height AS height_12, s0_.ean AS ean_13, s0_.purchaseprice AS purchaseprice_14, s0_.position AS position_15, s0_.minpurchase AS minpurchase_16, s0_.purchasesteps AS purchasesteps_17, s0_.maxpurchase AS maxpurchase_18, s0_.purchaseunit AS purchaseunit_19, s0_.referenceunit AS referenceunit_20, s0_.packunit AS packunit_21, s0_.shippingfree AS shippingfree_22, s0_.releasedate AS releasedate_23, s0_.shippingtime AS shippingtime_24, s1_.id AS id_25, s1_.template_id AS template_id_26, s1_.customer_group_key AS customer_group_key_27, s1_.from AS from_28, s1_.to AS to_29, s1_.price AS price_30, s1_.pseudoprice AS pseudoprice_31, s1_.percent AS percent_32, s2_.id AS id_33, s2_.groupkey AS groupkey_34, s2_.description AS description_35, s2_.tax AS tax_36, s2_.taxinput AS taxinput_37, s2_.mode AS mode_38, s2_.discount AS discount_39, s2_.minimumorder AS minimumorder_40, s2_.minimumordersurcharge AS minimumordersurcharge_41, s3_.id AS id_42, s3_.template_id AS template_id_43, s3_.attr1 AS attr1_44, s3_.attr2 AS attr2_45, s3_.attr3 AS attr3_46, s3_.attr4 AS attr4_47, s3_.attr5 AS attr5_48, s3_.attr6 AS attr6_49, s3_.attr7 AS attr7_50, s3_.attr8 AS attr8_51, s3_.attr9 AS attr9_52, s3_.attr10 AS attr10_53, s3_.attr11 AS attr11_54, s3_.attr12 AS attr12_55, s3_.attr13 AS attr13_56, s3_.attr14 AS attr14_57, s3_.attr15 AS attr15_58, s3_.attr16 AS attr16_59, s3_.attr17 AS attr17_60, s3_.attr18 AS attr18_61, s3_.attr19 AS attr19_62, s3_.attr20 AS attr20_63, s4_.id AS id_64, s4_.template_price_id AS template_price_id_65 FROM s_article_configurator_templates s0_ LEFT JOIN s_article_configurator_template_prices s1_ ON s0_.id = s1_.template_id LEFT JOIN s_core_customergroups s2_ ON s1_.customer_group_key = s2_.groupkey LEFT JOIN s_article_configurator_templates_attributes s3_ ON s0_.id = s3_.template_id LEFT JOIN s_article_configurator_template_prices_attributes s4_ ON s1_.id = s4_.template_price_id WHERE s0_.article_id = ?’ with params [4272]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s0_.purchaseprice’ in ‘field list’
Was kann das Problem sein? Fehlen vieleicht die Tabelen/Daten in der myphp Datenbank?
