Database erros after v6 upgrade

Help
1

Apologies for reviving an old-ish thread but even after updating to the latest version, I still have the problem.

Attempting to delete a group generates the error " Could not remove entries from table
FOREIGN KEY constraint failed"

Tail log says:

2025-02-21 10:02:01.832 ERROR gravityDB_delFromTable(9): SQL error exec("DELETE FROM "group" WHERE name IN (SELECT item FROM deltable);"): FOREIGN KEY constraint failed
2025-02-21 10:02:01.835 WARNING API: Could not remove entries from table (FOREIGN KEY constraint failed)

Token: https://tricorder.pi-hole.net/Ins7NyJj/

2

I suggest you do a teleporter backup, then move the gravity database to a backup location and import the telporter back. Run gravity afterwards. The database is at /etc/pihole/gravity.db

3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.