Keep Getting Variable passed to each... Warning message

**Stenrique** · 31 Mar 2007, 09:26 PM

I installed a brand new copy of zc137 onto my PC using XAMPP and installed all the mods. used in my live store. Everything went well until I imported a back-up database copy from my live store to the new zc137 copy locally. I keep encountering the following warning message:

Warning: Variable passed to each() is not an array or object in /home/.../includes/classes/db/mysql/query_factory.php on line 114

I have tried

database upgrade,
importing database tables w/o those from mods.,
installing zc136 onto a new sub-folder then import a database backup to the new zc136,
etc. etc.

but still the warning persist. Is there anyway to resolve this issue? I have spent 3 weeks to upgrade and now it seems like those time are wasted

. I have searched the forum but got no answer. Any advice is greatly appreciated. TIA.

**DrByte** · 1 Apr 2007, 06:42 AM

It's happening in one of the many database queries. The error message does not tell "which" one. This technically should never happen, but, apparently it does ... presumably because something's got it confused about the data it's seeing (or not seeing).

A methodical, step-by-step process will be required to narrow it down. Perhaps importing only one table at a time (or groups of related tables), or adding manual debug code to any of zillions of places in your store ... etc.

Perhaps a place to start is:
1. What version are you upgrading "from" ?
2. What addons have you installed on the old cart? Which addons on the "new" cart? Which ones did you intentionally "not" install on the new one?
3. "where" on the page is this occurring? Can you share a screen-shot, and perhaps paste the View Source data from the browser?

**Stenrique** · 1 Apr 2007, 02:17 PM

Thank you very much for your help DrByte.

1. What version are you upgrading "from" ?

I am upgrading from 1.3.6 to 1.3.7

2. What addons have you installed on the old cart? Which addons on the "new" cart? Which ones did you intentionally "not" install on the new one?

The following are mods that I have installed in both zc v1.3.6 and zc v1.3.7:
IH2,
Encrypted Master Password,
Improved Attributes Controller,
Sales Report,
User Tracking,
MZMT,
About Us Page,
Ask A Question,
BetterCategoriesEzInfo,
CAPTCHA Anti-Robot Registration,
Simple Google Analytics,
Stock by Attributes,
Zen Lightbox,
Scrolling Specials Sidebox,
Scrolling Whats New Sidebox,
Future Zen,
Drop Down Date of Birth Support,
Cross-Sell Advanced

These mods. are only in zc v1.3.6
Alternative Header,
Ausbank

New mod. in zc v1.3.7:
CSS Horizontal Drop Down Menu

3. "where" on the page is this occurring? Can you share a screen-shot, and perhaps paste the View Source data from the browser?

These warning messages always appear at the top of the web page. Also, their occurrences are rather unpredictably, sometimes right at the homepage, at times when I click on a category or products. I've attached 2 screenshots and the source data. Hope they can help in pinpointing the "culprit".