Database Error after upgrade SQLSTATE[HY000]


I was sick for a while and recently startet upgrading my nextcloud installation. It is hosted on a webspace of a german provider (ionos). Working perfectly for my purpose for years.

Upgrading form version 23. to 24-latest leads to the fact, that the website is not accessible any mor- There is a nextcloud logo shown but no login prompt.


All services which have been configured before are running. Like Sync of Desktop-Files, Adressbook and Calendar sync.

I can ssh to the server.

occ status shows:

/usr/bin/php8.1-cli ./occ status
The process control (PCNTL) extensions are required in case you want to interrupt long running commands - see PHP: PCNTL - Manual
Additionally the function ‘pcntl_signal’ and ‘pcntl_signal_dispatch’ need to be enabled in your php.ini.

  • installed: true
  • version:
  • versionstring: 24.0.12
  • edition:
  • maintenance: false
  • needsDbUpgrade: false
  • productname: Nextcloud
  • extendedSupport: false

/usr/bin/php8.1-cli ./occ maintenance:repair shows a lot of messages which seem to be ok but one Error:

  • Migrate oauth2_clients table to nextcloud schema
    • Update the oauth2_access_tokens table schema.
    • Update the oauth2_clients table schema.
    • ERROR: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 incomplete input

I do not find any hint online and also not in the forum (may be my fault), but I am stuck.

Any hint would be helpfull.


Finally did a new install from scratch and manually copied the files…