I have tried to install the FAQ manager several times on my site but each time i get the following error messages.
These appear above the header:
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]
The server details are:
PHP Version: 4.4.7 (Zend: 1.3.0)
Database: MySQL 4.1.22-standard
However, if i install it on my local machine, running Apache2Triad, with an exact copy of my online site, it runs fine, with no errors at all.
Local server details are:
PHP Version: 4.4.3-dev (Zend: 1.3.0)
Database: MySQL 4.0.26-nt-log
Both the live site, and the local site are version 1.3.7.
Personally, i can think of no major differences between the two versions of PHP, or MySQL. Anybody got any ideas what might be the problem.
Thanks
Steve


Reply With Quote
