Database ERROR!
Resultset failed for query SELECT h.id, t.translation, t.abstract, t.web_slug, h.level, h.image, h.sorting
from prd_product_hierarchy h JOIN prd_product_hierarchy_translation t ON t.product_slug=h.slug
where h.fk_parent_id= AND t.product_slug IN (select product_slug FROM pages where lang='en' AND isproduct='oem' AND active=1) and t.lang='en' GROUP BY t.web_slug ORDER BY h.sorting ASC.
More Information:
Resultset failed for query SELECT h.id, t.translation, t.abstract, t.web_slug, h.level, h.image, h.sorting
from prd_product_hierarchy h JOIN prd_product_hierarchy_translation t ON t.product_slug=h.slug
where h.fk_parent_id= AND t.product_slug IN (select product_slug FROM pages where lang='en' AND isproduct='oem' AND active=1) and t.lang='en' GROUP BY t.web_slug ORDER BY h.sorting ASC.
More Information:
- Mysql Error no #: 1064
- Mysql Error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t.product_slug IN (select product_slug FROM pages where lang='en' AND isprod' at line 3
- Date : April 6, 2025, 3:38 pm
- Stacktrace:
- /export/http/eliwell_2017/lib/database.class.php: 80
- /export/http/eliwell_2017/lib/database.class.php: 113
- /export/http/eliwell_2017/lib/product.class.php: 218
- /export/http/eliwell_2017/theme/eliwell_c4.2/page/products/prod_list.php: 3
- /export/http/eliwell_2017/theme/eliwell_c4.2/page/prod.php: 128
- /export/http/eliwell_2017/theme/eliwell_c4.2/page/content.php: 45
- /export/http/eliwell_2017/theme/eliwell_c4.2/page/content.php: 7
- /export/http/eliwell_2017/lib/content.class.php: 250
- /export/http/eliwell_2017/theme/eliwell_c4.2/index.php: 495
- /export/http/eliwell_2017/index.php: 17