Trying to delete adlist table, got Error: FOREIGN KEY constraint failed (19)

[yubiuser]

@rbe

It seems like a bug in Pi-hole or whatever,,,

It's not. On the contrary, the sqlite3 from your OS repos does not follow the sqlite maintainers which recommend to compile the binary with a flag that always respects FOREIGN KEY constraints.

Totally different issue, but same reason for failing with a lot more information about the foreign key constrains. Start reading the thread from here:

Interesting study: Leaky Forms

The issue is quite clearly with the order of the statements, as yubiuser has pointed out. The script issues statements that must fail because executing them would violate a foreign key constraint. In any database that honors foreign key constraints, those constraints must be kept, or your database may become corrupted. The reason why this works with different versions of SQLite3 is that the internal, SQLite3-specific PRAGMA foreign_keys that controls whether those constraints are honored may …