TiddlyWiki / TiddlyWiki5

A self-contained JavaScript wiki for the browser, Node.js, AWS Lambda etc.
https://tiddlywiki.com/
Other
8.07k stars 1.19k forks source link

[MWS] Delete an active role, crashes the server #8776

Open pmario opened 12 hours ago

pmario commented 12 hours ago

To reproduce:

Error log

syncer-server-filesystem: Dispatching 'save' task: $:/StoryList
Serving on http://127.0.0.1:8080
(press ctrl-C to exit)

$:/plugins/tiddlywiki/multiwikiserver/store/sql-engine.js:87
        return statement.run(params);
                         ^
SqliteError: FOREIGN KEY constraint failed
    at SqlEngine.runStatement ($:/plugins/tiddlywiki/multiwikiserver/store/sql-engine.js:87:19)
    at SqlTiddlerDatabase.deleteRole ($:/plugins/tiddlywiki/multiwikiserver/store/sql-tiddler-database.js:1150:14)
    at exports.handler ($:/plugins/tiddlywiki/multiwikiserver/routes/handlers/delete-role.js:42:22)
    at IncomingMessage.<anonymous> ($:/plugins/tiddlywiki/multiwikiserver/mws-server.js:515:10)
    at IncomingMessage.emit (node:events:518:28)
    at endReadableNT (node:internal/streams/readable:1698:12)
    at process.processTicksAndRejections (node:internal/process/task_queues:90:21) {
  code: 'SQLITE_CONSTRAINT_FOREIGNKEY'
}

Node.js v22.10.0
pmario commented 12 hours ago

If the role is not assigned to any user -> Delete works