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:
- Server setup
OS: Debian Wheezy
Thanks in advance for your help.