1030 Got error 28 from storage engine
in:
[SELECT pd.products_name as product_name, p.products_price as price_before, OLD_GET_PRODUCT_FINAL_PRICE(701,p.products_id,1) as price, t.tax_coeff*OLD_GET_PRODUCT_FINAL_PRICE(701,p.products_id,1) as price_tax, IS_CUSTOMER_IN_PRICE_GROUP(701,p.products_id,1) as is_price_group, p.products_model as product_model, p.products_quantity as quantity, p.products_trade_status as availability, p.products_id as pid, p2c.categories_id as cid, pd.products_description as description, p.products_image as image, max(pgt.code) as group_code, m.name as manufacturer FROM _centropen_products_description pd left outer join products_groups pg on pg.products_id = pd.products_id left outer join products_groups pg_master on pg_master.master_product_id = pd.products_id AND pg_master.shops_id = "701" LEFT OUTER JOIN products_groups_types pgt on pgt.id = pg_master.types_id AND pgt.code = "var" INNER JOIN _centropen_products p on p.products_id = pd.products_id INNER JOIN _centropen_products_to_categories p2c on p2c.products_id = p.products_id INNER JOIN products cp on cp.id = p2c.products_id INNER JOIN taxes t on t.id = cp.tax_id LEFT OUTER JOIN manufacturers m ON m.id = cp.manufacturers_id LEFT OUTER JOIN products_keywords pk ON cp.id = pk.products_id WHERE p.products_status = 1 AND (pg.types_id is null or pg.types_id <> 2) AND p2c.categories_id = "215574" GROUP BY p.products_id ORDER BY p.products_quantity DESC,if(availability=0, 90000, availability) ASC LIMIT 0, 16]
1030 Got error 28 from storage engine
in:
[SELECT pd.products_name as product_name, p.products_price as price_before, OLD_GET_PRODUCT_FINAL_PRICE(701,p.products_id,1) as price, t.tax_coeff*OLD_GET_PRODUCT_FINAL_PRICE(701,p.products_id,1) as price_tax, IS_CUSTOMER_IN_PRICE_GROUP(701,p.products_id,1) as is_price_group, p.products_model as product_model, p.products_quantity as quantity, p.products_trade_status as availability, p.products_id as pid, p2c.categories_id as cid, pd.products_description as description, p.products_image as image, max(pgt.code) as group_code, m.name as manufacturer FROM _centropen_products_description pd left outer join products_groups pg on pg.products_id = pd.products_id left outer join products_groups pg_master on pg_master.master_product_id = pd.products_id AND pg_master.shops_id = "701" LEFT OUTER JOIN products_groups_types pgt on pgt.id = pg_master.types_id AND pgt.code = "var" INNER JOIN _centropen_products p on p.products_id = pd.products_id INNER JOIN _centropen_products_to_categories p2c on p2c.products_id = p.products_id INNER JOIN products cp on cp.id = p2c.products_id INNER JOIN taxes t on t.id = cp.tax_id LEFT OUTER JOIN manufacturers m ON m.id = cp.manufacturers_id LEFT OUTER JOIN products_keywords pk ON cp.id = pk.products_id WHERE p.products_status = 1 AND (pg.types_id is null or pg.types_id <> 2) AND p2c.categories_id = "215574" GROUP BY p.products_id ORDER BY p.products_quantity DESC,if(availability=0, 90000, availability) ASC LIMIT 0, 16]
Message body empty