Page 1 of 1

This is the error message SQL

Posted: Sun Dec 17, 2017 1:05 am
by vienkr
This is the error message:
=============================================
1002 - Duplicate entry '' for key 'products_model'

update NEWS set products_quantity = '1', products_model = '', products_price = '', products_type = '0', products_date_available = null, products_weight = '0', products_status = '', products_tax_class_id = '', manufacturers_id = '0', products_last_modified = now() where products_id = '141'

================================================
I tried to edit the data but not. Who answers help to crime. I have to complete the weekend to complete the project . Help me please

Re: This is the error message SQL

Posted: Sun Dec 17, 2017 1:50 am
by requinix
It means the NEWS table requires all products_model values to be unique. One of each.

Either provide a value for the products_model, which means you probably need to fix the other row which is also empty, or decide whether the uniqueness constraint needs to be there.

Re: This is the error message SQL

Posted: Sat Aug 07, 2021 11:45 am
by kiash
You have made products_model field as unique property. thats why you are getting this error. I you do not required this field as unique then alter the unique attribute

Re: This is the error message SQL

Posted: Mon Sep 27, 2021 7:15 pm
by Vegan
this forum and WP all use a document ID that is a simple counter to make sure each row in a database is present

I suggest adopting the same idea