Pihole webserver returns HTTP 500 error after admin login

[SakiOroku]

Please follow the below template, it will help us to help you!

Expected Behaviour:

[Pihole webserver to open]

Actual Behaviour:

[Pihole webserver returns HTTP 500 error]

Debug Token:

[https://tricorder.pi-hole.net/LoCOFG2j/]

What Was Tried:

[I have already done pihole -r. Purged lighttpd then reinstalled it through pihole -r. Changed port to 3232 from port 80. The webserver was working fine for about a week until the webserver started returning HTTP error 500. Nothing was changed during this time. The Pihole still operates normally, its only the webserver that does not process database GET requests from the Pihole]

[rdwebdesign]

The debug log is showing many PHP errors:

2023-08-11 03:14:56: mod_fastcgi.c.487) FastCGI-stderr: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 56
2023-08-11 03:14:56: mod_fastcgi.c.487) FastCGI-stderr:PHP Fatal error:  Uncaught Error: Class 'SQLite3' not found in /var/www/html/admin/scripts/pi-hole/php/database.php:42
...
2023-08-11 03:15:04: mod_fastcgi.c.487) FastCGI-stderr:PHP Fatal error:  Uncaught Error: Call to undefined function ctype_alnum() in /var/www/html/admin/scripts/pi-hole/php/persistentlogin_token.php:18

Did you change PHP.ini file on your system?
Or did you recently update PHP to 7.4 from a previous 7.x version?

Apparently your PHP installation is missing at least one module (php-sqlite3) and there's another one disabled (php-ctype).

---

To verify, you need to execute this on the command line (in your Pi-hole machine):

echo "<?php phpinfo(); ?>" > /var/www/html/admin/info.php

This will create a new file.
Now, access the file via browser: http://pi.hole/admin/info.php (change port if needed)

Search for these sections (ctype, PDO and sqlite3):

[SakiOroku]

The only thing I can think of that could have affected PHP/sqlite3 is the firebog adlist auto-updater. I haven't touched the pihole for about a week and the webserver has worked fine for that time until today.

When I search for the sections you suggested, I do not have ctype functions, PDO drivers, SQLite Library, or sqlite3.defensive/sqlite3.extension_dir . Are these packages that I need to reinstall manually? Would these have been reinstalled via pihole -r?

EDIT: I also have messed with chadmayfields domain list. I haven't touched this for about a week either, and I do not think it would be this, but I thought I would bring it up.

[SakiOroku]

I gave up on fixing this. The only thing I can think of is that either the Firebog sync updater messed with something, or less likely, I incorrectly implemented the Pihole DHCP.

I was able to get the web server running again successfully after a clean reinstall (pihole uninstall, curl).