SUMMARY: I updated the SQLite on my Ubuntu dedicated server, but now I get an Internal Server Error when trying to run any PHP script (even "Hello World").
DETAILS: I rent a "Fully Managed" server from a large host, but they refused to update the SQLite on the server that was a few years old, saying I'm on my own.
I found an article that said to do "apt install libsqlite3-dev", but when I tried, I got this excerpt:
libsqlite3-dev is already the newest version (3.22.0-1ubuntu0.7).
Which is not true, that's not close to the newest version. I also tried "apt install sqlite3" but got the same result.
From another article I did:
cd /usr/local/bin
wget https://www.sqlite.org/2022/sqlite-autoconf-3400000.tar.gz
tar zxvf sqlite-autoconf-3400000.tar.gz
cd sqlite-autoconf-3400000
./configure
make
make install
That got SQLite installed, but now when I tried to run a simple "Hello World" PHP script, I get an Internal Server Error. The error log says:
>AH01215: php80.cgi: symbol lookup error: php80.cgi: undefined symbol: sqlite3_column_table_name: /[host name redacted]/cgi-system/php80.cgi
>End of script output before headers: php80.cgi
My <helloworld.php> file is:
<!DOCTYPE html>
<html>
<head>
<title>Hello world></title>
</head>
<body>
<?php echo'Hell, low whirled.';?>
</body>
</html>
I asked my host why my PHP won't run, and they said that I screwed something up when I updated SQLite. They said I can pay them $100 to "re-image" the server software (downgrading the SQLite), and then have them do a custom update of SQLite for me, for probably $300. I'm wary of paying $300 every time I want to update the software, so I'm hoping to get some help in getting my PHP/SQLite to play nice together (or to install SQLite properly after I pay $100 to have my server re-imaged).
My Ubuntu OS is 18.04.6 LTS (Bionic Beaver), and PHP is 8.0.
