Whenever I enable the paypal express my site goes down giving me the following at the top of the screen :
and then under my header it shows thisWarning: Variable passed to each() is not an array or object in /home/wccomput/public_html/includes/classes/db/mysql/query_factory.php on line 114
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/wccomput/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/wccomput/public_html/includes/functions/sessions.php on line 108
Warning: Cannot modify header information - headers already sent by (output started at /home/wccomput/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/wccomput/public_html/includes/init_includes/init_templates.php on line 78
I'm running the latest patch by Dr. Byte and have no other issues with the site when express is turned off.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_PRODUCT' at line 9
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd, zen_products_to_categories p2c, zen_categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '14' and p.products_date_available >=20070715 and p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]
_popupControl();
Any ideas are welcome.
thanks




