Magento SQLSTATE: Integrity constraint violation
This project received 15 bids from talented freelancers with an average bid price of £46 GBP.Get free quotes for a project like this
Project Budget£10 - £20 GBP
No work has been done to me website for many months., when i try to save or duplicate a new product i get this error.
I am looking for someone who knows magento and can find and fix this error in the correct manor.
The error i get is
SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '1321-1' for key 'UNQ_mg_CATALOGINVENTORY_STOCK_ITEM_PRODUCT_ID_STOCK_ID', query was: INSERT INTO `mg_cataloginventory_stock_item` (`product_id`, `stock_id`, `qty`, `use_config_min_qty`, `is_qty_decimal`, `use_config_backorders`, `use_config_min_sale_qty`, `use_config_max_sale_qty`, `is_in_stock`, `low_stock_date`, `use_config_notify_stock_qty`, `use_config_manage_stock`, `stock_status_changed_auto`, `use_config_qty_increments`, `use_config_enable_qty_inc`, `is_decimal_divided`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, '2016-10-04 14:00:37', ?, ?, ?, ?, ?, ?)
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online