Skip to content

Instantly share code, notes, and snippets.

@jkuester

jkuester/log.json

Last active November 9, 2025 18:41
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jkuester/30ba6c5d0c05459f5ecf476220cb6d10 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jkuester/30ba6c5d0c05459f5ecf476220cb6d10 to your computer and use it in GitHub Desktop.
Download ZIP
Raw Nextcloud error
Raw
log.json
{
"reqId": "JVUU3MZARWWIQo65Z4MY",
"level": 3,
"time": "2025-11-09T18:28:33+00:00",
"remoteAddr": "143.105.247.215",
"user": "jlkuester7",
"app": "index",
"method": "GET",
"url": "/index.php/apps/user_oidc/code?state=REDACTED&session_state=REDACTED&code=REDACTED",
"message": "An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column \"id_token\" of relation \"oc_user_oidc_sessions\" does not exist\nLINE 1: ...\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\"...\n ^",
"userAgent": "Mozilla/5.0 (X11; Linux x86_64; rv:143.0) Gecko/20100101 Firefox/143.0",
"version": "31.0.10.2",
"exception": {
"Exception": "OC\\DB\\Exceptions\\DbalException",
"Message": "An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column \"id_token\" of relation \"oc_user_oidc_sessions\" does not exist\nLINE 1: ...\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\"...\n ^",
"Code": 7,
"Trace": [
{
"file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
"line": 69,
"function": "wrap",
"class": "OC\\DB\\Exceptions\\DbalException",
"type": "::",
"args": [
{
"__class__": "Doctrine\\DBAL\\Exception\\InvalidFieldNameException"
},
"",
"INSERT INTO `*PREFIX*user_oidc_sessions` (`sid`, `sub`, `iss`, `authtoken_id`, `nc_session_id`, `created_at`, `id_token`, `user_id`, `provider_id`, `idp_session_closed`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10)"
]
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 306,
"function": "executeStatement",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->",
"args": [
"INSERT INTO `*PREFIX*user_oidc_sessions` (`sid`, `sub`, `iss`, `authtoken_id`, `nc_session_id`, `created_at`, `id_token`, `user_id`, `provider_id`, `idp_session_closed`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10)",
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": "*** sensitive parameters replaced ***",
"dcValue2": "*** sensitive parameters replaced ***",
"dcValue3": "*** sensitive parameters replaced ***",
"dcValue4": "*** sensitive parameters replaced ***",
"dcValue5": "*** sensitive parameters replaced ***"
},
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2,
"dcValue4": 2,
"dcValue5": 2
}
]
},
{
"file": "/var/www/html/lib/public/AppFramework/Db/QBMapper.php",
"line": 116,
"function": "executeStatement",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/custom_apps/user_oidc/lib/Db/SessionMapper.php",
"line": 216,
"function": "insert",
"class": "OCP\\AppFramework\\Db\\QBMapper",
"type": "->",
"args": [
{
"__class__": "OCA\\UserOIDC\\Db\\Session",
"id": null
}
]
},
{
"file": "/var/www/html/custom_apps/user_oidc/lib/Controller/LoginController.php",
"line": 621,
"function": "createOrUpdateSession",
"class": "OCA\\UserOIDC\\Db\\SessionMapper",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 200,
"function": "code",
"class": "OCA\\UserOIDC\\Controller\\LoginController",
"type": "->",
"args": [
"REDACTED",
"REDACTED",
{
"filesystem": true,
"password-unconfirmable": true
},
"",
""
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 114,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\UserOIDC\\Controller\\LoginController"
},
"code"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 161,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\UserOIDC\\Controller\\LoginController"
},
"code"
]
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 315,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::",
"args": [
"OCA\\UserOIDC\\Controller\\LoginController",
"code",
{
"__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
},
{
"_route": "user_oidc.login.code"
}
]
},
{
"file": "/var/www/html/lib/base.php",
"line": 1063,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->",
"args": [
"/apps/user_oidc/code"
]
},
{
"file": "/var/www/html/index.php",
"line": 24,
"function": "handleRequest",
"class": "OC",
"type": "::",
"args": []
}
],
"File": "/var/www/html/lib/private/DB/Exceptions/DbalException.php",
"Line": 56,
"Previous": {
"Exception": "Doctrine\\DBAL\\Exception\\InvalidFieldNameException",
"Message": "An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column \"id_token\" of relation \"oc_user_oidc_sessions\" does not exist\nLINE 1: ...\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\"...\n ^",
"Code": 7,
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1976,
"function": "convert",
"class": "Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter",
"type": "->",
"args": [
{
"__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
},
{
"__class__": "Doctrine\\DBAL\\Query"
}
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1918,
"function": "handleDriverException",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
{
"__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
},
{
"__class__": "Doctrine\\DBAL\\Query"
}
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1218,
"function": "convertExceptionDuringQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
{
"__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception"
},
"INSERT INTO \"oc_user_oidc_sessions\" (\"sid\", \"sub\", \"iss\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\", \"user_id\", \"provider_id\", \"idp_session_closed\") VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
[
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"And 5 more entries, set log level to debug to see all entries"
],
[
2,
2,
2,
2,
2,
"And 5 more entries, set log level to debug to see all entries"
]
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php",
"line": 292,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"INSERT INTO \"oc_user_oidc_sessions\" (\"sid\", \"sub\", \"iss\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\", \"user_id\", \"provider_id\", \"idp_session_closed\") VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
[
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"And 5 more entries, set log level to debug to see all entries"
],
[
2,
2,
2,
2,
2,
"And 5 more entries, set log level to debug to see all entries"
]
]
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 466,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection",
"type": "->",
"args": [
"INSERT INTO \"oc_user_oidc_sessions\" (\"sid\", \"sub\", \"iss\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\", \"user_id\", \"provider_id\", \"idp_session_closed\") VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10)",
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": "*** sensitive parameters replaced ***",
"dcValue2": "*** sensitive parameters replaced ***",
"dcValue3": "*** sensitive parameters replaced ***",
"dcValue4": "*** sensitive parameters replaced ***",
"dcValue5": "*** sensitive parameters replaced ***"
},
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2,
"dcValue4": 2,
"dcValue5": 2
}
]
},
{
"file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
"line": 67,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"INSERT INTO \"oc_user_oidc_sessions\" (\"sid\", \"sub\", \"iss\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\", \"user_id\", \"provider_id\", \"idp_session_closed\") VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10)",
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": "*** sensitive parameters replaced ***",
"dcValue2": "*** sensitive parameters replaced ***",
"dcValue3": "*** sensitive parameters replaced ***",
"dcValue4": "*** sensitive parameters replaced ***",
"dcValue5": "*** sensitive parameters replaced ***"
},
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2,
"dcValue4": 2,
"dcValue5": 2
}
]
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 306,
"function": "executeStatement",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->",
"args": [
"INSERT INTO `*PREFIX*user_oidc_sessions` (`sid`, `sub`, `iss`, `authtoken_id`, `nc_session_id`, `created_at`, `id_token`, `user_id`, `provider_id`, `idp_session_closed`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10)",
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": "*** sensitive parameters replaced ***",
"dcValue2": "*** sensitive parameters replaced ***",
"dcValue3": "*** sensitive parameters replaced ***",
"dcValue4": "*** sensitive parameters replaced ***",
"dcValue5": "*** sensitive parameters replaced ***"
},
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2,
"dcValue4": 2,
"dcValue5": 2
}
]
},
{
"file": "/var/www/html/lib/public/AppFramework/Db/QBMapper.php",
"line": 116,
"function": "executeStatement",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/custom_apps/user_oidc/lib/Db/SessionMapper.php",
"line": 216,
"function": "insert",
"class": "OCP\\AppFramework\\Db\\QBMapper",
"type": "->",
"args": [
{
"__class__": "OCA\\UserOIDC\\Db\\Session",
"id": null
}
]
},
{
"file": "/var/www/html/custom_apps/user_oidc/lib/Controller/LoginController.php",
"line": 621,
"function": "createOrUpdateSession",
"class": "OCA\\UserOIDC\\Db\\SessionMapper",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 200,
"function": "code",
"class": "OCA\\UserOIDC\\Controller\\LoginController",
"type": "->",
"args": [
"REDACTED",
"REDACTED",
{
"filesystem": true,
"password-unconfirmable": true
},
"",
""
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 114,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\UserOIDC\\Controller\\LoginController"
},
"code"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 161,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\UserOIDC\\Controller\\LoginController"
},
"code"
]
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 315,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::",
"args": [
"OCA\\UserOIDC\\Controller\\LoginController",
"code",
{
"__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
},
{
"_route": "user_oidc.login.code"
}
]
},
{
"file": "/var/www/html/lib/base.php",
"line": 1063,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->",
"args": [
"/apps/user_oidc/code"
]
},
{
"file": "/var/www/html/index.php",
"line": 24,
"function": "handleRequest",
"class": "OC",
"type": "::",
"args": []
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php",
"Line": 68,
"Previous": {
"Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"Message": "SQLSTATE[42703]: Undefined column: 7 ERROR: column \"id_token\" of relation \"oc_user_oidc_sessions\" does not exist\nLINE 1: ...\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\"...\n ^",
"Code": 7,
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line": 132,
"function": "new",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"type": "::",
"args": [
{
"__class__": "PDOException",
"errorInfo": [
"42703",
7,
"ERROR: column \"id_token\" of relation \"oc_user_oidc_sessions\" does not exist\nLINE 1: ...\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\"...\n ^"
]
}
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1212,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
"type": "->",
"args": []
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php",
"line": 292,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"INSERT INTO \"oc_user_oidc_sessions\" (\"sid\", \"sub\", \"iss\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\", \"user_id\", \"provider_id\", \"idp_session_closed\") VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
[
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"And 5 more entries, set log level to debug to see all entries"
],
[
2,
2,
2,
2,
2,
"And 5 more entries, set log level to debug to see all entries"
]
]
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 466,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection",
"type": "->",
"args": [
"INSERT INTO \"oc_user_oidc_sessions\" (\"sid\", \"sub\", \"iss\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\", \"user_id\", \"provider_id\", \"idp_session_closed\") VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10)",
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": "*** sensitive parameters replaced ***",
"dcValue2": "*** sensitive parameters replaced ***",
"dcValue3": "*** sensitive parameters replaced ***",
"dcValue4": "*** sensitive parameters replaced ***",
"dcValue5": "*** sensitive parameters replaced ***"
},
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2,
"dcValue4": 2,
"dcValue5": 2
}
]
},
{
"file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
"line": 67,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"INSERT INTO \"oc_user_oidc_sessions\" (\"sid\", \"sub\", \"iss\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\", \"user_id\", \"provider_id\", \"idp_session_closed\") VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10)",
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": "*** sensitive parameters replaced ***",
"dcValue2": "*** sensitive parameters replaced ***",
"dcValue3": "*** sensitive parameters replaced ***",
"dcValue4": "*** sensitive parameters replaced ***",
"dcValue5": "*** sensitive parameters replaced ***"
},
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2,
"dcValue4": 2,
"dcValue5": 2
}
]
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 306,
"function": "executeStatement",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->",
"args": [
"INSERT INTO `*PREFIX*user_oidc_sessions` (`sid`, `sub`, `iss`, `authtoken_id`, `nc_session_id`, `created_at`, `id_token`, `user_id`, `provider_id`, `idp_session_closed`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10)",
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": "*** sensitive parameters replaced ***",
"dcValue2": "*** sensitive parameters replaced ***",
"dcValue3": "*** sensitive parameters replaced ***",
"dcValue4": "*** sensitive parameters replaced ***",
"dcValue5": "*** sensitive parameters replaced ***"
},
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2,
"dcValue4": 2,
"dcValue5": 2
}
]
},
{
"file": "/var/www/html/lib/public/AppFramework/Db/QBMapper.php",
"line": 116,
"function": "executeStatement",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/custom_apps/user_oidc/lib/Db/SessionMapper.php",
"line": 216,
"function": "insert",
"class": "OCP\\AppFramework\\Db\\QBMapper",
"type": "->",
"args": [
{
"__class__": "OCA\\UserOIDC\\Db\\Session",
"id": null
}
]
},
{
"file": "/var/www/html/custom_apps/user_oidc/lib/Controller/LoginController.php",
"line": 621,
"function": "createOrUpdateSession",
"class": "OCA\\UserOIDC\\Db\\SessionMapper",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 200,
"function": "code",
"class": "OCA\\UserOIDC\\Controller\\LoginController",
"type": "->",
"args": [
"REDACTED",
"REDACTED",
{
"filesystem": true,
"password-unconfirmable": true
},
"",
""
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 114,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\UserOIDC\\Controller\\LoginController"
},
"code"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 161,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\UserOIDC\\Controller\\LoginController"
},
"code"
]
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 315,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::",
"args": [
"OCA\\UserOIDC\\Controller\\LoginController",
"code",
{
"__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
},
{
"_route": "user_oidc.login.code"
}
]
},
{
"file": "/var/www/html/lib/base.php",
"line": 1063,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->",
"args": [
"/apps/user_oidc/code"
]
},
{
"file": "/var/www/html/index.php",
"line": 24,
"function": "handleRequest",
"class": "OC",
"type": "::",
"args": []
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
"Line": 24,
"Previous": {
"Exception": "PDOException",
"Message": "SQLSTATE[42703]: Undefined column: 7 ERROR: column \"id_token\" of relation \"oc_user_oidc_sessions\" does not exist\nLINE 1: ...\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\"...\n ^",
"Code": "42703",
"Trace": [
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"line": 130,
"function": "execute",
"class": "PDOStatement",
"type": "->",
"args": [
null
]
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1212,
"function": "execute",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
"type": "->",
"args": []
},
{
"file": "/var/www/html/3rdparty/doctrine/dbal/src/Connections/PrimaryReadReplicaConnection.php",
"line": 292,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->",
"args": [
"INSERT INTO \"oc_user_oidc_sessions\" (\"sid\", \"sub\", \"iss\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\", \"user_id\", \"provider_id\", \"idp_session_closed\") VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
[
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"*** sensitive parameters replaced ***",
"And 5 more entries, set log level to debug to see all entries"
],
[
2,
2,
2,
2,
2,
"And 5 more entries, set log level to debug to see all entries"
]
]
},
{
"file": "/var/www/html/lib/private/DB/Connection.php",
"line": 466,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connections\\PrimaryReadReplicaConnection",
"type": "->",
"args": [
"INSERT INTO \"oc_user_oidc_sessions\" (\"sid\", \"sub\", \"iss\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\", \"user_id\", \"provider_id\", \"idp_session_closed\") VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10)",
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": "*** sensitive parameters replaced ***",
"dcValue2": "*** sensitive parameters replaced ***",
"dcValue3": "*** sensitive parameters replaced ***",
"dcValue4": "*** sensitive parameters replaced ***",
"dcValue5": "*** sensitive parameters replaced ***"
},
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2,
"dcValue4": 2,
"dcValue5": 2
}
]
},
{
"file": "/var/www/html/lib/private/DB/ConnectionAdapter.php",
"line": 67,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->",
"args": [
"INSERT INTO \"oc_user_oidc_sessions\" (\"sid\", \"sub\", \"iss\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\", \"user_id\", \"provider_id\", \"idp_session_closed\") VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10)",
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": "*** sensitive parameters replaced ***",
"dcValue2": "*** sensitive parameters replaced ***",
"dcValue3": "*** sensitive parameters replaced ***",
"dcValue4": "*** sensitive parameters replaced ***",
"dcValue5": "*** sensitive parameters replaced ***"
},
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2,
"dcValue4": 2,
"dcValue5": 2
}
]
},
{
"file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
"line": 306,
"function": "executeStatement",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->",
"args": [
"INSERT INTO `*PREFIX*user_oidc_sessions` (`sid`, `sub`, `iss`, `authtoken_id`, `nc_session_id`, `created_at`, `id_token`, `user_id`, `provider_id`, `idp_session_closed`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10)",
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": "*** sensitive parameters replaced ***",
"dcValue2": "*** sensitive parameters replaced ***",
"dcValue3": "*** sensitive parameters replaced ***",
"dcValue4": "*** sensitive parameters replaced ***",
"dcValue5": "*** sensitive parameters replaced ***"
},
{
"0": "And 5 more entries, set log level to debug to see all entries",
"dcValue1": 2,
"dcValue2": 2,
"dcValue3": 2,
"dcValue4": 2,
"dcValue5": 2
}
]
},
{
"file": "/var/www/html/lib/public/AppFramework/Db/QBMapper.php",
"line": 116,
"function": "executeStatement",
"class": "OC\\DB\\QueryBuilder\\QueryBuilder",
"type": "->",
"args": []
},
{
"file": "/var/www/html/custom_apps/user_oidc/lib/Db/SessionMapper.php",
"line": 216,
"function": "insert",
"class": "OCP\\AppFramework\\Db\\QBMapper",
"type": "->",
"args": [
{
"__class__": "OCA\\UserOIDC\\Db\\Session",
"id": null
}
]
},
{
"file": "/var/www/html/custom_apps/user_oidc/lib/Controller/LoginController.php",
"line": 621,
"function": "createOrUpdateSession",
"class": "OCA\\UserOIDC\\Db\\SessionMapper",
"type": "->",
"args": [
"*** sensitive parameters replaced ***"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 200,
"function": "code",
"class": "OCA\\UserOIDC\\Controller\\LoginController",
"type": "->",
"args": [
"REDACTED",
"REDACTED",
{
"filesystem": true,
"password-unconfirmable": true
},
"",
""
]
},
{
"file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php",
"line": 114,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\UserOIDC\\Controller\\LoginController"
},
"code"
]
},
{
"file": "/var/www/html/lib/private/AppFramework/App.php",
"line": 161,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->",
"args": [
{
"__class__": "OCA\\UserOIDC\\Controller\\LoginController"
},
"code"
]
},
{
"file": "/var/www/html/lib/private/Route/Router.php",
"line": 315,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::",
"args": [
"OCA\\UserOIDC\\Controller\\LoginController",
"code",
{
"__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer"
},
{
"_route": "user_oidc.login.code"
}
]
},
{
"file": "/var/www/html/lib/base.php",
"line": 1063,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->",
"args": [
"/apps/user_oidc/code"
]
},
{
"file": "/var/www/html/index.php",
"line": 24,
"function": "handleRequest",
"class": "OC",
"type": "::",
"args": []
}
],
"File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
"Line": 130
}
}
},
"message": "An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column \"id_token\" of relation \"oc_user_oidc_sessions\" does not exist\nLINE 1: ...\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\"...\n ^",
"exception": {
"query": "INSERT INTO `*PREFIX*user_oidc_sessions` (`sid`, `sub`, `iss`, `authtoken_id`, `nc_session_id`, `created_at`, `id_token`, `user_id`, `provider_id`, `idp_session_closed`) VALUES(:dcValue1, :dcValue2, :dcValue3, :dcValue4, :dcValue5, :dcValue6, :dcValue7, :dcValue8, :dcValue9, :dcValue10)"
},
"CustomMessage": "An exception occurred while executing a query: SQLSTATE[42703]: Undefined column: 7 ERROR: column \"id_token\" of relation \"oc_user_oidc_sessions\" does not exist\nLINE 1: ...\", \"authtoken_id\", \"nc_session_id\", \"created_at\", \"id_token\"...\n ^"
},
"id": "6910ddb093185"
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment