Skip to content
 

PG4WP 1.3.0 released !

WordPress 3.4 was officially released yesterday, so here is PG4WP 1.3.0 !

PG4WP 1.3.0 is mainly aimed at PostgreSQL 9.1+ compatibility, but there are also some improvements on data import (to ease migration from a MySQL setup) and WPMU support (not much tested though).

I’ve run a bunch of tests over different version of WP (no plugin enabled at all) :

  1. Fresh install :
    - WP 2.9.2 : OK (this is the least supported WordPress version from now on)
    - WP 3.3.2 : OK
    - WP 3.4 : OK
  2. Importing this blog’s data from WXR export (Tools>Export) :
    - In WP 2.9.2 : OK
    - In WP 3.3.2 : OK
    - In WP 3.4 : OK
  3. Upgrading (after import) :
    - From WP 2.9.2 to 3.4 : OK but had an error about `undefined function self_admin_url()` at the end of the upgrade process (I think it’s a WP 2.9 problem)
    - From WP 3.3.2 to 3.4 : OK with no error at all

These tests were run using PHP 5.2.17 on Apache 2.2.17 using PostgreSQL 8.3.15 (sorry I couldn’t test on PostgreSQL 9.1).

Important note : if you have problems with creating new categories with an old install of WordPress/PG4WP you may have to run the following SQL statement in your PostgreSQL database :

SELECT setval(wp_terms_seq, (SELECT MAX(term_id) FROM wp_terms)+1);

This will correct the sequence value for your setup.

The next release will focus on optimisations and code cleanup.

Download PG4WP 1.3.0 from the plugin directory

4 commentaires

  1. Frank dit :

    3.4.1 is working, too…

    Ever tried to change the password of a user? As an admin I tried to change the password of another user, but couldn’t login afterwards…

  2. Frank dit :

    found it – somehow my user_login had an uppercase letter in it and wordpress does compare with all lowercase names…

  3. netllama dit :

    Just installed with 3.8, and it seems to work ok, although I did see the following errors immediately following the installation:

    WordPress database error: [ERROR: syntax error at or near "a" LINE 1: DELETE a, b FROM wpyear5_options a, wpyear5_options b WHERE ^]
    DELETE a, b FROM wpyear5_options a, wpyear5_options b WHERE a.option_name LIKE ‘\_transient\_%’ AND a.option_name NOT LIKE ‘\_transient\_timeout\_%’ AND b.option_name = CONCAT( ‘_transient_timeout_’, SUBSTRING( a.option_name, 12 ) ) AND b.option_value < 1387862445

    WordPress database error: [ERROR: syntax error at or near "a" LINE 1: DELETE a, b FROM wpyear5_options a, wpyear5_options b WHERE ^]
    DELETE a, b FROM wpyear5_options a, wpyear5_options b WHERE a.option_name LIKE '\_site\_transient\_%' AND a.option_name NOT LIKE '\_site\_transient\_timeout\_%' AND b.option_name = CONCAT( '_site_transient_timeout_', SUBSTRING( a.option_name, 17 ) ) AND b.option_value < 1387862445

    Note, I'm using PostgreSQL-9.2.6 at the moment.

  4. Martii dit :

    Seems that 3.9 stopped working all together – applying this workaround helps: http://wordpress.org/support/topic/not-working-with-39