Update Gravity - Issue

Hello! Just installed a new Pi-Hole Server in CentOS 7.
The issue I am facing:
Gravity List Cannot be updated
Details about my system:
When run pihole -g get error as below:

--------------------
  [i] Neutrino emissions detected...
  [✗] Pulling blocklist source list into range
  [i] No source list found, or it is empty

[i] Building tree...
  [✗] Unable to build gravity tree in /etc/pihole/gravity_temp.db
  Error: no such table: main.gravity
-------------------------

when try pihole -g -r

--------------------------------
[✗] Unable to fill table adlist in database /etc/pihole/gravity.db
  Error: /tmp/tmp.VMr0BjNnzB.gravity line 1: expected 7 columns of data but found 6
----------------------------------

Tried to delete gravity.db and gravity_temp.db and situation is the same!

What I have changed since installing Pi-hole:
Nothing, since installation I got this error!
Error: /tmp/tmp.[tablename].gravity line 1: expected 7 columns of data but found 6

Please post the complete output of the following command from the Pi terminal:

pihole -g -f

[root@pihole ~]# pihole -g -f
[✓] Deleting existing list cache
[i] Neutrino emissions detected...
[✗] Pulling blocklist source list into range
[i] No source list found, or it is empty

[i] Building tree...
[✗] Unable to build gravity tree in /etc/pihole/gravity_temp.db
Error: no such table: main.gravity
[i] Number of gravity domains: 0 (0 unique domains)
[i] Number of exact blacklisted domains: 0
[i] Number of regex blacklist filters: 0
[i] Number of exact whitelisted domains: 0
[i] Number of regex whitelist filters: 0
[✓] Flushing DNS cache
[✓] Cleaning up stray matter

Please upload a debug log and post just the token generated by

pihole -d

allowing to upload when prompted, or do it through the Web interface:

Tools > Generate Debug Log

https://tricorder.pi-hole.net/qfbdexfgwj

You have no adlists shown. Use this FAQ to restore the default lists and rebuild gravity. If this produces errors please reply with the output and a new debug token.

Edit: also check your firewalld settings against our documentation:

Your debug log shows the following:

*** [ DIAGNOSING ]: FirewallD
[i] Firewalld service active
[✗]   Allow Service: http (https://docs.pi-hole.net/main/prerequisites/#firewalld)
[✗]   Allow Service: dns (https://docs.pi-hole.net/main/prerequisites/#firewalld)
[✓]   Allow Service: dhcp
[✓]   Allow Service: dhcpv6
[✗] FTL Custom Zone Not Detected (https://docs.pi-hole.net/main/prerequisites/#firewalld)

The same situation!
https://tricorder.pi-hole.net/57c36txert

Same error I am receiving, @ilirdaka. Even on fresh installs. I have not found a workaround yet.

I tried another fresh install on CentOS and is the same isue. Tried on Debian 10 minimal last version and everything is working great.

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