Three seperate mods, one common error

[strelitzia]

I've got an issue with my site that i originally thought was related to a module i tried to install. But i now think it is related to the existing cart and not the modules i wanted to add as all three modules give exactly the same error messages.
The modules in question are testimonials manager, faq manager and big royal mail.
The error produced is:

Warning: Variable passed to each() is not an array or object in /home/******/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/******/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/******/public_html/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/******/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/******/public_html/includes/init_includes/init_templates.php on line 78

And this appears below the header:

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 7
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from products p, 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 >=20071110 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

In view of the fact that an identical error is created by the three seperate modules i can't see that it is the mod at fault.

The server details are:

PHP Version: 4.4.7 (Zend: 1.3.0)
Database: MySQL 4.1.22-standard

I'm running zen version 1.3.7 with db patch level 1.3.7

Has anyone got any ideas what needs to be done to fix this issue?

Regards
Steve

[DrByte]

See the fix I posted here:http://www.zen-cart.com/forum/showthread.php?t=56436