Please follow the below template, it will help us to help you!
Fresh install on debian 12 fails with "WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error"
Please note that the file actually is there, the permissions look correct.
Tried to do a fresh install since my very old installation was not updating correctly. Ran into a plethora of errors since.
Expected Behaviour:
Database / pihole should behave like advertised (i.e. database access should be working).
Actual Behaviour:
2025-06-07 13:55:25.078 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:25.078 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:25.084 CEST [7491/T7530] WARNING: API: Could not read domains from database table (key: database_error, hint: Database not available)
2025-06-07 13:55:26.080 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:26.080 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:27.082 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:27.082 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:28.089 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:28.089 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:29.092 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:29.092 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:30.093 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:30.093 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:31.095 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:31.095 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:32.097 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:32.097 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:33.099 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:33.099 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:34.001 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:34.001 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:35.003 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:35.003 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:36.004 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:36.005 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:37.006 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:37.006 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:38.008 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:38.008 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:39.010 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:39.010 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:40.011 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:40.011 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error
2025-06-07 13:55:41.013 CEST [7491/T7512] ERROR: SQLite3: no such table: info in "SELECT value FROM info WHERE property = 'updated';" (1)
2025-06-07 13:55:41.013 CEST [7491/T7512] WARNING: gravity_updated(): SELECT value FROM info WHERE property = 'updated'; - SQL error prepare: SQL logic error