Ich hab jetzt die Custom Products von 1.2.2 auf 1.3.0 upgedatet. Direkt hat das nicht funktioniert. Daher habe ich die 1.2.2 gelöscht und die 1.3.0 neu eingespielt. Wenn ich das jetzt aktiviere bekomme ich bei den Artikeln “Ups! Ein Fehler ist aufgetreten! Wir wurden bereits über das Problem informiert und arbeiten an einer Lösung, bitte versuchen Sie es in Kürze erneut.” Hat jemand ne Idee??? Ich würde das gerne vor dem Wochenende wieder ans Laufen bringen 
Hier ein Auszug aus dem Log: Hilft das? [quote]Next exception ‘Doctrine\DBAL\DBALException’ with message ‘An exception occurred while executing ‘SELECT s0_.id AS id0, s0_.name AS name1, s0_.show_name AS show_name2, s0_.description AS description3, s0_.show_description AS show_description4, s0_.active AS active5, s0_.added AS added6, s0_.changed AS changed7, s0_.image_path AS image_path8, s0_.show_group_image AS show_group_image9, s1_.id AS id10, s1_.name AS name11, s1_.number AS number12, s1_.required AS required13, s1_.active AS active14, s1_.position AS position15, s1_.group_id AS group_id16, s1_.type_id AS type_id17, s1_.validators AS validators18, s1_.default_value AS default_value19, s1_.empty_text AS empty_text20, s1_.max_uploads AS max_uploads21, s2_.id AS id22, s2_.name AS name23, s2_.type AS type24, s2_.parent_id AS parent_id25, s3_.id AS id26, s3_.value AS value27, s3_.description AS description28, s3_.number AS number29, s3_.position AS position30 FROM s_plugin_customizing_groups s0_ INNER JOIN s_plugin_customizing_options s1_ ON s0_.id = s1_.group_id AND (s1_.active = 1) INNER JOIN s_plugin_customizing_types s2_ ON s1_.type_id = s2_.id LEFT JOIN s_plugin_customizing_values s3_ ON s1_.id = s3_.option_id INNER JOIN s_plugin_customizing_articles s5_ ON s0_.id = s5_.group_id INNER JOIN s_articles s4_ ON s4_.id = s5_.article_id AND (s4_.id = ?) WHERE s0_.active = 1 ORDER BY s1_.position ASC, s1_.id ASC, s3_.position ASC, s3_.id ASC’ with params [“2423”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s0_.show_name’ in ‘field list’’ in /home/www/p201814/html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91 Stack trace: #0 /home/www/p201814/html/shopware/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(701): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(PDOException), ‘SELECT s0_.id A…’, Array) #1 /home/www/p201814/html/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection->executeQuery(‘SELECT s0_.id A…’, Array, Array, NULL) #2 /home/www/p201814/html/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(286): Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 /home/www/p201814/html/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(794): Doctrine\ORM\Query->_doExecute() #4 /home/www/p201814/html/shopware/vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(612): Doctrine\ORM\AbstractQuery->execute(NULL, 2) #5 /home/www/p201814/html/shopware/engine/Shopware/Plugins/Community/Frontend/SwagCustomizing/Models/Customizing/Repository.php(64): Doctrine\ORM\AbstractQuery->getOneOrNullResult() #6 /home/www/p201814/html/shopware/engine/Shopware/Plugins/Community/Frontend/SwagCustomizing/Subscriber/Frontend.php(75): Shopware\CustomModels\Customizing\Repository->getGroupByArticleId() #7 [internal function]: Shopware\SwagCustomizing\Subscriber\Frontend->onPostDispatchFrontendDetail(Object(Enlight_Controller_ActionEventArgs)) #8 /home/www/p201814/html/shopware/engine/Library/Enlight/Event/Handler/Default.php(91): call_user_func(Array, Object(Enlight_Controller_ActionEventArgs)) #9 /home/www/p201814/html/shopware/engine/Library/Enlight/Event/EventManager.php(211): Enlight_Event_Handler_Default->execute(Object(Enlight_Controller_ActionEventArgs)) #10 /home/www/p201814/html/shopware/engine/Library/Enlight/Controller/Action.php(192): Enlight_Event_EventManager->notify(‘Enlight_Control…’, Object(Enlight_Controller_ActionEventArgs)) #11 /home/www/p201814/html/shopware/engine/Library/Enlight/Controller/Dispatcher/Default.php(528): Enlight_Controller_Action->dispatch(‘indexAction’) #12 /home/www/p201814/html/shopware/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #13 /home/www/p201814/html/shopware/engine/Shopware/Kernel.php(141): Enlight_Controller_Front->dispatch() #14 /home/www/p201814/html/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(472): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 /home/www/p201814/html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 /home/www/p201814/html/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(429): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 /home/www/p201814/html/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(329): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true) #18 /home/www/p201814/html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 /home/www/p201814/html/shopware/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(193): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true) #20 /home/www/p201814/html/shopware/engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #21 /home/www/p201814/html/shopware/shopware.php(109): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #22 {main} {“uid”:“981352b”} [/quote]
Hallo Volker, die Fehlermeldung ließt sich erstmal so, als wäre beim Update eine Spalte in der Datenbank nicht angelegt worden. Folgende Spalten wurden mit 4.3.3 angelegt: ALTER TABLE s_plugin_customizing_groups ADD COLUMN show_name INT(1) UNSIGNED NOT NULL ALTER TABLE s_plugin_customizing_groups ADD COLUMN show_description INT(1) UNSIGNED NOT NULL ALTER TABLE s_plugin_customizing_groups ADD COLUMN image_path VARCHAR(255) ALTER TABLE s_plugin_customizing_groups ADD COLUMN show_group_image INT(1) UNSIGNED NOT NULL ALTER TABLE s_plugin_customizing_options ADD COLUMN max_uploads INT( 11 ) UNSIGNED NULL Am besten schaust du erstmal nach ob alle diese Spalten auch in der Tabelle s_plugin_customizing_groups vorhanden sind und legst diese ggf. sonst über die Querries oben an. Grüße Moritz
1 „Gefällt mir“
Hallo Moritz, Vielen Dank 
:thumbup: und das am Wochenende Problem ist gelöst Ich würde gerne die Aufschlaege anzeigen lassen. Dazu habe ich dies im Backend auf “ja” gestellt. Aber irgendwie werden die jetzt doppelt angezeigt…
Bestätige hier, dass es ein Problem gibt von SW4 auf SW5 mit dem Custom Products Plugin.
Auch wenn ich dieses erneut Installiere (Neuinstallation) fand Shopware/das Plugin die Spalte „show_name“ nicht.
Lösung: Datenbank backup machen - 5 Tabellen (sind es glaube ich) zum Plugin löschen und das Plugin neu installieren
Lösung2: Datenbank backup machen - Query von SW Support ausführen
->
ALTER TABLE
s_plugin_customizing_groupsADD COLUMNshow_nameINT(1) UNSIGNED NOT NULL
ALTER TABLEs_plugin_customizing_groupsADD COLUMNshow_descriptionINT(1) UNSIGNED NOT NULL
ALTER TABLEs_plugin_customizing_groupsADD COLUMNimage_pathVARCHAR(255)
ALTER TABLEs_plugin_customizing_groupsADD COLUMNshow_group_imageINT(1) UNSIGNED NOT NULL
ALTER TABLEs_plugin_customizing_optionsADD COLUMNmax_uploadsINT( 11 ) UNSIGNED NULL