When you save item error

  • Posts: 30
  • Thank you received: 0
8 years 9 months ago #227946

-- HikaShop version -- : 2.6.0 business
-- 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?!

Last edit: 8 years 9 months ago by Святина.

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
8 years 9 months ago #227960

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.

The following user(s) said Thank You: Святина

Please Log in or Create an account to join the conversation.

  • Posts: 30
  • Thank you received: 0
8 years 9 months ago #228039

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.

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!

Please Log in or Create an account to join the conversation.

  • Posts: 13201
  • Thank you received: 2322
8 years 9 months ago #228046

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.

The following user(s) said Thank You: Святина

Please Log in or Create an account to join the conversation.

  • Posts: 30
  • Thank you received: 0
8 years 9 months ago #228125

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.

thank you very much! As always you are the best,thank you for so fast answer!

Please Log in or Create an account to join the conversation.

Time to create page: 0.078 seconds
Powered by Kunena Forum