No lists after update

[tim11]

Hello,

my pihole installation on debian 10 with apache was offline for 5 months, till the end it worked without any problems. After going online again i made an update, then all my list were gone. when im trying to add a new list, i receive message

Error, something went wrong!

going for diagnoses gives me

DataTables warning: table id=messagesTable - Ajax error. For more information about this error, please see 7. Warning: Ajax error

apache error log says

[Wed Feb 03 19:22:47.558075 2021] [proxy_fcgi:error] [pid 730:tid 139800858265344] [client :] AH01071: Got error 'PHP message: PHP Warning: Use of undefined constant SQLITE3_OPEN_READONLY - assumed 'SQLITE3_OPEN_READONLY' (this will throw an Error in a future version of PHP) in /var/www/html/admin/scripts/pi-hole/php/database.php on line 61PHP message: PHP Fatal error: Uncaught Error: Class 'SQLite3' not found in /var/www/html/admin/scripts/pi-hole/php/database.php:42\nStack trace:\n#0 /var/www/html/admin/scripts/pi-hole/php/database.php(65): SQLite3_connect_try('/etc/pihole/pih...', 'SQLITE3_OPEN_RE...', true)\n#1 /var/www/html/admin/api_db.php(56): SQLite3_connect('/etc/pihole/pih...')\n#2 {main}\n thrown in /var/www/html/admin/scripts/pi-hole/php/database.php on line 42', referer: http:///groups-domains.php?type=white
[Wed Feb 03 19:22:50.894062 2021] [proxy_fcgi:error] [pid 730:tid 139800967370496] [client ] AH01071: Got error 'PHP message: PHP Warning: Use of undefined constant SQLITE3_OPEN_READONLY - assumed 'SQLITE3_OPEN_READONLY' (this will throw an Error in a future version of PHP) in /var/www/html/admin/scripts/pi-hole/php/database.php on line 61PHP message: PHP Fatal error: Uncaught Error: Class 'SQLite3' not found in /var/www/html/admin/scripts/pi-hole/php/database.php:42\nStack trace:\n#0 /var/www/html/admin/scripts/pi-hole/php/database.php(65): SQLite3_connect_try('/etc/pihole/pih...', 'SQLITE3_OPEN_RE...', true)\n#1 /var/www/html/admin/api_db.php(56): SQLite3_connect('/etc/pihole/pih...')\n#2 {main}\n thrown in /var/www/html/admin/scripts/pi-hole/php/database.php on line 42', referer: http:///db_graph.php

Update Gravity has no effect on adding lists, neither with gui nor bash.

There where no system changes since going offline but the update.

anyone got a solution?

thx in advance

[Bucking_Horn]

Apache is not supported by Pi-hole.

That said, it's likely that your missing lists are only a display issue.
Your Apache is complaining about undefined constant SQLITE3_OPEN_READONLY, so I guess its missing a database connection.

You should consult the Apache installation instructions you've used to get Pi-hole running, or search these forums for advice - maybe Installing Pi-hole on Existing Apache Server recently posted by one of our helpful users already has enough to get you going.

[tim11]

Thanks for your help, i will check when im back home (business trip :/)