Problem with Beta 5.0:
I’ve been running the PiHole v5 beta for about the past month. I went to run an update today to update to the most recent version of the beta code, and was greeted with an error message when attempting to update Gravity at the end of the process. This error also repeats itself any time I call an update to Gravity itself.
The terminal reads:
Unable to fill gravity table in database /etc/pihole/gravity_temp.db Error: /tmp/tmp.461xDziPgw.gravity line 53869: expected 2 columns of data but found 3
I encountered this issue last week when I attempted to update as well (on the same machine). I tried updating my OS (CentOS 7 on VMware) and performing a database rebuild per documentation that I found elsewhere on the forum, and that didn’t seem to help. I ended up rolling back to a backup because the repair operation completely hosed my group configuration as well.
The PiHole still appears to be blocking correctly from the little bit that I’ve been table to test it so far, and I can query URLs on the blocklists from the web interface; however, the blacklisted domain count is -2, and the updates to gravity don’t appear to be completing successfully (on account of the database error).
I’d like to provide the opportunity to work through this before I roll back to my snapshot (or last backup). Any help would be appreciated!
Debug Token (edit):