Cannot create a database

[Philip Metzger]

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

...done._

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(
    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?

[phpLiteAdmin]

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

$directory = false;


$databases = array(
    array(
        'path'=> '../database/database.sqlite',
        'name'=> 'Database'
    ),
);

[Philip Metzger]

Ah yes perfect thanks!

[phpLiteAdmin]

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.

[Philip Metzger]

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