Sudden strange problem editing products

[Javier]

Javier

December 15, 2016 at 2:36 pm

Since a couple of days, maybe after the last woocommerce update, we are having problems editing products. We are given a “are you sure you want to do this?” error in WordPress and lose all the changes.

Checking the log:

WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘) ORDER BY p.menu_order DESC, p.post_date DESC LIMIT 1’ at line 1 for query SELECT DISTINCT p.* FROM wp_posts AS p INNER JOIN wp_term_relationships AS tr ON p.ID = tr.object_id INNER JOIN wp_term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy IN (“product_cat”, “pa_accesorios”, “pa_caja”, “pa_cargador-combo-100-plus”, “pa_cierre”, “pa_color”, “pa_edadtalla”, “pa_medida”, “pa_medidas-cojines”, “pa_medidas-pesarios”, “pa_medidas-ruedas”, “pa_modelo”, “pa_modelos-bastones”, “pa_no-de-pie”, “pa_productos-en-alquiler”, “pa_sillas-de-ruedas”, “pa_talla”, “pa_tallas-faja”, “pa_tallas-ortesis”, “pa_tallas-pinza”, “pa_usuarios-preferentes”) WHERE ( p.menu_order >= 860 OR p.post_date >= ‘2014-08-17 04:51:53’ AND p.menu_order = 860 ) AND p.post_type IN (‘product’) AND p.post_status = ‘publish’ AND tt.term_id IN (3604,3603,104,) ORDER BY p.menu_order DESC, p.post_date DESC LIMIT 1 made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/virtue_premium/base.php’), include(‘/themes/virtue_premium/woocommerce/single-product.php’), woocommerce_get_template_part, wc_get_template_part, load_template, require(‘/themes/virtue_premium/woocommerce/content-single-product.php’), do_action(‘woocommerce_single_product_summary’), WP_Hook->do_action, WP_Hook->apply_filters, woocommerce_template_single_title, wc_get_template, include(‘/themes/virtue_premium/woocommerce/single-product/title.php’), previous_post_link_plus, adjacent_post_link_plus, get_adjacent_post_plus

Is there something to do with the theme?

kind regards