WordPress.org

Ready to get started?Download WordPress

Forums

PDO (SQLite) For WordPress
[resolved] [Plugin: PDO (SQLite) For WordPress] One or more database tables are unavailable. The database may n (3 posts)

  1. Kojichan
    Member
    Posted 2 years ago #

    I'm getting this error when trying to run the install for WordPress.

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

    I've edited the 'wp_config.php' to include: define('DB_TYPE', 'sqlite');, setup the API codes.

    Put the PDO files in the /wp-content/ folder, not a plugin folder, created a /database/ directory in the /wp-content/ folder and set it to 777 CHMOD.

    EVen set /wp-admin/include/schema.php and upgrade.php to 666 CHMOD as another website suggested.

    Then when I run the install, I am presented with this error.

    The Database is created fine /database/MyBlog.sqlite, as well as debug.txt, and a .htaccess file.

    But the Database is empty. Blank. It's like WP couldn't create the Tables, so it's blank.

    I've tried this on two different servers, both with PHP 5.0 and PDO SQLite installed on both.

    Do you know what could be wrong?

    Edit:

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

    These are the errors from the debug.txt file. Further proving the Database is empty. No tables were created by whatever created the DB.

  2. Kojichan
    Member
    Posted 2 years ago #

    I hate to double post, but I can't seem to edit my previous post. (Too long ago I'm assuming).

    I ended up finding an old version of WordPress + PDO pack bundled in, installing that, then 'Upgrading' to the newest WordPress.

    Worked out of the box, and the update, surprisingly, worked very well.

    If anyone else is having this problem, try this website:

    http://xeonbloomfield.com/2011/04/22/projects-wordpress-sqlite-repack/

    (I hope that link works, if not do a google search for this:

    [projects] WordPress SQLite Repack

    And it's the top-most link)

    Ciao!

  3. KalleAnka
    Member
    Posted 2 years ago #

    The install procedure did not work for me either on WP v3.3.2

    It worked on WP v3.1.2 following this install procedure:
    http://epilogica.info/articles/how-to/wordpress/installing-sqlite-PDO.htm

    After the installation is complete one can upgrade to v3.3.2 or later via the dashboard.

    Previous WP versions can be downloaded here:
    http://wordpress.org/download/release-archive/

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.