SQLiteDatabase: not installed

[Former user]

I have a problem when using phpLiteAdmin with database on a USB-stick on a Raspberry Pi3B+ with Raspbian-stretch.

phpLiteAdmin works fine with databases in /var/www/html/databases

When referring to a database on the USB-device, I get message SQLiteDatabase: not installed

Until now I did not succeed in solving the problem.

[phpLiteAdmin]

This looks like these databases on the usb-device are not SQLite3 databases, but SQLite2. phpLiteAdmin can only read SQlite2 databases with the php-extension SQLiteDatabase installed. This extension is deprecated, just like SQLite 2, and thus normally not installed on php installations nowadays. It is not that easy to install it on Stretch, as there is no such package.

You can easily convert Sqlite2 databases into SQlite3 and then manage these with phpLiteAdmin. To do so, make sure you have both sqlite (for sqlite version 2) and sqlite3 package installed:

apt-get install sqlite sqlite3

Then convert your database into sqlite3 on the command line with:

sqlite OLD.DB .dump | sqlite3 NEW.DB

(replace OLD.DB and NEW.DB with the filenames.)

Hoewever, the original application that created the sqlite2 database most likely will not be able to read the sqlite3 file.

[phpLiteAdmin]

Or does it work to open the databases of the usb device if you copy then to /var/www/... ? Then it is not a version problem, but most likely a permission problem.

Please copy the whole error message, it should be a lot longer.

[phpLiteAdmin]

Closed because not enough information and missing feedback