Database error
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday. If you have problems with registration ask help on contact us page pleaseIf you not got email within 24~36 business hours, firstly check your spam box, and if no any email from the support there - back to the forum and read answer here. DO NOT ANSWER ON EMAILS [noreply@pluginus.net] FROM THE FORUM!! Emails are just for your info, all answers should be published only here.
The support doesn work on Saturdays and Sundays, so some Friday requests can be answered on Monday.
Hi,
I am getting this error in the log file. It seems related to this plugin but I can't tell for sure. Is it related and is there a fix please? I use version 3.3.4.3
Thanks
Thomas
[14-Sep-2023 10:37:23 UTC] WordPress database error Column 'post_title' in where clause is ambiguous for query
SELECT wp_posts.ID
FROM wp_posts LEFT JOIN wp_postmeta sku_meta ON ( wp_posts.ID = sku_meta.post_id AND sku_meta.meta_key='_sku' ) LEFT JOIN wp_posts parents ON ( wp_posts.post_parent = parents.ID AND wp_posts.post_parent != '0' )
WHERE 1=1 AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) AND (((post_title LIKE '%Shoppingvagn%')) AND ((post_title LIKE '%4%')) AND ((post_title LIKE '%hjul%')) ) AND ( wp_posts.post_parent = '0' OR parents.post_status = 'publish' )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/woocommerce/templates/archive-product.php'), do_action('woocommerce_after_main_content'), WP_Hook->do_action, WP_Hook->apply_filters, shoptimizer_after_content, do_action('shoptimizer_sidebar'), WP_Hook->do_action, WP_Hook->apply_filters, shoptimizer_get_sidebar, get_sidebar, locate_template, load_template, require_once('/themes/shoptimizer/sidebar.php'), dynamic_sidebar, WP_Widget->display_callback, WOOF_Widget->widget, do_shortcode, preg_replace_callback, do_shortcode_tag, WOOF->woof_shortcode, WOOF->render_html, include('/plugins/woocommerce-products-filter/views/woof.php'), woof_print_item_by_key, do_action('woof_print_html_type_by_onsales'), WP_Hook->do_action, WP_Hook->apply_filters, WOOF_EXT->print_html_type, WOOF->render_html_e, include('/plugins/woocommerce-products-filter/ext/by_onsales/views/woof.php'), WOOF->dynamic_count, apply_filters('woof_dynamic_count_attr'), WP_Hook->apply_filters, WOOF_EXT_BY_TEXT->woof_dynamic_count_attr, WOOF_EXT_BY_TEXT->get_all_ids, WOOF_EXT_BY_TEXT->init_text_search, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
One more error when I use search on the site. Also referring to Woof
[14-Sep-2023 11:31:21 UTC] WordPress database error Column 'post_title' in where clause is ambiguous for query
SELECT wp_posts.ID
FROM wp_posts LEFT JOIN wp_postmeta sku_meta ON ( wp_posts.ID = sku_meta.post_id AND sku_meta.meta_key='_sku' ) LEFT JOIN wp_posts parents ON ( wp_posts.post_parent = parents.ID AND wp_posts.post_parent != '0' )
WHERE 1=1 AND wp_posts.post_type = 'product' AND ((wp_posts.post_status = 'publish')) AND (((post_title LIKE '%royal%')) AND ((post_title LIKE '%hydro%')) ) AND ( wp_posts.post_parent = '0' OR parents.post_status = 'publish' )
GROUP BY wp_posts.ID
ORDER BY wp_posts.post_date DESC
made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/plugins/woocommerce/templates/archive-product.php'), do_action('woocommerce_after_main_content'), WP_Hook->do_action, WP_Hook->apply_filters, shoptimizer_after_content, do_action('shoptimizer_sidebar'), WP_Hook->do_action, WP_Hook->apply_filters, shoptimizer_get_sidebar, get_sidebar, locate_template, load_template, require_once('/themes/shoptimizer/sidebar.php'), dynamic_sidebar, WP_Widget->display_callback, WOOF_Widget->widget, do_shortcode, preg_replace_callback, do_shortcode_tag, WOOF->woof_shortcode, WOOF->render_html, include('/plugins/woocommerce-products-filter/views/woof.php'), woof_print_item_by_key, do_action('woof_print_html_type_by_onsales'), WP_Hook->do_action, WP_Hook->apply_filters, WOOF_EXT->print_html_type, WOOF->render_html_e, include('/plugins/woocommerce-products-filter/ext/by_onsales/views/woof.php'), WOOF->dynamic_count, apply_filters('woof_dynamic_count_attr'), WP_Hook->apply_filters, WOOF_EXT_BY_TEXT->woof_dynamic_count_attr, WOOF_EXT_BY_TEXT->get_all_ids, WOOF_EXT_BY_TEXT->init_text_search, WP_Query->__construct, WP_Query->query, WP_Query->get_posts
Hello
What plugin version number are you using?
3.3.4.3
Please paste your license key here - https://share.pluginus.net/image/i20230222134241.png -> https://share.pluginus.net/image/i20230222134511.png and wp-admin access - https://share.pluginus.net/image/i20230222134615.png
Done
Hello
Try in file - \wp-content\plugins\woocommerce-products-filter\ext\by_text\index.php - add code - https://share.pluginus.net/image/i20230918124747.png
This is what the line should look like:
$sub_sql[] = $wpdb->prepare("({$wpdb->posts}.{$terms} $search_type %s)", $like);
and do a test
Hi Pablo,
I think it worked, , because the previous error log is not reported so far. But now it is two new errors :
[18-Sep-2023 11:07:15 UTC] WordPress database error Commands out of sync; you can't run this command now for query UPDATE `wp_options` SET `option_value` = '1697627235' WHERE `option_name` = '_transient_timeout_woocommerce_blocks_asset_api_script_data_ssl' made by shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Automattic\WooCommerce\Blocks\Assets\Api->update_script_data_cache, set_transient, update_option
[18-Sep-2023 11:09:24 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's fly'' at line 1 for query SELECT * FROM wp_commercekit_searches WHERE search_term = 'let's fly' made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, COMMERCEKIT_AJAX::do_commercekit_ajax, do_action('wp_ajax_commercekit_search_counts'), WP_Hook->do_action, WP_Hook->apply_filters, commercekit_ajax_search_counts
Thomas
Hello
These errors have nothing to do with my plugin
Ok good to know.What about the fix I manually changed related to your plugin? Will it be in next release?
Yes it will be included in the new version of the plugin