Page 1 of 3 123 LastLast
Results 1 to 10 of 26
  1. #1
    Join Date
    Sep 2006
    Posts
    280
    Plugin Contributions
    2

    Default 1054 Unknown column 'p.product_price_w' in 'field list'

    i received this error:
    1054 Unknown column 'p.product_price_w' in 'field list'
    in:
    [select p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.product_price_w, p.products_virtual, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_qty_box_status, p.products_quantity_order_max, p.products_sort_order from products p, products_description pd where p.products_id = pd.products_id and p.products_id = '932']
    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.
    It only seems to affect the product preview in the admin section of the cart and - my guess - it is related to the wholesale mod.
    I asked before but haven't got any reply

  2. #2
    Join Date
    Aug 2005
    Posts
    26,512
    Plugin Contributions
    9

    Default Re: have issue w/DB

    What ZenCart Version?

    What are your server specs?
    php version especially
    Zen-Venom Get Bitten
    Get Your Business Found

  3. #3
    Join Date
    Jan 2004
    Posts
    60,536
    Blog Entries
    4
    Plugin Contributions
    145

    Default Re: 1054 Unknown column 'p.product_price_w' in 'field list'

    Yes, it's part of an addon.
    You've evidently got the PHP part of the addon on your site, but you don't have the SQL changes applied to your site.
    .

    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.



  4. #4
    Join Date
    Sep 2006
    Posts
    280
    Plugin Contributions
    2

    Default Re: have issue w/DB

    Quote Originally Posted by kobra View Post
    What ZenCart Version?

    What are your server specs?
    php version especially
    PHP version 5.2.15
    MySQL Disk Space 21.87 MB
    MySQL version 5.0.91-community
    Apache version 2.2.17
    Perl version 5.8.8

    I also ran the sql again but the statements where ignored for reason of "tables already exist"

  5. #5
    Join Date
    Aug 2005
    Posts
    26,512
    Plugin Contributions
    9

    Default Re: 1054 Unknown column 'p.product_price_w' in 'field list'

    Please refer to DrByte's post
    Zen-Venom Get Bitten
    Get Your Business Found

  6. #6
    Join Date
    Sep 2006
    Posts
    280
    Plugin Contributions
    2

    Default Re: 1054 Unknown column 'p.product_price_w' in 'field list'

    i ran the sql again and it says statements ignored tables already exist
    zencart version 1.3.9h

  7. #7
    Join Date
    Jan 2004
    Posts
    60,536
    Blog Entries
    4
    Plugin Contributions
    145

    Default Re: 1054 Unknown column 'p.product_price_w' in 'field list'

    Are you sure it's talking about the correct tables?
    .

    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.



  8. #8
    Join Date
    Aug 2005
    Posts
    26,512
    Plugin Contributions
    9

    Default Re: 1054 Unknown column 'p.product_price_w' in 'field list'

    i ran the sql again and it says statements ignored tables already exist
    Most add on SQL is configured for a standard table - \
    One with NO prefix

    Do your other ZenCart tables have a prefix?
    Zen-Venom Get Bitten
    Get Your Business Found

  9. #9
    Join Date
    Jan 2004
    Posts
    60,536
    Blog Entries
    4
    Plugin Contributions
    145

    Default Re: 1054 Unknown column 'p.product_price_w' in 'field list'

    judging from the error message content, I was guessing they don't
    .

    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.



  10. #10
    Join Date
    Sep 2006
    Posts
    280
    Plugin Contributions
    2

    Default Re: 1054 Unknown column 'p.product_price_w' in 'field list'

    nope. no pre-fix

 

 
Page 1 of 3 123 LastLast

Similar Threads

  1. 1054 Unknown column 'p.products_condition' in 'field list'
    By rxalex in forum General Questions
    Replies: 2
    Last Post: 29 Jun 2010, 03:41 PM
  2. 1054 Unknown column 'products_cost' in 'field list'
    By wowemall in forum General Questions
    Replies: 2
    Last Post: 29 Mar 2008, 07:07 AM
  3. 1054 Unknown column 'startdate' in 'field list'
    By uncletadd in forum General Questions
    Replies: 6
    Last Post: 11 Oct 2007, 05:41 PM
  4. 1054 Unknown column 'pov.products_options_values_quantity' in 'field list'
    By romy in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 23 May 2007, 08:38 AM

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
  •