I m running into a problem, where my Doains on List are Bugged.
My system is a Raspberry Pi Zero 2 w.
Debug token:
Your gravity database is corrupted:
2026-04-05 20:51:58.010 CEST [615/T702] ERROR: SQLite3: database corruption at line 74517 of [b270f8339e] (11)
2026-04-05 20:51:58.011 CEST [615/T702] ERROR: SQLite3: database corruption at line 74667 of [b270f8339e] (11)
2026-04-05 20:51:58.011 CEST [615/T702] ERROR: SQLite3: statement aborts at 10: database disk image is malformed; [] (11)
2026-04-05 20:51:58.012 CEST [615/T702] ERROR: SQLite3: database disk image is malformed in "SELECT value FROM info WHERE property = 'updated';" (11)
2026-04-05 20:51:58.013 CEST [615/T702] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: database disk image is malformed
2026-04-05 20:51:59.018 CEST [615/T702] ERROR: SQLite3: database corruption at line 74517 of [b270f8339e] (11)
2026-04-05 20:51:59.019 CEST [615/T702] ERROR: SQLite3: database corruption at line 74667 of [b270f8339e] (11)
2026-04-05 20:51:59.019 CEST [615/T702] ERROR: SQLite3: statement aborts at 10: database disk image is malformed; [] (11)
2026-04-05 20:51:59.020 CEST [615/T702] ERROR: SQLite3: database disk image is malformed in "SELECT value FROM info WHERE property = 'updated';" (11)
2026-04-05 20:51:59.021 CEST [615/T702] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: database disk image is malformed
Please run pihole -g -r recover to try to recover the database, then check again.
You can also try to force a recover with pihole -g -r recover force.
If after the command above it still shows errors or no lists/domains, you will need to run pihole -g -r recreate to create a new database from scratch.
In this case, you will need to import the lists and domains using a teleporter backup. If you don't have a backup, you will need to manually re-add your lists and domains.