Hallo zusammen,
im Backend bei der Benutzerverwaltung erhalten wir seit heute folgende Fehlermeldung:
Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.
An exception occurred while executing ‚SELECT s0_.id AS id_0, s0_.roleID AS roleID_1, s0_.localeID AS localeID_2, s0_.username AS username_3, s0_.password AS password_4, s0_.encoder AS encoder_5, s0_.apiKey AS apiKey_6, s0_.sessionID AS sessionID_7, s0_.lastlogin AS lastlogin_8, s0_.name AS name_9, s0_.email AS email_10, s0_.active AS active_11, s0_.failedlogins AS failedlogins_12, s0_.lockeduntil AS lockeduntil_13, s0_.extended_editor AS extended_editor_14, s0_.disabled_cache AS disabled_cache_15, s1_.id AS id_16, s1_.authID AS authID_17, s1_.mittwald_yubikey AS mittwald_yubikey_18 FROM s_core_auth s0_ LEFT JOIN s_core_auth_attributes s1_ ON s0_.id = s1_.authID WHERE s0_.id = ?‘ with params [„59“]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚s1_.mittwald_yubikey‘ 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(766): Doctrine\ORM\AbstractQuery->execute(NULL, 2) #6 engine/Shopware/Controllers/Backend/UserManager.php(108): Doctrine\ORM\AbstractQuery->getOneOrNullResult(2) #7 engine/Library/Enlight/Controller/Action.php(159): Shopware_Controllers_Backend_UserManager->getUserDetailsAction() #8 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch(‚getUserDetailsA…‘) #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(177): Enlight_Controller_Front->dispatch() #11 vendor/symfony/http-kernel/HttpCache/HttpCache.php(487):
Einloggen ins Backend funktioniert einwandfrei, der Benutzer lässt sich jedoch nicht editieren. Auch der API-Zugriff der Warenwirtschaft funktioniert so nicht.
Hat jemand eine Lösung für das Problem (ggf. über Datenbankeingriff)?!