Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2012
    Posts
    2
    Plugin Contributions
    0

    Default Help with error when inserting/updating custom product

    I've created a custom product type ("products_extra") with its own database table with extra fields but I'm getting a weird error in my logs whenever I try to insert or update one of these products.

    I'm not sure where to look in the code to fix it. Does anyone know what the error below means?

    PHP Fatal error: 1054:Unknown column 'products_extra' in 'field list' :: insert into products_extra (products_extra, products_id) values ('', '1') in [...]query_factory.php on line 101

    Your help is really appreciated. Thank you.

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Help with error when inserting/updating custom product

    The PHP error message is telling you that the field named "products_extra" does not exist in the table named "products_extra".

  3. #3
    Join Date
    Apr 2012
    Posts
    2
    Plugin Contributions
    0

    Default Re: Help with error when inserting/updating custom product

    Hi lat9 and thanks for your assistance,

    Do you know what would cause this error or where in the code to look (update_product.php or maybe collect_info.php ?) so I can fix it?

  4. #4
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,401
    Plugin Contributions
    87

    Default Re: Help with error when inserting/updating custom product

    Try your admin's tools->Developers Tool Kit. In the search phrase, type products_extra and search for that in all admin files. That will bring up a list of where the products_extra name is used and will point you to the PHP file that contains the errant call.

 

 

Similar Threads

  1. Replies: 34
    Last Post: 23 Mar 2016, 06:20 PM
  2. v139h error updating field in custom table
    By boxes in forum General Questions
    Replies: 2
    Last Post: 4 Oct 2012, 03:22 PM
  3. 403 Forbidden error when updating product
    By pinixdesign in forum Setting Up Categories, Products, Attributes
    Replies: 28
    Last Post: 27 Mar 2012, 05:10 AM
  4. Inserting custom DB query into product listing
    By twdhosting in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 30 Jun 2008, 08:20 AM
  5. Error when inserting product to new categories
    By yellowdaises in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 28 Nov 2006, 06:38 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