Closed

Magento SQLSTATE[23000]: Integrity constraint violation

This project received 14 bids from talented freelancers with an average bid price of £47 GBP.

Get free quotes for a project like this
Employer working
Project Budget
£10 - £20 GBP
Total Bids
14
Project Description

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[23000]: 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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online