1054 Unknown column 'pov.products_options_values

21 May 2007, 9:08 AM

#1

New Zenner

Join Date:: May 2007
Location:: york, pa
Posts:: 98
Plugin Contributions:: 0

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.

22 May 2007, 6:24 AM

#2

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,511
Plugin Contributions:: 176

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?

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

22 May 2007, 10:54 AM

#3

sakwoya

New Zenner

Join Date:: Jan 2004
Posts:: 26
Plugin Contributions:: 2

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

23 May 2007, 7:38 AM

#4

romy

New Zenner

Join Date:: May 2007
Location:: york, pa
Posts:: 98
Plugin Contributions:: 0

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...