Upgrade to 26.0.1 failed

[details=“Support intro”]

When attempting to upgrade to Nextcloud 26.0.1 I received the message:

An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 near “(”: syntax error

My site is hosted with Infomaniak, I have a shell but no root access. Nextcloud was working with PHP 7.3 and SQLite, it would be better with PHP 8.2 and MariaDB, available on the site.

Thank you for any help.

You should upgrade php to 8.1 and use postgres or mariadb. System Requirements

1 Like

Thank you! I have to rebuild my databases:-( Have a nice day!

You can convert an existing SQLite database of an existing Nextcloud installation to MySQL/MariaDB or Postgres: Converting database type — Nextcloud latest Administration Manual latest documentation

Thanks. Is it possible to re-install Nextcloud with an existing database? My attempts in that way have failed.

I’m not an expert when it comes to databases, and I have never tried it, so I’m not sure. I would say, in theory it should be possible, but in practice it probably depends on a lot of factors. At least there doesn’t seem to be a bulltetproof and well documented process for that, or I couldn’t find one.

The safest and easiest way would be to restore a backup from before the failed NC26 update, then do the database migration, and perform the update to NC26 again.

If you don’t have a backup, you need to consider how much effort it is worth to you. If you have only a few users, with mainly files and no calendars or other things that are only stored in the database, re-installing from scratch is probably the better and at the end of the day also the easier way to do it.

Thanks again. I will try. In between I saved my contacts list, thanks to the Android Contacts application :slight_smile:

You should upgrade php to 8.1 and use postgres or mariadb. System Requirements

That systems requirement page says that SQLite is still supported. Is that no longer true?

Hi, see [Bug]: Error updating from 25.0.5 to 26.0.0, using SQLite3, `General error: 1 near “(”: syntax error` · Issue #37649 · nextcloud/server · GitHub

SQLite is only for testing and minimal installs. Use postgres or MariaDB as you’ll have to install any database anyway. So why not install postgres or MariaDB directly instead of installing SQlite and later convert to another database? Makes no sense and it’s just more work. Also - because SQlite is only for testing you could run into problems because support could be dropped completely in the near future.

My point is that I don’t think that’s true anymore. I only have a minimal installation, but the upgrade still doesn’t work with SQLite.

I’ll switch to using MariaDB as that seems to be the best solution. But someone should consider removing SQLite from the documentation as NextCloud no longer works properly with it.