### â ïž This issue respects the following points: â ïž
- [X] This is a _single_ **âŠbug**, not a question or a configuration/webserver/proxy issue.
- [X] This is not a bug in the [browser extension](https://github.com/marius-wieschollek/passwords-webextension) or another client.
- [X] This issue is **not** already reported on Github _(I've searched it)_.
- [X] Nextcloud Server and the Passwords App **is** up to date. See [Nextcloud Apps](https://apps.nextcloud.com/apps/passwords).
- [X] There are no warnings and errors reported in the Passwords App settings in the admin area
- [X] The following apps are not installed: Rainloop
### Server Information
```shell
{
"version": {
"server": "29.0.5.1",
"app": "2024.9.20",
"lsr": false,
"php": "8.3.10",
"cronPhp": "8.3.10"
},
"environment": {
"os": "Linux",
"architecture": "x86_64",
"bits": 64,
"database": "pgsql",
"cron": "cron",
"proxy": false,
"sslProxy": true,
"subdirectory": false
},
"services": {
"images": "imagick",
"favicons": "default",
"previews": "default",
"security": "hibp",
"words": "auto",
"previewApi": false,
"faviconApi": false
},
"status": {
"autoBackupRestored": false
},
"settings": {
"channel": "stable",
"nightlies": false,
"handbook": false,
"performance": 5
},
"encryption": {
"sse": {
"SSEv1r1": false,
"SSEv1r2": false,
"SSEv2r1": false,
"SSEv3r1": false,
"none": true,
"default": "none"
},
"cse": {
"CSEv1r1": true,
"none": false,
"default": "CSEv1r1"
}
}
}
```
### Client Information
Browser and Version: Firefox 130.0.1 (64-Bit)
Client OS and Version: Windows 11 Version 23H2 build:22631.4169
### Bug description
My report on nextcloud.com (german)
https://help.nextcloud.com/t/passwords-app-version-20240920-fehlermeldung/204217
I suddenly have errors on my cloud and I don't have a solution yet.
The "Passwords App" basically works.
It only affects ONE user for whom the app no ââlonger works.
The user has also protected the Passwords app with an E2E password, like the others.
The app was still working for him last night.
The error only affects one user.
My Cloud:
Nextcloud Version: HUB 8 (29.0.5)
DB: pgsql
php: 8.3
Passwords App Version: 20240920
Since this morning there have been THREE error messages in the log via the web interface:
Fatal passwords DoesNotExistException Did expect one result but found none when executing: query âSELECT * FROM *PREFIX*passwords_challenge WHERE (deleted = :dcValue1) AND (user_id = :dcValue2) AND (uuid = :dcValue3)â;
Fatal passwords ApiException Loading challenge failed
Fehler passwords Error âLoading challenge failedâ in \CA\Passwords\Controller\Api\SessionApiController::request
here is a picture if i want use the passwords app
![App-Password-Fehler](https://github.com/user-attachments/assets/c339ec31-f49f-44db-82be-cd865ded3515)
### Steps to reproduce
I can't reproduce it. I imported my passwords a week ago and was able to use them with the app until yesterday. Now the app is more or less blocked for this one user
### Expected behavior
For other users and admins, the app works as usual.
### Nextcloud Logs
```shell
{"reqId":"GySZUSrF76kSGFClTjmM","level":4,"time":"2024-09-17T13:58:29+02:00","remoteAddr":"MyIPv4orIPv6","user":"MyUserWithProblem","app":"passwords","method":"GET","url":"/index.php/apps/passwords/api/1.0/session/request","message":"Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*passwords_challenge` WHERE (`deleted` = :dcValue1) AND (`user_id` = :dcValue2) AND (`uuid` = :dcValue3)\"; ","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:130.0) Gecko/20100101 Firefox/130.0","version":"29.0.5.1","exception":{"Exception":"OCP\\AppFramework\\Db\\DoesNotExistException","Message":"Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*passwords_challenge` WHERE (`deleted` = :dcValue1) AND (`user_id` = :dcValue2) AND (`uuid` = :dcValue3)\"; ","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/passwords/lib/Db/AbstractMapper.php","line":194,"function":"findEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Db/AbstractMapper.php","line":167,"function":"findOneByFields","class":"OCA\\Passwords\\Db\\AbstractMapper","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Db/AbstractMapper.php","line":107,"function":"findOneByField","class":"OCA\\Passwords\\Db\\AbstractMapper","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Services/Object/AbstractService.php","line":100,"function":"findByUuid","class":"OCA\\Passwords\\Db\\AbstractMapper","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Services/Object/ChallengeService.php","line":71,"function":"findByUuid","class":"OCA\\Passwords\\Services\\Object\\AbstractService","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Services/UserChallengeService.php","line":185,"function":"findByUuid","class":"OCA\\Passwords\\Services\\Object\\ChallengeService","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Services/UserChallengeService.php","line":109,"function":"getDefaultChallenge","class":"OCA\\Passwords\\Services\\UserChallengeService","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Controller/Api/SessionApiController.php","line":113,"function":"getChallengeData","class":"OCA\\Passwords\\Services\\UserChallengeService","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"request","class":"OCA\\Passwords\\Controller\\Api\\SessionApiController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1053,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","Line":283,"message":"Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*passwords_challenge` WHERE (`deleted` = :dcValue1) AND (`user_id` = :dcValue2) AND (`uuid` = :dcValue3)\"; ","exception":{},"CustomMessage":"Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*passwords_challenge` WHERE (`deleted` = :dcValue1) AND (`user_id` = :dcValue2) AND (`uuid` = :dcValue3)\"; "}}
{"reqId":"GySZUSrF76kSGFClTjmM","level":3,"time":"2024-09-17T13:58:29+02:00","remoteAddr":"MyIPv4orIPv6","user":"MyUserWithProblem","app":"passwords","method":"GET","url":"/index.php/apps/passwords/api/1.0/session/request","message":"Error \"Loading challenge failed\" in OCA\\Passwords\\Controller\\Api\\SessionApiController::request","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:130.0) Gecko/20100101 Firefox/130.0","version":"29.0.5.1","data":{"app":"passwords"}}
{"reqId":"GySZUSrF76kSGFClTjmM","level":4,"time":"2024-09-17T13:58:29+02:00","remoteAddr":"MyIPv4orIPv6","user":"MyUserWithProblem","app":"passwords","method":"GET","url":"/index.php/apps/passwords/api/1.0/session/request","message":"Loading challenge failed","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:130.0) Gecko/20100101 Firefox/130.0","version":"29.0.5.1","exception":{"Exception":"OCA\\Passwords\\Exception\\ApiException","Message":"Loading challenge failed","Code":256,"Trace":[{"file":"/var/www/nextcloud/apps/passwords/lib/Services/UserChallengeService.php","line":109,"function":"getDefaultChallenge","class":"OCA\\Passwords\\Services\\UserChallengeService","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Controller/Api/SessionApiController.php","line":113,"function":"getChallengeData","class":"OCA\\Passwords\\Services\\UserChallengeService","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"request","class":"OCA\\Passwords\\Controller\\Api\\SessionApiController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1053,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/apps/passwords/lib/Services/UserChallengeService.php","Line":189,"Previous":{"Exception":"OCP\\AppFramework\\Db\\DoesNotExistException","Message":"Did expect one result but found none when executing: query \"SELECT * FROM `*PREFIX*passwords_challenge` WHERE (`deleted` = :dcValue1) AND (`user_id` = :dcValue2) AND (`uuid` = :dcValue3)\"; ","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/passwords/lib/Db/AbstractMapper.php","line":194,"function":"findEntity","class":"OCP\\AppFramework\\Db\\QBMapper","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Db/AbstractMapper.php","line":167,"function":"findOneByFields","class":"OCA\\Passwords\\Db\\AbstractMapper","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Db/AbstractMapper.php","line":107,"function":"findOneByField","class":"OCA\\Passwords\\Db\\AbstractMapper","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Services/Object/AbstractService.php","line":100,"function":"findByUuid","class":"OCA\\Passwords\\Db\\AbstractMapper","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Services/Object/ChallengeService.php","line":71,"function":"findByUuid","class":"OCA\\Passwords\\Services\\Object\\AbstractService","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Services/UserChallengeService.php","line":185,"function":"findByUuid","class":"OCA\\Passwords\\Services\\Object\\ChallengeService","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Services/UserChallengeService.php","line":109,"function":"getDefaultChallenge","class":"OCA\\Passwords\\Services\\UserChallengeService","type":"->"},{"file":"/var/www/nextcloud/apps/passwords/lib/Controller/Api/SessionApiController.php","line":113,"function":"getChallengeData","class":"OCA\\Passwords\\Services\\UserChallengeService","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":232,"function":"request","class":"OCA\\Passwords\\Controller\\Api\\SessionApiController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":138,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":184,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":338,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1053,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":49,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/lib/public/AppFramework/Db/QBMapper.php","Line":283},"message":"Loading challenge failed","exception":{},"CustomMessage":"Loading challenge failed"}}
```
### Browser Logs
_No response_