Error connecting to database /etc/pihole/gravity.db: Unable to open database: unable to open database file

[mholland]

Getting error as shown in screenshot:

" Error connecting to database /etc/pihole/gravity.db: Unable to open database: unable to open database file"

However, blacklists do seem to be working, and dns resolution is as normal.

Also having trouble uploading log to tricorder

[DL6ER]

What does

ls -lh /etc/pihole
groups pihole

say?

[mholland]

I'm seeing quite a few of these in the debug log since updating to the 5 beta:

"2020-01-19 15:33:38: (mod_fastcgi.c.421) FastCGI-stderr: PHP Warning: SQLite3::query(): Unable to prepare statement: 1, no such table: network_addresses in /var/www/html/admin/api_db.php on line 69"

@DL6ER

ls -lh /etc/pihole groups pihole

[DL6ER]

What does

pihole -v

say?

Please run

pihole -g

[mholland]

I just ran the instructions that were on the blog page announcing it.

[DL6ER]

Something seems to have gone wrong, your core code doesn't seem to have been upgraded.

What is the output of

cd /etc/.pihole
git status

?

[mholland]

@DL6ER

cd /etc/.pihole git status

[DL6ER]

Okay, so this is unexpected. Do you still have the output that was generated during the upgrade? It not, please try

pihole -r

and chose Repair.

[mholland]

doing that just now, so far its showing that a php7.3-intl did not install first time.

[mholland]

Its working now:

Thank You

Im guessing it for some reason failed to install the php7.3-intl first time round

[DL6ER]

Glad it's working now for you. We'll make sure to investigate what might have caused the issue you're seeing.

Thanks for helping us test Pi-hole v5.0!