Fatal error: Uncaught Exception: Error: Table './db/tmp/#sql4aa7_12c1058_0' doesn't exist<br />Error No: 1146<br />WITH RECURSIVE category_path (category_id, title, name) AS
(
SELECT c1.category_id, cd.name AS title, cd.name AS name
FROM oc_category c1
INNER JOIN oc_category_description cd ON (cd.category_id = c1.category_id) AND cd.language_id = '1'
WHERE c1.parent_id = 0 and c1.status = 1
UNION ALL
SELECT c.category_id, cd2.name AS title, CONCAT(cp.name, '>', cd2.name)
FROM category_path AS cp
JOIN oc_category AS c ON cp.category_id = c.parent_id
JOIN oc_category_description cd2 ON (cd2.category_id = c.category_id) AND cd2.language_id = '1'
WHERE c.status = 1
)
SELECT
cp.name as path,
(
SELECT keyword
FROM oc_url_alias
WHERE QUERY = 'category_id=6') AS keyword,
cat.*,
cds.*
FROM category_path cp
INNER JOIN oc_category cat ON cat.category_id = cp.category_id
LEFT JOIN oc_category_description cds ON (cat.category_id = cds.category_id)
WHERE cp.category_id = 6 in /montagem/sdb1/d13782amia/public_html/system/database/mysqliclass.php:46
Stack trace:
#0 /montagem/sdb1/d13782amia/public_html/system/library/db.php(35): MySQLiClass->query('WITH RECURSIVE ...')
#1 /montagem/sdb1/d13782amia/public_html/catalog/model/catalog/category.php(35): DB->query('WITH RECURSIVE ...')
#2 /montagem/sdb1/d13782amia/public_html/catalog/controller/product/category.php(43): ModelCatalogCategory->getCategory('6')
#3 /montagem/sdb1/d13782amia/public_html/system/engine/front.php(42): ControllerProductCategory->index()
#4 /montagem/sdb1/d13782amia/public_html/system/engine/front.php(29): Front->execute(Object(Action))
#5 /montagem/sdb1/d13782amia/public_html/index.php(451): Front->dispatch(Object(Action), Object(Action))
#6 {main}
thrown in /montagem/sdb1/d13782amia/public_html/system/database/mysqliclass.php on line 46