sim0n00ps/OF-DL
52
58
Fork 19
Code Issues 32 Pull Requests 1 Actions Packages Projects 1 Releases 15 Wiki Activity

Exception: 'UNIQUE constraint failed #79

New Issue
Closed
opened 2025-11-15 06:43:05 +00:00 by asdfjkllkjkl · 1 comment
asdfjkllkjkl commented 2025-11-15 06:43:05 +00:00
Copy Link

Any ideas how to fix this? Keep getting the following error after login:

Exception caught: SQLite Error 19: 'UNIQUE constraint failed: users.username'.

StackTrace: at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db)
at Microsoft.Data.Sqlite.SqliteDataReader.NextResult()
at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken)
--- End of stack trace from previous location ---
at OF_DL.Helpers.DBHelper.CreateUsersDB(Dictionary`2 users)

Any ideas how to fix this? Keep getting the following error after login: Exception caught: SQLite Error 19: 'UNIQUE constraint failed: users.username'. StackTrace: at Microsoft.Data.Sqlite.SqliteException.ThrowExceptionForRC(Int32 rc, sqlite3 db) at Microsoft.Data.Sqlite.SqliteDataReader.NextResult() at Microsoft.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbCommand.ExecuteNonQueryAsync(CancellationToken cancellationToken) --- End of stack trace from previous location --- at OF_DL.Helpers.DBHelper.CreateUsersDB(Dictionary`2 users)
melithine commented 2025-11-18 15:31:40 +00:00
Collaborator
Copy Link

One of the creators you follow changed their username in a weird way, like deleting one account and renaming a second account to the name of the first one. Delete your users.db file in the main ofdl folder (or the config folder if using Docker).

One of the creators you follow changed their username in a weird way, like deleting one account and renaming a second account to the name of the first one. Delete your users.db file in the main ofdl folder (or the config folder if using Docker).
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
bug
Something is not working
code-submitted
Some code has been written to address this issue, but has not yet made it into a release version yet.
duplicate
This issue or pull request already exists
feature-request
New feature
invalid
Something is wrong
needs-documentation
The OFDL documentation needs to be updated for this issue.
needs-info
More information is needed
triaged-and-escalated
This has been triaged and needs help from a specific developer.
wontfix
This won't be fixed
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
JIREX melithine whimsical-c4lic0 sim0n00ps
No Assignees
2 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: sim0n00ps/OF-DL#79
No description provided.
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?