SQL Syntax Issues

  • Resolved garikaib

    (@garikaib)


    5 years, 3 months ago

    I am getting the following issue in my debug log on my test site.

    [11-Feb-2021 06:32:46 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 ” at line 1 for query select * from wp_webpushr_abandoned_cart where date_time < current_timestamp – INTERVAL hour made by do_action_ref_array(‘webpushr_abandoned_cart’), WP_Hook->do_action, WP_Hook->apply_filters, webpushr_send_abandoned_notification

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author webpushr

    (@webpushr)

    5 years, 3 months ago

    Hi @garikaib

    Thank you for using Webpushr. While our team investigates this further, can you please help us with the following:

    Please go to Webpushr Plugin’s Configuration Page. Inside “WooCommerce Settings”, please check the value for the following two:
    1- “Enable Abandoned Cart Notification”. Please tell us if it is checked or unchecked.
    2- The last setting of “Send Push Notification After”, does it show any value in hours, like 6 hours?

    Please check the “Enable Abandoned Cart Notification” setting on the top, and please enter a value in hours for “Send Push Notification After” and then SAVE this form please. Let us know if you still see this error after you’ve SAVED the form.

    Thread Starter garikaib

    (@garikaib)

    5 years, 3 months ago

    Thank you. I have checked and:
    1. Enable Abandoned Cart Notification is checked (enabled I think). I don’t remember doing this to be honest I only configured the plugin a while back when I installed it. I don’t think it had this option in it but I am not sure.
    2. There is just Only After the time value box is empty. Again I feel like I am seeing these settings for the first time in my life.

    I have chosen to disable the option and the error is no longer showing in the logs. I strongly suspect one of the updates came with these options but did not have usable default values. I didn’t notice the changes and hence never made changes to the options.

    Plugin Author webpushr

    (@webpushr)

    5 years, 3 months ago

    Hi @garikaib

    You are spot on! One of our updates introduced this feature but the default values were not present that could be used.

    Thank you for letting us know of this.

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

The topic ‘SQL Syntax Issues’ is closed to new replies.