error involving query_factory.php and checkout_success

**rapidsci1** · 6 Feb 2007, 05:56 PM

I had a report of there being an error on the checkout_success page. I have not been able to recreate the problem but the user sent in a fax of the screen. Seems there is no value being passed in for the foreach on line 312 of query_factory.php. Any ideas as to what may be causing this and if it is perhaps just the session expiring and failing rather violently?

Thanks-

**Ajeh** · 6 Feb 2007, 05:58 PM

What version of Zen Cart are you running?

Clean install or an upgrade? If an upgrade from what version to what version?

What version php?

**rapidsci1** · 6 Feb 2007, 11:08 PM

Clean Install on 1.3.7
PHP Version 5.1.6

**crackedup** · 13 Feb 2007, 11:17 AM

Hello, Please can you help? I am building a website for a friend of mine at www.nwpcs.co.uk and all was well till last night, now I am getting this error

[FONT=Times New Roman]Warning: Variable passed to each() is not an array or object in /home/nwcomput/public_html/nwpcs/includes/classes/db/mysql/query_factory.php on line 114

Warning: session_start() [[/FONT][FONT=Times New Roman]function.session-start[/FONT][FONT=Times New Roman]]: Cannot send session cache limiter - headers already sent (output started at /home/nwcomput/public_html/nwpcs/includes/classes/db/mysql/query_factory.php:114) in /home/nwcomput/public_html/nwpcs/includes/functions/sessions.php on line 108

Warning: Cannot modify header information - headers already sent by (output started at /home/nwcomput/public_html/nwpcs/includes/classes/db/mysql/query_factory.php:114) in /home/nwcomput/public_html/nwpcs/includes/init_includes/init_templates.php on line 78[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]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 >=20070213 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS][/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]If anyone knows how to fix this it would be greatly appreciated..thanks[/FONT]

**Pixxi** · 14 Mar 2007, 04:37 PM

@crackedup:

Are you using database-caching?

If you are, try changing to file-based caching by editing your includes/configure.php and admin/includes/configure.php and changing:

PHP Code:


define('SQL_CACHE_METHOD', 'database');

to:

PHP Code:


define('SQL_CACHE_METHOD', 'file');

Then report back.

**beilana** · 15 Apr 2007, 12:52 AM

Thanks,

I Had This Exact Same Problem & It Was Fixed By This Suggestion. I Am Sure It Fixed It For The Other Guy As Well.

What It The Problem With The Cashe?