FOREIGN KEY constraint failed

[JustPeachy]

The issue I am facing:

I have Google'd these issues and no reasonable answers.

New debain system on a Netbook with * Pi-hole v5.17.1

• FTL v5.23
• Web Interface v5.20.1

OS is fully patched and updated.

Issues:

1. Updating the gravity blocklists results in an error:
   [✓] Preparing new gravity database
   [i] Creating new gravity databases...
   [✗] Unable to copy data from /etc/pihole/gravity.db to /etc/pihole/gravity.db_temp
   Runtime error near line 16: FOREIGN KEY constraint failed (19)
   [✗] Unable to create gravity database. Please try again later. If the problem persists, please contact support.

2. I don't know if this is a redherring or an actual issue:
   *** [ DIAGNOSING ]: contents of /etc/lighttpd/conf.d
   /etc/lighttpd/conf.d does not exist.

Details about my system:
Debain v12 fully patched and updated running on a netbook (lots of HD space and sufficient ram), connected to a highspeed modem via CAT5.

Debug: https://tricorder.pi-hole.net/D7UMKjNH/

[JustPeachy]

I have run: pihole -r

There was an output error:
[✗] Unable to copy data from /etc/pihole/gravity.db to /etc/pihole/gravity.db_temp
Runtime error near line 16: FOREIGN KEY constraint failed (19)
[✗] Unable to create gravity database. Please try again later. If the problem persists, please contact support.

This post was helpful but did not fix my errors:

Error connecting to database /etc/pihole/gravity.db: Unable to open database: unable to open database file

Its working now: [image] [image] Thank You Im guessing it for some reason failed to install the php7.3-intl first time round

[JustPeachy]

Uninstalled, reinstalled.

Default block list appears to be working.

I wanted to add some more blocklists.

[jfb]

@JustPeachy

I wanted to add some more blocklists.

Are you able to do so now?

[JustPeachy]

ok diving back in....

I was using this page:

Avoid The Hack: The Best Pi-Hole Blocklists (2023) | Avoid the Hack...

For block lists.

Looks like the OSID lists might have something in there which is causing a DB issue.
I was using Full: https://dbl.oisd.nl/

I am not using it now and Pi Hole appears to update fine.

[eeshaan]

Was running into the same error. Turned out to be the result of restoring a backup from a previous release of Pi-hole. Copied the adlists manually and there were no issues creating the database.