search

paulgibbs / achievements

Achievements gamifies your WordPress site with challenges, badges, and points.
http://achievementsapp.com
63 stars 9 forks source link

woocommerce breaks achievements #101

Closed paulgibbs closed 11 years ago

paulgibbs commented 11 years ago

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_dpaevent'' 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 commented 11 years ago

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

paulgibbs commented 11 years ago

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

paulgibbs commented 11 years ago

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

stueynet commented 11 years ago

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 commented 11 years ago

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 commented 11 years ago

@coenjacobs Apparently https://github.com/woothemes/woocommerce/issues/3149 hasn't gotten into a release yet. Can you let us know when it will be?