Bookmarks: Update to 20.0.6 - bookmarks error

[danielgauss]

Steps to reproduce

1. Started the web updater to update to NextCloud 20.0.6
2. Disabled maintenance mode to continue update in browser
3. 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]

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]

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]

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"

```Preparing update

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"```

[basvandenbrink]

This issue seems to be a duplicate of #1389.

[marcelklehr]

Duplicate of #1389 #1388

[Gigadoc2]

This, eh, is #1389
Maybe you mean https://github.com/nextcloud/bookmarks/issues/1388? :smile:

[mbreskovec]

Guys, is here any way, how to restore my lost bookmarks by this issue?

[marcelklehr]

@mbreskovec I've written up a guide, assuming you have a db backup: https://github.com/nextcloud/bookmarks/wiki/Recovering-from-DB-Backup

[mbreskovec]

@marcelklehr Thx Marcel. But I am afraid, that I dont have database backup :-/