SQLiteDatabase: not installed
Issue #364
invalid
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.
Comments (3)
-
repo owner -
repo owner 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.
-
repo owner - changed status to invalid
Closed because not enough information and missing feedback
- Log in to comment
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) andsqlite3
package installed:Then convert your database into sqlite3 on the command line with:
(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.