# Fehler nach erfolgter Installation /Update **URL:** \ **Category:** Installation/Einstieg\ **Created:** [18. Januar 2017 um 10:23 UTC](https://forum.shopware.com/t/fehler-nach-erfolgter-installation-update/42890 "2017-01-18T10:23:51Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![madunus](https://avatars.discourse-cdn.com/v4/letter/m/ecae2f/32.png) [@madunus](https://forum.shopware.com/u/madunus)\ **Post date:** [18. Januar 2017 um 10:23 UTC](https://forum.shopware.com/t/fehler-nach-erfolgter-installation-update/42890/1 "2017-01-18T10:23:51Z")
Habe folgenden Fehler beim Aufruf im Backend . Erscheint beim Aufruf Kunde oder Artikel anlegen. Hat hier jemand eine Idee was das sein könnte ?   Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‘SELECT s0\_.id AS id\_0, s0\_.table\_name AS table\_name\_1, s0\_.column\_name AS column\_name\_2, s0\_.column\_type AS column\_type\_3, s0\_.default\_value AS default\_value\_4, s0\_.entity AS entity\_5, s0\_.label AS label\_6, s0\_.help\_text AS help\_text\_7, s0\_.support\_text AS support\_text\_8, s0\_.translatable AS translatable\_9, s0\_.display\_in\_backend AS display\_in\_backend\_10, s0\_.custom AS custom\_11, s0\_.position AS position\_12, s0\_.array\_store AS array\_store\_13 FROM s\_attribute\_configuration s0\_ WHERE s0\_.table\_name = ? ORDER BY s0\_.position ASC’ with params [“s\_user\_attributes”]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘s0\_.default\_value’ 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/Bundle/AttributeBundle/Service/CrudService.php(289): Doctrine\ORM\AbstractQuery-\>getArrayResult() #7 engine/Shopware/Bundle/AttributeBundle/Service/CrudService.php(187): Shopware\Bundle\AttributeBundle\Service\CrudService-\>getTableConfiguration(‘s\_user\_attribut…’) #8 engine/Shopware/Bundle/AttributeBundle/Controllers/Backend/AttributeData.php(93): Shopware\Bundle\AttributeBundle\Service\CrudService-\>getList(‘s\_user\_attribut…’) #9 engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_AttributeData-\>listAction() #10 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‘listAction’) #11 engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), ---
**Author:** ![JanineOverhausKocan](https://avatars.discourse-cdn.com/v4/letter/j/65b543/32.png) [@JanineOverhausKocan](https://forum.shopware.com/u/JanineOverhausKocan)\ **Post date:** [18. Januar 2017 um 12:55 UTC](https://forum.shopware.com/t/fehler-nach-erfolgter-installation-update/42890/2 "2017-01-18T12:55:22Z")
Hallo, da fehlt die Spalte default\_value in der Tabelle s\_attribute\_configuration. Vermutlich konnte das Update nicht ganz durchgeführt werden, schau mal ob in der s\_schema\_version Tabelle eine Meldung in der Error-Spalte zu finden ist. Ansonsten kannst du die Spalte über das folgende Insert-Query selbst anlegen: ALTER TABLE `s_attribute_configuration` ADD`default_value` VARCHAR(500) CHARACTER SET utf8 COLLATE utf8\_unicode\_ci NULL DEFAULT NULL; Viele Grüße aus Schöppingen Janine   ---
**Author:** ![madunus](https://avatars.discourse-cdn.com/v4/letter/m/ecae2f/32.png) [@madunus](https://forum.shopware.com/u/madunus)\ **Post date:** [18. Januar 2017 um 14:35 UTC](https://forum.shopware.com/t/fehler-nach-erfolgter-installation-update/42890/3 "2017-01-18T14:35:37Z")
Hallo   In der Error spalte ist alles OK da steht überall Null drin.   Die  Spalte default\_value fehlt aber tatsächlich in der s\_attribute\_configuration.   Da ich aber nicht verstehe wie die Spalte eingefügt werden muss, muss ich mich hier erst mal einlesen. ---
**Author:** ![madunus](https://avatars.discourse-cdn.com/v4/letter/m/ecae2f/32.png) [@madunus](https://forum.shopware.com/u/madunus)\ **Post date:** [19. Januar 2017 um 16:27 UTC](https://forum.shopware.com/t/fehler-nach-erfolgter-installation-update/42890/4 "2017-01-19T16:27:23Z")
Ok das obere habe ich hinbekommen.   Jetzt noch die Kunden, da hab ich auch nen Fehler. Das dürfte die s\_user\_billingadress s2 sein  und dort customernumber in field list in Was muss ich da genau ergänzen ?   Was muss da genau eingetragen werden ? Danke     Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‚SELECT s0\_.id AS id\_0, s0\_.customernumber AS customernumber\_1, s0\_.firstname AS firstname\_2, s0\_.firstlogin AS firstlogin\_3, s0\_.lastname AS lastname\_4, s0\_.accountmode AS accountmode\_5, s1\_.description AS description\_6, s2\_.company AS company\_7, s2\_.zipcode AS zipcode\_8, s2\_.city AS city\_9, COUNT(s3\_.id) AS sclr\_10, SUM(s3\_.invoice\_amount) AS sclr\_11 FROM s\_user s0\_ INNER JOIN s\_user\_billingaddress s2\_ ON s0\_.id = s2\_.userID LEFT JOIN s\_core\_customergroups s1\_ ON s0\_.customergroup = s1\_.groupkey LEFT JOIN s\_order s3\_ ON s0\_.id = s3\_.userID AND (s3\_.status \<\> -1 AND s3\_.status \<\> 4) GROUP BY s0\_.id ORDER BY s0\_.id DESC LIMIT 15 OFFSET 0‘: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s0\_.customernumber‘ 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/Customer.php(284): Doctrine\ORM\AbstractQuery-\>getArrayResult() #7 engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Customer-\>getListAction() #8 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‚getListAction‘) #9 engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #10 engine/Shopware/Kernel.php(179): Enlight\_Controller\_Front-\>dispatch() #11 vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) # ---
**Author:** ![madunus](https://avatars.discourse-cdn.com/v4/letter/m/ecae2f/32.png) [@madunus](https://forum.shopware.com/u/madunus)\ **Post date:** [21. Januar 2017 um 06:55 UTC](https://forum.shopware.com/t/fehler-nach-erfolgter-installation-update/42890/5 "2017-01-21T06:55:53Z")
Kann mir keiner helfen ? Wäre für eine Antwort dankbar.