Results 1 to 4 of 4
  1. #1
    Join Date
    May 2007
    Location
    york, pa
    Posts
    98
    Plugin Contributions
    0

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

  2. #2
    Join Date
    Jan 2004
    Posts
    60,302
    Blog Entries
    4
    Plugin Contributions
    51

    Default 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!
    Donations always welcome: www.zen-cart.com/donate

    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.



  3. #3
    Join Date
    Jan 2004
    Posts
    26
    Plugin Contributions
    1

    Default 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

  4. #4
    Join Date
    May 2007
    Location
    york, pa
    Posts
    98
    Plugin Contributions
    0

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

 

 

Similar Threads

  1. 1054 Unknown column 'ci.customers_info_id' in 'on clause'
    By alyxsmom in forum Managing Customers and Orders
    Replies: 1
    Last Post: 27 Jun 2006, 04:51 PM
  2. 1054 Unknown column 'products_id' in 'where clause'
    By Darkwander in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 15 Jun 2006, 10:59 PM
  3. Replies: 2
    Last Post: 13 Jun 2006, 06:34 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •