Teleportor restore function is broken in Pi-hole v5.18.3 FTL v5.25.2 Web Interface v5.21

Help
1

Expected Behaviour:

-operating system Ubuntu Noble 24.04 LTS Armbian
-hardware]_ armbian sbc

  • Pi-hole v5.18.3
  • FTL v5.25.2
  • Web Interface v5.21
    fresh install of OS, fresh install of pihole with standard modules. Up and running fine.
    Then go to Teleporter, restore, untick those:
    Client
    Group
    Audit log
    Static DHCP Leases
    Local DNS Records
    Local CNAME Records
    click restore. Message says done importing.
    Issue pihole -g via command line should grab the new ad list updates.

Actual Behaviour:

pihole -g returns error as:

[sudo] password for vince:
  [i] Neutrino emissions detected...
  [✓] Pulling blocklist source list into range

  [✓] 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)
Runtime error near line 20: FOREIGN KEY constraint failed (19)
   [✗] Unable to create gravity database. Please try again later. If the problem persists, please contact support.
@armbian:~$ uname -a
Linux armbian 6.6.48-ophub #1 SMP Fri Aug 30 06:10:45 EDT 2024 aarch64 aarch64 aarch64 GNU/Linux

Debug Token:

[✓] Your debug token is: https://tricorder.pi-hole.net/Lh9lidnb/

2

after this error happened, I tried to restore another backup dated 2023-04-17 and it worked now (and this time kept all the ticked options without untick anything) . So the problem is from the backup from 2024-02-26 I think. It could either be that backup has some bug, or there's rule/domains that triggered the issue. If dev wants the backup for the 2024-02-26, let me know.

3

It was probably an issue with the gravity.

That's what I'm thinking too.
The teleporter functions were not recently changed and we never received a similar complaint.