Clean install on GCP Ubuntu 20.04 VM.
Everything seems to be working except that the adlists are not loading. There seems to be a problem with the SQLite3 database or connection.
I tried to update gravity from CLI with these results:
/etc/pihole$ cat adlists.list https://raw.githubusercontent.com/StevenBlack/hosts/master/hosts https://mirror1.malwaredomains.com/files/justdomains /etc/pihole$ pihole -g Error: no such table: info [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 [✗] Unable to update gravity timestamp in database /etc/pihole/gravity.db Error: near line 2: no such table: info Error: no such table: vw_gravity Error: no such table: vw_gravity [i] Number of gravity domains: ( unique domains) Error: near ")": syntax error Error: no such table: vw_blacklist [i] Number of exact blacklisted domains: Error: no such table: vw_regex_blacklist [i] Number of regex blacklist filters: Error: no such table: vw_whitelist [i] Number of exact whitelisted domains: Error: no such table: vw_regex_whitelist [i] Number of regex whitelist filters: [✓] Flushing DNS cache [✓] Cleaning up stray matter [✓] DNS service is running [✓] Pi-hole blocking is Enabled
Trying to add from the web admin interface produces this error
**Error, something went wrong!** While preparing statement: no such table: adlist