Quote from Beth on September 3, 2026, 15:25
Hello,
I am raising this ticket on behalf of one of our clients who is using your plugin on their WooCommerce site. Whenever they open the plugin to do a bulk idt, the request times out and shows a 504 server error. I took this to our hosting team to investigate, as we were wondering if this is a resource issue, and they asked me to bring this to you.
What appears to be happening is that when the plugin opens, it clogs up the database with the following:
Id: 6294
User: masons_db
Host: localhost
db: masons_wp
Command: Query
Time: 335
State: executing
Info: SELECT DISTINCT wp_users.ID,wp_users.display_name
FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) INNER JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id ) INNER JOIN wp_usermeta AS mt2 ON ( wp_users.ID = mt2.user_id ) INNER JOIN wp_usermeta AS mt3 ON ( wp_users.ID = mt3.user_id ) INNER JOIN wp_usermeta AS mt4 ON ( wp_users.ID = mt4.user_id ) INNER JOIN wp_usermeta AS mt5 ON ( wp_users.ID = mt5.user_id )
WHERE 1=1 AND (
wp_usermeta.meta_key = 'wp_iufsr:administrator'
OR
mt1.meta_key = 'wp_iufsr:editor'
OR
mt2.meta_key = 'wp_iufsr:author'
OR
mt3.meta_key = 'wp_iufsr:shop_manager'
OR
mt4.meta_key = 'wp_iufsr:wpseo_manager'
OR
mt5.meta_key = 'wp_iufsr:wpseo_editor'This is a reproduceable error by running 'show fullprocesslist\G' in mysql whilst the plugin is trying to open. Would you be able to help us with this? If you need any assistance, we can run whatever is required!
Thanks!
Hello,
I am raising this ticket on behalf of one of our clients who is using your plugin on their WooCommerce site. Whenever they open the plugin to do a bulk idt, the request times out and shows a 504 server error. I took this to our hosting team to investigate, as we were wondering if this is a resource issue, and they asked me to bring this to you.
What appears to be happening is that when the plugin opens, it clogs up the database with the following:
Id: 6294
User: masons_db
Host: localhost
db: masons_wp
Command: Query
Time: 335
State: executing
Info: SELECT DISTINCT wp_users.ID,wp_users.display_name
FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) INNER JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id ) INNER JOIN wp_usermeta AS mt2 ON ( wp_users.ID = mt2.user_id ) INNER JOIN wp_usermeta AS mt3 ON ( wp_users.ID = mt3.user_id ) INNER JOIN wp_usermeta AS mt4 ON ( wp_users.ID = mt4.user_id ) INNER JOIN wp_usermeta AS mt5 ON ( wp_users.ID = mt5.user_id )
WHERE 1=1 AND (
wp_usermeta.meta_key = 'wp_iufsr:administrator'
OR
mt1.meta_key = 'wp_iufsr:editor'
OR
mt2.meta_key = 'wp_iufsr:author'
OR
mt3.meta_key = 'wp_iufsr:shop_manager'
OR
mt4.meta_key = 'wp_iufsr:wpseo_manager'
OR
mt5.meta_key = 'wp_iufsr:wpseo_editor'This is a reproduceable error by running 'show fullprocesslist\G' in mysql whilst the plugin is trying to open. Would you be able to help us with this? If you need any assistance, we can run whatever is required!
Thanks!