Can't copy products

[cruiser]

I upgraded to the newest version 1.5.7d and I installed Numinix to add some extra fields but ever since then I can't copy products. Only can create new products.

This is the error I received when trying to copy a product as a new item:

[14-Apr-2022 23:56:24 America/Los_Angeles] Request URI: /myadmin/index.php?cmd=category_product_listing&action=copy_product_confirm&cPath=4522&pa ge=1, IP address: xx.xxx.xxx.xxx
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/includes/functions/database.php:44]
#5 zen_db_perform() called at [/myadmin/includes/modules/copy_product_confirm.php:103]
#6 require(/myadmin/includes/modules/copy_product_confirm.php) called at [/myadmin/category_product_listing.php:272]
#7 require(/myadmin/category_product_listing.php) called at [/myadmin/index.php:11]
--> PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'condition, old_sku, products_status, products_date_added, products_date_avail...' at line 1 :: INSERT INTO products (products_type, products_quantity, products_model, products_image, products_price, products_virtual, products_weight, products_tax_class_id, manufacturers_id, products_ordered, products_quantity_order_min, products_quantity_order_units, products_priced_by_attribute, product_is_free, product_is_call, products_quantity_mixed, product_is_always_free_shipping, products_qty_box_status, products_quantity_order_max, products_sort_order, products_discount_type, products_discount_type_from, products_price_sorter, master_categories_id, products_mixed_discount_quantity, metatags_title_status, metatags_products_name_status, metatags_model_status, metatags_price_status, metatags_title_tagline_status, products_dealer_url, products_condition, bin_location, condition, old_sku, products_status, products_date_added, products_date_available) VALUES ('1', '0', 'mywidget', 'mywidget.png', '57.9900', '0', '1', '0', '1', '0', '1', '1', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '57.9900', '4522', '1', '0', '0', '0', '0', '0', '', '', '', '', '', '0', now(), null) ==> (as called by) /includes/functions/database.php on line 44 <== in /includes/classes/db/mysql/query_factory.php on line 171.

[lat9]

Could it be that condition is a reserved name, needing ticks, e.g. `condition`, around the name?

[carlwhat]

Could it be that condition is a reserved name, needing ticks, e.g. `condition`, around the name?

condition is in fact a reserved word, as of mysql 5.0.

personally i would chose a different column name for your extra data fields, as i think this problem will keep on bearing its fangs in the most unlikely of places....

best.

[cruiser]

Yes, i manually deleted "condition" from the table and all is good again. Thanks!