Update auf 18.0.6 gescheitert An unhandled exception has been thrown:

roqon · July 4, 2020, 10:30am

Hi Leute, hab seit Jahren Nextcloud (auf einem Uberspace Account) laufen. Leider nun ein Totalausfall.

Hab über den webupdater 18.0.4 zu 18.0.6 versucht. Das blieb hängen. In der Konsole hatte ich nach dem login die Fehlermeldung php 7.4 sei zu hoch, nur bis 7.3 unsterstützt. Also die php Version gewechselt. Nunmehr der Fehler:

php occ app:list
An unhandled exception has been thrown:
Doctrine\DBAL\DBALException: Failed to connect to the database: An exception occurred in driver: SQLSTATE[HY000] [1045] Access denied for user ‘tralala’@‘localhost’ (using password: YES) in /var/www/virtual/roqon/html/cloud/lib/private/DB/Connection.php:64
Stack trace:
#0 /var/www/virtual/roqon/html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(448): OC\DB\Connection->connect()
#1 /var/www/virtual/roqon/html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(410): Doctrine\DBAL\Connection->getDatabasePlatformVersion()
#2 /var/www/virtual/roqon/html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(354): Doctrine\DBAL\Connection->detectDatabasePlatform()
#3 /var/www/virtual/roqon/html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(710): Doctrine\DBAL\Connection->getDatabasePlatform()
#4 /var/www/virtual/roqon/html/cloud/lib/private/DB/Connection.php(151): Doctrine\DBAL\Connection->setTransactionIsolation(2)
#5 /var/www/virtual/roqon/html/cloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DriverManager.php(181): OC\DB\Connection->__construct(Array, Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#6 /var/www/virtual/roqon/html/cloud/lib/private/DB/ConnectionFactory.php(156): Doctrine\DBAL\DriverManager::getConnection(Array, Object(Doctrine\DBAL\Configuration), Object(Doctrine\Common\EventManager))
#7 /var/www/virtual/roqon/html/cloud/lib/private/Server.php(641): OC\DB\ConnectionFactory->getConnection(‘mysql’, Array)
#8 /var/www/virtual/roqon/html/cloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#9 /var/www/virtual/roqon/html/cloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet(‘OCP\IDBConnecti…’)
#10 /var/www/virtual/roqon/html/cloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query(‘OCP\IDBConnecti…’)
#11 /var/www/virtual/roqon/html/cloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#12 /var/www/virtual/roqon/html/cloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet(‘DatabaseConnect…’)
#13 /var/www/virtual/roqon/html/cloud/lib/private/Server.php(1560): OC\ServerContainer->query(‘DatabaseConnect…’)
#14 /var/www/virtual/roqon/html/cloud/lib/private/Server.php(362): OC\Server->getDatabaseConnection()
#15 /var/www/virtual/roqon/html/cloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#16 /var/www/virtual/roqon/html/cloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet(‘OC\Authenticati…’)
#17 /var/www/virtual/roqon/html/cloud/lib/private/AppFramework/Utility/SimpleContainer.php(68): OC\ServerContainer->query(‘OC\Authenticati…’)
#18 /var/www/virtual/roqon/html/cloud/lib/private/AppFramework/Utility/SimpleContainer.php(98): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#19 /var/www/virtual/roqon/html/cloud/lib/private/AppFramework/Utility/SimpleContainer.php(119): OC\AppFramework\Utility\SimpleContainer->resolve(‘OC\Authenticati…’)
#20 /var/www/virtual/roqon/html/cloud/lib/private/ServerContainer.php(150): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#21 /var/www/virtual/roqon/html/cloud/lib/private/AppFramework/Utility/SimpleContainer.php(68): OC\ServerContainer->query(‘OC\Authenticati…’)
#22 /var/www/virtual/roqon/html/cloud/lib/private/AppFramework/Utility/SimpleContainer.php(98): OC\AppFramework\Utility\SimpleContainer->buildClass(Object(ReflectionClass))
#23 /var/www/virtual/roqon/html/cloud/lib/private/AppFramework/Utility/SimpleContainer.php(119): OC\AppFramework\Utility\SimpleContainer->resolve(‘OC\Authenticati…’)
#24 /var/www/virtual/roqon/html/cloud/lib/private/ServerContainer.php(150): OC\AppFramework\Utility\SimpleContainer->query(‘OC\Authenticati…’)
#25 /var/www/virtual/roqon/html/cloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query(‘OC\Authenticati…’)
#26 /var/www/virtual/roqon/html/cloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#27 /var/www/virtual/roqon/html/cloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet(‘OC\Authenticati…’)
#28 /var/www/virtual/roqon/html/cloud/lib/private/Server.php(374): OC\ServerContainer->query(‘OC\Authenticati…’)
#29 /var/www/virtual/roqon/html/cloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#30 /var/www/virtual/roqon/html/cloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet(‘OC\User\Session’)
#31 /var/www/virtual/roqon/html/cloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query(‘OC\User\Session’)
#32 /var/www/virtual/roqon/html/cloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#33 /var/www/virtual/roqon/html/cloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet(‘UserSession’)
#34 /var/www/virtual/roqon/html/cloud/lib/private/Server.php(1436): OC\ServerContainer->query(‘UserSession’)
#35 /var/www/virtual/roqon/html/cloud/lib/private/Server.php(694): OC\Server->getUserSession()
#36 /var/www/virtual/roqon/html/cloud/3rdparty/pimple/pimple/src/Pimple/Container.php(118): OC\Server->OC{closure}(Object(OC\Server))
#37 /var/www/virtual/roqon/html/cloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet(‘OC\App\AppManag…’)
#38 /var/www/virtual/roqon/html/cloud/lib/private/AppFramework/Utility/SimpleContainer.php(165): OC\ServerContainer->query(‘OC\App\AppManag…’)
#39 /var/www/virtual/roqon/html/cloud/3rdparty/pimple/pimple/src/Pimple/Container.php(114): OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility{closure}(Object(OC\Server))
#40 /var/www/virtual/roqon/html/cloud/lib/private/ServerContainer.php(125): Pimple\Container->offsetGet(‘AppManager’)
#41 /var/www/virtual/roqon/html/cloud/lib/private/Server.php(1731): OC\ServerContainer->query(‘AppManager’)
#42 /var/www/virtual/roqon/html/cloud/lib/private/legacy/app.php(346): OC\Server->getAppManager()
#43 /var/www/virtual/roqon/html/cloud/lib/private/legacy/app.php(114): OC_App::getEnabledApps()
#44 /var/www/virtual/roqon/html/cloud/lib/base.php(640): OC_App::loadApps(Array)
#45 /var/www/virtual/roqon/html/cloud/lib/base.php(1053): OC::init()
#46 /var/www/virtual/roqon/html/cloud/console.php(46): require_once(‘/var/www/virtua…’)
#47 /var/www/virtual/roqon/html/cloud/occ(11): require_once(‘/var/www/virtua…’)

Tja. Und hier bin ich mit meinem Latein am Ende. Kann mir jemand helfen bei der Interpretation des Fehlers und was die nächsten Schritte sind?

Herzlichen Dank schon mal! Roq On

eehmke · July 6, 2020, 4:38pm

Kannst du denn die Datenbank manuell öffnen?

roqon · July 6, 2020, 6:04pm

Hab das o.g. Problem gelöst. Ich hatte an einer gänzlich falschen config.php gebastelt, da es auf dem Server ein altes Verzeichnis mit einer (ungenutzten) Nextcloud Instanz gab.

Jetzt kämpfe ich an

Updating …
Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing ‘UPDATE oc_flow_operations SET entity = ? WHERE entity = ‘’’ with params [“OCA\WorkflowEngine\Entity\File”]:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘entity’ in ‘where clause’

Mal sehen, ob Suchmaschinen was zutage bringen …
Vielen Dank!