Can’t edit size chart

Hello Georgetheodorakis,

Thanks for reaching out to us and apologies for the inconvenience.

Can you please tell us that are you getting any errors while creating or editing the size chart?

Is this issue coming after any plugin or theme updates? If possible then share the error log here that helps us to review your query in detail.

If you have added any new plugins then deactivate them one by one to check that which plugin causing an issue.

Best Regards,
Hitendra & Dotstore Team

Hi,
I have the same problem, when doing an add, it opens extra slow and sometimes returns a 504 error. This is the query statement I see from the database when opening the database.

SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1  AND ( 
  ( wp_postmeta.meta_key = 'prod-chart' AND wp_postmeta.meta_value = '484298' ) 
  OR 
  ( mt1.meta_key = 'prod-chart' AND mt1.meta_value LIKE '%[484298,%' ) 
  OR 
  ( mt1.meta_key = 'prod-chart' AND mt1.meta_value LIKE '%,484298,%' ) 
  OR 
  ( mt1.meta_key = 'prod-chart' AND mt1.meta_value LIKE '%,484298]%' ) 
  OR 
  ( mt1.meta_key = 'prod-chart' AND mt1.meta_value LIKE '%[484298]%' )
) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'future' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending' OR wp_posts.post_status = 'private') GROUP BY wp_posts.ID ORDER BY wp_postmeta.meta_value DESC LIMIT 0, 10

I upgraded the plugin version to: 2.2.3 for this problem.

Hello Georgetheodorakis,

Thanks for sharing the details here.

Okay, there is no issue in the query as all have the same queries for that.

It might be a conflict issue or might some settings are not saved properly and causing an issue.

You can try with the default WooCommerce and size chart plugin if there is any conflict issue with the other plugins or you can switch the theme to default.

Best Regards,
Hitendra & Dotstore Team

You are right!
The plugin code use many ‘LIKE’ queries, so it cause the database crash.

And the SILLY support said their code is OK ??????

I have the same problem as you.