Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

eStore – mysql errors – UPDATE SET available_copies

by

Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › WP eStore Troubleshooting › eStore – mysql errors – UPDATE SET available_copies

  • This topic has 2 replies, 3 voices, and was last updated 8 years, 1 month ago by admin.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • April 25, 2017 at 10:00 pm #14198
    trodak
    Member

    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

    April 25, 2017 at 10:18 pm #75536
    wzp
    Moderator

    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

    April 27, 2017 at 1:50 am #75537
    admin
    Keymaster

    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.

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Registration
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2025 | Tips and Tricks HQ