Pending Alerts not seen on Live Site – Cloudflare?

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

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 4 years, 8 months ago by Frank.

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 4 years, 8 months ago by Frank.

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

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

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

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 ??

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.

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 4 years, 8 months ago by KoolPal.

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.

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!

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