Update to 20.0.6 - bookmarks error

danielgauss commented 3 years ago

Steps to reproduce

Started the web updater to update to NextCloud 20.0.6
Disabled maintenance mode to continue update in browser
Separate "update to 20.0.6" page is shown

Expected behaviour

Update all features and apps

Actual behaviour

Exception: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT "b"."id" FROM "oc_bookmarks" "b" LEFT JOIN "oc_bookmarks_tree" "t" ON b.id = t.id AND ? WHERE "t"."id" IS NULL' with params ["bookmark"]: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type boolean: "bookmark"

Server configuration

Operating system: Gentoo Linux

Web server: Apache 2.4.46

Database: PostgreSQL 13.1

PHP version: PHP 7.4.14

Nextcloud version: should now be 20.0.6

Updated from an older Nextcloud/ownCloud or fresh install: Updated from 20.0.5

Where did you install Nextcloud from: Web updater

Signing status:

Signing status

``` Cannot access this ```

List of activated apps:

App list

``` Enabled: - accessibility: 1.6.0 - activity: 2.13.4 - apporder: 0.11.0 - bookmarks: 4.0.6 - calendar: 2.1.3 - cloud_federation_api: 1.3.0 - comments: 1.10.0 - contacts: 3.4.3 - contactsinteraction: 1.1.0 - dashboard: 7.0.0 - dav: 1.16.2 - federatedfilesharing: 1.10.2 - federation: 1.10.1 - files: 1.15.0 - files_antivirus: 3.1.1 - files_mindmap: 0.0.24 - files_pdfviewer: 2.0.1 - files_rightclick: 0.17.0 - files_sharing: 1.12.2 - files_trashbin: 1.10.1 - files_versions: 1.13.0 - files_videoplayer: 1.9.0 - firstrunwizard: 2.9.0 - gpxpod: 4.2.4 - logreader: 2.5.0 - lookup_server_connector: 1.8.0 - news: 15.1.1 - nextcloud_announcements: 1.9.0 - notes: 4.0.2 - notifications: 2.8.0 - oauth2: 1.8.0 - password_policy: 1.10.1 - photos: 1.2.3 - privacy: 1.4.0 - provisioning_api: 1.10.0 - recommendations: 0.8.0 - serverinfo: 1.10.0 - settings: 1.2.0 - sharebymail: 1.10.0 - spreed: 10.0.5 - support: 1.3.0 - survey_client: 1.8.0 - systemtags: 1.10.0 - tasks: 0.13.6 - text: 3.1.0 - theming: 1.11.0 - twofactor_backupcodes: 1.9.0 - updatenotification: 1.10.0 - user_status: 1.0.1 - viewer: 1.4.0 - weather_status: 1.0.0 - workflowengine: 2.2.0 Disabled: - admin_audit - encryption - files_external - user_ldap ```

Client configuration

Browser: Vivaldi

Operating system: Windows

WohthaN commented 3 years ago

Confirm being affected by the same exact problem! (on debian 10 though):

su www-data -s /bin/bash -c "php7.3 occ upgrade -n"
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Setting log level to debug
Updating database schema
Updated database
Updating <bookmarks> ...
Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT "b"."id" FROM "oc_bookmarks" "b" LEFT JOIN "oc_bookmarks_tree" "t" ON b.id = t.id AND ? WHERE "t"."id" IS NULL' with params ["bookmark"]:

SQLSTATE[22P02]: Invalid text representation: 7 ERROR:  invalid input syntax for type boolean: "bookmark"
Update failed
Maintenance mode is kept active
Resetting log level

j-be commented 3 years ago

Same here:

Nextcloud updated from 20.0.5
Ubuntu 20.04 LTS (armhf)
PostgreSQL 12
PHP 7.4.3

Happy to help debugging if needed.

sdstolworthy commented 3 years ago

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT "b"."id" FROM "oc_bookmarks" "b" LEFT JOIN "oc_bookmarks_tree" "t" ON b.id = t.id AND ? WHERE "t"."id" IS NULL' with params ["bookmark"]: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type boolean: "bookmark"



Set log level to debug

Turned on maintenance mode

Repair step: Repair MySQL collation

Repair info: Not a mysql database -> nothing to do

Repair step: Repair SQLite autoincrement

Repair step: Copy data from accounts table when migrating from ownCloud

Repair step: Drop account terms table when migrating from ownCloud

Updating database schema

Updated database

Repair step: Deduplicate shared bookmark folders

Repair info: Removed 0 duplicate shares

Repair step: Remove superfluous shared bookmark folders

Repair info: Removed 0 superfluous shares

Repair step: Remove orphaned bookmark shares

Repair info: Removed 0 orphaned shares

Repair info: Removed 0 orphaned public links

Repair step: Remove orphaned bookmark tree items

Repair info: Removed 0 orphaned bookmarks entries

Repair info: Removed 0 orphaned folders entries

Repair info: Removed 0 orphaned children entries

Repair info: Removed 0 orphaned bookmark folders

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'SELECT "b"."id" FROM "oc_bookmarks" "b" LEFT JOIN "oc_bookmarks_tree" "t" ON b.id = t.id AND ? WHERE "t"."id" IS NULL' with params ["bookmark"]: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type boolean: "bookmark"```