New Zenner
- Join Date:
- Mar 2007
- Posts:
- 44
- Plugin Contributions:
- 0
HELP Web Site Error!!!!!
I am getting the following error. Any ideas?
Warning: Cannot modify header information - headers already sent by (output started at /home/admcompa/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/admcompa/public_html/includes/init_includes/init_templates.php on line 78
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUC' at line 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20071002 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]