Fatal error: Uncaught Exception: Error: Got error '126 "Index is corrupted"' for '/tmp/#sql-temptable-a7f25-26df07-91c418.MAI'<br />Error No: 126<br />SELECT
p.product_id,
p.custom_value_1,
p.custom_value_2,
p.custom_value_3,
p.custom_value_4,
p.custom_value_5,
p.price,
p.price_w,
p.price_w_special,
p.price_w_special_date_start,
p.price_w_special_date_end,
p.price_r_special,
p.price_r_special_date_start,
p.price_r_special_date_end,
p.image,
p.tax_class_id,
p.date_added,
p.date_modified,
p.model,
p.mtrl,
p.minimum,
p.quantity,
p.unit_ratio,
pd.name,
pd.description,
pd.meta_title,
pd.custom_text_1,
pd.custom_text_2,
pd.custom_text_3,
pd.custom_text_4,
pd.custom_text_5,
pd.special_note,
pd.special_note_color,
md.name as manufacturer,
m.manufacturer_id,
m.image as manufacturer_image,
(
SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id
AND pd2.customer_group_id = '3'
AND pd2.quantity = '1'
AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW())
AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC
LIMIT 1
) AS discount,
(
SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id
AND ps.customer_group_id = '3'
AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW())
AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC
LIMIT 1
) AS special,
(
SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id
AND r1.status = '1'
GROUP BY r1.product_id
) AS rating
FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p2c.product_id = p.product_id) LEFT JOIN oc_category_path cp ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product_filter pf ON (p.product_id = pf.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN oc_manufacturer_description md ON (p.manufacturer_id = md.manufacturer_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '8627' GROUP BY p.product_id ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,12 in /home/crm6933/public_html/system/library/db/mysqli.php:49
Stack trace:
#0 /home/crm6933/public_html/system/library/db.php(45): DB\MySQLi->query('SELECT\n\t\t\tp.pro...')
#1 /home/crm6933/public_html/catalog/model/catalog/product.php(401): DB->query('SELECT\n\t\t\tp.pro...')
#2 /home/crm6933/storage/modification/system/engine/loader.php(289): ModelCatalogProduct->getProducts(Array)
#3 /home/crm6933/public_html/system/engine/proxy.php(47): Loader->{closure}(Array, Array)
#4 /home/crm6933/public_html/catalog/controller/product/product.php(968): Proxy->__call('getProducts', Array)
#5 /home/crm6933/storage/modification/system/engine/action.php(79): ControllerProductProduct->index()
#6 /home/crm6933/public_html/catalog/controller/startup/router.php(47): Action->execute(Object(Registry))
#7 /home/crm6933/storage/modification/system/engine/action.php(79): ControllerStartupRouter->index()
#8 /home/crm6933/public_html/system/engine/router.php(67): Action->execute(Object(Registry))
#9 /home/crm6933/public_html/system/engine/router.php(56): Router->execute(Object(Action))
#10 /home/crm6933/public_html/system/framework.php(187): Router->dispatch(Object(Action), Object(Action))
#11 /home/crm6933/public_html/system/startup.php(104): require_once('/home/crm6933/p...')
#12 /home/crm6933/public_html/index.php(20): start('catalog')
#13 {main}
thrown in /home/crm6933/public_html/system/library/db/mysqli.php on line 49