Skip to content

PG4WP compatibility with PostgreSQL 9.1+

2 novembre 2011, 11:49

PostgreSQL 9.1 introduces a change in the default value for the « standard_conforming_strings » parameter.

When this parameter is « on » (which is the new default), PostgreSQL will stop accepting the backslash character for escaping single quote in strings.

For now, if you want to use WordPress/PG4WP with any version of PostgreSQL starting with 9.1, you’ll need to set « standard_conforming_strings = off » in your « postgresql.conf » file.

I’ll try to find a solution for the next release of PG4WP so that it works « out of the box » with PostgreSQL 9.1+

Archivé sous PG4WP. Taggé ,
Un commentaire

New release : PG4WP 1.2.2

11 septembre 2011, 2:18

PG4WP 1.2.0 had a bug that caused WordPress paging to not work, so it’s time for PG4WP 1.2.2 to come out !

This new release corrects this problem.

Also included are some code reorganising (for easier testing of the SQL rewriting code), and some changes to the install/upgrade handling code mainly for WPMU support.

Please note that WPMU does not work yet with PG4WP, but I still intend to get it working if it is possible.

Note : 1.2.1 had a regression so it shouldn’t be used at all.

Download : PG4WP 1.2.2

Archivé sous PG4WP. Taggé , ,
3 commentaires

PG4WP and WordPress Multisite (aka WPMU)

26 août 2011, 9:00

Since version 3.0, WordPress integrated multisite code into its core code, so I’ve recently tested setting up a network of sites on a dev environment.

Not so surprisingly it didn’t work, but the generated errors showed that it shouldn’t be very difficult to get it working.

WPMU will require code reorganisation, and enhanced support for upgrading functions.
I’m starting to work on these changes mainly because they will improve the overall quality of PG4WP.

If you are interested in PG4WP support for WPMU and want to help testing, please contact me by leaving a comment here or via the contact form.

Archivé sous PG4WP. Taggé , , ,
Un commentaire

PG4WP 1.2.0 released !

24 août 2011, 11:33

PG4WP 1.2.0 is finally out !

This version has been tested with WordPress 3.2.1 and works OK.
It should also work with WP 2.9.2 (tested during development phase), and probably older versions as well (but untested).

If you are using an older version of PG4WP and want to upgrade, don’t forget to make a complete backup first (just in case something goes wrong), and try to follow these steps :

  1. Check that you are using PG4WP 1.1.0 and upgrade your WordPress to version 2.9.2 (if it is not your currently running version yet)
  2. Upgrade PG4WP to version 1.2.0 (the best is to remove `db.php`from `wp-content/` and `pg4wp/` from `wp-content/plugins/` and then to proceed as for a new installation, because the directory structure was reorganised)
  3. Verify that your setup is working correctly with PG4WP 1.2.0
  4. Upgrade WordPress to v3.2.1 which is the latest version tested

If you need support or help, you can use the WordPress.org support forum and open a new topic about your problem if one doesn’t already exists.

Here is a direct link to download PG4WP 1.2.0

Archivé sous PG4WP. Taggé , , , ,
Commenter

Time for a release candidate (PG4WP 1.2.0rc)

18 août 2011, 11:43

I’ve juste tagged PG4WP version 1.2.0rc, which after complete testing should become the next stable version of PG4WP.

PG4WP 1.2.0b1 had a few regressions that caused some WordPress features to not work properly.
This new release fixes them and improve installation so that WordPress can now tell you if your login/password is wrong.

Here is the link for direct download : http://downloads.wordpress.org/plugin/postgresql-for-wordpress.1.2.0rc.zip

Please leave a comment if you happen to test it.

Archivé sous PG4WP. Taggé , , ,
Commenter

PG4WP 1.2.0b1 (Beta release)

3 août 2011, 11:43

I’ve just tagged PG4WP version 1.2.0b1 in order to ease testing.

You can download it from http://downloads.wordpress.org/plugin/postgresql-for-wordpress.1.2.0b1.zip.

This version should work with WordPress up to version 3.2.1 and includes  some improvements to generic plugins support.

Please note :

  1. if upgrading you should overwrite your ‘db.php’ with the one from the ‘pg4wp’ directory as it was split in 2 files in order to simplify future upgrades
  2. the ‘pg4wp’ directory can now be placed either in ‘wp-content/plugins/’ or ‘wp-content/’ at your choice.
    Putting it in ‘wp-content/’ will hide it from the plugins in your dashboard (it will still appear as a « drop-in plugin » though, which seems okay for me)
  3. this version is to be considered as « beta » quality (don’t forget to make backups before upgrading), but all my tests were successfull

