• 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/

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Contributor studiograsshopper

    (@studiograsshopper)

    Hi,

    First, deactivate GCW and see if, when navigating to whichever page is throwing the error, you still get an error. Pay attention to the error log timestamp to make sure that you are looking at the correct entry.

    Note: deactivating the plugin won’t break anything, but it will temporarily screw up the display of your site. So, reactivate GCW as soon as you’ve done this test.

    Report back with your findings and we’ll go from there.

    Plugin Contributor studiograsshopper

    (@studiograsshopper)

    For info, I can’t recreate this on my test install.
    It may be useful to check your server’s versions of mySQL and PHP – just in case.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Server SQL errors’ is closed to new replies.