Database Error

Hi, I have database error in logs, I disabled ATUM Multi-Inventory but the error is still found, so the problem is from ATUM Inventory (core). Thanks in advance for your assistance.

ATUM Multi-Inventory → 1.9.7

ATUM Inventory (core) → 1.9.50

WordPress database error Not unique table/alias: ‘www_term_relationships’ for query SELECT SQL_CALC_FOUND_ROWS www_posts.ID
FROM www_posts LEFT JOIN www_term_relationships ON (www_posts.ID = www_term_relationships.object_id) LEFT JOIN www_term_relationships ON (www_posts.ID = www_term_relationships.object_id) LEFT JOIN www_term_relationships AS tt1 ON (www_posts.ID = tt1.object_id)
WHERE 1=1 AND (
www_term_relationships.term_taxonomy_id IN (370,556,557,660,668,694,710,911,950,951,953,954,955,965,967,968,969,970,972,976,980,981,982,985,990,991,992,995,997,999,1000,1002,1003,1004,1005,1007,1008,1009,1011,1012,1014,1015,1016,1018,1019,1021,1022,1023,1024,1027,1028,1030,1035,1036,1040,1041,1042,1043,1044,1045,1046,1047,1048,1049,1050,1051,1052,1054,1055,1056,1058,1060,1061,1062,1063,1064,1065,1066,1067,1068,1069,1070,1071,1072,1073,1074,1075,1076,1077,1078,1079,1080,1081,1082,1083,1084)
) AND ((www_posts.post_type = ‘product’ AND (www_posts.post_status = ‘publish’ OR www_posts.post_status = ‘wc-acqra-double-paid’ OR www_posts.post_status = ‘wc-cblost’ OR www_posts.post_status = ‘wc-paidreserve’ OR www_posts.post_status = ‘wc-returnfunded’ OR www_posts.post_status = ‘wc-cbacptd’ OR www_posts.post_status = ‘wc-productswap’ OR www_posts.post_status = ‘wc-funded’ OR www_posts.post_status = ‘wc-returnedorders’ OR www_posts.post_status = ‘wc-unresponsive’ OR www_posts.post_status = ‘wc-chinesedrop’ OR www_posts.post_status = ‘wc-importexport’ OR www_posts.post_status = ‘wc-chargebackinbound’ OR www_posts.post_status = ‘wc-pending-fraud’ OR www_posts.post_status = ‘wc-fraudrefunded’ OR www_posts.post_status = ‘wc-gs’ OR www_posts.post_status = ‘wc-storecreditcompl’ OR www_posts.post_status = ‘wc-presale’ OR www_posts.post_status = ‘wc-fraud’ OR www_posts.post_status = ‘wc-reship’ OR www_posts.post_status = ‘wc-oos’ OR www_posts.post_status = ‘wc-pending-support’ OR www_posts.post_status = ‘wc-updated-tracking’ OR www_posts.post_status = ‘wc-partial-shipped’))) AND ( ( www_posts.ID IN (
SELECT DISTINCT pr.post_parent FROM www_atum_inventories ati
INNER JOIN www_posts pr ON ati.product_id = pr.ID
INNER JOIN www_wc_product_meta_lookup pml ON (ati.product_id = pml.product_id AND ati.is_main = 1 AND pml.stock_status IN (‘instock’, ‘onbackorder’))
INNER JOIN www_atum_product_data apd ON ati.product_id = apd.product_id

     WHERE apd.multi_inventory = 1 AND pr.post_parent IS NOT NULL AND pr.post_parent > 0 ) OR www_posts.ID IN ( 
        SELECT DISTINCT pr.post_parent FROM www_atum_inventories ati
        INNER JOIN www_posts pr ON ati.product_id = pr.ID  
            INNER JOIN www_atum_inventory_meta atim ON (ati.ID = atim.inventory_id AND ati.is_main = 0 AND atim.stock_status IN ('instock', 'onbackorder'))
            INNER JOIN www_atum_product_data apd ON ati.product_id = apd.product_id

     WHERE apd.multi_inventory = 1 AND pr.post_parent IS NOT NULL AND pr.post_parent > 0 ) OR www_posts.ID IN ( SELECT DISTINCT ati.product_id FROM www_atum_inventories ati  
            INNER JOIN www_wc_product_meta_lookup pml ON (ati.product_id = pml.product_id AND ati.is_main = 1 AND pml.stock_status IN ('instock', 'onbackorder'))
            INNER JOIN www_atum_product_data apd ON ati.product_id = apd.product_id
         WHERE apd.multi_inventory = 1 ) OR www_posts.ID IN ( SELECT DISTINCT ati.product_id FROM www_atum_inventories ati  
            INNER JOIN www_atum_inventory_meta atim ON (ati.ID = atim.inventory_id AND ati.is_main = 0 AND atim.stock_status IN ('instock', 'onbackorder'))
            INNER JOIN www_atum_product_data apd ON ati.product_id = apd.product_id
         WHERE apd.multi_inventory = 1 ))  AND ( 

www_posts.ID NOT IN (
SELECT object_id
FROM www_term_relationships
WHERE term_taxonomy_id IN (7)
)
AND
www_term_relationships.term_taxonomy_id IN (205,226,344,521,565,600,724,928,942)
AND
tt1.term_taxonomy_id IN (205,226,344,521,565,600,724,928,942)

…

…

• This topic was modified 8 months ago by Word.