Posting data error
Avatar image
Mar 12, 2020
Roland Seiringer wrote
This is the message I am getting. Could someone be of assistance.

1104; The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay
INSERT INTO wp_wc_product_meta_lookup (`product_id`, `sku`, `virtual`, `downloadable`, `min_price`, `max_price`, `onsale`, `stock_quantity`, `stock_status`, `rating_count`, `average_rating`, `total_sales`) SELECT T1.`ID` AS `product_id`,T2.`meta_value` AS `sku`,IF(T3.meta_value = 'yes', 1, 0) AS `virtual`,IF(T4.meta_value = 'yes', 1, 0) AS `downloadable`,IFNULL(MIN(T5.meta_value + 0), 0) AS `min_price`,IFNULL(MAX(T5.meta_value + 0), 0) AS `max_price`,IF((CAST(T5.meta_value AS DECIMAL) >= 0) AND (CAST(T6.meta_value AS CHAR) != '')AND (CAST(T5.meta_value AS DECIMAL(10,2)) = CAST(T6.meta_value AS DECIMAL(10,2))) ,1, 0) AS `onsale`,IF(T7.meta_value = 'yes', T8.meta_value, NULL) AS `stock_quantity`,T9.`meta_value` AS `stock_status`,0 AS `rating_count`,T10.`meta_value` AS `average_rating`,T11.`meta_value` AS `total_sales` FROM `wp_posts` AS T1 LEFT JOIN `wp_postmeta` AS T2 ON (T2.post_id = T1.ID) AND (T2.meta_key = '_sku') LEFT JOIN `wp_postmeta` AS T3 ON (T3.post_id = T1.ID) AND (T3.meta_key = '_virtual') LEFT JOIN `wp_postmeta` AS T4 ON (T4.post_id = T1.ID) AND (T4.meta_key = '_downloadable') LEFT JOIN `wp_postmeta` AS T5 ON (T5.post_id = T1.ID) AND (T5.meta_key = '_price') LEFT JOIN `wp_postmeta` AS T6 ON (T6.post_id = T1.ID) AND (T6.meta_key = '_sale_price') LEFT JOIN `wp_postmeta` AS T7 ON (T7.post_id = T1.ID) AND (T7.meta_key = '_manage_stock') LEFT JOIN `wp_postmeta` AS T8 ON (T8.post_id = T1.ID) AND (T8.meta_key = '_stock') LEFT JOIN `wp_postmeta` AS T9 ON (T9.post_id = T1.ID) AND (T9.meta_key = '_stock_status') LEFT JOIN `wp_postmeta` AS T10 ON (T10.post_id = T1.ID) AND (T10.meta_key = '_wc_average_rating') LEFT JOIN `wp_postmeta` AS T11 ON (T11.post_id = T1.ID) AND (T11.meta_key = 'total_sales') WHERE T1.ID IN (Null) GROUP BY T1.ID ;
Reply
1 Answer
Avatar image
Mar 13, 2020
Andrii Yanosh agent wrote
Hello Roland,



Thank you for contacting us.

We have replied to you in the ticket RLY-ZSQTQ-924



Please check it and reply to us there.

We are waiting to hear from you soon.

Wishing you a great weekend!