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),
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 ADDdefault_value VARCHAR(500) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;
Viele Grüße aus Schöppingen
Janine
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.
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) #
Kann mir keiner helfen ?
Wäre für eine Antwort dankbar.