- Posts: 30
- Thank you received: 0
When you save item error
-- Joomla version -- : 3.48
When you save item error :
1062 Duplicate entry '' for key 'product_code' SQL=UPDATE `kytrq_hikashop_product` SET `product_name`='Наборы весом 100 грамм.(9 тресс)',`product_code`='',`product_quantity`='-1',`product_manufacturer_id`='44',`product_published`='1',`product_tax_id`='11',`product_msrp`='0.0000000',`product_page_title`='',`product_url`='',`product_meta_description`='',`product_keywords`='Волосы купить,волосы на заколках,',`product_alias`='Naboryi-vesom-100',`product_canonical`='',`product_min_per_order`='0',`product_max_per_order`='0',`product_sale_start`='',`product_sale_end`='',`product_access`='all',`product_warehouse_id`='',`product_weight`='100.000',`product_weight_unit`='g',`product_length`='0.000',`product_width`='0.000',`product_height`='0.000',`product_dimension_unit`='m',`product_layout`='',`product_quantity_layout`='',`product_group_after_purchase`='',`product_type`='main',`product_description`='<p><strong>',`product_modified`='1453935546' WHERE `product_id`='3048'
and gone to all the products that I filled , what to do?! Make OpenServer!please help!
What's the problem?!
Please Log in or Create an account to join the conversation.
It means that there is no product code in the product you're trying to save. Please make sure that you have the product code field of the product filled before saving or it won't work as that is a required field.
Please Log in or Create an account to join the conversation.
Oh, Nicholas, I was waiting for You! Thank you! And how can it do without the product code?! I don't need it on the website! and in admin panel too!nicolas wrote: Hi,
It means that there is no product code in the product you're trying to save. Please make sure that you have the product code field of the product filled before saving or it won't work as that is a required field.
Please Log in or Create an account to join the conversation.
We can't leave that field empty, HikaShop is doing a lot of work based on these product codes.
But once filled, you will no more have errors, and in Configuration > Display > Product you can disable the option to show the product code. That way it will never appear on frontend.
Please Log in or Create an account to join the conversation.
thank you very much! As always you are the best,thank you for so fast answer!Xavier wrote: Hi,
We can't leave that field empty, HikaShop is doing a lot of work based on these product codes.
But once filled, you will no more have errors, and in Configuration > Display > Product you can disable the option to show the product code. That way it will never appear on frontend.
Please Log in or Create an account to join the conversation.