Brauche Hilfe An exception occurred while executing

Hallo

Wir brauchen Hilfe bei folgendem Problem

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, s3_.syn_gs_title AS syn_gs_title_64, s3_.syn_gs_description AS syn_gs_description_65, s3_.syn_gs_category AS syn_gs_category_66, s3_.syn_gs_gender AS syn_gs_gender_67, s3_.syn_gs_age_group AS syn_gs_age_group_68, s3_.syn_gs_size AS syn_gs_size_69, s3_.syn_gs_size_type AS syn_gs_size_type_70, s3_.syn_gs_size_system AS syn_gs_size_system_71, s3_.syn_gs_color AS syn_gs_color_72, s3_.syn_gs_energy_efficiency_class AS syn_gs_energy_efficiency_class_73, s3_.syn_gs_adult AS syn_gs_adult_74, s3_.syn_gs_condition AS syn_gs_condition_75, s3_.syn_gs_identifier_exists AS syn_gs_identifier_exists_76, s3_.syn_gs_pattern AS syn_gs_pattern_77, s3_.syn_gs_material AS syn_gs_material_78, s3_.syn_gs_excluded_destination AS syn_gs_excluded_destination_79, s3_.syn_gs_sale_price_effective_begin AS syn_gs_sale_price_effective_begin_80, s3_.syn_gs_sale_price_effective_end AS syn_gs_sale_price_effective_end_81, s3_.syn_gs_custom_label0 AS syn_gs_custom_label0_82, s3_.syn_gs_custom_label1 AS syn_gs_custom_label1_83, s3_.syn_gs_custom_label2 AS syn_gs_custom_label2_84, s3_.syn_gs_custom_label3 AS syn_gs_custom_label3_85, s3_.syn_gs_custom_label4 AS syn_gs_custom_label4_86, s4_.id AS id_87, s4_.template_price_id AS template_price_id_88 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 [„9571“]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s3_.syn_gs_title‘ 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(1936): Doctrine\ORM\AbstractQuery->getArrayResult() #7 engine/Shopware/Controllers/Backend/Article.php(1994): Shopware_Controllers_Backend_Article->getArticleConfiguratorTemplate(‚9571‘, Array) #8 engine/Shopware/Controllers/Backend/Article.php(1428): Shopware_Controllers_Backend_Article->getArticle(‚9571‘) #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(180): 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}  

 

 

 

Hallo,

der Fehler steht doch deutlich da: "Column not found: 1054 Unknown column ‚s3_. syn_gs_title‘ in ‚field list‘ ". Da dies kein Standardfeld ist, erzeugt den Fehler ein installiertes Plugin.

Beste Grüße

Sebastian

Hallo

 

Erst mal Danke .

Allerdings habe ich keinen Schimmer welches, denn gestern ging noch alles und wir haben keine update etc gemacht.

Hab jetzt auch fast alles deaktiviert, ohne Änderung

@HausundSicherheit schrieb:

Hallo

 

Erst mal Danke .

Allerdings habe ich keinen Schimmer welches, denn gestern ging noch alles und wir haben keine update etc gemacht.

Hab jetzt auch fast alles deaktiviert, ohne Änderung

Hallo,

hast du das Shopware - Plugin „Google Shopping Professional“ aktiv?

Beste Grüße

Sebastian

Nein

Hallo,

kann es sein, das du das Plugin einmal aktiv oder installiert hattest? Der Feldname syn_gs_title deutet nämlich darauf hin, weil syn = SYNERGY NETWORKS GmbH, gs = Google Shopping und dazu kommt nach deinem fehlenden Feld genau die Felder, die das Plugin alle besitzt. Ich gehe also davon aus, das du das Plugin einmal bei dir installiert hattest und dieses fehlerhaft deinstalliert wurde, sodass das Plugin nun deinstalliert ist, aber das System immernoch denkt, dass die Felder da sind.

Welche Shopware - Version ist bei dir im Einsatz? Wenn über Shopware 5.2, kannst du ja mal in der Freitextfelder-Verwaltung das Model vom Artikel neu generieren lassen und danach den kompletten Shop Cache (also inklusive Theme- und Backend-Cache) leeren.

Beste Grüße

Sebastian

1 „Gefällt mir“

Hallo

 

Was immer es auch war…habe auf 5.2.21 aktualisiert…Jetzt ist der Fehler weg.

 

Danke fuer Tipps und Zeit

“Brauche Hilfe” ist als Titel übrigens sehr dürftig…
Man sollte wenigstens anreissen worum es geht.