[Bug]: Upgrade 25.0.8 Sqlite - General error: 1 incomplete input
Open
Nobody has claimed this yet.
0. Needs triage
25-feedback
bug
feature: install and update
needs review
- Dominant language
- PHP
- Stars
- 36.9k
- Forks
- 5.2k
- Avg merge
- 2d 3h
- Merged PRs (30d)
- 713
Description
⚠️ This issue respects the following points: ⚠️
- This is a bug, not a question or a configuration/webserver/proxy issue.
- This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
- Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
- 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
2. Click on migrate
3. get this error
Expected behavior
No error
Installation method
Archive
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?
- 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
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the core migration identified as 27000Date20220613163520 and the failing CREATE TABLE query for oc_onlyoffice_filekey; inspect the migration path through lib/private/DB/MigrationService.php. Reproduce the 25.0.6.1-to-25.0.8.2 SQLite upgrade and confirm that the migration completes without the incomplete-input error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php, sqlite
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100