[Bug]: Upgrade 25.0.8 Sqlite - General error: 1 incomplete input

NeroNekro commented 1 year ago

⚠️ This issue respects the following points: ⚠️

[X] This is a bug, not a question or a configuration/webserver/proxy issue.
[X] This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
[X] Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
[X] I agree to follow Nextcloud's Code of Conduct.

Bug description

Update vorbereiten

Log-Level auf "debug" gesetzt

Reparaturschritt: Repair MySQL collation

Reparaturinformation: Not a mysql database -> nothing to do

Reparaturschritt: Repair SQLite autoincrement

Reparaturschritt: Copy data from accounts table when migrating from ownCloud

Reparaturschritt: Drop account terms table when migrating from ownCloud

Das Datenbankschema wird aktualisiert

Exception: Database error when running migration 27000Date20220613163520 for app core An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 incomplete input

Steps to reproduce

1.Upload 25.0.8 Files to Host

Click on migrate
get this error

Expected behavior

No error

Installation method

Nextcloud Server version

25

Operating system

None

PHP engine version

8.0

Web server

None

Database engine version

SQLite

Is this bug present after an update or on a fresh install?

Update

Are you using the Nextcloud Server Encryption module?

No

What user-backends are you using?

[x] Default user-backend (database)
[ ] LDAP/ Active Directory
[ ] SSO - SAML
[ ] Other

Configuration report

No response

List of activated Apps

No response

Nextcloud Signing status

Not working

Nextcloud Logs

{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 1,
  "time": "2023-07-20T05:44:52+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "updater",
  "method": "",
  "url": "--",
  "message": "\\OC\\Updater::maintenanceEnabled: Turned on maintenance mode",
  "userAgent": "--",
  "version": "25.0.6.1",
  "data": {
    "app": "updater"
  }
}
{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 0,
  "time": "2023-07-20T05:44:52+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "core",
  "method": "",
  "url": "--",
  "message": "starting upgrade from 25.0.6.1 to 25.0.8.2",
  "userAgent": "--",
  "version": "25.0.6.1",
  "data": {
    "app": "core"
  }
}
{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 1,
  "time": "2023-07-20T05:44:52+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "updater",
  "method": "",
  "url": "--",
  "message": "OC\\Repair\\Events\\RepairStepEvent: Repair step: Repair MySQL collation",
  "userAgent": "--",
  "version": "25.0.6.1",
  "data": {
    "app": "updater"
  }
}
{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 1,
  "time": "2023-07-20T05:44:52+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "updater",
  "method": "",
  "url": "--",
  "message": "OC\\Repair\\Events\\RepairInfoEvent: Repair info: Not a mysql database -> nothing to do",
  "userAgent": "--",
  "version": "25.0.6.1",
  "data": {
    "app": "updater"
  }
}
{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 1,
  "time": "2023-07-20T05:44:52+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "updater",
  "method": "",
  "url": "--",
  "message": "OC\\Repair\\Events\\RepairStepEvent: Repair step: Repair SQLite autoincrement",
  "userAgent": "--",
  "version": "25.0.6.1",
  "data": {
    "app": "updater"
  }
}
{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 1,
  "time": "2023-07-20T05:44:53+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "updater",
  "method": "",
  "url": "--",
  "message": "OC\\Repair\\Events\\RepairStepEvent: Repair step: Copy data from accounts table when migrating from ownCloud",
  "userAgent": "--",
  "version": "25.0.6.1",
  "data": {
    "app": "updater"
  }
}
{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 1,
  "time": "2023-07-20T05:44:53+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "updater",
  "method": "",
  "url": "--",
  "message": "OC\\Repair\\Events\\RepairStepEvent: Repair step: Drop account terms table when migrating from ownCloud",
  "userAgent": "--",
  "version": "25.0.6.1",
  "data": {
    "app": "updater"
  }
}
{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 1,
  "time": "2023-07-20T05:44:53+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "updater",
  "method": "",
  "url": "--",
  "message": "\\OC\\Updater::dbUpgradeBefore: Updating database schema",
  "userAgent": "--",
  "version": "25.0.6.1",
  "data": {
    "app": "updater"
  }
}
{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 3,
  "time": "2023-07-20T05:44:53+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "no app in context",
  "method": "",
  "url": "--",
  "message": "Database error when running migration 27000Date20220613163520 for app core\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 incomplete input",
  "userAgent": "--",
  "version": "25.0.6.1",
  "exception": {
    "Exception": "Exception",
    "Message": "Database error when running migration 27000Date20220613163520 for app core\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 incomplete input",
    "Code": 0,
    "Trace": [
      {
        "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Updater.php",
        "line": 323,
        "function": "migrate",
        "class": "OC\\DB\\MigrationService",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Updater.php",
        "line": 262,
        "function": "doCoreUpgrade",
        "class": "OC\\Updater",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Updater.php",
        "line": 141,
        "function": "doUpgrade",
        "class": "OC\\Updater",
        "type": "->",
        "args": [
          "25.0.8.2",
          "25.0.6.1"
        ]
      },
      {
        "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/core/Command/Upgrade.php",
        "line": 225,
        "function": "upgrade",
        "class": "OC\\Updater",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Command/Command.php",
        "line": 255,
        "function": "execute",
        "class": "OC\\Core\\Command\\Upgrade",
        "type": "->",
        "args": [
          [
            "Symfony\\Component\\Console\\Input\\ArgvInput"
          ],
          [
            "Symfony\\Component\\Console\\Output\\ConsoleOutput"
          ]
        ]
      },
      {
        "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Application.php",
        "line": 1009,
        "function": "run",
        "class": "Symfony\\Component\\Console\\Command\\Command",
        "type": "->",
        "args": [
          [
            "Symfony\\Component\\Console\\Input\\ArgvInput"
          ],
          [
            "Symfony\\Component\\Console\\Output\\ConsoleOutput"
          ]
        ]
      },
      {
        "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Application.php",
        "line": 273,
        "function": "doRunCommand",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->",
        "args": [
          [
            "OC\\Core\\Command\\Upgrade"
          ],
          [
            "Symfony\\Component\\Console\\Input\\ArgvInput"
          ],
          [
            "Symfony\\Component\\Console\\Output\\ConsoleOutput"
          ]
        ]
      },
      {
        "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Application.php",
        "line": 149,
        "function": "doRun",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->",
        "args": [
          [
            "Symfony\\Component\\Console\\Input\\ArgvInput"
          ],
          [
            "Symfony\\Component\\Console\\Output\\ConsoleOutput"
          ]
        ]
      },
      {
        "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Console/Application.php",
        "line": 214,
        "function": "run",
        "class": "Symfony\\Component\\Console\\Application",
        "type": "->",
        "args": [
          [
            "Symfony\\Component\\Console\\Input\\ArgvInput"
          ],
          [
            "Symfony\\Component\\Console\\Output\\ConsoleOutput"
          ]
        ]
      },
      {
        "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/console.php",
        "line": 100,
        "function": "run",
        "class": "OC\\Console\\Application",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/occ",
        "line": 11,
        "args": [
          "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/console.php"
        ],
        "function": "require_once"
      }
    ],
    "File": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/MigrationService.php",
    "Line": 420,
    "Previous": {
      "Exception": "Doctrine\\DBAL\\Exception\\DriverException",
      "Message": "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 incomplete input",
      "Code": 1,
      "Trace": [
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1780,
          "function": "convert",
          "class": "Doctrine\\DBAL\\Driver\\API\\SQLite\\ExceptionConverter",
          "type": "->",
          "args": [
            [
              "Doctrine\\DBAL\\Driver\\PDO\\Exception"
            ],
            [
              "Doctrine\\DBAL\\Query"
            ]
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1719,
          "function": "handleDriverException",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            [
              "Doctrine\\DBAL\\Driver\\PDO\\Exception"
            ],
            [
              "Doctrine\\DBAL\\Query"
            ]
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1067,
          "function": "convertExceptionDuringQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            [
              "Doctrine\\DBAL\\Driver\\PDO\\Exception"
            ],
            "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)",
            [],
            []
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/Connection.php",
          "line": 261,
          "function": "executeQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)",
            [],
            [],
            null
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1809,
          "function": "executeQuery",
          "class": "OC\\DB\\Connection",
          "type": "->",
          "args": [
            "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)"
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/Migrator.php",
          "line": 162,
          "function": "query",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)"
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/Migrator.php",
          "line": 69,
          "function": "applySchema",
          "class": "OC\\DB\\Migrator",
          "type": "->",
          "args": [
            [
              "Doctrine\\DBAL\\Schema\\Schema"
            ]
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/Connection.php",
          "line": 582,
          "function": "migrate",
          "class": "OC\\DB\\Migrator",
          "type": "->",
          "args": [
            [
              "Doctrine\\DBAL\\Schema\\Schema"
            ]
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/MigrationService.php",
          "line": 531,
          "function": "migrateToSchema",
          "class": "OC\\DB\\Connection",
          "type": "->",
          "args": [
            [
              "Doctrine\\DBAL\\Schema\\Schema"
            ]
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/MigrationService.php",
          "line": 416,
          "function": "executeStep",
          "class": "OC\\DB\\MigrationService",
          "type": "->",
          "args": [
            "27000Date20220613163520",
            false
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Updater.php",
          "line": 323,
          "function": "migrate",
          "class": "OC\\DB\\MigrationService",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Updater.php",
          "line": 262,
          "function": "doCoreUpgrade",
          "class": "OC\\Updater",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Updater.php",
          "line": 141,
          "function": "doUpgrade",
          "class": "OC\\Updater",
          "type": "->",
          "args": [
            "25.0.8.2",
            "25.0.6.1"
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/core/Command/Upgrade.php",
          "line": 225,
          "function": "upgrade",
          "class": "OC\\Updater",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Command/Command.php",
          "line": 255,
          "function": "execute",
          "class": "OC\\Core\\Command\\Upgrade",
          "type": "->",
          "args": [
            [
              "Symfony\\Component\\Console\\Input\\ArgvInput"
            ],
            [
              "Symfony\\Component\\Console\\Output\\ConsoleOutput"
            ]
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Application.php",
          "line": 1009,
          "function": "run",
          "class": "Symfony\\Component\\Console\\Command\\Command",
          "type": "->",
          "args": [
            [
              "Symfony\\Component\\Console\\Input\\ArgvInput"
            ],
            [
              "Symfony\\Component\\Console\\Output\\ConsoleOutput"
            ]
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Application.php",
          "line": 273,
          "function": "doRunCommand",
          "class": "Symfony\\Component\\Console\\Application",
          "type": "->",
          "args": [
            [
              "OC\\Core\\Command\\Upgrade"
            ],
            [
              "Symfony\\Component\\Console\\Input\\ArgvInput"
            ],
            [
              "Symfony\\Component\\Console\\Output\\ConsoleOutput"
            ]
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Application.php",
          "line": 149,
          "function": "doRun",
          "class": "Symfony\\Component\\Console\\Application",
          "type": "->",
          "args": [
            [
              "Symfony\\Component\\Console\\Input\\ArgvInput"
            ],
            [
              "Symfony\\Component\\Console\\Output\\ConsoleOutput"
            ]
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Console/Application.php",
          "line": 214,
          "function": "run",
          "class": "Symfony\\Component\\Console\\Application",
          "type": "->",
          "args": [
            [
              "Symfony\\Component\\Console\\Input\\ArgvInput"
            ],
            [
              "Symfony\\Component\\Console\\Output\\ConsoleOutput"
            ]
          ]
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/console.php",
          "line": 100,
          "function": "run",
          "class": "OC\\Console\\Application",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/occ",
          "line": 11,
          "args": [
            "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/console.php"
          ],
          "function": "require_once"
        }
      ],
      "File": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Driver/API/SQLite/ExceptionConverter.php",
      "Line": 82,
      "Previous": {
        "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
        "Message": "SQLSTATE[HY000]: General error: 1 incomplete input",
        "Code": 1,
        "Trace": [
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
            "line": 87,
            "function": "new",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
            "type": "::",
            "args": [
              [
                "PDOException",
                [
                  "HY000",
                  1,
                  "incomplete input"
                ]
              ]
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Connection.php",
            "line": 1062,
            "function": "query",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Connection",
            "type": "->",
            "args": [
              "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)"
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/Connection.php",
            "line": 261,
            "function": "executeQuery",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->",
            "args": [
              "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)",
              [],
              [],
              null
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Connection.php",
            "line": 1809,
            "function": "executeQuery",
            "class": "OC\\DB\\Connection",
            "type": "->",
            "args": [
              "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)"
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/Migrator.php",
            "line": 162,
            "function": "query",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->",
            "args": [
              "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)"
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/Migrator.php",
            "line": 69,
            "function": "applySchema",
            "class": "OC\\DB\\Migrator",
            "type": "->",
            "args": [
              [
                "Doctrine\\DBAL\\Schema\\Schema"
              ]
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/Connection.php",
            "line": 582,
            "function": "migrate",
            "class": "OC\\DB\\Migrator",
            "type": "->",
            "args": [
              [
                "Doctrine\\DBAL\\Schema\\Schema"
              ]
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/MigrationService.php",
            "line": 531,
            "function": "migrateToSchema",
            "class": "OC\\DB\\Connection",
            "type": "->",
            "args": [
              [
                "Doctrine\\DBAL\\Schema\\Schema"
              ]
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/MigrationService.php",
            "line": 416,
            "function": "executeStep",
            "class": "OC\\DB\\MigrationService",
            "type": "->",
            "args": [
              "27000Date20220613163520",
              false
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Updater.php",
            "line": 323,
            "function": "migrate",
            "class": "OC\\DB\\MigrationService",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Updater.php",
            "line": 262,
            "function": "doCoreUpgrade",
            "class": "OC\\Updater",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Updater.php",
            "line": 141,
            "function": "doUpgrade",
            "class": "OC\\Updater",
            "type": "->",
            "args": [
              "25.0.8.2",
              "25.0.6.1"
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/core/Command/Upgrade.php",
            "line": 225,
            "function": "upgrade",
            "class": "OC\\Updater",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Command/Command.php",
            "line": 255,
            "function": "execute",
            "class": "OC\\Core\\Command\\Upgrade",
            "type": "->",
            "args": [
              [
                "Symfony\\Component\\Console\\Input\\ArgvInput"
              ],
              [
                "Symfony\\Component\\Console\\Output\\ConsoleOutput"
              ]
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Application.php",
            "line": 1009,
            "function": "run",
            "class": "Symfony\\Component\\Console\\Command\\Command",
            "type": "->",
            "args": [
              [
                "Symfony\\Component\\Console\\Input\\ArgvInput"
              ],
              [
                "Symfony\\Component\\Console\\Output\\ConsoleOutput"
              ]
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Application.php",
            "line": 273,
            "function": "doRunCommand",
            "class": "Symfony\\Component\\Console\\Application",
            "type": "->",
            "args": [
              [
                "OC\\Core\\Command\\Upgrade"
              ],
              [
                "Symfony\\Component\\Console\\Input\\ArgvInput"
              ],
              [
                "Symfony\\Component\\Console\\Output\\ConsoleOutput"
              ]
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Application.php",
            "line": 149,
            "function": "doRun",
            "class": "Symfony\\Component\\Console\\Application",
            "type": "->",
            "args": [
              [
                "Symfony\\Component\\Console\\Input\\ArgvInput"
              ],
              [
                "Symfony\\Component\\Console\\Output\\ConsoleOutput"
              ]
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Console/Application.php",
            "line": 214,
            "function": "run",
            "class": "Symfony\\Component\\Console\\Application",
            "type": "->",
            "args": [
              [
                "Symfony\\Component\\Console\\Input\\ArgvInput"
              ],
              [
                "Symfony\\Component\\Console\\Output\\ConsoleOutput"
              ]
            ]
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/console.php",
            "line": 100,
            "function": "run",
            "class": "OC\\Console\\Application",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/occ",
            "line": 11,
            "args": [
              "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/console.php"
            ],
            "function": "require_once"
          }
        ],
        "File": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
        "Line": 26,
        "Previous": {
          "Exception": "PDOException",
          "Message": "SQLSTATE[HY000]: General error: 1 incomplete input",
          "Code": "HY000",
          "Trace": [
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
              "line": 82,
              "function": "query",
              "class": "PDO",
              "type": "->",
              "args": [
                "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)"
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Connection.php",
              "line": 1062,
              "function": "query",
              "class": "Doctrine\\DBAL\\Driver\\PDO\\Connection",
              "type": "->",
              "args": [
                "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)"
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/Connection.php",
              "line": 261,
              "function": "executeQuery",
              "class": "Doctrine\\DBAL\\Connection",
              "type": "->",
              "args": [
                "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)",
                [],
                [],
                null
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Connection.php",
              "line": 1809,
              "function": "executeQuery",
              "class": "OC\\DB\\Connection",
              "type": "->",
              "args": [
                "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)"
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/Migrator.php",
              "line": 162,
              "function": "query",
              "class": "Doctrine\\DBAL\\Connection",
              "type": "->",
              "args": [
                "CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)"
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/Migrator.php",
              "line": 69,
              "function": "applySchema",
              "class": "OC\\DB\\Migrator",
              "type": "->",
              "args": [
                [
                  "Doctrine\\DBAL\\Schema\\Schema"
                ]
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/Connection.php",
              "line": 582,
              "function": "migrate",
              "class": "OC\\DB\\Migrator",
              "type": "->",
              "args": [
                [
                  "Doctrine\\DBAL\\Schema\\Schema"
                ]
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/MigrationService.php",
              "line": 531,
              "function": "migrateToSchema",
              "class": "OC\\DB\\Connection",
              "type": "->",
              "args": [
                [
                  "Doctrine\\DBAL\\Schema\\Schema"
                ]
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/DB/MigrationService.php",
              "line": 416,
              "function": "executeStep",
              "class": "OC\\DB\\MigrationService",
              "type": "->",
              "args": [
                "27000Date20220613163520",
                false
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Updater.php",
              "line": 323,
              "function": "migrate",
              "class": "OC\\DB\\MigrationService",
              "type": "->",
              "args": []
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Updater.php",
              "line": 262,
              "function": "doCoreUpgrade",
              "class": "OC\\Updater",
              "type": "->",
              "args": []
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Updater.php",
              "line": 141,
              "function": "doUpgrade",
              "class": "OC\\Updater",
              "type": "->",
              "args": [
                "25.0.8.2",
                "25.0.6.1"
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/core/Command/Upgrade.php",
              "line": 225,
              "function": "upgrade",
              "class": "OC\\Updater",
              "type": "->",
              "args": []
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Command/Command.php",
              "line": 255,
              "function": "execute",
              "class": "OC\\Core\\Command\\Upgrade",
              "type": "->",
              "args": [
                [
                  "Symfony\\Component\\Console\\Input\\ArgvInput"
                ],
                [
                  "Symfony\\Component\\Console\\Output\\ConsoleOutput"
                ]
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Application.php",
              "line": 1009,
              "function": "run",
              "class": "Symfony\\Component\\Console\\Command\\Command",
              "type": "->",
              "args": [
                [
                  "Symfony\\Component\\Console\\Input\\ArgvInput"
                ],
                [
                  "Symfony\\Component\\Console\\Output\\ConsoleOutput"
                ]
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Application.php",
              "line": 273,
              "function": "doRunCommand",
              "class": "Symfony\\Component\\Console\\Application",
              "type": "->",
              "args": [
                [
                  "OC\\Core\\Command\\Upgrade"
                ],
                [
                  "Symfony\\Component\\Console\\Input\\ArgvInput"
                ],
                [
                  "Symfony\\Component\\Console\\Output\\ConsoleOutput"
                ]
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/symfony/console/Application.php",
              "line": 149,
              "function": "doRun",
              "class": "Symfony\\Component\\Console\\Application",
              "type": "->",
              "args": [
                [
                  "Symfony\\Component\\Console\\Input\\ArgvInput"
                ],
                [
                  "Symfony\\Component\\Console\\Output\\ConsoleOutput"
                ]
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/lib/private/Console/Application.php",
              "line": 214,
              "function": "run",
              "class": "Symfony\\Component\\Console\\Application",
              "type": "->",
              "args": [
                [
                  "Symfony\\Component\\Console\\Input\\ArgvInput"
                ],
                [
                  "Symfony\\Component\\Console\\Output\\ConsoleOutput"
                ]
              ]
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/console.php",
              "line": 100,
              "function": "run",
              "class": "OC\\Console\\Application",
              "type": "->",
              "args": []
            },
            {
              "file": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/occ",
              "line": 11,
              "args": [
                "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/console.php"
              ],
              "function": "require_once"
            }
          ],
          "File": "/var/www/vhosts/hosting106820.a2f18.netcup.net/httpdocs/example.de/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
          "Line": 82
        }
      }
    },
    "message": "Database error when running migration 27000Date20220613163520 for app core\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 incomplete input",
    "exception": {},
    "CustomMessage": "Database error when running migration 27000Date20220613163520 for app core\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 incomplete input"
  }
}
{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 3,
  "time": "2023-07-20T05:44:53+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "updater",
  "method": "",
  "url": "--",
  "message": "\\OC\\Updater::failure: Exception: Database error when running migration 27000Date20220613163520 for app core\nAn exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 incomplete input",
  "userAgent": "--",
  "version": "25.0.6.1",
  "data": {
    "app": "updater"
  }
}
{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 3,
  "time": "2023-07-20T05:44:53+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "updater",
  "method": "",
  "url": "--",
  "message": "\\OC\\Updater::updateEnd: Update failed",
  "userAgent": "--",
  "version": "25.0.6.1",
  "data": {
    "app": "updater"
  }
}
{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 1,
  "time": "2023-07-20T05:44:53+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "updater",
  "method": "",
  "url": "--",
  "message": "\\OC\\Updater::maintenanceActive: Maintenance mode is kept active",
  "userAgent": "--",
  "version": "25.0.6.1",
  "data": {
    "app": "updater"
  }
}
{
  "reqId": "cHbKoKKJeA6wqxEoud1K",
  "level": 1,
  "time": "2023-07-20T05:44:53+00:00",
  "remoteAddr": "",
  "user": "--",
  "app": "updater",
  "method": "",
  "url": "--",
  "message": "\\OC\\Updater::resetLogLevel: Reset log level to Warning(2)",
  "userAgent": "--",
  "version": "25.0.6.1",
  "data": {
    "app": "updater"
  }
}

Additional info

No response

kesselb commented 1 year ago

cc @susnux

Looks like the form errors with sqlite and schema comments. OnlyOfffice had column comments in the past (https://github.com/ONLYOFFICE/onlyoffice-nextcloud/commit/da5343fb24ed463ddab1287a88b9637dd65708f0).

The generated query here looks weird ;)

CREATE TABLE oc_onlyoffice_filekey (id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, file_id BIGINT DEFAULT -1 --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier --internal file identifier, \"key\" VARCHAR(128) NOT NULL COLLATE BINARY, lock INTEGER DEFAULT 0 NOT NULL, fs INTEGER DEFAULT 0 NOT NULL)

kesselb commented 1 year ago

@NeroNekro

Mind to edit https://github.com/nextcloud/server/blob/stable25/lib/private/DB/SQLiteMigrator.php on your local installation (e.g., with a ftp client)

Change the function like below

    protected function getDiff(Schema $targetSchema, \Doctrine\DBAL\Connection $connection) {
        $platform = $connection->getDatabasePlatform();
        $platform->registerDoctrineTypeMapping('tinyint unsigned', 'integer');
        $platform->registerDoctrineTypeMapping('smallint unsigned', 'integer');
        $platform->registerDoctrineTypeMapping('varchar ', 'string');

        foreach ($targetSchema->getTables() as $table) {
            $table->setComment(null);
            foreach ($table->getColumns() as $column) {
                // column comments are not supported on SQLite
                $column->setComment(null);

                // with sqlite autoincrement columns is of type integer
                if ($column->getType() instanceof BigIntType && $column->getAutoincrement()) {
                    $column->setType(Type::getType('integer'));
                }
            }
        }

        return parent::getDiff($targetSchema, $connection);
    }

Try the upgrade again?

EkkiBrue commented 1 year ago

I´m having the exact same issue on the exact same hoster (netcup!) - I try to update from 24.0.12. to 25.0.12.

I also tried to edit SQLiteMigrator.php with the upper code. It ended in the exact same error.

Anyone has a solution on this ?

EkkiBrue commented 1 year ago

`Exception: Database error when running migration 25000Date20220602190540 for app core An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 incomplete input

Detaillierte Protokollmeldungen Update vorbereiten

Log-Level auf "debug" gesetzt

Wartungsmodus eingeschaltet

Reparaturschritt: Repair MySQL collation

Reparaturinformation: Not a mysql database -> nothing to do

Reparaturschritt: Repair SQLite autoincrement

Reparaturschritt: Copy data from accounts table when migrating from ownCloud

Reparaturschritt: Drop account terms table when migrating from ownCloud

Das Datenbankschema wird aktualisiert

Exception: Database error when running migration 25000Date20220602190540 for app core An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 incomplete input`

EkkiBrue commented 1 year ago

@NeroNekro could you solve your problem ? If yes, could you please let me know. It seems it somehow belongs to netcup, or ?

NeroNekro commented 1 year ago

I solved the problem with switching to MySQL xD

Thanks

EkkiBrue commented 1 year ago

@NeroNekro Could you give me some hint how I can manage this ? Is there a Solution / Doc to do this on the fly ? Is it safe to change DB / CONFIG before leaving maintenence mode ?

joshtrichards commented 3 months ago

@EkkiBrue Yes, there's an entire chapter of the manual dedicated to the topic: https://docs.nextcloud.com/server/latest/admin_manual/configuration_database/db_conversion.html

nextcloud / server