Md Anisur Rahman

That youtube URL is from the plugin shortcut –

[video_lightbox_youtube video_id=”fozyDIqYDpQ” width=”640″ height=”480″ anchor=”https://www.glotolo.com/wp-content/uploads//2017/10/stock-market-trading-PRKKJK2d.jpg” alt=”text that describes this image”]

yeah, that actually what i need. Thank you very much ??

okay got one thing, allowing those roles to “manage_woocommerce” capability provide them access to wp-admin, but on the other site it doesn’t require that, any idea??

Okay, i have disabled all plugin except WooCommerce, then installed WP Optimize and deleted all of my Transient options from database using WP Optimize. After that i have visited my site deleting all cache and cookies and after one visit to front-end and login on back-end i now see there are 27 transient options in my database, shown by WP Optimize to be removed. Now, what might be the cause for this??

Okay, i asked on my hosting support, they replied like this:-

“The reason for the problem is the large amount of queries your WordPress application executes to the database name database. The root cause of the problem is that your wp_options table has more than 137 000 _transient_ rows.
Apparently your are using a plugin that caches information in the database and this extensive usage leads to timeouts.
You should revise the active plugins and reconsider using the one that causes the issue.
I have checked this further and it appears that the database rows are created by the Woocommerce plugin. I have tried the build in options for clearing the Expired Transients and sessions, but that did not make any difference. As the plugin is vital for your website, I can only suggest you to contact the plugin developers and ask them for assistance or support regarding this matter.”