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
    Location
    Arizona
    Posts
    27,835
    Plugin Contributions
    9

    Default Re: have issue w/DB

    What ZenCart Version?

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

  3. #3
    Join Date
    Jan 2004
    Posts
    63,371
    Blog Entries
    5
    Plugin Contributions
    181

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

  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
    Location
    Arizona
    Posts
    27,835
    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

  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
    63,371
    Blog Entries
    5
    Plugin Contributions
    181

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

  8. #8
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,835
    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

  9. #9
    Join Date
    Jan 2004
    Posts
    63,371
    Blog Entries
    5
    Plugin Contributions
    181

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

  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 'COWOA_order' in 'field list'
    By willieWontGo in forum PayPal Express Checkout support
    Replies: 9
    Last Post: 1 Jul 2011, 08:18 PM
  2. 1054 Unknown column 'p.products_carrot' in 'field list'
    By vivianso in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 23 Jun 2011, 05:25 PM
  3. 1054 Unknown column 'zen_order_id' in 'field list'
    By bunnyzoe in forum PayPal Website Payments Pro support
    Replies: 0
    Last Post: 6 Jun 2009, 08:18 PM
  4. 1054 Unknown column 'account_name' in 'field list'
    By jford in forum Built-in Shipping and Payment Modules
    Replies: 4
    Last Post: 22 Aug 2006, 11:24 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR