1054 Unknown column 'pov.products_options_values_quantity' in 'field list'
Could anyone help me with Option Values
when I hit the option Values ..I get this:
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 cart1_products_options_values pov left join cart1_products_options_values_to_products_options pov2po on pov.products_options_values_id = pov2po.products_options_values_id left join cart1_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.
Re: 1054 Unknown column 'pov.products_options_values_quantity' in 'field list'
What version of Zen Cart are you using?
What version of MySQL?
What addons/contributions have you installed?
What exactly were you attempting to do when you encountered this message?
Re: 1054 Unknown column 'pov.products_options_values_quantity' in 'field list'
Hi
I'm really an osCommerce type guy so this may be wrong:
1054 in osCommerce often is a result of a 'left join' within the query and is down to the original code not working with SQL5.
Unfortunately the osC bug reports no longer seem to be accessible so I cannot point you to the solution there - basically you have to write a couple of sets of parenthesis into the code to properly isolate the left join.
Try
http://dev.mysql.com/doc/refman/5.0/en/join.html
Graeme
Re: 1054 Unknown column 'pov.products_options_values_quantity' in 'field list'
o.k when I hit version in my admin..this is what i get:
-Database: MySQL 4.1.11-Debian_4sarge7
-PHP Version 4.4.7
-Zen Cart 1.3.7 Database Patch Level: 1.3.7
I wanted to add color and sizes to my option pages
This is the site:http://www.pirateguild.biz/
Plus when I click any image in the New Products For May
No image shows ...what is all that about
Thanks for the help...