Site crash with express enabled

[wccomp]

Whenever I enable the paypal express my site goes down giving me the following at the top of the screen :

Warning: 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

and then under my header it shows this

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();

I'm running the latest patch by Dr. Byte and have no other issues with the site when express is turned off.

Any ideas are welcome.

thanks

[Kim]

This error sounds very similar to the one you had with IH2 - sounds like you have some other underlying problems ...

[wccomp]

Kim

I agree they are too simiular to not be related somewhere but I dont have a clue where to start to look. I haven't added or changed anything, with the exception of IH2 blowing up on me for no reason.

How should I start to troubleshoot this? My sql knowledge is limited to say the least.

[Kim]

What are your server specs? Php version, MYSQL version etc.

[wccomp]

PHP Version is 4.4.6
MySQL 4.1.21
Server OS: Linux 2.6.9-55.EL

This is the info from Version in admin will that work for what we need?

Thanks

[DrByte]

Is this v1.3.7 or v1.3.7.1 ?
What patches have you installed?
What contribs are installed?

[wccomp]

1.3.7, as for contribs I have IH2, ask a question, captcha, google checkout, improved who's online, rma, testimonial manager and user tracking.

I have your patch for PPE and I have the Patch for USPS.

[wccomp]

I also have the admin security patch installed.

Thanks

[DrByte]

The fix is posted here:
http://www.zen-cart.com/forum/showthread.php?t=56436

(Fresh v1.3.7.1 installs already contain this fix. Upgrades do not - they will be handled with the v1.3.8 upgrade instead.)

[wccomp]

Just want to tell Kim and Dr. Byte thank you very much for the help.



Thanks again