Cannot create a database

Issue #377 resolved
Philip Metzger created an issue

I have a lumen app project, where there is a directory called public that contains the phpliteadmin.php file, then I have another directory on the same level as public called database.

When I start phpliteadmin I get the following issue:

There was a problem setting up your database, ../database\. An attempt will be made to find out what's going on so you can fix the problem more easily.

_Checking supported SQLite PHP extensions...

PDO: installed
PDO SQLite Driver: installed
SQLite3: not installed
SQLiteDatabase: not installed


My public/phpliteadmin.php looks like this:

//directory relative to this file to search for databases (if false, manually list databases in the $databases variable)
$directory = '../database';

//whether or not to scan the subdirectories of the above directory infinitely deep
$subdirectories = false;

//if the above $directory variable is set to false, you must specify the databases manually in an array as the next variable
//if any of the databases do not exist as they are referenced by their path, they will be created automatically
$databases = array(
        'path'=> 'database.sqlite',
        'name'=> 'Database'

in the database directory i have database/database.sqlite.

By the way I am using windows if that makes a difference.

Any idea how to get this working?

Comments (5)

  1. phpLiteAdmin repo owner

    If you only want to use this one database, try this:

    $directory = false;
    $databases = array(
            'path'=> '../database/database.sqlite',
            'name'=> 'Database'
  2. phpLiteAdmin repo owner

    The $databases array is ignored unless you set $directory=false.

    Your original configuration should find your database nevertheless, however I assume there was some problem with filesystem rights or something like this.

    Anyhow, good that it’s working.

  3. Philip Metzger reporter

    Yeah, could it be the filesystem wilth windows using forward slashes and other OS’s using backslashes? Thinking that because of this:

    database, ../database\. An attempt

  4. Log in to comment