[duplicate] query_factory.php

[Kodam]

Hello,

Zencart fresh install : 1.3.5
upgrade : 1.3.5 > 1.3.6
upgrade : 1.3.5 > 1.3.7

Worked for months and now there is a problem

Here is the problem :

http://moeroshop.net/db-problem.jpg

I believe it's a bug because I didn't touch any setup of my shop nor items, nothing and it do this (more thant 1 hour now).

What is its problem ?

Line 114 query_factory.php :

while (list($key, $value) = each($zp_result_array[0])) {

thank you

[Ajeh]

Do a search in the Developer's Tool Kit on the first input box with nothing selected in the dropdown for:
EXPECTED_PRODUCTS_SORT
EXPECTED_PRODUCTS_FIELD
MAX_DISPLAY_UPCOMING_PRODUCTS

Does it locate all of these settings?

What are their values?

[Kodam]

Here is the results :

Key: EXPECTED_PRODUCTS_SORT
Title: Expected Sort Order
Description: This is the sort order used in the expected products box.
Value: desc
Group: ID#1 My Store

Key: EXPECTED_PRODUCTS_FIELD
Title: Expected Sort Field
Description: The column to sort by in the expected products box.
Value: date_expected
Group: ID#1 My Store

Key: MAX_DISPLAY_UPCOMING_PRODUCTS
Title: Upcoming Products
Description: Number of 'upcoming' products to display
Value: 10
Group: ID#3 Maximum Values

[Kodam]

It seems that the flat rate shipping option is causing this problem.
I deactivated it and it works.

[wilt]

Hi,

Can you post what sql cacheing method you are using. You can find the setting in your includes/configure.php file.

e.g.

define('SQL_CACHE_METHOD', 'database');

[Kodam]

Here my cacheing method :

define('SQL_CACHE_METHOD', 'database');

with further investigation dhl airborn module installed and put on false was causing trouble if another shipping method like flat rate or shipping by item is activated. I uninstalled this dhl and all back to normal.

[wilt]

Hi,

Can you post a link to where you got the DHL Airborne module from, as it is not a default ZC shipping method

I'm having trouble duplicating the problem, and trying to set up a site similar to yours, in hopes of reproducing the problem

[DrByte]

1. What is your PHP version?
2. And your MySQL version?
3. What is your PHP setting for Magic Quotes ? (ie: Admin->Tools->Server Info-> search the screen for "magic_quotes_runtime" ... on or off ?)

[DrByte]

This previously-reported bug appears to be the same issue, and the fix should resolve your problem too:
http://www.zen-cart.com/forum/showthread.php?t=56436