Search for:
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 JOIN prd_product_search s ON t.product_slug=s.l3 AND country='IT' AND s.active=1 AND (s.is_hvac=0 OR (s.is_hvac=1 AND s.is_hvac_readable=1)) AND s.start_date<=NOW() AND (s.expire_date='0000-00-00' OR s.expire_date>NOW())
where h.fk_parent_id= AND s.l2='C_ROOM' and (s.expire_date='0000-00-00' OR s.expire_date>=NOW()) 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 JOIN prd_product_search s ON t.product_slug=s.l3 AND country='IT' AND s.active=1 AND (s.is_hvac=0 OR (s.is_hvac=1 AND s.is_hvac_readable=1)) AND s.start_date<=NOW() AND (s.expire_date='0000-00-00' OR s.expire_date>NOW())
where h.fk_parent_id= AND s.l2='C_ROOM' and (s.expire_date='0000-00-00' OR s.expire_date>=NOW()) 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 s.l2='C_ROOM' and (s.expire_date='0000-00-00' OR s.expire_date>=NOW()) and t' at line 3
- Date : November 23, 2024, 9:21 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: 209
- /export/http/eliwell_2017/theme/eliwell_c4.2/page/products2/prod_list.php: 3
- /export/http/eliwell_2017/theme/eliwell_c4.2/page/prod_v2.php: 183
- /export/http/eliwell_2017/theme/eliwell_c4.2/page/content.php: 47
- /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: 482
- /export/http/eliwell_2017/index.php: 17