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
    3,339
    Plugin Contributions
    31

    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
    3,339
    Plugin Contributions
    31

    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. 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
  2. Download ABOUT US - Inserting Custom Page Into Sidebox
    By Centec2b in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 31 Jul 2008, 07:07 PM
  3. 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
  4. Error updating product details
    By lucky__starre in forum General Questions
    Replies: 10
    Last Post: 28 Nov 2007, 05:53 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
  •