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.
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".
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?
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.