Monday, December 17, 2012

Installing Wordpress SQLite PDO

Installing the PDO (SQLite) plugin for Wordpress requires a little fine-tuning of the Wordpress PHP files. You will need to ensure that SQLite has been installed on your (web hosting) server. The following configuration has been tested for Wordpress Version 3.1.2.
1. Download Wordpress 3.1.2 and PDO (SQLite) Plugin 2.7.0 from wordpress.org
2. Extract/uncompress the two downloads. You should now have a 'wordpress' folder and a 'pdo-for-wordpress' folder
3. Place the 'pdo' folder and 'db.php' file, located in the 'pdo-for-wordpress' folder, in the 'wp-content' folder located in the 'wordpress' folder
4. Create a folder named 'database' in the 'wp-content' folder of the 'wordpress' folder
5. Rename the 'wp-config-sample.php' file located in the 'wordpress' folder to 'wp-config.php'
6. Open the 'wp-config.php' file renamed above in a text editor (e.g. gedit on linux)
7. Add the following line
define('DB_TYPE', 'sqlite'); // use sqlite
after the lines
/** The Database Collate type. Don't change this if in doubt. */define('DB_COLLATE', '');
to give
/** The Database Collate type. Don't change this if in doubt. */define('DB_COLLATE', '');define('DB_TYPE', 'sqlite'); // use sqlite
8. Replace the lines
with your own randomly generated keys to give something like
Save the file
The random keys can be generated online by visiting https://api.wordpress.org/secret-key/1.1/salt/
9. Open the 'wp_install.php' file located in the 'wordpress/wp-content/pdo' folder in a text editor and replace the line
with the line
Save the file and shutdown your editor
10. Upload all the folders and files located WITHIN the 'wordpress' folder to your (web hosting) server
11. Set the file permissions of the 'database' folder created above (Step 4.) to 777
12. Navigate your web browser to http://yourdomain/wp-admin/install.php to initiate the Wordpress install process
13. Enter a username and password and then click the 'install' button
14. You might see PHP code being printed to your browser - ignore this and scroll to the bottom of the page
15. Note your password and then click the 'login' link located at the bottom of the page
16. Enter your username and password. You should then be taken to the Wordpress Configuration Panel
Remember that you need to have SQLite installed on your (web hosting) server for this to work.
Good luck.