- This topic has 2 replies, 3 voices, and was last updated 7 years, 7 months ago by .
Viewing 3 posts - 1 through 3 (of 3 total)
Viewing 3 posts - 1 through 3 (of 3 total)
- You must be logged in to reply to this topic.
Support site for Tips and Tricks HQ premium products
by
Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Troubleshooting › eStore – mysql errors – UPDATE SET available_copies
I’m getting a ton of these errors in my error_log. Not sure if it’s really affecting anything other than the logs grow rather large and will over time.
[27-Mar-2017 20:13:14 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 ‘SET available_copies = ”, sales_count = ‘1’ WHERE id=’5” at line 1 for query UPDATE SET available_copies = ”, sales_count = ‘1’ WHERE id=’5′ made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/Avada/page.php’), the_content, apply_filters(‘the_content’), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, FusionSC_Container->render, do_shortcode, preg_replace_callback, do_shortcode_tag, fusion_builder_row, do_shortcode, preg_replace_callback, do_shortcode_tag, FusionSC_Column->render, do_shortcode, preg_replace_callback, do_shortcode_tag, FusionSC_Modal->render, do_shortcode, preg_replace_callback, do_shortcode_tag, FusionSC_FusionText->render, apply_filters(‘fusion_text_content’), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, eStore_download_with_credits_button, eStore_show_download_with_credits_button, eStore_buy_with_credits_handler, eStore_deliver_download
I noticed the date stamp of that error is March 27th. Have there been any more recent errors? That date stamp seems to correspond with the time of your last support thread.
https://support.tipsandtricks-hq.com/forums/topic/estore-credits-shared-among-multiple-users
I have sent you a new copy of the credit token addon. That should address the issue. Let me know if you still see the error showing up after you update that addon.