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