Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 26
  1. #11
    Join Date
    Sep 2006
    Posts
    277
    Plugin Contributions
    2

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

    so, what do i do now?

  2. #12
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

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

    What's the actual SQL you're trying to run?
    .

    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.

  3. #13
    Join Date
    Sep 2006
    Posts
    277
    Plugin Contributions
    2

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

    since i figured this error has to do with my dual pricing mod i ran this sql:
    ALTER TABLE `customers` ADD `customers_whole` VARCHAR( 4 ) DEFAULT '0' NOT NULL;
    ALTER TABLE `products` ADD `products_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `products_price`;
    ALTER TABLE `products_attributes` ADD `options_values_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `options_values_price`;
    ALTER TABLE `products_discount_quantity` ADD `discount_price_w` VARCHAR( 150 ) DEFAULT '0' AFTER `discount_price`;
    ALTER TABLE `customers` ADD `customers_wholesale` VARCHAR( 4 ) DEFAULT '0' NOT NULL AFTER `customers_whole`;

  4. #14
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

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

    Alright. What's confusing to me is you're saying that running that is giving you messages like "table already exists". But none of those statements are trying to create new tables. They're just adding new fields/columns. The error message should be different if that's the SQL you're running.
    .

    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.

  5. #15
    Join Date
    Sep 2006
    Posts
    277
    Plugin Contributions
    2

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

    ok. just to be sure. here is the EXACT result of running it again:
    Failed: 5
    ERROR: Cannot ADD column customers_whole because it already exists.
    ERROR: Cannot ADD column products_price_w because it already exists.
    ERROR: Cannot ADD column options_values_price_w because it already exists.
    ERROR: Cannot ADD column discount_price_w because it already exists.
    ERROR: Cannot ADD column customers_wholesale because it already exists.
    Note: 5 statements ignored. See "upgrade_exceptions" table for additional details.

  6. #16
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

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

    And you're still getting "1054 Unknown column 'p.product_price_w' in 'field list'" ???
    .

    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.

  7. #17
    Join Date
    Sep 2006
    Posts
    277
    Plugin Contributions
    2

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

    yes. still the same. i made a search in the code for that p. ...thingy and found quite a few instances. i thought i posted it but it seems the post is gone. and - oddly, the error is ONLY in the product preview in the admin section

  8. #18
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

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

    Your SQL added the field:
    products_price_w

    The error is referencing:
    p.product_price_w

    Notice one has an S in the field name and one does not ...

    You need to determine if the SQL is incorrect or the code calling it ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  9. #19
    Join Date
    Sep 2006
    Posts
    277
    Plugin Contributions
    2

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

    Quote Originally Posted by Ajeh View Post
    Your SQL added the field:
    products_price_w

    The error is referencing:
    p.product_price_w

    Notice one has an S in the field name and one does not ...

    You need to determine if the SQL is incorrect or the code calling it ...
    Let me do some more research and i'lll be back wit the results...

  10. #20
    Join Date
    Sep 2006
    Posts
    277
    Plugin Contributions
    2

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

    I searched for the "p.product_price_w" in the shop coding and found it in 5 php files and also found references to other tables or columns (i don't know which) that have this p. in front:
    $products_query = "select p.products_id, p.master_categories_id, p.products_status, pd.products_name, p.products_model, p.products_image,
    p.products_price, p.products_price_w, p.products_weight, p.products_tax_class_id,
    p.products_quantity_order_min, p.products_quantity_order_units,
    p.product_is_free, p.products_priced_by_attribute,
    p.products_discount_type, p.products_discount_type_from
    from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
    where p.products_id = '" . (int)$products_id . "'
    and pd.products_id = p.products_id
    and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";
    this example is from includes/classes/shopping_cart.php

 

 
Page 2 of 3 FirstFirst 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