Wordpress

if you need to move wordpress to a new url then the following sql script will be handy (update the urls in it of course):

To force wordpress to use SSL for the admin area you simply can add a line to your wp-config.php file located in the root of your wordpress installation: define(‘FORCE_SSL_ADMIN’, true);  

Just created a PG4WP fork with described changed from my last post. Here is the github url for version 2.0.0 that supports wordpress 3.9.1: https://github.com/mbogner/pg4wp2/tree/v2.0.0 Just click the “Download ZIP” button on the target page.

Till 3.8 everything was ok and my blog survived every update. But for 3.9 this changed as the postgresql driver I am using (PG4WP)is not compatible out of the box anymore. There were no updates for the last two years. Here are the two fixes I had to make: To resolve the error “Call to undefined

I found strange errors like the following in my apache_error.log [Thu May 02 20:59:58 2013] [error] [client 84.114.158.229] WordPress database error ERROR: column p.id does not exist\\\\\\\\nLINE 1: SELECT p.id FROM wp_posts AS p WHERE … I found out that this comes from line 1178 in wp-includes/link-template.php. Just change the p.id at after the SELECT