Nextcloud version 22.1.0.1 (error log)

Support intro

Sorry to hear you’re facing problems :slightly_frowning_face:

help.nextcloud.com is for home/non-enterprise users. If you’re running a business, paid support can be accessed via portal.nextcloud.com where we can ensure your business keeps running smoothly.

In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:

example

Or for longer, use three backticks above and below the code snippet:

longer
example
here

Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can :heart:

Nextcloud version (eg, 20.0.5): 22.1.0.1
Operating system and version (eg, Ubuntu 20.04): CentOS Stream 8
Apache or nginx version (eg, Apache 2.4.25): nginx/1.14.1
PHP version (eg, 7.4): 7.4
MariaDB version: 10.6.4

The issue you are facing:

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

Steps to replicate it:

  1. Upload file
  2. Delete file
  3. Publish file
  4. Rename file

The output of your Nextcloud log in Admin > Logging:

[index] Error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'configvalue` + 1)` WHERE (`userid` = 'A13DFB32-3D9F-4445-9FEF-7195E3623F27') ...' at line 1

GET /core/preview?fileId=2778&x=1920&y=1080&a=true
from 10.205.48.166 by A13DFB32-3D9F-4445-9FEF-7195E3623F27 at 2021-08-11T16:23:42+03:00

The output of your config.php file in /path/to/nextcloud (make sure you remove any identifiable information!):

<?php
$CONFIG = array (
  'passwordsalt' => 'is hidden',
  'secret' => 'is hidden',
  'trusted_domains' =>
  array (
    0 => 'localhost',
    1 => 'is hidden',
  ),
  'datadirectory' => '/opt/nc-data',
  'dbtype' => 'mysql',
  'version' => '22.1.0.1',
  'overwrite.cli.url' => 'is hidden',
  'overwritehost' => 'is hidden',
  'overwriteprotocol' => 'https',
  'trusted_proxies' =>
  array (
    0 => 'is hidden',
    1 => 'is hidden',
    2 => 'is hidden',
  ),
  'overwritecondaddr' => 'is hidden',
  'dbname' => 'nc',
  'dbhost' => 'localhost',
  'dbport' => '',
  'dbtableprefix' => 'oc_',
  'mysql.utf8mb4' => true,
  'dbuser' => 'is hidden',
  'dbpassword' => 'is hidden',
  'installed' => true,
  'instanceid' => 'is hidden',
  'default_language' => 'ru',
  'default_phone_region' => 'RU',
  'defaultapp' => 'files',
  'force_language' => 'ru',
  'default_locale' => 'ru',
  'knowledgebaseenabled' => 'false',
  'allow_user_to_change_display_name' => 'false',
  'skeletondirectory' => '/opt/nc-www/core/skeleton0',
  'memcache.local' => '\\OC\\Memcache\\Redis',
  'memcache.locking' => '\\OC\\Memcache\\Redis',
  'memcache.distributed' => '\\OC\\Memcache\\Redis',
  'redis' =>
  array (
    'host' => '/run/redis/redis.sock',
  ),
  'log_type' => 'file',
  'logfile' => '/opt/nc-data/nextcloud.log',
  'log_rotate_size' => 10 * 1024 * 1024,
  'loglevel' => 3,
  'logdateformat' => 'Y-m-d H:i:s T',
  'logtimezone' => 'Europe/Moscow',
  'lost_password_link' => 'is hidden',
  'mail_domain' => 'is hidden',
  'mail_from_address' => 'nextcloud',
  'mail_smtpmode' => 'sendmail',
  'maintenance' => false,
  'app_install_overwrite' =>
  array (
    0 => 'admin_notifications',
  ),
);

Same error on version 22.1.1.