Can´t update "Bookmarks"

Nextcloud version (eg, 20.0.5): replace me
Operating system and version (eg, Ubuntu 20.04): replace me
Apache or nginx version (eg, Apache 2.4.25): replace me
PHP version (eg, 7.4): replace me

The issue you are facing:

Hi Folks,
tried to update the Bookmark app which failed

Is this the first time you’ve seen this error? (Y/N): Y

Steps to replicate it:

  1. Loged in as Admin
  2. Click update
  3. Get the Following error

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

Any Advices what to do now?

Can´t login anymore :frowning:


An issue ticket already exists for that ptroblem:

As a workaround, disable the Bookmarks app on the console using the occ command and wait for a fixed bookmarks app version.

What woulkd be the command on the console for disabling this?

Make sure that the occ command is executed as the user under which your web server is running :wink:

> ./occ app:disable --help
  disable an app

  app:disable <app-id>...

  app-id                disable the specified app

  -h, --help            Display help for the given command. When no command is given display help for the list command
  -q, --quiet           Do not output any message
  -V, --version         Display this application version
      --ansi            Force ANSI output
      --no-ansi         Disable ANSI output
  -n, --no-interaction  Do not ask any interactive question
      --no-warnings     Skip global warnings, show command output only
  -v|vv|vvv, --verbose  Increase the verbosity of messages: 1 for normal output, 2 for more verbose output and 3 for debug

Great! Thanks a lot!