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),
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 ADDdefault_value VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;
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) #