deck
deck copied to clipboard
nextcloud
Nextcloud 23 not showing Shares - Shared by me
mariadb 10.5.13 php8.0.13 Apache ubuntu 20.04 lts
....with a tons of shares
click in the files app left on shares, collapse and select shared from u. the list of your shares is empty. i have tons of shares. btw the other category "shared with me" includes all the shares with me.
It works fine here as well, though I upgraded in multiple steps during beta and RC state. Probably it is related to the database error your reported: nextcloud/server#29985
i tryed to remove an existing share, i got this:
{"reqId":"9CwZYoHmz2hzfQF4Njh5","level":3,"time":"2021-11-30T15:47:24+01:00","remoteAddr":"---","user":"---","app":"no app in context","method":"DELETE","url":"/ocs/v2.php/apps/files_sharing/api/v1/shares/2168","message":"OCA\\Collectives\\Db\\CollectiveShareMapper::deleteByToken(): Argument nextcloud/server#1 ($token) must be of type string, null given, called in /var/www/nextcloud/apps/collectives/lib/Listeners/ShareDeletedListener.php on line 30 in file '/var/www/nextcloud/apps/collectives/lib/Db/CollectiveShareMapper.php' line 125","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:94.0) Gecko/20100101 Firefox/94.0","version":"23.0.0.10","exception":{"Exception":"Exception","Message":"OCA\\Collectives\\Db\\CollectiveShareMapper::deleteByToken(): Argument nextcloud/server#1 ($token) must be of type string, null given, called in /var/www/nextcloud/apps/collectives/lib/Listeners/ShareDeletedListener.php on line 30 in file '/var/www/nextcloud/apps/collectives/lib/Db/CollectiveShareMapper.php' line 125","Code":0,"Trace":[{"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/ocs/v1.php","line":62,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":23,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","Line":158,"Previous":{"Exception":"TypeError","Message":"OCA\\Collectives\\Db\\CollectiveShareMapper::deleteByToken(): Argument nextcloud/server#1 ($token) must be of type string, null given, called in /var/www/nextcloud/apps/collectives/lib/Listeners/ShareDeletedListener.php on line 30","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/collectives/lib/Listeners/ShareDeletedListener.php","line":30,"function":"deleteByToken","class":"OCA\\Collectives\\Db\\CollectiveShareMapper","type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":87,"function":"handle","class":"OCA\\Collectives\\Listeners\\ShareDeletedListener","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":251,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":73,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":88,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":100,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php","line":1210,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/Controller/ShareAPIController.php","line":415,"function":"deleteShare","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":217,"function":"deleteShare","class":"OCA\\Files_Sharing\\Controller\\ShareAPIController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":126,"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/ocs/v1.php","line":62,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":23,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/apps/collectives/lib/Db/CollectiveShareMapper.php","Line":125},"CustomMessage":"--"},"id":"61a639834a059"}
When pasting code or logs here, please use code fences:
```
put code here
```
That is better readable, avoids linebreaks in the middle of a word etc 😉.
When pasting code or logs here, please use code fences:
put code here
That is better readable, avoids linebreaks in the middle of a word etc 😉.
sorry for that:
{"reqId":"9CwZYoHmz2hzfQF4Njh5","level":3,"time":"2021-11-30T15:47:24+01:00","remoteAddr":"---","user":"---","app":"no app in context","method":"DELETE","url":"/ocs/v2.php/apps/files_sharing/api/v1/shares/2168","message":"OCA\\Collectives\\Db\\CollectiveShareMapper::deleteByToken(): Argument nextcloud/server#1 ($token) must be of type string, null given, called in /var/www/nextcloud/apps/collectives/lib/Listeners/ShareDeletedListener.php on line 30 in file '/var/www/nextcloud/apps/collectives/lib/Db/CollectiveShareMapper.php' line 125","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:94.0) Gecko/20100101 Firefox/94.0","version":"23.0.0.10","exception":{"Exception":"Exception","Message":"OCA\\Collectives\\Db\\CollectiveShareMapper::deleteByToken(): Argument nextcloud/server#1 ($token) must be of type string, null given, called in /var/www/nextcloud/apps/collectives/lib/Listeners/ShareDeletedListener.php on line 30 in file '/var/www/nextcloud/apps/collectives/lib/Db/CollectiveShareMapper.php' line 125","Code":0,"Trace":[{"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/ocs/v1.php","line":62,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":23,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","Line":158,"Previous":{"Exception":"TypeError","Message":"OCA\\Collectives\\Db\\CollectiveShareMapper::deleteByToken(): Argument nextcloud/server#1 ($token) must be of type string, null given, called in /var/www/nextcloud/apps/collectives/lib/Listeners/ShareDeletedListener.php on line 30","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/collectives/lib/Listeners/ShareDeletedListener.php","line":30,"function":"deleteByToken","class":"OCA\\Collectives\\Db\\CollectiveShareMapper","type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php","line":87,"function":"handle","class":"OCA\\Collectives\\Listeners\\ShareDeletedListener","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":251,"function":"__invoke","class":"OC\\EventDispatcher\\ServiceEventListener","type":"->"},{"file":"/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php","line":73,"function":"callListeners","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":88,"function":"dispatch","class":"Symfony\\Component\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php","line":100,"function":"dispatch","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Share20/Manager.php","line":1210,"function":"dispatchTyped","class":"OC\\EventDispatcher\\EventDispatcher","type":"->"},{"file":"/var/www/nextcloud/apps/files_sharing/lib/Controller/ShareAPIController.php","line":415,"function":"deleteShare","class":"OC\\Share20\\Manager","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":217,"function":"deleteShare","class":"OCA\\Files_Sharing\\Controller\\ShareAPIController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":126,"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/ocs/v1.php","line":62,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":23,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/apps/collectives/lib/Db/CollectiveShareMapper.php","Line":125},"CustomMessage":"--"},"id":"61a639834a059"}
but i already did that
You currently use singe backtick characters around the code on the same line. But as my example above you need to use three backtick characters before and after the code on dedicated lines.
EDIT: However, not that important here as it is indeed a single line only, as of the nature of the raw Nextcloud logs.
It works fine here as well, though I upgraded in multiple steps during beta and RC state. Probably it is related to the database error your reported: nextcloud/server#29985
some people wrote the db issue could be related to buld upload from nc client.
I think this one is related to the collectives app. Please try to disable it and report back if this fixes the issue. Thanks!
i have disabled and will take a look the next hours, but my shares did not appear in the list of mine.
FYI @mejo- @azul For the collectives exception trace. Though it then looks unrelated to the issue that is disappearing when deck is disabled. Could you see if there is any other error message when loading the Shared with me page?
Also please report which version of deck you are using and maybe check the just release 1.6.0 to see if this also shows up the issue.
Let's format the trace a bit
{
"app" : "no app in context",
"exception" : {
"Code" : 0,
"CustomMessage" : "--",
"Exception" : "Exception",
"File" : "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"Line" : 158,
"Message" : "OCA\\Collectives\\Db\\CollectiveShareMapper::deleteByToken(): Argument nextcloud/server#1 ($token) must be of type string, null given, called in /var/www/nextcloud/apps/collectives/lib/Listeners/ShareDeletedListener.php on line 30 in file '/var/www/nextcloud/apps/collectives/lib/Db/CollectiveShareMapper.php' line 125",
"Previous" : {
"Code" : 0,
"Exception" : "TypeError",
"File" : "/var/www/nextcloud/apps/collectives/lib/Db/CollectiveShareMapper.php",
"Line" : 125,
"Message" : "OCA\\Collectives\\Db\\CollectiveShareMapper::deleteByToken(): Argument nextcloud/server#1 ($token) must be of type string, null given, called in /var/www/nextcloud/apps/collectives/lib/Listeners/ShareDeletedListener.php on line 30",
"Trace" : [
{
"class" : "OCA\\Collectives\\Db\\CollectiveShareMapper",
"file" : "/var/www/nextcloud/apps/collectives/lib/Listeners/ShareDeletedListener.php",
"function" : "deleteByToken",
"line" : 30,
"type" : "->"
},
{
"class" : "OCA\\Collectives\\Listeners\\ShareDeletedListener",
"file" : "/var/www/nextcloud/lib/private/EventDispatcher/ServiceEventListener.php",
"function" : "handle",
"line" : 87,
"type" : "->"
},
{
"class" : "OC\\EventDispatcher\\ServiceEventListener",
"file" : "/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
"function" : "__invoke",
"line" : 251,
"type" : "->"
},
{
"class" : "Symfony\\Component\\EventDispatcher\\EventDispatcher",
"file" : "/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
"function" : "callListeners",
"line" : 73,
"type" : "->"
},
{
"class" : "Symfony\\Component\\EventDispatcher\\EventDispatcher",
"file" : "/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php",
"function" : "dispatch",
"line" : 88,
"type" : "->"
},
{
"class" : "OC\\EventDispatcher\\EventDispatcher",
"file" : "/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php",
"function" : "dispatch",
"line" : 100,
"type" : "->"
},
{
"class" : "OC\\EventDispatcher\\EventDispatcher",
"file" : "/var/www/nextcloud/lib/private/Share20/Manager.php",
"function" : "dispatchTyped",
"line" : 1210,
"type" : "->"
},
{
"class" : "OC\\Share20\\Manager",
"file" : "/var/www/nextcloud/apps/files_sharing/lib/Controller/ShareAPIController.php",
"function" : "deleteShare",
"line" : 415,
"type" : "->"
},
{
"class" : "OCA\\Files_Sharing\\Controller\\ShareAPIController",
"file" : "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"function" : "deleteShare",
"line" : 217,
"type" : "->"
},
{
"class" : "OC\\AppFramework\\Http\\Dispatcher",
"file" : "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"function" : "executeController",
"line" : 126,
"type" : "->"
},
{
"class" : "OC\\AppFramework\\Http\\Dispatcher",
"file" : "/var/www/nextcloud/lib/private/AppFramework/App.php",
"function" : "dispatch",
"line" : 157,
"type" : "->"
},
{
"class" : "OC\\AppFramework\\App",
"file" : "/var/www/nextcloud/lib/private/Route/Router.php",
"function" : "main",
"line" : 302,
"type" : "::"
},
{
"class" : "OC\\Route\\Router",
"file" : "/var/www/nextcloud/ocs/v1.php",
"function" : "match",
"line" : 62,
"type" : "->"
},
{
"args" : [
"/var/www/nextcloud/ocs/v1.php"
],
"file" : "/var/www/nextcloud/ocs/v2.php",
"function" : "require_once",
"line" : 23
}
]
},
"Trace" : [
{
"class" : "OC\\AppFramework\\Http\\Dispatcher",
"file" : "/var/www/nextcloud/lib/private/AppFramework/App.php",
"function" : "dispatch",
"line" : 157,
"type" : "->"
},
{
"class" : "OC\\AppFramework\\App",
"file" : "/var/www/nextcloud/lib/private/Route/Router.php",
"function" : "main",
"line" : 302,
"type" : "::"
},
{
"class" : "OC\\Route\\Router",
"file" : "/var/www/nextcloud/ocs/v1.php",
"function" : "match",
"line" : 62,
"type" : "->"
},
{
"args" : [
"/var/www/nextcloud/ocs/v1.php"
],
"file" : "/var/www/nextcloud/ocs/v2.php",
"function" : "require_once",
"line" : 23
}
]
},
"id" : "61a639834a059",
"level" : 3,
"message" : "OCA\\Collectives\\Db\\CollectiveShareMapper::deleteByToken(): Argument nextcloud/server#1 ($token) must be of type string, null given, called in /var/www/nextcloud/apps/collectives/lib/Listeners/ShareDeletedListener.php on line 30 in file '/var/www/nextcloud/apps/collectives/lib/Db/CollectiveShareMapper.php' line 125",
"method" : "DELETE",
"remoteAddr" : "---",
"reqId" : "9CwZYoHmz2hzfQF4Njh5",
"time" : "2021-11-30T15:47:24+01:00",
"url" : "/ocs/v2.php/apps/files_sharing/api/v1/shares/2168",
"user" : "---",
"userAgent" : "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:94.0) Gecko/20100101 Firefox/94.0",
"version" : "23.0.0.10"
}
Tracking the collectives issue here: https://gitlab.com/collectivecloud/collectives/-/issues/265
I wonder how the described issue and the posted error backtrace belong to each other.
@apg1980 the error suggests that you tried to delete a share, right? During this operation, for some reason the error that you posted above happened. We're working on a fix for this in the Collectives app: https://gitlab.com/collectivecloud/collectives/-/merge_requests/431
@apg1980 could you please try to reproduce the error with empty share list one more time? First re-enable the deck app, then go to the shares list and if it's still empty, look again whether a new error got logged to the Nextcloud logs?
For discovering the correct log entries, it helps to first open the log file and watch it live while doing the action that is supposed to trigger the error. In the terminal this can be done with tail -f <path-to-logfile>.
Hi i can confirm, my shares disappear after enabling latest deck app 1.6
{
"reqId": "d0tZn90bSLCyhmyVyNHG",
"level": 3,
"time": "2021-12-02T07:34:54+01:00",
"remoteAddr": "---",
"user": "---",
"app": "no app in context",
"method": "GET",
"url": "/ocs/v1.php/apps/files_sharing/api/v1/shares?format=json&shared_with_me=false&include_tags=true",
"message": "Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*deck_cards` WHERE `id` = :dcValue1 ORDER BY `order` ASC, `id` ASC\"; ",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:94.0) Gecko/20100101 Firefox/94.0",
"version": "23.0.0.10",
"exception": {
"Exception": "OCP\\AppFramework\\Db\\DoesNotExistException",
"Message": "Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*deck_cards` WHERE `id` = :dcValue1 ORDER BY `order` ASC, `id` ASC\"; ",
"Code": 0,
"Trace": [
{
"file": "/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
"line": 361,
"function": "findOneQuery",
"class": "OCP\\AppFramework\\Db\\QBMapper",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/deck/lib/Db/CardMapper.php",
"line": 140,
"function": "findEntity",
"class": "OCP\\AppFramework\\Db\\QBMapper",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/deck/lib/Sharing/ShareAPIHelper.php",
"line": 56,
"function": "find",
"class": "OCA\\Deck\\Db\\CardMapper",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/files_sharing/lib/Controller/ShareAPIController.php",
"line": 316,
"function": "formatShare",
"class": "OCA\\Deck\\Sharing\\ShareAPIHelper",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/files_sharing/lib/Controller/ShareAPIController.php",
"line": 873,
"function": "formatShare",
"class": "OCA\\Files_Sharing\\Controller\\ShareAPIController",
"type": "->"
},
{
"file": "/var/www/nextcloud/apps/files_sharing/lib/Controller/ShareAPIController.php",
"line": 815,
"function": "getFormattedShares",
"class": "OCA\\Files_Sharing\\Controller\\ShareAPIController",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 217,
"function": "getShares",
"class": "OCA\\Files_Sharing\\Controller\\ShareAPIController",
"type": "->"
},
{
"file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
"line": 126,
"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/ocs/v1.php",
"line": 62,
"function": "match",
"class": "OC\\Route\\Router",
"type": "->"
}
],
"File": "/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php",
"Line": 283,
"CustomMessage": "--"
},
"id": "61a86940e6678"
}
Thanks for that, I edited your post to make it more readable for later reference.
Hello the issue is still present in nc 23.0.3 with latest app version of deck.
I'm not sure if that is directly related: the nextcloud iPhone app shows me a "Share 500 internal server error" everytime I open the nextcloud app. But all folders are visible.
In the log I see combined with this error message:
OCP\AppFramework\Db\DoesNotExistException: Did expect one result but found none when executing: query "SELECT * FROM *PREFIX*deck_cards WHERE id = :dcValue1 ORDER BY order ASC, id ASC";
If I disable the deck app, the error msg disappears.
Deck version 1.7.1 on nextcloud 24.0.5
Exactly this
Il Dom 18 Set 2022, 11:59 tjareson @.***> ha scritto:
I'm not sure if that is directly related: the nextcloud iPhone app shows me a "Share 500 internal server error" everytime I open the nextcloud app. But all folders are visible. In the log I see combined with this error message: OCP\AppFramework\Db\DoesNotExistException: Did expect one result but found none when executing: query "SELECT * FROM PREFIXdeck_cards WHERE id = :dcValue1 ORDER BY order ASC, id ASC";
If I disable the deck app, the error msg disappears. Deck version 1.7.1 on nextcloud 24.0.5
— Reply to this email directly, view it on GitHub https://github.com/nextcloud/deck/issues/3464#issuecomment-1250234123, or unsubscribe https://github.com/notifications/unsubscribe-auth/A2US4VAIZ655DJ5XZWG4FCLV63RYNANCNFSM5JCCTKWQ . You are receiving this because you commented.Message ID: @.***>
Same for me, but I noticed that it happened only for few users. Perhaps something in the db is the cause, like invalid mountpoints... need further investigation.
Il Gio 27 Ott 2022, 14:41 apg1980 @.***> ha scritto:
Hi, any updates here? issue still exists on nc 25 with Deck 1.8.1
— Reply to this email directly, view it on GitHub https://github.com/nextcloud/deck/issues/3464#issuecomment-1293468472, or unsubscribe https://github.com/notifications/unsubscribe-auth/A2US4VAIUDBBTUVXAYFKVHLWFJZ7FANCNFSM5JCCTKWQ . You are receiving this because you commented.Message ID: @.***>
I have got the same issue : Did expect one result but found none when executing: query "SELECT * FROM *PREFIX*deck_cards WHERE id = :dcValue1 ORDER BY order ASC, id ASC"; "
NC 24.0.7 DECK version : 1.7.3
