woocommerce breaks achievements

[paulgibbs]

woocommerce_terms_clauses()

[11-May-2013 06:35:38 UTC] 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 'AS tm ON (t.term_id = tm.woocommerce_term_id AND tm.meta_key = 'order_dpa_event'' at line 1 for query SELECT t., tt., tm.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id LEFT JOIN AS tm ON (t.term_id = tm.woocommerce_term_id AND tm.meta_key = 'order_dpa_event') WHERE tt.taxonomy IN ('dpa_event') AND tt.count > 0 ORDER BY tm.meta_value+0 ASC, t.name ASC made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, dpa_init, do_action('dpa_init'), call_user_func_array, dpa_ready, do_action('dpa_ready'), call_user_func_array, dpa_register_events, get_terms

[paulgibbs]

https://gist.github.com/paulgibbs/5561643 is a fix

[paulgibbs]

Spoken to Coen at Woo; WooCommerce bug. I'll update here when I know which version of WC has the fix.

[paulgibbs]

This should be fixed in whatever the next release of WooCommerce is.

[stueynet]

This seems to be back. Anybody else seeing it again? I see the fix was implemented but I am getting the error again when using debug bar in WP.

[stueynet]

Sorry my mistake. It looks like this fix was not included in the latest woocommerce update. It was overwritten. I added it again. How can we ensure this gets added to Woocommerce?

[paulgibbs]

@coenjacobs Apparently woocommerce/woocommerce#3149 hasn't gotten into a release yet. Can you let us know when it will be?