minor issues with 3.8

  • Attempting to use with 3.8 seems to mostly work, although immediately following installation I saw the following errors:

    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

    https://www.ads-software.com/plugins/postgresql-for-wordpress/

Viewing 7 replies - 1 through 7 (of 7 total)

  • I am having this exact issue, does anybody know a fix?

    Thread Starter netllama

    (@netllama)

    As far as I can tell, those errors are harmless. At least I haven’t seen any impact as a result of them yet.

    How do you sign in to edit your wordpress site? As the error comes during the installation, I don’t think the process actually completes on mine, so although the default wordpress site gets created I can’t log into the admin side of things as it doesn’t recognise my username

    Thread Starter netllama

    (@netllama)

    I’m definitely not having that problem. I can login as admin without any issues. What version of postgresql are you using? I’ve got 9.2.6.

    Not sure on my Postgresql version but I did see that on the PG4WP page

    https://www.ads-software.com/plugins/postgresql-for-wordpress/

    …It’s only compatible up to WordPress 3.4.2, whereas I’d downloaded 3.8 so that possibly caused it to fail.

    I started from scratch with 3.4.2 and now it all works, so could have been a mistake I made in the process, or I’m guessing it was the issue that 3.8 is not supported by PG4WP

    Thread Starter netllama

    (@netllama)

    The entire point of this thread is people using this plugin with 3.8. So i’m not really sure what you’re trying to say.

    Okay I’m new to WordPress

    I just read on the plugin page “Compatible up to: 3.4.2” so assumed that’s why I was getting the error, therefore I reverted back from 3.8 to 3.4.2 to fix it

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘minor issues with 3.8’ is closed to new replies.