wordpress-heroku icon indicating copy to clipboard operation
wordpress-heroku copied to clipboard

Updating to Wordpress 4.2.2

Open RichardBray opened this issue 10 years ago • 4 comments

I've tried several times to update but keep getting this error;

WordPress database error: [ERROR: syntax error at or near "a" LINE 1: DELETE a, b FROM wp_options a, wp_options b ^]
DELETE a, b FROM wp_options a, wp_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 < 1433256011

WordPress database error: [ERROR: syntax error at or near "a" LINE 1: DELETE a, b FROM wp_options a, wp_options b ^]
DELETE a, b FROM wp_options a, wp_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 < 1433256011

WordPress database error: [ERROR: syntax error at or near "FULL" LINE 1: SHOW FULL COLUMNS FROM wp_options ^]
SHOW FULL COLUMNS FROM `wp_options`

Any ideas?

RichardBray avatar Jun 02 '15 14:06 RichardBray

I'm getting these same errors, and I'm running WordPress 4.2.2 also.

pschlenker avatar Jun 14 '15 12:06 pschlenker

From the WordPress 4.2.2 release notes:

WordPress versions 4.2 and earlier are affected by a critical cross-site scripting vulnerability, which could enable anonymous users to compromise a site. WordPress 4.2.2 includes a comprehensive fix for this issue.

getaaron avatar Jul 31 '15 21:07 getaaron

How can I set version 4.2.2,please let me know..

manishnagdewani96170 avatar Oct 13 '15 12:10 manishnagdewani96170

I guess this has to do with the non-maintained pg4wp plugin. A potential fix could be this:

https://wordpress.org/support/topic/upgrade-to-wp421-fail

leifg avatar Feb 26 '16 13:02 leifg