Field List

[WWWD]

Per the following error, it looks like there is a column missing from "field List" but I cannot find the file. I have verified that the column does exist, it just looks like it is not pointing correctly.

[28-Jun-2015 21:11:55 EST5EDT] [client 64.7.70.206 ] PHP Fatal error: 1054:Unknown column 'm.manufacturers_name' in 'field list' :: SELECT DISTINCT p.products_image, m.manufacturers_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id,
p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1,
s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price,
p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping,
p.products_qty_box_status FROM cy6s_products p LEFT JOIN cy6s_specials s on p.products_id = s.products_id LEFT JOIN cy6s_products_description pd on p.products_id = pd.products_id JOIN cy6s_products_to_categories p2c on p.products_id = p2c.products_id WHERE p.products_status = 1
and pd.language_id = '1'

Where is this "Field List" found, developer tools hasn't helped.

[lruskauff]

Hi
Can you please post a link to y our website and answer some of the questions in the posting tips.
Thanks
Lin

[RodG]

Per the following error, it looks like there is a column missing from "field List" but I cannot find the file.

When did this problem start?

What addons have you installed (or tried to install) that would have coincided with the start of the problem?

What other info can you provide that may give us a clue?

I can't tell you much at the moment other than "field List" isn't to be found in any of the stock zencart code (V154).
Furthermore, a code search for where "p.products_image" is followed by "m.manufacturers_name" as part of a search query is nowhere to be found either.

Ergo, my conclusion is that you have an add-on module that is causing the error.

Cheers
RodG

[Design75]

field list is not part of the code.

this is the field list :

p.products_image, m.manufacturers_name, p.products_quantity, p.products_id, p.products_type, p.master_categories_id, 
p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, 
s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, 
p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, 
p.products_qty_box_status

these are the field that are used for the sql query, and one of those fields is missing. in your case m.manufacturers_name.

I saw another post of you in the dynamic attribute filter module, but also one where you said you removed the mod. Probably you didn't remove all of the edits you made.

[RodG]

field list is not part of the code.

Doh! Of course it isn't. I've NO idea what *I* was thinking.

Cheers
RodG

[WWWD]

I am running ZC 1.5.4

I loaded the Variable Filter add in and have since stripped out all of the installed pages and run the uninstall sql. It appears that there is something caught in the craw of the query generator and I have no clue how to clear it.

the URL is http://scholledresses.com selecting "categories" causes the error, everything else seems to be working.

[Ajeh]

If you use the Developer's Tool Kit and search for:
SELECT DISTINCT p.products_image, m.manufacturers_name, p.products_quantity,

Does anything come up for that select?

The problem with it is m.manufacturers_name cannot be pulled as that information is in the tables called but rather in the table manufacturers ...

[WWWD]

That string does not show up anywhere in developers' tools' search.

The interesting thing is that it is only when Category is called from the side bar or drop down. If it is called from All Items, it works just fine.

[WWWD]

I made .bak copies of every modified file before editing. I deleted the edited files and restored from the .bak files. I have not deleted the "new" files because all references to them should have been deleted when I ran the uninstal sql file; no?

[RodG]

I have not deleted the "new" files because all references to them should have been deleted when I ran the uninstal sql file; no?

No. not so. The uninstal.sql scripts only revert changes made to the database. It doesn't touch any 'new' files. The 'new' files need to be deleted manually. Leaving them in place could *cause* errors if they happen to be 1) automatically loaded by Zen-Cart, and 2) if they contain references to the tables/records that were removed when running the uninstall scripts.

For future reference, other can keeping the database 'tidy' there is never a need to undo/uninstall any changes made to the database by an install script. These changes, on their own, will *never cause or create a problem. The problem(s) only occur if you uninstall the SQL changes but neglect to take care of the related files.

Cheers
RodG

*never means except in extreme cases where code has been *very poorly* written and expects table records to have an explicit field count in a specific order (and no one has written code like that for years)