If you try it, please notify me of your results by commenting on this post (please don’t forget to write the version of WordPress you tried to setup).

Archivé sous PG4WP. Taggé , ,
2 commentaires

Some good news about PG4WP

2 août 2011, 2:26

First of all, I must apologize for not giving any news about PG4WP for a so long time …

I finally came back to PG4WP development, and already integrated a bunch of updates in the development release (which you can download from http://downloads.wordpress.org/plugin/postgresql-for-wordpress.zip ).

If your wordpress is currently running version 2.9.2 with PG4WP 1.1.0 (or the previous development release), you can upgrade to WordPress 3.2.1 using the following steps :

  1.  update PG4WP (replace all the files with the ones from the zip archive)
  2.  overwrite `db.php` in your `/wp-content/` directory with the one from the `pg4wp/` directory
  3. check that `db.php` has the correct configuration for you (error logging is enabled in the archive)
  4. upgrade WordPress with the method you like and you’re done

I’ve tested new install with WP 2.9.2, 3.0.6, 3.1.4 and 3.2.1

Some people asked me about how to have some plugins to work in WP with PG4WP.
I’m going to write some guidelines about this, but you must keep in mind that this may be really difficult for database intensive plugins (especially if they use direct mysql calls).

For now, PG4WP embeds some workarounds for Akismet and WP Stats that are provided with WordPress.
I need to think about the best way to handle plugins workaround.

I hope to have feedback about my recent modifications so I can build up a stable release quickly (maybe at the en of this week or early next week).

PS : This blog now runs WP 3.2.1 with the latest PG4WP development code

 

Archivé sous PG4WP. Taggé , , ,
Commenter

[Update] WordPress 3.0-beta1 is out, PG4WP development goes on

5 avril 2010, 1:04

Time for some news, and these are quite good.

The development version of PG4WP seems to work ok with WordPress 3.0-beta1.
I’ve improved the ‘db.php’ file that sets PG4WP up during WP’s startup to remove some annoying notices (they don’t appear in a « non-debug » install but still exist) and to remove potential fatal errors.

Upgrading from WP 2.9.2 to WP 3.0-beta1 works OK (you’ll get some errors about INDEX creations in ‘pg4wp_errors.log’ if you enabled it, but these can be ignored), you have to update PG4WP before you upgrade.
Making a fresh install of WP 3.0-beta1 works OK too, at least in ‘single blog’ mode (I didn’t test the Multi-blogs mode yet).

PG4WP now appears in the installed extensions and can be activated (in fact this has no effect).
You shouldn’t use the « extension update » feature from WordPress for now, this won’t work as expected.

A new release is on the way, PG4WP 1.2.0 will be out soon, hopefully before WordPress 3.0 official release … Stay tuned :)

If you want to try out :

Here is a direct link to PG4WP development version

Here is a direct link to PG4WP development version
Archivé sous PG4WP. Taggé , ,
6 commentaires

PG4WP 1.1.0 is out with WP 2.9.2 support

16 février 2010, 10:43

Yes ! I’ve just released PG4WP 1.1.0, and it is the official release having support for WordPress 2.9.x series :)

Many thanks to all of you who tested the development releases and gave me feedback and patches to make PG4WP better.

There are still some annoying problems (read more here), but they are in the TODO list for the next release.

Here are some of my ideas for the future :

- resolve most problems introduced by rewriting rules

- build up some kind of « modularized » support for WordPress’ plugins that need special handling

- have WordPress’ import feature work correctly at least with WXR files when using PG4WP

- convert PG4WP into some kind of Framework to easily integrate support for other databases (maybe I’ll call this DBs4WP ?)

- maybe build up a SQLite version, but are there people interested ?

It is time for you to give me any other ideas or wishes, just comment on this post :)

Archivé sous PG4WP. Taggé , , ,
5 commentaires

[Update] PG4WP 1.1.0rc3

1 février 2010, 10:57

PGP4WP 1.1.0rc3 is out, integrating some patches transmited by Boris HUISGEN (many thanks to him).

I tagged this release as stable, but it still needs testing before I remove the ‘rc’ status.

See the changelog if you want to know what has changed.

Please vote in the plugin directory if it works for you.

[Update] A bug was introduced in PG4WP 1.1.0rc3 when handling permalinks, so I released a quickfix in 1.1.0rc4 that shouldn’t have the problem.

You can download PG4WP 1.1.0rc4 from the plugin directory here.

Archivé sous PG4WP. Taggé , , , ,
2 commentaires
« Entrées anciennes