Update to 30.0.0 beta 4 trouble with photos app

ℹ️ Support
, ,
1

my web update failed on the “start update” button after the web updater ran though it’s commands. It stated the photos app was to blame. I ran occ app:disable photos and the install continued.

using apache in ubuntu 24.04 php 8.3

2

Do you have the exact error or the log entries from that period of time?

3

I believe these are the relavant log entries…

{“reqId”:“yqBWQwQXSAUudENyogav”,“level”:3,“time”:“2024-08-07T18:01:48-04:00”,“remoteAddr”:“74.15.251.27”,“user”:“–”,“app”:“no app in context”,“method”:“GET”,“url”:“/core/ajax/update.php?requesttoken=Skmxo2Du5IjamDZcbVOONx8eYrOgupY%2FibfWAW4uGNg%3D%3AMx7nyTig1vHp8FtoGAnqY1d1KovawsVK58W1MkVkXrI%3D”,“message”:“Database error when running migration 30000Date20240417075404 for app photos\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1093 You can’t specify target table ‘oc_preferences’ for update in FROM clause”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36 Edg/127.0.0.0”,“version”:“30.0.0.5”,“exception”:{“Exception”:“Exception”,“Message”:“Database error when running migration 30000Date20240417075404 for app photos\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1093 You can’t specify target table ‘oc_preferences’ for update in FROM clause”,“Code”:0,“Trace”:[{“file”:“/var/www/nextcloud/lib/private/legacy/OC_App.php”,“line”:736,“function”:“migrate”,“class”:“OC\DB\MigrationService”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Updater.php”,“line”:320,“function”:“updateApp”,“class”:“OC_App”,“type”:“::”,“args”:[“*** sensitive parameters replaced “]},{“file”:”/var/www/nextcloud/lib/private/Updater.php",“line”:231,“function”:“doAppUpgrade”,“class”:“OC\Updater”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Updater.php”,“line”:98,“function”:“doUpgrade”,“class”:“OC\Updater”,“type”:“->”},{“file”:“/var/www/nextcloud/core/ajax/update.php”,“line”:168,“function”:“upgrade”,“class”:“OC\Updater”,“type”:“->”}],“File”:“/var/www/nextcloud/lib/private/DB/MigrationService.php”,“Line”:391,“Previous”:{“Exception”:“OC\DB\Exceptions\DbalException”,“Message”:“An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1093 You can’t specify target table ‘oc_preferences’ for update in FROM clause”,“Code”:1093,“Trace”:[{“file”:“/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php”,“line”:67,“function”:“wrap”,“class”:“OC\DB\Exceptions\DbalException”,“type”:“::”},{“file”:“/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:288,“function”:“executeStatement”,“class”:“OC\DB\ConnectionAdapter”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/photos/lib/Migration/Version30000Date20240417075404.php”,“line”:45,“function”:“executeStatement”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/MigrationService.php”,“line”:512,“function”:“postSchemaChange”,“class”:“OCA\Photos\Migration\Version30000Date20240417075404”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/MigrationService.php”,“line”:387,“function”:“executeStep”,“class”:“OC\DB\MigrationService”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/legacy/OC_App.php”,“line”:736,“function”:“migrate”,“class”:“OC\DB\MigrationService”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Updater.php”,“line”:320,“function”:“updateApp”,“class”:“OC_App”,“type”:“::”,“args”:[" sensitive parameters replaced “]},{“file”:”/var/www/nextcloud/lib/private/Updater.php",“line”:231,“function”:“doAppUpgrade”,“class”:“OC\Updater”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Updater.php”,“line”:98,“function”:“doUpgrade”,“class”:“OC\Updater”,“type”:“->”},{“file”:“/var/www/nextcloud/core/ajax/update.php”,“line”:168,“function”:“upgrade”,“class”:“OC\Updater”,“type”:“->”}],“File”:“/var/www/nextcloud/lib/private/DB/Exceptions/DbalException.php”,“Line”:54,“Previous”:{“Exception”:“Doctrine\DBAL\Exception\DriverException”,“Message”:“An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1093 You can’t specify target table ‘oc_preferences’ for update in FROM clause”,“Code”:1093,“Trace”:[{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1943,“function”:“convert”,“class”:“Doctrine\DBAL\Driver\API\MySQL\ExceptionConverter”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1885,“function”:“handleDriverException”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1213,“function”:“convertExceptionDuringQuery”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php”,“line”:292,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/Connection.php”,“line”:359,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connections\PrimaryReadReplicaConnection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php”,“line”:65,“function”:“executeStatement”,“class”:“OC\DB\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:288,“function”:“executeStatement”,“class”:“OC\DB\ConnectionAdapter”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/photos/lib/Migration/Version30000Date20240417075404.php”,“line”:45,“function”:“executeStatement”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/MigrationService.php”,“line”:512,“function”:“postSchemaChange”,“class”:“OCA\Photos\Migration\Version30000Date20240417075404”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/MigrationService.php”,“line”:387,“function”:“executeStep”,“class”:“OC\DB\MigrationService”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/legacy/OC_App.php”,“line”:736,“function”:“migrate”,“class”:“OC\DB\MigrationService”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Updater.php”,“line”:320,“function”:“updateApp”,“class”:“OC_App”,“type”:“::”,“args”:[" sensitive parameters replaced “]},{“file”:”/var/www/nextcloud/lib/private/Updater.php",“line”:231,“function”:“doAppUpgrade”,“class”:“OC\Updater”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Updater.php”,“line”:98,“function”:“doUpgrade”,“class”:“OC\Updater”,“type”:“->”},{“file”:“/var/www/nextcloud/core/ajax/update.php”,“line”:168,“function”:“upgrade”,“class”:“OC\Updater”,“type”:“->”}],“File”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php”,“Line”:117,“Previous”:{“Exception”:“Doctrine\DBAL\Driver\PDO\Exception”,“Message”:“SQLSTATE[HY000]: General error: 1093 You can’t specify target table ‘oc_preferences’ for update in FROM clause”,“Code”:1093,“Trace”:[{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php”,“line”:39,“function”:“new”,“class”:“Doctrine\DBAL\Driver\PDO\Exception”,“type”:“::”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1211,“function”:“exec”,“class”:“Doctrine\DBAL\Driver\PDO\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php”,“line”:292,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/Connection.php”,“line”:359,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connections\PrimaryReadReplicaConnection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php”,“line”:65,“function”:“executeStatement”,“class”:“OC\DB\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:288,“function”:“executeStatement”,“class”:“OC\DB\ConnectionAdapter”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/photos/lib/Migration/Version30000Date20240417075404.php”,“line”:45,“function”:“executeStatement”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/MigrationService.php”,“line”:512,“function”:“postSchemaChange”,“class”:“OCA\Photos\Migration\Version30000Date20240417075404”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/MigrationService.php”,“line”:387,“function”:“executeStep”,“class”:“OC\DB\MigrationService”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/legacy/OC_App.php”,“line”:736,“function”:“migrate”,“class”:“OC\DB\MigrationService”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Updater.php”,“line”:320,“function”:“updateApp”,“class”:“OC_App”,“type”:“::”,“args”:[" sensitive parameters replaced “]},{“file”:”/var/www/nextcloud/lib/private/Updater.php",“line”:231,“function”:“doAppUpgrade”,“class”:“OC\Updater”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Updater.php”,“line”:98,“function”:“doUpgrade”,“class”:“OC\Updater”,“type”:“->”},{“file”:“/var/www/nextcloud/core/ajax/update.php”,“line”:168,“function”:“upgrade”,“class”:“OC\Updater”,“type”:“->”}],“File”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php”,“Line”:28,“Previous”:{“Exception”:“PDOException”,“Message”:“SQLSTATE[HY000]: General error: 1093 You can’t specify target table ‘oc_preferences’ for update in FROM clause”,“Code”:“HY000”,“Trace”:[{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php”,“line”:33,“function”:“exec”,“class”:“PDO”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php”,“line”:1211,“function”:“exec”,“class”:“Doctrine\DBAL\Driver\PDO\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php”,“line”:292,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/Connection.php”,“line”:359,“function”:“executeStatement”,“class”:“Doctrine\DBAL\Connections\PrimaryReadReplicaConnection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php”,“line”:65,“function”:“executeStatement”,“class”:“OC\DB\Connection”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php”,“line”:288,“function”:“executeStatement”,“class”:“OC\DB\ConnectionAdapter”,“type”:“->”},{“file”:“/var/www/nextcloud/apps/photos/lib/Migration/Version30000Date20240417075404.php”,“line”:45,“function”:“executeStatement”,“class”:“OC\DB\QueryBuilder\QueryBuilder”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/MigrationService.php”,“line”:512,“function”:“postSchemaChange”,“class”:“OCA\Photos\Migration\Version30000Date20240417075404”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/DB/MigrationService.php”,“line”:387,“function”:“executeStep”,“class”:“OC\DB\MigrationService”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/legacy/OC_App.php”,“line”:736,“function”:“migrate”,“class”:“OC\DB\MigrationService”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Updater.php”,“line”:320,“function”:“updateApp”,“class”:“OC_App”,“type”:“::”,“args”:[" sensitive parameters replaced ***”]},{“file”:“/var/www/nextcloud/lib/private/Updater.php”,“line”:231,“function”:“doAppUpgrade”,“class”:“OC\Updater”,“type”:“->”},{“file”:“/var/www/nextcloud/lib/private/Updater.php”,“line”:98,“function”:“doUpgrade”,“class”:“OC\Updater”,“type”:“->”},{“file”:“/var/www/nextcloud/core/ajax/update.php”,“line”:168,“function”:“upgrade”,“class”:“OC\Updater”,“type”:“->”}],“File”:“/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php”,“Line”:33}}}},“message”:“Database error when running migration 30000Date20240417075404 for app photos\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1093 You can’t specify target table ‘oc_preferences’ for update in FROM clause”,“exception”:{},“CustomMessage”:“Database error when running migration 30000Date20240417075404 for app photos\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1093 You can’t specify target table ‘oc_preferences’ for update in FROM clause”}}
{“reqId”:“yqBWQwQXSAUudENyogav”,“level”:3,“time”:“2024-08-07T18:01:48-04:00”,“remoteAddr”:“74.15.251.27”,“user”:“–”,“app”:“updater”,“method”:“GET”,“url”:“/core/ajax/update.php?requesttoken=Skmxo2Du5IjamDZcbVOONx8eYrOgupY%2FibfWAW4uGNg%3D%3AMx7nyTig1vHp8FtoGAnqY1d1KovawsVK58W1MkVkXrI%3D”,“message”:“\OC\Updater::failure: Exception: Database error when running migration 30000Date20240417075404 for app photos\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1093 You can’t specify target table ‘oc_preferences’ for update in FROM clause”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36 Edg/127.0.0.0”,“version”:“30.0.0.5”,“data”:{“app”:“updater”}}
{“reqId”:“yqBWQwQXSAUudENyogav”,“level”:3,“time”:“2024-08-07T18:01:48-04:00”,“remoteAddr”:“74.15.251.27”,“user”:“–”,“app”:“updater”,“method”:“GET”,“url”:“/core/ajax/update.php?requesttoken=Skmxo2Du5IjamDZcbVOONx8eYrOgupY%2FibfWAW4uGNg%3D%3AMx7nyTig1vHp8FtoGAnqY1d1KovawsVK58W1MkVkXrI%3D”,“message”:“\OC\Updater::updateEnd: Update failed”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36 Edg/127.0.0.0”,“version”:“30.0.0.5”,“data”:{“app”:“updater”}}

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.