Unable to Fill Gravity Table

General Beta 5.0
30

I updated to the latest beta today and updated Gravity (after re-enabling the list in question), and I'm still getting an error:

  [i] Storing downloaded domains in new gravity database...
  [✗] Unable to fill gravity table in database /etc/pihole/gravity_temp.db
  Error: /tmp/tmp.t2YzCTWcZq.gravity line 54018: expected 2 columns of data but found 3
  [✓] Cleaning up stray matter
  [✓] DNS service is running
  [✓] Pi-hole blocking is Enabled

If I run the 'head' command from earlier on the new file:

# head -n 54018 /tmp/tmp.t2YzCTWcZq.gravity | tail -n 10
zedo.com,5
zeepmedia.com,5
zencudo.co.uk,5
zenkreka.com,5
zenzuu.com,5
zeus.developershed.com,5
zeusclicks.com,5
zintext.com,5
zmedia.com,5
zumobi.com,5005.free-counter.co.uk,6 <-------

What's interesting though is that the blocked domain readout isn't -2 this time around.

I can provide more info as requested.

31

Ah sorry, please run

pihole checkout core fix/gravity_add_newline

first to receive my proposed fix for testing. This hasn't been merged into the beta as of now as I'd like to confirm this is the true solution.

32

That appears to have done it, as I don't receive the error after importing your fix (and I confirmed that the culprit list was still enabled).

Thank you for your time. I appreciate the help!

1 Like