1054 Unknown column 'p.products_id' in 'on clause'

[tharrison]

Our ISP upgraded their MySQL server over the weekend and now I get this error anytime we try to view a product page or sub-category page:

1054 Unknown column 'p.products_id' in 'on clause'

Our ISP is telling us our script code is looking for a table called "p" and there is no such table in the database. Duh!. However, the "p.products_id" call is all through out the code in some 600+ files.

Please Help!

[Ajeh]

See if this post in the Wiki helps you out ...

http://www.zen-cart.com/wiki/index.p...27on_clause.27

[tharrison]

You are correct!...Many Thanks!

[tharrison]

Same error, new column: After importing attributes and options tables:
--------------------------------------------------------------------------------------------
1054 Unknown column 'popt.products_options_rows' in 'field list'
in:
[select distinct popt.products_options_id, popt.products_options_name, popt.products_options_sort_order, popt.products_options_type, popt.products_options_length, popt.products_options_comment, popt.products_options_size, popt.products_options_images_per_row, popt.products_options_images_style, popt.products_options_rows from products_options popt, products_attributes patrib where patrib.products_id='250' and patrib.options_id = popt.products_options_id and popt.language_id = '1' order by LPAD(popt.products_options_sort_order,11,"0")]
--------------------------------------------------------------------------------------------

My Process:

1. New Install Zencart v1.3.7
2. Import customers, customers_info db, test.
3. Import orders, orders_products, orders_status, order_status_history and
order_total db, test.
4. Import products and products_description db, test.
5. Import any products attributes or options tables, get error msg.
6. Empty all product attribute or option tables, no error msg.

I've compared all table from the old MySQL 4 db with the newly install db on MySQL 5 and they are identical.

I'm stumped! Time for a drink!

[DrByte]

What version was your Zen Cart site using before the upgrade ?

Unknown column 'popt.products_options_rows'

Does the 'products_options_rows' field exist in the products_options table ?

[tharrison]

What version was your Zen Cart site using before the upgrade ?


Does the 'products_options_rows' field exist in the products_options table ?

Version 1.2.5

[tharrison]

Both db have "products_options_row".

[DrByte]

What exact procedure did you follow for upgrading your Zen Cart files/database from v1.2.5 to v1.3.7 ?

[DrByte]

Unknown column 'popt.products_options_rows'

Both db have "products_options_row".

If both databases have the field, but the database engine is telling you it cannot find the field ... then you must have it pointed to the wrong database.

Are your database settings in your configure.php pointed to the right database, server, username, password? Do they have the correct db table-prefix set?

[tharrison]

If both databases have the field, but the database engine is telling you it cannot find the field ... then you must have it pointed to the wrong database.

Are your database settings in your configure.php pointed to the right database, server, username, password? Do they have the correct db table-prefix set?

The problem was the field name: 'products_option_rows' The ending "s" in the field name was not on either table. I changed both. Imported each attribute and options tables one at a time and it is now working just fine. All attributes and options are functional and no more error.

Tip of the day:
Pay attention to the details!