Support » Plugin: In Stock Mailer for WooCommerce » Pending Alerts not seen on Live Site – Cloudflare?

  • Resolved KoolPal

    (@koolpal)


    Hi,

    After successfully testing this plugin on local dev, I installed on my LIVE Site.

    Everything works up to customer being able to submit email address and seeing the signed up text

    BUT

    In Admin, I cannot see any entries in Pending Alerts section

    My LIVE site is using Cloudflare. Would it cause some issues?

    How can I debug this?

    Please guide.

    Thanks.

Viewing 14 replies - 1 through 14 (of 14 total)
  • KoolPal

    (@koolpal)

    OK. I made some headway!

    I dug deeper and found that some tables are NOT getting created on my LIVE website

    On localhost, I have the below tables for this plugin:

    On my Live website, I can see only 1 table for this plugin

    I will need some help to fix this.

    Thanks

    Plugin Author Frank

    (@frankspress)

    Hi,
    It could be many reasons, it’s unrelated to this plugin or Cloudflare.
    It’s likely a problem with file permission on your server. If WordPress can’t write to database or execute a particular file you can run into these type of issues.
    Are you running Linux if yes which distro/version?
    What permission / file ownership have you set up for WordPress?
    Have you installed WordPress yourself or it’s a shared host image?

    • This reply was modified 6 months ago by Frank.
    Plugin Author Frank

    (@frankspress)

    ism_out_of_stock_request
    ism_sent_email

    are the only two db table generated by the plugin, wp_instock_email_alert is from another plugin.
    Please look into file permissions the tables are not being created.
    Also, what’s you MySQL version?

    • This reply was modified 6 months ago by Frank.
    KoolPal

    (@koolpal)

    Hi,

    Let me try to give you as much info as possible

    Itโ€™s likely a problem with file permission on your server. If WordPress canโ€™t write to database or execute a particular file you can run into these type of issues.
    AND
    What permission / file ownership have you set up for WordPress?

    From Site Health Info:

    Are you running Linux if yes which distro/version?

    From Site Health Info:

    Have you installed WordPress yourself or itโ€™s a shared host image?

    I have installed this using Softaculous Apps Installer

    are the only two db table generated by the plugin, wp_instock_email_alert is from another plugin.

    You are right. wp_instock_email_alert appears to be from one of the numerous plugins I tested on localhost ๐Ÿ™

    Also, whatโ€™s you MySQL version?

    From Site Health Info:

    Please let me know in case you would require any other info.

    Thanks

    Plugin Author Frank

    (@frankspress)

    Can you please confirm 100% that ism_out_of_stock_request is not being created.
    Do you have access to the command line ?

    Plugin Author Frank

    (@frankspress)

    if you can read /var/log/mysql/error.log would be of great help

    KoolPal

    (@koolpal)

    OK! I found some entries in 2 error logs

    Error Log 1
    https://pastebin.com/raw/BcGeegRs

    Error Log 2
    https://pastebin.com/raw/niATUfBS

    I hope this helps you to guide me to resolve this ๐Ÿ™‚

    Plugin Author Frank

    (@frankspress)

    There is no error regarding creating the table. I only see select and insert errors. Try this first, uninstall, remove it and then download the plugin again and activate.

    KoolPal

    (@koolpal)

    OK.

    I deleted the error logs from both the files.
    I uninstalled and deleted the plugin.
    I saw that table ism_sent_email is also removed from the db
    I then installed the latest version from WP plugin repository
    As soon as I activated the plugin, I saw the below error in one of the error logs

    [25-Mar-2020 12:44:27 UTC] WordPress database error Table 'igetmkbs_wp475.wptg_ism_out_of_stock_request' doesn't exist for query  SELECT wptg_ism_out_of_stock_request.id, GROUP_CONCAT(wptg_ism_out_of_stock_request.id SEPARATOR '-*_' ) as ids,
                                       GROUP_CONCAT( wptg_ism_out_of_stock_request.product_id SEPARATOR '-*_' ) as product_id ,
                                       GROUP_CONCAT( wptg_posts.post_title SEPARATOR '-*_' ) as product_name,
                                       wptg_ism_out_of_stock_request.email, wptg_users.ID as user_ID, wptg_users.display_name as user_name FROM wptg_ism_out_of_stock_request
                                 INNER JOIN wptg_posts ON ( wptg_posts.ID = wptg_ism_out_of_stock_request.product_id )
                                 INNER JOIN wptg_postmeta ON (wptg_ism_out_of_stock_request.product_id = wptg_postmeta.post_id)
                                 LEFT JOIN wptg_users ON (wptg_ism_out_of_stock_request.email = wptg_users.user_email)
                                 WHERE ( wptg_posts.post_type = 'product' OR wptg_posts.post_type = 'product_variation' ) AND
                                       wptg_postmeta.meta_value = 'instock' AND
                                       wptg_ism_out_of_stock_request.sent_id IS NULL
                                 GROUP BY wptg_ism_out_of_stock_request.email  made by do_action_ref_array('in_stock_email_event'), WP_Hook->do_action, WP_Hook->apply_filters, inStockManager::emailRequestsAsync, inStockManager::get_email_list_to_email

    I also noticed that my old settings were restored. Where are these stored? Perhaps everything is not removed when I deleted the plugin and something leftover is causing this issue?

    Please let me know

    • This reply was modified 6 months ago by KoolPal.
    Plugin Author Frank

    (@frankspress)

    Yeah tables are removed to delete data you might have about a customer, plugin options are not because they are not sensitive information, and you don’t have to reconfigure it if you deactivate it.
    Ok, let me remove quotes and fix character set, this may fix the issue.

    Plugin Author Frank

    (@frankspress)

    Please try the fix and let me know. Remember to deactivate and reactivate
    Frank.

    Hi Frank

    Success ๐Ÿ™‚

    Please try the fix and let me know.

    This worked as expected. I can see the requests now!

    Plugin Author Frank

    (@frankspress)

    Hi,
    Thanks for bring it up I’m glad it worked.
    I believe it was the escaping issue that can cause problems on some installations but also the charset. Is your install in a language other than English?

    ๐Ÿ™‚ Thank YOU!

    Is your install in a language other than English?

    No. It’s English

Viewing 14 replies - 1 through 14 (of 14 total)
  • You must be logged in to reply to this topic.