E019: HTTP status 500. Failed GET request. Check your server configuration and log. | Zuletzt synchronisiert: vor 0 Sekunden

[Schneehexe]

Which version of floccus are you using?

5.4.5

How many bookmarks do you have, roughly?

Several thousand

Are you using other means to sync bookmarks in parallel to floccus?

No

Sync method

Nextcloud Bookmarks

Which browser are you using? In case you are using the phone App, specify the Android or iOS version and device please.

Firefox 140.0.2

Which version of Nextcloud Bookmarks are you using? (if relevant)

15.1.1

Which version of Nextcloud? (if relevant)

31.0.6

What kind of WebDAV server are you using? (if relevant)

No response

Describe the Bug

When synchronizing, the bookmarks should be uploaded to the server. I get the error when doing this:

E019: HTTP status 500. Failed GET request. Check your server configuration and log. | Zuletzt synchronisiert: vor 0 Sekunden

Expected Behavior

The bookmarks are synchronized.....

To Reproduce

-Install the Nextcloud “Bookmarks” app.

-Install floccus as a browser extension in Firefox

-Open access in the browser to the Nextcloud user who synchronizes the bookmarks (due to a current login error at Nextcloud server)

-Login to the server in floccus (works)

-Choose to upload bookmarks to the server only.

-Perform the synchronization

-Receive the error message

I can send log files if someone explains to me which log files are involved and where I can find them.

Debug log provided

• I have provided a debug log file

[github-actions]

Hello 👋

Thank you for taking the time to open this issue with floccus. I know it's frustrating when software
causes problems. You have made the right choice to come here and open an issue to make sure your problem gets looked at
and if possible solved. Let me give you a short introduction on what to expect from this issue tracker to avoid misunderstandings.
I'm Marcel. I created floccus a few years ago, and have been maintaining it since. I currently work for Nextcloud
which leaves me with less time for side projects like this one than I used to have.
I still try to answer all issues and if possible fix all bugs here, but it sometimes takes a while until I get to it.
Until then, please be patient. It helps when you stick around to answer follow up questions I may have,
as very few bugs can be fixed directly from the first bug report, without any interaction. If information is missing in your bug report
and the issue cannot be solved without it, I will have to close the issue after a while.
Note also that GitHub in general is a place where people meet to make software better together. Nobody here is under any obligation
to help you, solve your problems or deliver on any expectations or demands you may have, but if enough people come together we can
collaborate to make this software better. For everyone.
Thus, if you can, you could also have a look at other issues to see whether you can help other people with your knowledge
and experience. If you have coding experience it would also be awesome if you could step up to dive into the code and
try to fix the odd bug yourself. Everyone will be thankful for extra helping hands!
If you cannot lend a helping hand, to continue the development and maintenance of this project in a sustainable way,
I ask that you donate to the project when opening an issue (or at least once your issue is solved), if you're not a donor already.
You can find donation options at https://floccus.org/donate/. Thank you!

One last word: If you feel, at any point, like you need to vent, this is not the place for it; you can go to the Nextcloud forum,
to twitter or somewhere else. But this is a technical issue tracker, so please make sure to
focus on the tech and keep your opinions to yourself.

Thank you for reading through this primer. I look forward to working with you on this issue!
Cheers 💙

[marcelklehr]

Hi @Schneehexe
Could you check the Nextcloud log for errors related to the bookmarks app? The nextcloud log can be found either by logging into your nextcloud as an admin, going to Admin settings -> Logging. Or in the file system at /path/to/nextcloud/data/nextcloud.log

[Schneehexe]

Is that suitable for your analysis?

