DB error

  • Resolved Sam

    (@sammazza)


    10 years, 8 months ago

    some pluging… (unknown which) has caused this error. I have no idea how to track the plugin or the cause of the error. Any help would be apprecaited.

    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 ” at line 4 for query SELECT MAX(id)
    FROM rbq_sr_woo_abandoned_items
    WHERE user_id = 0
    AND product_id = made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), do_action(‘init’), call_user_func_array, WC_Form_Handler->update_cart_action, WC_Cart->set_quantity, do_action(‘woocommerce_before_cart_item_quantity_zero’), call_user_func_array, sr_abandoned_remove_cart_item
    [07-Mar-2014 06:24:13 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 ‘AND id IN ()’ at line 6 for query UPDATE rbq_sr_woo_abandoned_items
    SET product_abandoned = 1

    WHERE user_id = 0
    AND product_id =
    AND id IN () made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’)
    login wootester
    pswd testing

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

  • Have you installed woocommerce plugin? Try deactivating the plugin and let us know if it works. if that doesn’t work:

    deactivating all plugins (yes, all) to see if this resolves the problem. If this works, re-activate the plugins one by one until you find the problematic plugin(s). If you can’t get into your admin dashboard, try resetting the plugins folder by FTP or PhpMyAdmin (read “How to deactivate all plugins when you can’t log in to wp-admin” if you need help). Sometimes, an apparently inactive plugin can still cause problems.

    Thread Starter Sam

    (@sammazza)

    Yes, i have woocommerce. I contacted wootheme and they say, it is some other plugin (add on to woo) that is at fault. The issue is i don’t know how / what caused the error. I cant duplicate it. So disabling all plugin and test one at a time is of no use. The error only happened once.

    I tried looking at the file names mentioned but that did not give me a good lead. Any idea idea how how find who is responsible for woo-abandond-item?

    It might be from the plugin “Woocommerce Abandon Cart Pro”. Kindly have look on there if you have that plugin activated.

    Thread Starter Sam

    (@sammazza)

    I dont have that plugin installed. Not the pro version. Any other thoughts?

    Have you installed “Smart Reporter for WooCommerce and WP eCommerce” plugin? The table “sr_woo_abandoned_items” is installed by this plugin only. ??

    Thread Starter Sam

    (@sammazza)

    Yes. Thanks. I will contact them

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘DB error’ is closed to new replies.

Tags