WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Issue on WP 3.3. fresh install with SQLite3 (2 posts)

  1. arachma1
    Member
    Posted 2 years ago #

    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

  2. arachma1
    Member
    Posted 2 years ago #

    I finally just decided to apply a very quick workaround:

    1. Install MySQL and all related packages
    2. Setup WordPress to use MySQL
    3. Complete WordPress installation
    4. Dump MySQL database and convert it into SQLite3 database
    5. Install and setup "PDO (SQLite) For WordPress" plugin
    6. Setup WordPress to use SQLite3 database
    7. Remove MySQL and all related packages

    My WordPress is now happily running with SQLite3 database

    I think PDO SQLite3 should be natively supported in WordPress so this kind of workaround is not needed anymore.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags