"No tables in database" if WAL files are not writable

Issue #368 new
Thomas created an issue

I'm trying to install phpliteadmin on a raspberry. I installed sqlite3, apache and php

sudo apt-get install sqlite3 -y sudo apt-get install apache2 -y sudo apt-get install php libapache2-mod-php -y when i know try to start phpliteadmin in an empty directory and try to create a database i get the following error:

PDO: installed PDO SQLite Driver: not installed SQLite3: not installed SQLiteDatabase: not installed when i install the pdo sqlite driver the errot goes away but i want to use the other databse php extensions, because with the PDO SQLite Driver i cannot read database with WAL set. why do i get the error SQLite3: not installed when it is installed. is there anything missing?

Comments (4)

  1. phpLiteAdmin repo owner

    The sqlite package you installed is not PHP's SQLite extension, it is the standalone SQLite binary that has nothing to do with PHP. To install the SQlite extension of PHP you need one of these, depending on your PHP version:

    #!bash
    
    apt-get install php7.0-sqlite3
    apt-get install php5-sqlite
    
    See https://bitbucket.org/phpliteadmin/public/wiki/Installation

    You cannot use the SQLiteDatabase extension for SQLite 2 on most modern Distributions, as it is deprecated and not available in most Linux distributions.

    If you install the package mentioned above, you most likely have both SQLite3 and the PDO Sqlite extension available. phpLiteAdmin will use PDO as first choice, but you can try to force it to use SQLite3 by changing

    #!php
    
    define("FORCETYPE", false);
    

    to

    #!php
    
    define("FORCETYPE", "SQLite3");
    

    in phpliteadmin.php

    Please explain further what your problem with PDO's SQlite extension is. phpLiteAdmin currently does not use WAL anyway.

  2. phpLiteAdmin repo owner

    So the remaining issue is basically that phpLiteAdmin does not complain that these files are not writable, right?

  3. Log in to comment