***",{"__class__":"ReflectionParameter","name":"publicFolderMapper"},{"__class__":"ReflectionParameter","name":"timeFactory"},{"__class__":"ReflectionParameter","name":"logger"},{"__class__":"ReflectionParameter","name":"url"},{"__class__":"ReflectionParameter","name":"htmlExporter"},{"__class__":"ReflectionParameter","name":"authorizer"},{"__class__":"ReflectionParameter","name":"bookmarks"},{"__class__":"ReflectionParameter","name":"folders"},{"__class__":"ReflectionParameter","name":"rootFolder"},{"__class__":"ReflectionParameter","name":"lockManager"}]]},{"file":"/home/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":106,"function":"buildClass","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->","args":[{"__class__":"ReflectionClass","name":"OCA\\Bookmarks\\Controller\\BookmarkController"}]},{"file":"/home/www/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php","line":124,"function":"resolve","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->","args":["OCA\\Bookmarks\\Controller\\BookmarkController"]},{"file":"/home/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php","line":440,"function":"query","class":"OC\\AppFramework\\Utility\\SimpleContainer","type":"->","args":["OCA\\Bookmarks\\Controller\\BookmarkController"]},{"file":"/home/www/nextcloud/lib/private/AppFramework/DependencyInjection/DIContainer.php","line":412,"function":"queryNoFallback","class":"OC\\AppFramework\\DependencyInjection\\DIContainer","type":"->","args":["OCA\\Bookmarks\\Controller\\BookmarkController"]},{"file":"/home/www/nextcloud/lib/private/AppFramework/App.php","line":140,"function":"query","class":"OC\\AppFramework\\DependencyInjection\\DIContainer","type":"->","args":["OCA\\Bookmarks\\Controller\\BookmarkController"]},{"file":"/home/www/nextcloud/lib/private/Route/Router.php","line":307,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Bookmarks\\Controller\\BookmarkController","releaseLock",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"bookmarks.bookmark.release_lock"}]},{"file":"/home/www/nextcloud/lib/base.php","line":1040,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/bookmarks/public/rest/v2/lock"]},{"file":"/home/www/nextcloud/index.php","line":24,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/home/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":1197,"message":"OCP\\DB\\QueryBuilder\\IQueryBuilder::resetQueryPart is deprecated and will be removed soon.","exception":{},"CustomMessage":"OCP\\DB\\QueryBuilder\\IQueryBuilder::resetQueryPart is deprecated and will be removed soon."}} {"reqId":"aGKFYD8_WIvppj1CbyvvRAAAAAM","level":0,"time":"2025-06-30T12:38:57+00:00","remoteAddr":"62.27.235.30","user":"hbc20b","app":"no app in context","method":"DELETE","url":"/index.php/apps/bookmarks/public/rest/v2/lock","message":"OCA\\Bookmarks\\Controller\\BookmarkController::releaseLock uses the @PublicPage annotation and should use the #[OCP\\AppFramework\\Http\\Attribute\\PublicPage] attribute instead","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"31.0.6.2","data":[]} {"reqId":"aGKFYD8_WIvppj1CbyvvRAAAAAM","level":0,"time":"2025-06-30T12:38:57+00:00","remoteAddr":"62.27.235.30","user":"hbc20b","app":"no app in context","method":"DELETE","url":"/index.php/apps/bookmarks/public/rest/v2/lock","message":"OCA\\Bookmarks\\Controller\\BookmarkController::releaseLock uses the @NoCSRFRequired annotation and should use the #[OCP\\AppFramework\\Http\\Attribute\\NoCSRFRequired] attribute instead","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"31.0.6.2","data":[]} {"reqId":"aGKFYD8_WIvppj1CbyvvRAAAAAM","level":0,"time":"2025-06-30T12:38:57+00:00","remoteAddr":"62.27.235.30","user":"hbc20b","app":"no app in context","method":"DELETE","url":"/index.php/apps/bookmarks/public/rest/v2/lock","message":"OCA\\Bookmarks\\Controller\\BookmarkController::releaseLock uses the @NoCSRFRequired annotation and should use the #[OCP\\AppFramework\\Http\\Attribute\\NoCSRFRequired] attribute instead","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"31.0.6.2","data":[]} {"reqId":"aGKFYD8_WIvppj1CbyvvRAAAAAM","level":0,"time":"2025-06-30T12:38:57+00:00","remoteAddr":"62.27.235.30","user":"hbc20b","app":"no app in context","method":"DELETE","url":"/index.php/apps/bookmarks/public/rest/v2/lock","message":"dirty table reads: SELECT COUNT(*) AS attemptsFROMPREFIXbruteforce_attempts WHERE (occurred > :dcValue1) AND (subnet = :dcValue2) AND (action= :dcValue3)","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"31.0.6.2","exception":{"Exception":"Exception","Message":"dirty table reads: SELECT COUNT(*) ASattemptsFROMPREFIXbruteforce_attempts WHERE (occurred > :dcValue1) AND (subnet = :dcValue2) AND (action= :dcValue3)","Code":0,"Trace":[{"file":"/home/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->","args":["SELECT COUNT(*) ASattemptsFROMPREFIXbruteforce_attempts WHERE (occurred > :dcValue1) AND (subnet = :dcValue2) AND (action= :dcValue3)",{"dcValue1":1751243937,"dcValue2":"62.27.235.30/32","dcValue3":"bookmarks#releaseLock"},{"dcValue1":2,"dcValue2":2,"dcValue3":2}]},{"file":"/home/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->","args":["SELECT COUNT(*) ASattemptsFROMPREFIXbruteforce_attempts WHERE (occurred > :dcValue1) AND (subnet = :dcValue2) AND (action= :dcValue3)",{"dcValue1":1751243937,"dcValue2":"62.27.235.30/32","dcValue3":"bookmarks#releaseLock"},{"dcValue1":2,"dcValue2":2,"dcValue3":2}]},{"file":"/home/www/nextcloud/lib/private/Security/Bruteforce/Backend/DatabaseBackend.php","line":44,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/home/www/nextcloud/lib/private/Security/Bruteforce/Throttler.php","line":118,"function":"getAttempts","class":"OC\\Security\\Bruteforce\\Backend\\DatabaseBackend","type":"->","args":["62.27.235.30/32",1751243937,"bookmarks#releaseLock"]},{"file":"/home/www/nextcloud/lib/private/Security/Bruteforce/Throttler.php","line":129,"function":"getAttempts","class":"OC\\Security\\Bruteforce\\Throttler","type":"->","args":["62.27.235.30","bookmarks#releaseLock"]},{"file":"/home/www/nextcloud/lib/private/Security/Bruteforce/Throttler.php","line":202,"function":"getDelay","class":"OC\\Security\\Bruteforce\\Throttler","type":"->","args":["62.27.235.30","bookmarks#releaseLock"]},{"file":"/home/www/nextcloud/lib/private/AppFramework/Middleware/Security/BruteForceMiddleware.php","line":52,"function":"sleepDelayOrThrowOnMax","class":"OC\\Security\\Bruteforce\\Throttler","type":"->","args":["62.27.235.30","bookmarks#releaseLock"]},{"file":"/home/www/nextcloud/lib/private/AppFramework/Middleware/MiddlewareDispatcher.php","line":73,"function":"beforeController","class":"OC\\AppFramework\\Middleware\\Security\\BruteForceMiddleware","type":"->","args":[{"__class__":"OCA\\Bookmarks\\Controller\\BookmarkController"},"releaseLock"]},{"file":"/home/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":106,"function":"beforeController","class":"OC\\AppFramework\\Middleware\\MiddlewareDispatcher","type":"->","args":[{"__class__":"OCA\\Bookmarks\\Controller\\BookmarkController"},"releaseLock"]},{"file":"/home/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Bookmarks\\Controller\\BookmarkController"},"releaseLock"]},{"file":"/home/www/nextcloud/lib/private/Route/Router.php","line":307,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Bookmarks\\Controller\\BookmarkController","releaseLock",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"bookmarks.bookmark.release_lock"}]},{"file":"/home/www/nextcloud/lib/base.php","line":1040,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/bookmarks/public/rest/v2/lock"]},{"file":"/home/www/nextcloud/index.php","line":24,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/home/www/nextcloud/lib/private/DB/Connection.php","Line":406,"message":"dirty table reads: SELECT COUNT(*) ASattemptsFROMPREFIXbruteforce_attempts WHERE (occurred > :dcValue1) AND (subnet = :dcValue2) AND (action= :dcValue3)","tables":["oc_login_address","oc_bruteforce_attempts"],"reads":["oc_bruteforce_attempts"],"exception":{},"CustomMessage":"dirty table reads: SELECT COUNT(*) ASattemptsFROMPREFIXbruteforce_attempts WHERE (occurred > :dcValue1) AND (subnet = :dcValue2) AND (action= :dcValue3)"}}

[marcelklehr]

Mmh, your log level seems to be set to debug which adds a lot of clutter to the output. Please set the log level to something like 2 (warning level) and trigger the error once again, then one of the last entries should be the error we seek. You can set the log level either in the logs UI in the admin settings or in the file path/to/nextcloud/config/config.php

[Schneehexe]

The log level has been changed to “Warning”.
Here is the excerpt of the log while floccus was trying to upload his bookmarks to the cloud:

`{"reqId":"aGUqkBOQs0DFztKm1b9g7wAAAAA","level":3,"time":"2025-07-02T12:48:19+00:00","remoteAddr":"195.52.23.122","user":"xxc20b","app":"index","method":"GET","url":"/index.php/apps/bookmarks/public/rest/v2/folder?root=-1&layers=0","message":"Did expect one result but found none when executing: query \"SELECT `s`.`id`, `s`.`folder_id`, `s`.`owner`, `s`.`participant`, `s`.`type`, `s`.`can_write`, `s`.`can_share`, `s`.`created_at` FROM `*PREFIX*bookmarks_shares` `s` INNER JOIN `*PREFIX*bookmarks_shared_to_shares` `t` ON s.id = t.share_id WHERE `t`.`shared_folder_id` = ?\"; ","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:140.0) Gecko/20100101 Firefox/140.0","version":"31.0.6.2","exception":{"Exception":"OCP\\AppFramework\\Db\\DoesNotExistException","Message":"Did expect one result but found none when executing: query \"SELECT `s`.`id`, `s`.`folder_id`, `s`.`owner`, `s`.`participant`, `s`.`type`, `s`.`can_write`, `s`.`can_share`, `s`.`created_at` FROM `*PREFIX*bookmarks_shares` `s` INNER JOIN `*PREFIX*bookmarks_shared_to_shares` `t` ON s.id = t.share_id WHERE `t`.`shared_folder_id` = ?\"; ","Code":0,"Trace":[{"file":"/home/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","line":375,"function":"findOneQuery","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/home/www/nextcloud/apps/bookmarks/lib/Db/ShareMapper.php","line":187,"function":"findEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->","args":[{"__class__":"OC\\DB\\QueryBuilder\\QueryBuilder"}]},{"file":"/home/www/nextcloud/apps/bookmarks/lib/Db/TreeMapper.php","line":922,"function":"findBySharedFolder","class":"OCA\\Bookmarks\\Db\\ShareMapper","type":"->","args":[10]},{"function":"OCA\\Bookmarks\\Db\\{closure}","class":"OCA\\Bookmarks\\Db\\TreeMapper","type":"->","args":["*** sensitive parameters replaced ***"]},{"file":"/home/www/nextcloud/apps/bookmarks/lib/Db/TreeMapper.php","line":921,"function":"array_map","args":[{"__class__":"Closure"},["*** sensitive parameters replaced ***"]]},{"file":"/home/www/nextcloud/apps/bookmarks/lib/Controller/FoldersController.php","line":564,"function":"getSubFolders","class":"OCA\\Bookmarks\\Db\\TreeMapper","type":"->","args":[767,0,false]},{"file":"/home/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"getFolders","class":"OCA\\Bookmarks\\Controller\\FoldersController","type":"->","args":[-1,0]},{"file":"/home/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Bookmarks\\Controller\\FoldersController"},"getFolders"]},{"file":"/home/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\Bookmarks\\Controller\\FoldersController"},"getFolders"]},{"file":"/home/www/nextcloud/lib/private/Route/Router.php","line":307,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\Bookmarks\\Controller\\FoldersController","getFolders",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"bookmarks.folders.get_folders"}]},{"file":"/home/www/nextcloud/lib/base.php","line":1040,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/bookmarks/public/rest/v2/folder"]},{"file":"/home/www/nextcloud/index.php","line":24,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/home/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","Line":277,"message":"Did expect one result but found none when executing: query \"SELECT `s`.`id`, `s`.`folder_id`, `s`.`owner`, `s`.`participant`, `s`.`type`, `s`.`can_write`, `s`.`can_share`, `s`.`created_at` FROM `*PREFIX*bookmarks_shares` `s` INNER JOIN `*PREFIX*bookmarks_shared_to_shares` `t` ON s.id = t.share_id WHERE `t`.`shared_folder_id` = ?\"; ","exception":{},"CustomMessage":"Did expect one result but found none when executing: query \"SELECT `s`.`id`, `s`.`folder_id`, `s`.`owner`, `s`.`participant`, `s`.`type`, `s`.`can_write`, `s`.`can_share`, `s`.`created_at` FROM `*PREFIX*bookmarks_shares` `s` INNER JOIN `*PREFIX*bookmarks_shared_to_shares` `t` ON s.id = t.share_id WHERE `t`.`shared_folder_id` = ?\"; "}}

[marcelklehr]

Thank you, this looks like an error I can work with. I'll try to fix it soon.

[marcelklehr]

Do you know if your nextcloud uses a postgres database? That would explain the error. I've created a fix for this and will release it soon, let's see if it works :)

[Schneehexe]

Postgres? I don't know - how can I recognize this?

'dbtype' => 'mysql',

Is that what you meant?

I currently have version 5.5.6 in Firefox and still have the same problem.

[marcelklehr]

I currently have version 5.5.6 in Firefox and still have the same problem.

Yes, this is actually a bug in Nextcloud Bookmarks. I will publish a release for that soon.

[marcelklehr]

v15.1.3 is out now and should fix this. Let me know how it goes, please :)