With attributes 1054 unknown column...

[ellivir]

I have installed the latest 1.3.6 and made database upgrade according to the guide lines. Upgrade went fine and all in the shop looked fine.
I didn't have in my old shop any products with attributes but I decided to put now.

As soon as I add some attributes, I get this error on product page:

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 kauppa136_products_options popt, kauppa136_products_attributes patrib where patrib.products_id='11' and patrib.options_id = popt.products_options_id and popt.language_id = '2' order by LPAD(popt.products_options_sort_order,11,"0")]

- - - -
In the product list (under the category) I get the product info visible and the picture too but when clicking the product to go to the individual product page it gets the above error in case there are some attributes linked to the product. If no attributes, all looks fine.

Elli

[Ajeh]

Are you sure you upgraded both the code and the database?

Are you sure that both the
/includes/configure.php
/admin/includes/configure.php

files on the server are looking at the same database?

[ellivir]

Are you sure you upgraded both the code and the database?

Are you sure that both the
/includes/configure.php
/admin/includes/configure.php

files on the server are looking at the same database?

Yes, it should be and those both configure files are pointing to the same database indeed.
I also looked with the zc_install folder again if it would say to me something is not upgraded and it tells me "No upgrade needed". So, I didn't proceed from that again either then. Evrything should have been done right already.

[Ajeh]

If you look in your database via phpMyAdmin ... how many tables do you have?

[ellivir]

If you look in your database via phpMyAdmin ... how many tables do you have?

If I calculated correctly I have 93 tables there.

[ellivir]

I made the database upgrade again despite the installer was saying "No upgrade needed" and I got the product page with attributes visible and the error message
"1054 Unknown column 'popt.products_options_rows' in 'field list' in:
[select distinct popt.products_options_id, popt.products_options_name, --- etc."
disappeared! :)

So, all seems fine now.

Elli

[Ajeh]

How very odd ...

That change was made in the upgrade from v1.2.7 to v1.3.0 ...

[vivaraquel]

Well, I have the latest version of zencart freshly installed and I thought I'd try setting up some attributes but I get that error after I enter an option name and I click on option value. I have not upgraded anything as this is my first install.

1054 Unknown column 'pov.products_options_values_quantity' in 'field list'
in:
[select pov.products_options_values_id, pov.products_options_values_name, pov.products_options_values_quantity, pov2po.products_options_id, pov.products_options_values_sort_order from products_options_values pov left join products_options_values_to_products_options pov2po on pov.products_options_values_id = pov2po.products_options_values_id left join products_options po on pov2po.products_options_id = po.products_options_id where pov.language_id = '1' and pov2po.products_options_values_id !='0' order by po.products_options_name, LPAD(pov.products_options_values_sort_order,11,'0'), pov.products_options_values_name]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

Thats the error.