15.4.0-beta2: internal server errors when marking feed as read #1211
Comments
ghost
added
the
|
Hey thanks for the report and the testing :) It's the same on mysql 8.0: {
"reqId": "WgYBXk1VwsWQV9csCFpG",
"level": 3,
"time": "2021-03-01T11:08:48+00:00",
"remoteAddr": "95.90.254.119",
"user": "benjamin",
"app": "index",
"method": "POST",
"url": "/index.php/apps/news/feeds/12/read",
"message": {
"Exception": "OC\\DB\\Exceptions\\DbalException",
"Message": "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxIt' at line 1",
"Code": 1064,
"Trace": [
{
"file": "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
"line": 77,
"function": "wrap",
"class": "OC\\DB\\Exceptions\\DbalException",
"type": "::"
},
{
"file": "/var/www/nextcloud/apps/news/lib/Db/FeedMapperV2.php",
"line": 178,
"function": "executeUpdate",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/news/lib/Service/FeedServiceV2.php",
"line": 358,
"function": "read",
"class": "OCA\\News\\Db\\FeedMapperV2",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/news/lib/Controller/FeedController.php",
"line": 286,
"function": "read",
"class": "OCA\\News\\Service\\FeedServiceV2",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 218,
"function": "read",
"class": "OCA\\News\\Controller\\FeedController",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 127,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
"line": 157,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/Route/Router.php",
"line": 302,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::"
},
{
"file": "/var/www/nextcloud/lib/base.php",
"line": 993,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->"
},
{
"file": "/var/www/nextcloud/index.php",
"line": 37,
"function": "handleRequest",
"class": "OC",
"type": "::"
}
],
"File": "/var/www/nextcloud/lib/private/DB/Exceptions/DbalException.php",
"Line": 70,
"Previous": {
"Exception": "Doctrine\\DBAL\\Exception\\SyntaxErrorException",
"Message": "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxIt' at line 1",
"Code": 1064,
"Trace": [
{
"file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1728,
"function": "convert",
"class": "Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1667,
"function": "handleDriverException",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1146,
"function": "convertExceptionDuringQuery",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/DB/Connection.php",
"line": 257,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1747,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/DB/Connection.php",
"line": 236,
"function": "executeUpdate",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
"line": 75,
"function": "executeUpdate",
"class": "OC\\DB\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/news/lib/Db/FeedMapperV2.php",
"line": 178,
"function": "executeUpdate",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/news/lib/Service/FeedServiceV2.php",
"line": 358,
"function": "read",
"class": "OCA\\News\\Db\\FeedMapperV2",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/news/lib/Controller/FeedController.php",
"line": 286,
"function": "read",
"class": "OCA\\News\\Service\\FeedServiceV2",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 218,
"function": "read",
"class": "OCA\\News\\Controller\\FeedController",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 127,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
"line": 157,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/Route/Router.php",
"line": 302,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::"
},
{
"file": "/var/www/nextcloud/lib/base.php",
"line": 993,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->"
},
{
"file": "/var/www/nextcloud/index.php",
"line": 37,
"function": "handleRequest",
"class": "OC",
"type": "::"
}
],
"File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php",
"Line": 84,
"Previous": {
"Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"Message": "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxIt' at line 1",
"Code": 1064,
"Trace": [
{
"file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
"line": 50,
"function": "new",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
"type": "::"
},
{
"file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1144,
"function": "exec",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/DB/Connection.php",
"line": 257,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1747,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/DB/Connection.php",
"line": 236,
"function": "executeUpdate",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
"line": 75,
"function": "executeUpdate",
"class": "OC\\DB\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/news/lib/Db/FeedMapperV2.php",
"line": 178,
"function": "executeUpdate",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/news/lib/Service/FeedServiceV2.php",
"line": 358,
"function": "read",
"class": "OCA\\News\\Db\\FeedMapperV2",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/news/lib/Controller/FeedController.php",
"line": 286,
"function": "read",
"class": "OCA\\News\\Service\\FeedServiceV2",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 218,
"function": "read",
"class": "OCA\\News\\Controller\\FeedController",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 127,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
"line": 157,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/Route/Router.php",
"line": 302,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::"
},
{
"file": "/var/www/nextcloud/lib/base.php",
"line": 993,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->"
},
{
"file": "/var/www/nextcloud/index.php",
"line": 37,
"function": "handleRequest",
"class": "OC",
"type": "::"
}
],
"File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
"Line": 26,
"Previous": {
"Exception": "PDOException",
"Message": "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxIt' at line 1",
"Code": "42000",
"Trace": [
{
"file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
"line": 44,
"function": "exec",
"class": "PDO",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1144,
"function": "exec",
"class": "Doctrine\\DBAL\\Driver\\PDO\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/DB/Connection.php",
"line": 257,
"function": "executeStatement",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php",
"line": 1747,
"function": "executeStatement",
"class": "OC\\DB\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/DB/Connection.php",
"line": 236,
"function": "executeUpdate",
"class": "Doctrine\\DBAL\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php",
"line": 75,
"function": "executeUpdate",
"class": "OC\\DB\\Connection",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/news/lib/Db/FeedMapperV2.php",
"line": 178,
"function": "executeUpdate",
"class": "OC\\DB\\ConnectionAdapter",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/news/lib/Service/FeedServiceV2.php",
"line": 358,
"function": "read",
"class": "OCA\\News\\Db\\FeedMapperV2",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/news/lib/Controller/FeedController.php",
"line": 286,
"function": "read",
"class": "OCA\\News\\Service\\FeedServiceV2",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 218,
"function": "read",
"class": "OCA\\News\\Controller\\FeedController",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 127,
"function": "executeController",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
"line": 157,
"function": "dispatch",
"class": "OC\\AppFramework\\Http\\Dispatcher",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/Route/Router.php",
"line": 302,
"function": "main",
"class": "OC\\AppFramework\\App",
"type": "::"
},
{
"file": "/var/www/nextcloud/lib/base.php",
"line": 993,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->"
},
{
"file": "/var/www/nextcloud/index.php",
"line": 37,
"function": "handleRequest",
"class": "OC",
"type": "::"
}
],
"File": "/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php",
"Line": 44
}
}
},
"CustomMessage": "--"
},
"userAgent": "Mozilla/5.0 (X11; Linux x86_64; rv:86.0) Gecko/20100101 Firefox/86.0",
"version": "21.0.0.18"
} |
|
Interestingly the android client doesn't trigger this. I can mark a feed as read, without errors. |
SMillerDev
added a commit
to SMillerDev/news
that referenced
this issue
Mar 1, 2021
Issue nextcloudGH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
SMillerDev
added a commit
to SMillerDev/news
that referenced
this issue
Mar 2, 2021
Issue nextcloudGH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
SMillerDev
added a commit
to SMillerDev/news
that referenced
this issue
Mar 2, 2021
Issue nextcloudGH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
SMillerDev
added a commit
to SMillerDev/news
that referenced
this issue
Mar 2, 2021
Issue nextcloudGH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
SMillerDev
added a commit
to SMillerDev/news
that referenced
this issue
Mar 9, 2021
Issue nextcloudGH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
SMillerDev
added a commit
to SMillerDev/news
that referenced
this issue
Mar 17, 2021
Issue nextcloudGH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
SMillerDev
added a commit
to SMillerDev/news
that referenced
this issue
Mar 23, 2021
Issue nextcloudGH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
SMillerDev
added a commit
to SMillerDev/news
that referenced
this issue
Mar 23, 2021
Issue nextcloudGH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
SMillerDev
added a commit
to SMillerDev/news
that referenced
this issue
Mar 23, 2021
Issue nextcloudGH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
SMillerDev
added a commit
to SMillerDev/news
that referenced
this issue
Mar 25, 2021
Issue nextcloudGH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
SMillerDev
added a commit
to SMillerDev/news
that referenced
this issue
Mar 30, 2021
Issue nextcloudGH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
SMillerDev
added a commit
that referenced
this issue
Mar 31, 2021
Issue GH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
Grotax
added a commit
that referenced
this issue
Apr 3, 2021
Changed - Add BATS as integration tests (#1213) - Update FeedFetcher to import categories from feeds (#1248) - Update serialization of item to include categories (#1248) - Make PHPStan stricter (#955) - Search: Add folder search (#1215) - Improve test coverage (#1263) - Allow directly adding a feed without going through the discovery process (#1265) Fixed - Do not show deleted feeds in item list (#1214) - Fix update queries (#1211)
Merged
Grotax
added a commit
that referenced
this issue
Apr 3, 2021
Changed - Add BATS as integration tests (#1213) - Update FeedFetcher to import categories from feeds (#1248) - Update serialization of item to include categories (#1248) - Make PHPStan stricter (#955) - Search: Add folder search (#1215) - Improve test coverage (#1263) - Allow directly adding a feed without going through the discovery process (#1265) Fixed - Do not show deleted feeds in item list (#1214) - Fix update queries (#1211) Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
Grotax
added a commit
that referenced
this issue
Apr 3, 2021
Changed - Add BATS as integration tests (#1213) - Update FeedFetcher to import categories from feeds (#1248) - Update serialization of item to include categories (#1248) - Make PHPStan stricter (#955) - Search: Add folder search (#1215) - Improve test coverage (#1263) - Allow directly adding a feed without going through the discovery process (#1265) Fixed - Do not show deleted feeds in item list (#1214) - Fix update queries (#1211) Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
|
Not sure if I'm experiencing the same issue, but this doesn't seem to be fixed. At 15.4.0,
Is it the same issue or should I create a new one? |
Neo11
pushed a commit
to Neo11/news
that referenced
this issue
May 28, 2022
Issue nextcloudGH-1211 Signed-off-by: Sean Molenaar <sean@seanmolenaar.eu>
Neo11
pushed a commit
to Neo11/news
that referenced
this issue
May 28, 2022
Changed - Add BATS as integration tests (nextcloud#1213) - Update FeedFetcher to import categories from feeds (nextcloud#1248) - Update serialization of item to include categories (nextcloud#1248) - Make PHPStan stricter (nextcloud#955) - Search: Add folder search (nextcloud#1215) - Improve test coverage (nextcloud#1263) - Allow directly adding a feed without going through the discovery process (nextcloud#1265) Fixed - Do not show deleted feeds in item list (nextcloud#1214) - Fix update queries (nextcloud#1211) Signed-off-by: Benjamin Brahmer <info@b-brahmer.de>
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
IMPORTANT
Read and tick the following checkbox after you have created the issue or place an x inside the brackets ;)
Explain the Problem
There are internal server errors after upgrading News to 15.4.0-beta2 when marking a feed as read using Sqlite or PSQL (haven't tested Mariadb/MySQL).
Steps to Reproduce
Explain what you did to encounter the issue
System Information
Contents of nextcloud/data/nextcloud.log
Sqlite
{ "reqId": "9RmJRKkbsFWG1vtgokwb", "level": 3, "time": "2021-02-28T11:38:25+00:00", "remoteAddr": "127.0.0.1", "user": "user", "app": "index", "method": "POST", "url": "/apps/news/feeds/1/read", "message": { "Exception": "OC\\DB\\Exceptions\\DbalException", "Message": "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 near \"items\": syntax error", "Code": 1, "Trace": [ { "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php", "line": 77, "function": "wrap", "class": "OC\\DB\\Exceptions\\DbalException", "type": "::", "args": [ { "__class__": "Doctrine\\DBAL\\Exception\\SyntaxErrorException" } ] }, { "file": "/var/www/html/custom_apps/news/lib/Db/FeedMapperV2.php", "line": 178, "function": "executeUpdate", "class": "OC\\DB\\ConnectionAdapter", "type": "->", "args": [ "UPDATE `*PREFIX*news_items` items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php", "line": 358, "function": "read", "class": "OCA\\News\\Db\\FeedMapperV2", "type": "->", "args": [ "user", 1, 40 ] }, { "file": "/var/www/html/custom_apps/news/lib/Controller/FeedController.php", "line": 286, "function": "read", "class": "OCA\\News\\Service\\FeedServiceV2", "type": "->", "args": [ "user", 1, 40 ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 218, "function": "read", "class": "OCA\\News\\Controller\\FeedController", "type": "->", "args": [ 1, 40 ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 127, "function": "executeController", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\FeedController" }, "read" ] }, { "file": "/var/www/html/lib/private/AppFramework/App.php", "line": 157, "function": "dispatch", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\FeedController" }, "read" ] }, { "file": "/var/www/html/lib/private/Route/Router.php", "line": 302, "function": "main", "class": "OC\\AppFramework\\App", "type": "::", "args": [ "OCA\\News\\Controller\\FeedController", "read", { "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer" }, { "feedId": "1", "_route": "news.feed.read" } ] }, { "file": "/var/www/html/lib/base.php", "line": 993, "function": "match", "class": "OC\\Route\\Router", "type": "->", "args": [ "/apps/news/feeds/1/read" ] }, { "file": "/var/www/html/index.php", "line": 37, "function": "handleRequest", "class": "OC", "type": "::", "args": [] } ], "File": "/var/www/html/lib/private/DB/Exceptions/DbalException.php", "Line": 70, "Previous": { "Exception": "Doctrine\\DBAL\\Exception\\SyntaxErrorException", "Message": "An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 near \"items\": syntax error", "Code": 1, "Trace": [ { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1728, "function": "convert", "class": "Doctrine\\DBAL\\Driver\\API\\SQLite\\ExceptionConverter", "type": "->", "args": [ { "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception" }, { "__class__": "Doctrine\\DBAL\\Query" } ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1667, "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": 1146, "function": "convertExceptionDuringQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ { "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception" }, "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/lib/private/DB/Connection.php", "line": 257, "function": "executeStatement", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1747, "function": "executeStatement", "class": "OC\\DB\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/lib/private/DB/Connection.php", "line": 236, "function": "executeUpdate", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php", "line": 75, "function": "executeUpdate", "class": "OC\\DB\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/custom_apps/news/lib/Db/FeedMapperV2.php", "line": 178, "function": "executeUpdate", "class": "OC\\DB\\ConnectionAdapter", "type": "->", "args": [ "UPDATE `*PREFIX*news_items` items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php", "line": 358, "function": "read", "class": "OCA\\News\\Db\\FeedMapperV2", "type": "->", "args": [ "user", 1, 40 ] }, { "file": "/var/www/html/custom_apps/news/lib/Controller/FeedController.php", "line": 286, "function": "read", "class": "OCA\\News\\Service\\FeedServiceV2", "type": "->", "args": [ "user", 1, 40 ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 218, "function": "read", "class": "OCA\\News\\Controller\\FeedController", "type": "->", "args": [ 1, 40 ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 127, "function": "executeController", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\FeedController" }, "read" ] }, { "file": "/var/www/html/lib/private/AppFramework/App.php", "line": 157, "function": "dispatch", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\FeedController" }, "read" ] }, { "file": "/var/www/html/lib/private/Route/Router.php", "line": 302, "function": "main", "class": "OC\\AppFramework\\App", "type": "::", "args": [ "OCA\\News\\Controller\\FeedController", "read", { "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer" }, { "feedId": "1", "_route": "news.feed.read" } ] }, { "file": "/var/www/html/lib/base.php", "line": 993, "function": "match", "class": "OC\\Route\\Router", "type": "->", "args": [ "/apps/news/feeds/1/read" ] }, { "file": "/var/www/html/index.php", "line": 37, "function": "handleRequest", "class": "OC", "type": "::", "args": [] } ], "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/SQLite/ExceptionConverter.php", "Line": 71, "Previous": { "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception", "Message": "SQLSTATE[HY000]: General error: 1 near \"items\": syntax error", "Code": 1, "Trace": [ { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php", "line": 50, "function": "new", "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception", "type": "::", "args": [ { "errorInfo": [ "HY000", 1, "near \"items\": syntax error" ], "__class__": "PDOException" } ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1144, "function": "exec", "class": "Doctrine\\DBAL\\Driver\\PDO\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)" ] }, { "file": "/var/www/html/lib/private/DB/Connection.php", "line": 257, "function": "executeStatement", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1747, "function": "executeStatement", "class": "OC\\DB\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/lib/private/DB/Connection.php", "line": 236, "function": "executeUpdate", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php", "line": 75, "function": "executeUpdate", "class": "OC\\DB\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/custom_apps/news/lib/Db/FeedMapperV2.php", "line": 178, "function": "executeUpdate", "class": "OC\\DB\\ConnectionAdapter", "type": "->", "args": [ "UPDATE `*PREFIX*news_items` items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php", "line": 358, "function": "read", "class": "OCA\\News\\Db\\FeedMapperV2", "type": "->", "args": [ "user", 1, 40 ] }, { "file": "/var/www/html/custom_apps/news/lib/Controller/FeedController.php", "line": 286, "function": "read", "class": "OCA\\News\\Service\\FeedServiceV2", "type": "->", "args": [ "user", 1, 40 ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 218, "function": "read", "class": "OCA\\News\\Controller\\FeedController", "type": "->", "args": [ 1, 40 ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 127, "function": "executeController", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\FeedController" }, "read" ] }, { "file": "/var/www/html/lib/private/AppFramework/App.php", "line": 157, "function": "dispatch", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\FeedController" }, "read" ] }, { "file": "/var/www/html/lib/private/Route/Router.php", "line": 302, "function": "main", "class": "OC\\AppFramework\\App", "type": "::", "args": [ "OCA\\News\\Controller\\FeedController", "read", { "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer" }, { "feedId": "1", "_route": "news.feed.read" } ] }, { "file": "/var/www/html/lib/base.php", "line": 993, "function": "match", "class": "OC\\Route\\Router", "type": "->", "args": [ "/apps/news/feeds/1/read" ] }, { "file": "/var/www/html/index.php", "line": 37, "function": "handleRequest", "class": "OC", "type": "::", "args": [] } ], "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php", "Line": 26, "Previous": { "Exception": "PDOException", "Message": "SQLSTATE[HY000]: General error: 1 near \"items\": syntax error", "Code": "HY000", "Trace": [ { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php", "line": 44, "function": "exec", "class": "PDO", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)" ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1144, "function": "exec", "class": "Doctrine\\DBAL\\Driver\\PDO\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)" ] }, { "file": "/var/www/html/lib/private/DB/Connection.php", "line": 257, "function": "executeStatement", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1747, "function": "executeStatement", "class": "OC\\DB\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/lib/private/DB/Connection.php", "line": 236, "function": "executeUpdate", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/lib/private/DB/ConnectionAdapter.php", "line": 75, "function": "executeUpdate", "class": "OC\\DB\\Connection", "type": "->", "args": [ "UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)", [], [] ] }, { "file": "/var/www/html/custom_apps/news/lib/Db/FeedMapperV2.php", "line": 178, "function": "executeUpdate", "class": "OC\\DB\\ConnectionAdapter", "type": "->", "args": [ "UPDATE `*PREFIX*news_items` items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)" ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php", "line": 358, "function": "read", "class": "OCA\\News\\Db\\FeedMapperV2", "type": "->", "args": [ "user", 1, 40 ] }, { "file": "/var/www/html/custom_apps/news/lib/Controller/FeedController.php", "line": 286, "function": "read", "class": "OCA\\News\\Service\\FeedServiceV2", "type": "->", "args": [ "user", 1, 40 ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 218, "function": "read", "class": "OCA\\News\\Controller\\FeedController", "type": "->", "args": [ 1, 40 ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 127, "function": "executeController", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\FeedController" }, "read" ] }, { "file": "/var/www/html/lib/private/AppFramework/App.php", "line": 157, "function": "dispatch", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\FeedController" }, "read" ] }, { "file": "/var/www/html/lib/private/Route/Router.php", "line": 302, "function": "main", "class": "OC\\AppFramework\\App", "type": "::", "args": [ "OCA\\News\\Controller\\FeedController", "read", { "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer" }, { "feedId": "1", "_route": "news.feed.read" } ] }, { "file": "/var/www/html/lib/base.php", "line": 993, "function": "match", "class": "OC\\Route\\Router", "type": "->", "args": [ "/apps/news/feeds/1/read" ] }, { "file": "/var/www/html/index.php", "line": 37, "function": "handleRequest", "class": "OC", "type": "::", "args": [] } ], "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php", "Line": 44 } } }, "CustomMessage": "--" }, "userAgent": "Mozilla/5.0 (X11; Linux x86_64; rv:86.0) Gecko/20100101 Firefox/86.0", "version": "21.0.0.18", "id": "603b80f51120a" }PSQL1
{ "reqId": "XStmz7ExYBT3UAYZdxMA", "level": 3, "time": "2021-02-28T12:57:35+00:00", "remoteAddr": "127.0.0.1", "user": "user", "app": "index", "method": "GET", "url": "/index.php/apps/news/items?id=1&limit=40&oldestFirst=false&search=&showAll=false&type=0", "message": { "Exception": "Doctrine\\DBAL\\Exception\\DriverException", "Message": "An exception occurred while executing a query: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: boolean = integer\nLINE 1: ... = $1) AND (items.feed_id = $2) AND (items.unread = 1) ORDER...\n ^\nHINT: No operator matches the given name and argument types. You might need to add explicit type casts.", "Code": 7, "Trace": [ { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1728, "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": 1667, "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": 1040, "function": "convertExceptionDuringQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ { "__class__": "Doctrine\\DBAL\\Driver\\PDO\\Exception" }, "SELECT \"items\".* FROM \"oc_news_items\" \"items\" INNER JOIN \"oc_news_feeds\" \"feeds\" ON items.feed_id = feeds.id WHERE (feeds.user_id = ?) AND (items.feed_id = ?) AND (items.unread = 1) ORDER BY \"items\".\"last_modified\" DESC, \"items\".\"id\" DESC LIMIT 40", [ "user", 1 ], [] ] }, { "file": "/var/www/html/lib/private/DB/Connection.php", "line": 226, "function": "executeQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ "SELECT \"items\".* FROM \"oc_news_items\" \"items\" INNER JOIN \"oc_news_feeds\" \"feeds\" ON items.feed_id = feeds.id WHERE (feeds.user_id = ?) AND (items.feed_id = ?) AND (items.unread = 1) ORDER BY \"items\".\"last_modified\" DESC, \"items\".\"id\" DESC LIMIT 40", [ "user", 1 ], [], null ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php", "line": 210, "function": "executeQuery", "class": "OC\\DB\\Connection", "type": "->", "args": [ "SELECT \"items\".* FROM \"oc_news_items\" \"items\" INNER JOIN \"oc_news_feeds\" \"feeds\" ON items.feed_id = feeds.id WHERE (feeds.user_id = :userId) AND (items.feed_id = :feedId) AND (items.unread = 1) ORDER BY \"items\".\"last_modified\" DESC, \"items\".\"id\" DESC LIMIT 40", { "userId": "user", "feedId": 1 }, [] ] }, { "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 286, "function": "execute", "class": "Doctrine\\DBAL\\Query\\QueryBuilder", "type": "->", "args": [] }, { "file": "/var/www/html/lib/public/AppFramework/Db/QBMapper.php", "line": 320, "function": "execute", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->", "args": [] }, { "file": "/var/www/html/custom_apps/news/lib/Db/ItemMapperV2.php", "line": 471, "function": "findEntities", "class": "OCP\\AppFramework\\Db\\QBMapper", "type": "->", "args": [ { "__class__": "OC\\DB\\QueryBuilder\\QueryBuilder" } ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/ItemServiceV2.php", "line": 342, "function": "findAllFeed", "class": "OCA\\News\\Db\\ItemMapperV2", "type": "->", "args": [ "user", 1, 40, 0, true, false, [] ] }, { "file": "/var/www/html/custom_apps/news/lib/Controller/ItemController.php", "line": 141, "function": "findAllInFeedWithFilters", "class": "OCA\\News\\Service\\ItemServiceV2", "type": "->", "args": [ "user", 1, 40, 0, true, false, [] ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 218, "function": "index", "class": "OCA\\News\\Controller\\ItemController", "type": "->", "args": [ 0, 1, 40, 0, false, false, "" ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 127, "function": "executeController", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\ItemController" }, "index" ] }, { "file": "/var/www/html/lib/private/AppFramework/App.php", "line": 157, "function": "dispatch", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\ItemController" }, "index" ] }, { "file": "/var/www/html/lib/private/Route/Router.php", "line": 302, "function": "main", "class": "OC\\AppFramework\\App", "type": "::", "args": [ "OCA\\News\\Controller\\ItemController", "index", { "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer" }, { "_route": "news.item.index" } ] }, { "file": "/var/www/html/lib/base.php", "line": 993, "function": "match", "class": "OC\\Route\\Router", "type": "->", "args": [ "/apps/news/items" ] }, { "file": "/var/www/html/index.php", "line": 37, "function": "handleRequest", "class": "OC", "type": "::", "args": [] } ], "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php", "Line": 83, "Previous": { "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception", "Message": "SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: boolean = integer\nLINE 1: ... = $1) AND (items.feed_id = $2) AND (items.unread = 1) ORDER...\n ^\nHINT: No operator matches the given name and argument types. You might need to add explicit type casts.", "Code": 7, "Trace": [ { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php", "line": 84, "function": "new", "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception", "type": "::", "args": [ { "errorInfo": [ "42883", 7, "ERROR: operator does not exist: boolean = integer\nLINE 1: ... = $1) AND (items.feed_id = $2) AND (items.unread = 1) ORDER...\n ^\nHINT: No operator matches the given name and argument types. You might need to add explicit type casts." ], "__class__": "PDOException" } ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1032, "function": "execute", "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement", "type": "->", "args": [ [ "user", 1 ] ] }, { "file": "/var/www/html/lib/private/DB/Connection.php", "line": 226, "function": "executeQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ "SELECT \"items\".* FROM \"oc_news_items\" \"items\" INNER JOIN \"oc_news_feeds\" \"feeds\" ON items.feed_id = feeds.id WHERE (feeds.user_id = ?) AND (items.feed_id = ?) AND (items.unread = 1) ORDER BY \"items\".\"last_modified\" DESC, \"items\".\"id\" DESC LIMIT 40", [ "user", 1 ], [], null ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php", "line": 210, "function": "executeQuery", "class": "OC\\DB\\Connection", "type": "->", "args": [ "SELECT \"items\".* FROM \"oc_news_items\" \"items\" INNER JOIN \"oc_news_feeds\" \"feeds\" ON items.feed_id = feeds.id WHERE (feeds.user_id = :userId) AND (items.feed_id = :feedId) AND (items.unread = 1) ORDER BY \"items\".\"last_modified\" DESC, \"items\".\"id\" DESC LIMIT 40", { "userId": "user", "feedId": 1 }, [] ] }, { "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 286, "function": "execute", "class": "Doctrine\\DBAL\\Query\\QueryBuilder", "type": "->", "args": [] }, { "file": "/var/www/html/lib/public/AppFramework/Db/QBMapper.php", "line": 320, "function": "execute", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->", "args": [] }, { "file": "/var/www/html/custom_apps/news/lib/Db/ItemMapperV2.php", "line": 471, "function": "findEntities", "class": "OCP\\AppFramework\\Db\\QBMapper", "type": "->", "args": [ { "__class__": "OC\\DB\\QueryBuilder\\QueryBuilder" } ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/ItemServiceV2.php", "line": 342, "function": "findAllFeed", "class": "OCA\\News\\Db\\ItemMapperV2", "type": "->", "args": [ "user", 1, 40, 0, true, false, [] ] }, { "file": "/var/www/html/custom_apps/news/lib/Controller/ItemController.php", "line": 141, "function": "findAllInFeedWithFilters", "class": "OCA\\News\\Service\\ItemServiceV2", "type": "->", "args": [ "user", 1, 40, 0, true, false, [] ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 218, "function": "index", "class": "OCA\\News\\Controller\\ItemController", "type": "->", "args": [ 0, 1, 40, 0, false, false, "" ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 127, "function": "executeController", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\ItemController" }, "index" ] }, { "file": "/var/www/html/lib/private/AppFramework/App.php", "line": 157, "function": "dispatch", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\ItemController" }, "index" ] }, { "file": "/var/www/html/lib/private/Route/Router.php", "line": 302, "function": "main", "class": "OC\\AppFramework\\App", "type": "::", "args": [ "OCA\\News\\Controller\\ItemController", "index", { "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer" }, { "_route": "news.item.index" } ] }, { "file": "/var/www/html/lib/base.php", "line": 993, "function": "match", "class": "OC\\Route\\Router", "type": "->", "args": [ "/apps/news/items" ] }, { "file": "/var/www/html/index.php", "line": 37, "function": "handleRequest", "class": "OC", "type": "::", "args": [] } ], "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php", "Line": 26, "Previous": { "Exception": "PDOException", "Message": "SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: boolean = integer\nLINE 1: ... = $1) AND (items.feed_id = $2) AND (items.unread = 1) ORDER...\n ^\nHINT: No operator matches the given name and argument types. You might need to add explicit type casts.", "Code": "42883", "Trace": [ { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php", "line": 82, "function": "execute", "class": "PDOStatement", "type": "->", "args": [ [ "user", 1 ] ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php", "line": 1032, "function": "execute", "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement", "type": "->", "args": [ [ "user", 1 ] ] }, { "file": "/var/www/html/lib/private/DB/Connection.php", "line": 226, "function": "executeQuery", "class": "Doctrine\\DBAL\\Connection", "type": "->", "args": [ "SELECT \"items\".* FROM \"oc_news_items\" \"items\" INNER JOIN \"oc_news_feeds\" \"feeds\" ON items.feed_id = feeds.id WHERE (feeds.user_id = ?) AND (items.feed_id = ?) AND (items.unread = 1) ORDER BY \"items\".\"last_modified\" DESC, \"items\".\"id\" DESC LIMIT 40", [ "user", 1 ], [], null ] }, { "file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php", "line": 210, "function": "executeQuery", "class": "OC\\DB\\Connection", "type": "->", "args": [ "SELECT \"items\".* FROM \"oc_news_items\" \"items\" INNER JOIN \"oc_news_feeds\" \"feeds\" ON items.feed_id = feeds.id WHERE (feeds.user_id = :userId) AND (items.feed_id = :feedId) AND (items.unread = 1) ORDER BY \"items\".\"last_modified\" DESC, \"items\".\"id\" DESC LIMIT 40", { "userId": "user", "feedId": 1 }, [] ] }, { "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php", "line": 286, "function": "execute", "class": "Doctrine\\DBAL\\Query\\QueryBuilder", "type": "->", "args": [] }, { "file": "/var/www/html/lib/public/AppFramework/Db/QBMapper.php", "line": 320, "function": "execute", "class": "OC\\DB\\QueryBuilder\\QueryBuilder", "type": "->", "args": [] }, { "file": "/var/www/html/custom_apps/news/lib/Db/ItemMapperV2.php", "line": 471, "function": "findEntities", "class": "OCP\\AppFramework\\Db\\QBMapper", "type": "->", "args": [ { "__class__": "OC\\DB\\QueryBuilder\\QueryBuilder" } ] }, { "file": "/var/www/html/custom_apps/news/lib/Service/ItemServiceV2.php", "line": 342, "function": "findAllFeed", "class": "OCA\\News\\Db\\ItemMapperV2", "type": "->", "args": [ "user", 1, 40, 0, true, false, [] ] }, { "file": "/var/www/html/custom_apps/news/lib/Controller/ItemController.php", "line": 141, "function": "findAllInFeedWithFilters", "class": "OCA\\News\\Service\\ItemServiceV2", "type": "->", "args": [ "user", 1, 40, 0, true, false, [] ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 218, "function": "index", "class": "OCA\\News\\Controller\\ItemController", "type": "->", "args": [ 0, 1, 40, 0, false, false, "" ] }, { "file": "/var/www/html/lib/private/AppFramework/Http/Dispatcher.php", "line": 127, "function": "executeController", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\ItemController" }, "index" ] }, { "file": "/var/www/html/lib/private/AppFramework/App.php", "line": 157, "function": "dispatch", "class": "OC\\AppFramework\\Http\\Dispatcher", "type": "->", "args": [ { "__class__": "OCA\\News\\Controller\\ItemController" }, "index" ] }, { "file": "/var/www/html/lib/private/Route/Router.php", "line": 302, "function": "main", "class": "OC\\AppFramework\\App", "type": "::", "args": [ "OCA\\News\\Controller\\ItemController", "index", { "__class__": "OC\\AppFramework\\DependencyInjection\\DIContainer" }, { "_route": "news.item.index" } ] }, { "file": "/var/www/html/lib/base.php", "line": 993, "function": "match", "class": "OC\\Route\\Router", "type": "->", "args": [ "/apps/news/items" ] }, { "file": "/var/www/html/index.php", "line": 37, "function": "handleRequest", "class": "OC", "type": "::", "args": [] } ], "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php", "Line": 82 } }, "CustomMessage": "--" }, "userAgent": "Mozilla/5.0 (X11; Linux x86_64; rv:86.0) Gecko/20100101 Firefox/86.0", "version": "21.0.0.18", "id": "603b9363061ca" }PSQL2
{"reqId":"iOdXscD6Kz7Pp3NIRfQ7","level":3,"time":"2021-02-28T12:58:50+00:00","remoteAddr":"127.0.0.1","user":"user","app":"index","method":"POST","url":"/index.php/apps/news/feeds/1/read","message":{"Exception":"OC\\DB\\Exceptions\\DbalException","Message":"An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"WHERE\"\nLINE 1: UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :us...\n ^","Code":7,"Trace":[{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":77,"function":"wrap","class":"OC\\DB\\Exceptions\\DbalException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Exception\\SyntaxErrorException"}]},{"file":"/var/www/html/custom_apps/news/lib/Db/FeedMapperV2.php","line":178,"function":"executeUpdate","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["UPDATE `*PREFIX*news_items` items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)"]},{"file":"/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php","line":358,"function":"read","class":"OCA\\News\\Db\\FeedMapperV2","type":"->","args":["user",1,40]},{"file":"/var/www/html/custom_apps/news/lib/Controller/FeedController.php","line":286,"function":"read","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":["user",1,40]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"read","class":"OCA\\News\\Controller\\FeedController","type":"->","args":[1,40]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\News\\Controller\\FeedController"},"read"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\News\\Controller\\FeedController"},"read"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\News\\Controller\\FeedController","read",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"feedId":"1","_route":"news.feed.read"}]},{"file":"/var/www/html/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/news/feeds/1/read"]},{"file":"/var/www/html/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/Exceptions/DbalException.php","Line":70,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\SyntaxErrorException","Message":"An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"WHERE\"\nLINE 1: UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :us...\n ^","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1728,"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":1667,"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":1146,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDO\\Exception"},"UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":257,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1747,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":236,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":75,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/custom_apps/news/lib/Db/FeedMapperV2.php","line":178,"function":"executeUpdate","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["UPDATE `*PREFIX*news_items` items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)"]},{"file":"/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php","line":358,"function":"read","class":"OCA\\News\\Db\\FeedMapperV2","type":"->","args":["user",1,40]},{"file":"/var/www/html/custom_apps/news/lib/Controller/FeedController.php","line":286,"function":"read","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":["user",1,40]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"read","class":"OCA\\News\\Controller\\FeedController","type":"->","args":[1,40]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\News\\Controller\\FeedController"},"read"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\News\\Controller\\FeedController"},"read"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\News\\Controller\\FeedController","read",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"feedId":"1","_route":"news.feed.read"}]},{"file":"/var/www/html/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/news/feeds/1/read"]},{"file":"/var/www/html/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php","Line":58,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"WHERE\"\nLINE 1: UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :us...\n ^","Code":7,"Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php","line":50,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::","args":[{"errorInfo":["42601",7,"ERROR: syntax error at or near \"WHERE\"\nLINE 1: UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :us...\n ^"],"__class__":"PDOException"}]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1144,"function":"exec","class":"Doctrine\\DBAL\\Driver\\PDO\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)"]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":257,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1747,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":236,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":75,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/custom_apps/news/lib/Db/FeedMapperV2.php","line":178,"function":"executeUpdate","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["UPDATE `*PREFIX*news_items` items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)"]},{"file":"/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php","line":358,"function":"read","class":"OCA\\News\\Db\\FeedMapperV2","type":"->","args":["user",1,40]},{"file":"/var/www/html/custom_apps/news/lib/Controller/FeedController.php","line":286,"function":"read","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":["user",1,40]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"read","class":"OCA\\News\\Controller\\FeedController","type":"->","args":[1,40]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\News\\Controller\\FeedController"},"read"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\News\\Controller\\FeedController"},"read"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\News\\Controller\\FeedController","read",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"feedId":"1","_route":"news.feed.read"}]},{"file":"/var/www/html/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/news/feeds/1/read"]},{"file":"/var/www/html/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":26,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \"WHERE\"\nLINE 1: UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :us...\n ^","Code":"42601","Trace":[{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php","line":44,"function":"exec","class":"PDO","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)"]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1144,"function":"exec","class":"Doctrine\\DBAL\\Driver\\PDO\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)"]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":257,"function":"executeStatement","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/3rdparty/doctrine/dbal/src/Connection.php","line":1747,"function":"executeStatement","class":"OC\\DB\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/lib/private/DB/Connection.php","line":236,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/lib/private/DB/ConnectionAdapter.php","line":75,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["UPDATE \"oc_news_items\" items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)",[],[]]},{"file":"/var/www/html/custom_apps/news/lib/Db/FeedMapperV2.php","line":178,"function":"executeUpdate","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["UPDATE `*PREFIX*news_items` items SET WHERE (feeds.user_id = :userId) AND (feeds.id = :feedId) AND (items.id =< :maxItemId)"]},{"file":"/var/www/html/custom_apps/news/lib/Service/FeedServiceV2.php","line":358,"function":"read","class":"OCA\\News\\Db\\FeedMapperV2","type":"->","args":["user",1,40]},{"file":"/var/www/html/custom_apps/news/lib/Controller/FeedController.php","line":286,"function":"read","class":"OCA\\News\\Service\\FeedServiceV2","type":"->","args":["user",1,40]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":218,"function":"read","class":"OCA\\News\\Controller\\FeedController","type":"->","args":[1,40]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":127,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\News\\Controller\\FeedController"},"read"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":157,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\News\\Controller\\FeedController"},"read"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\News\\Controller\\FeedController","read",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"feedId":"1","_route":"news.feed.read"}]},{"file":"/var/www/html/lib/base.php","line":993,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/news/feeds/1/read"]},{"file":"/var/www/html/index.php","line":37,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Connection.php","Line":44}}},"CustomMessage":"--"},"userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:86.0) Gecko/20100101 Firefox/86.0","version":"21.0.0.18","id":"603b938cd3dc2"}Contents of Browser Error Console
Read http://ggnome.com/wiki/Using_The_Browser_Error_Console if you are unsure what to put hereThe text was updated successfully, but these errors were encountered: