# Update Custom Products
**URL:** https://forum.shopware.com/t/update-custom-products/26475
**Category:** Shopware 3.5
**Tags:** administration
**Created:** [24. April 2015 um 16:59 UTC](https://forum.shopware.com/t/update-custom-products/26475 "2015-04-24T16:59:19Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@VolkerSchroder](https://forum.shopware.com/u/VolkerSchroder)
#### Post date: [24. April 2015 um 16:59 UTC](https://forum.shopware.com/t/update-custom-products/26475/1 "2015-04-24T16:59:19Z")
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 😛
---
### Author:  [@VolkerSchroder](https://forum.shopware.com/u/VolkerSchroder)
#### Post date: [24. April 2015 um 20:15 UTC](https://forum.shopware.com/t/update-custom-products/26475/2 "2015-04-24T20:15:02Z")
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]
---
### Author:  [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)
#### Post date: [25. April 2015 um 13:45 UTC](https://forum.shopware.com/t/update-custom-products/26475/3 "2015-04-25T13:45:12Z")
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
---
### Author:  [@VolkerSchroder](https://forum.shopware.com/u/VolkerSchroder)
#### Post date: [25. April 2015 um 16:01 UTC](https://forum.shopware.com/t/update-custom-products/26475/4 "2015-04-25T16:01:53Z")
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…
---
### Author:  [@Arya\_Svitkona](https://forum.shopware.com/u/Arya_Svitkona)
#### Post date: [13. Mai 2016 um 09:21 UTC](https://forum.shopware.com/t/update-custom-products/26475/5 "2016-05-13T09:21:09Z")
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_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