Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2007
    Location
    AZ
    Posts
    1,911
    Plugin Contributions
    2

    Default PHP Fatal error: 1054:Unknown column 'pd.products_merkmale' in 'field list'

    Site is affiinityfictionpress.com
    Version1.5.5e
    Product Type Book is the only module added.

    When a product (either product_general or product_bookx ~ there is one of each type) is selected to add to cart a warning an error has occurred appears.

    The content of the error log file is:
    [19-Aug-2017 06:10:00 UTC] Request URI: /index.php?main_page=shopping_cart, IP address:
    #1 trigger_error() called at [/home/affinity/public_html/includes/classes/db/mysql/query_factory.php:154]
    #2 queryFactory->show_error() called at [/home/affinity/public_html/includes/classes/db/mysql/query_factory.php:127]
    #3 queryFactory->set_error() called at [/home/affinity/public_html/includes/classes/db/mysql/query_factory.php:252]
    #4 queryFactory->Execute() called at [/home/affinity/public_html/includes/classes/shopping_cart.php:1203]
    #5 shoppingCart->get_products() called at [/home/affinity/public_html/includes/modules/pages/shopping_cart/header_php.php:23]
    #6 require(/home/affinity/public_html/includes/modules/pages/shopping_cart/header_php.php) called at [/home/affinity/public_html/index.php:36]

    [19-Aug-2017 06:10:00 UTC] PHP Fatal error: 1054:Unknown column 'pd.products_merkmale' in 'field list' :: select p.products_id, p.master_categories_id, p.products_status, pd.products_name, pd.products_merkmale, p.products_model, p.products_image,
    p.products_price, p.products_weight, p.products_tax_class_id,
    p.products_quantity_order_min, p.products_quantity_order_units, p.products_quantity_order_max,
    p.product_is_free, p.products_priced_by_attribute,
    p.products_discount_type, p.products_discount_type_from, p.products_virtual, p.product_is_always_free_shipping
    from products p, products_description pd
    where p.products_id = '2'
    and pd.products_id = p.products_id
    and pd.language_id = '1' ==> (as called by) /home/affinity/public_html/includes/classes/shopping_cart.php on line 1203 <== in /home/affinity/public_html/includes/classes/db/mysql/query_factory.php on line 154

    I am not sure what to look for in or add to in the database.

    Thanks in advance for the help!

    Tina

  2. #2
    Join Date
    Mar 2007
    Location
    AZ
    Posts
    1,911
    Plugin Contributions
    2

    Default Re: Add to cart breaks site

    OMGosh!

    The shopping_cart.php from the product type book mod was flawed (?).
    I merged the stock file with the mod and all is ok now.

    Sorry - I should have checked this first.

 

 

Similar Threads

  1. v155 Fatal error: 1054:Unknown column 'status' in 'field list'
    By theenglandstore in forum PayPal Express Checkout support
    Replies: 7
    Last Post: 5 Aug 2017, 09:09 PM
  2. v151 Error 1054 Unknown column 'countries_active' in 'field list'
    By alhakeem2001 in forum General Questions
    Replies: 3
    Last Post: 10 Feb 2013, 07:55 PM
  3. v151 Fatal error: 1054:Unknown column 'gzpost' in 'field list'
    By dellaenterprises in forum Upgrading to 1.5.x
    Replies: 11
    Last Post: 22 Jan 2013, 12:29 AM
  4. Error 1054 Unknown column 'products_length' in 'field list'
    By exdealsad in forum All Other Contributions/Addons
    Replies: 6
    Last Post: 3 Nov 2010, 06:42 PM
  5. ERROR 1054 Unknown column 'zen_order_id' in 'field list'
    By paperthreads in forum PayPal Express Checkout support
    Replies: 6
    Last Post: 16 Feb 2010, 04:03 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR