Issue on WP 3.3. fresh install with SQLite3

Hello Everybody,

I saw that WordPress now can use SQLite so I want to try it.

I expected that this is not an easy install and I need a workaround this as the interface for SQLite is a plugin, i.e. it needs to be installed AFTER the database has been created.

The issue that I experienced is that, I just got the following message after I executed wp-admin/install.php:

One or more database tables are unavailable. The database may need to be repaired

When I clicked on “repaired” I got the options to either “Repair Database” or “Repair and Optimized Database”. But clicking any of them does not bring me any where a part from the option to “Please try again”.

The debug.txt file fills up with the following message:

Line 431, Function: prepareQuery, Message: Problem preparing the PDO SQL Statement. Error was no such table: wp_options

It is clear that there is no such table as it is a fresh install. However, the install script managed to generate MyBlog.sqlite database file.

I think I need to manually create all necessary tables. If that is the case, could anybody tell me that necessary tables?

Or is there any other fundamental setting that I missed?

Some related settings that I have are the following:

– wp-config.php

define(‘DB_TYPE’, ‘sqlite’);
define(‘DB_NAME’, ‘myweblog.db’);
define(‘DB_HOST’, ‘localhost’);
define(‘DB_CHARSET’, ‘utf8’);
define(‘DB_COLLATE’, ”);

– Server setup

OS: Debian Wheezy
PHP5: 5.3.8.0-1+b1
SQLite3: 3.7.9-2
Nginx: 1.1.11-1

Thanks in advance for your help.

Kind regards,

Anto