Server SQL errors
-
I’m getting a number of SQL errors in my server log. Woo mentions that they are from /plugins/genesis-connect-woocommerce/templates/taxonomy.php
I’m running Genesis with the Agency theme along side of WooCommerce. Everything is currently up to date.
Here’s the address of my dev site: http://guitarsnjazz.nightskytech.com/products/archtop-guitars/
Any ideas?
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_pa_guitar-‘ 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_pa_guitar-cutaway’) WHERE tt.taxonomy IN (‘pa_guitar-cutaway’) ORDER BY tm.meta_value+0 ASC, t.name ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/genesis-connect-woocommerce/templates/taxonomy.php’), genesis, do_action(‘genesis_after_content’), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once(‘/themes/genesis/sidebar.php’), do_action(‘genesis_sidebar’), call_user_func_array, gencwooc_ss_do_sidebar, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, get_terms
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_pa_guitar-‘ 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_pa_guitar-sound-hole’) WHERE tt.taxonomy IN (‘pa_guitar-sound-hole’) ORDER BY tm.meta_value+0 ASC, t.name ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/genesis-connect-woocommerce/templates/taxonomy.php’), genesis, do_action(‘genesis_after_content’), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once(‘/themes/genesis/sidebar.php’), do_action(‘genesis_sidebar’), call_user_func_array, gencwooc_ss_do_sidebar, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, get_terms
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_pa_guitar-‘ 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_pa_guitar-fretboard’) WHERE tt.taxonomy IN (‘pa_guitar-fretboard’) ORDER BY tm.meta_value+0 ASC, t.name ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/genesis-connect-woocommerce/templates/taxonomy.php’), genesis, do_action(‘genesis_after_content’), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once(‘/themes/genesis/sidebar.php’), do_action(‘genesis_sidebar’), call_user_func_array, gencwooc_ss_do_sidebar, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, get_terms
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_pa_guitar-‘ 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_pa_guitar-composition’) WHERE tt.taxonomy IN (‘pa_guitar-composition’) ORDER BY tm.meta_value+0 ASC, t.name ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/genesis-connect-woocommerce/templates/taxonomy.php’), genesis, do_action(‘genesis_after_content’), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once(‘/themes/genesis/sidebar.php’), do_action(‘genesis_sidebar’), call_user_func_array, gencwooc_ss_do_sidebar, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, get_terms
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_pa_guitar-‘ 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_pa_guitar-tonewoods’) WHERE tt.taxonomy IN (‘pa_guitar-tonewoods’) ORDER BY tm.meta_value+0 ASC, t.name ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/genesis-connect-woocommerce/templates/taxonomy.php’), genesis, do_action(‘genesis_after_content’), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once(‘/themes/genesis/sidebar.php’), do_action(‘genesis_sidebar’), call_user_func_array, gencwooc_ss_do_sidebar, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, get_terms
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_pa_guitar-‘ 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_pa_guitar-pickup-type’) WHERE tt.taxonomy IN (‘pa_guitar-pickup-type’) ORDER BY tm.meta_value+0 ASC, t.name ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/genesis-connect-woocommerce/templates/taxonomy.php’), genesis, do_action(‘genesis_after_content’), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once(‘/themes/genesis/sidebar.php’), do_action(‘genesis_sidebar’), call_user_func_array, gencwooc_ss_do_sidebar, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, get_terms
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_pa_guitar-‘ 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_pa_guitar-bridge’) WHERE tt.taxonomy IN (‘pa_guitar-bridge’) ORDER BY tm.meta_value+0 ASC, t.name ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/genesis-connect-woocommerce/templates/taxonomy.php’), genesis, do_action(‘genesis_after_content’), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once(‘/themes/genesis/sidebar.php’), do_action(‘genesis_sidebar’), call_user_func_array, gencwooc_ss_do_sidebar, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, get_terms
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_pa_guitar-‘ 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_pa_guitar-lower-bout-range’) WHERE tt.taxonomy IN (‘pa_guitar-lower-bout-range’) ORDER BY tm.meta_value+0 ASC, t.name ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/genesis-connect-woocommerce/templates/taxonomy.php’), genesis, do_action(‘genesis_after_content’), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once(‘/themes/genesis/sidebar.php’), do_action(‘genesis_sidebar’), call_user_func_array, gencwooc_ss_do_sidebar, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, get_terms
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_pa_guitar-‘ 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_pa_guitar-nut-width-range’) WHERE tt.taxonomy IN (‘pa_guitar-nut-width-range’) ORDER BY tm.meta_value+0 ASC, t.name ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/genesis-connect-woocommerce/templates/taxonomy.php’), genesis, do_action(‘genesis_after_content’), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once(‘/themes/genesis/sidebar.php’), do_action(‘genesis_sidebar’), call_user_func_array, gencwooc_ss_do_sidebar, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, get_terms
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_pa_guitar-‘ 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_pa_guitar-scale-range’) WHERE tt.taxonomy IN (‘pa_guitar-scale-range’) ORDER BY tm.meta_value+0 ASC, t.name ASC made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/genesis-connect-woocommerce/templates/taxonomy.php’), genesis, do_action(‘genesis_after_content’), call_user_func_array, genesis_get_sidebar, get_sidebar, locate_template, load_template, require_once(‘/themes/genesis/sidebar.php’), do_action(‘genesis_sidebar’), call_user_func_array, gencwooc_ss_do_sidebar, genesis_do_sidebar, dynamic_sidebar, call_user_func_array, WP_Widget->display_callback, WC_Widget_Layered_Nav->widget, get_terms
http://ww.wp.xz.cn/extend/plugins/genesis-connect-woocommerce/
The topic ‘Server SQL errors’ is closed to new replies.