Magento SQLSTATE[23000]: Integrity constraint violation

£10-20 GBP

Closed

Posted

over 7 years ago

£10-20 GBP

Paid on delivery

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', ?, ?, ?, ?, ?, ?)

Project ID: 11714447

About the project

13 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

13 freelancers are bidding on average £49 GBP for this job

@CoVaLiDiTy

magento specialist here, can help you fix this issue in you magento cart . can start right away and finish quickly. regards, max

£20 GBP in 1 day

4.9

(270 reviews)

7.0

@somalime

Hello, It's looks like something make your auto increment system to come out of sync. Well, there are many causes for that, and we can't say for sure unless we check it thoroughly. If you let us check it, we will find the cause of your problem and fix it. If you are interested, please send us a message or contact us via :

£77 GBP in 1 day

5.0

(4 reviews)

5.3

@DevoirTechsoft

Hello, We have studied the requirements and found it matches our skills. We are having an enthusiastic team with us having years of experience in PHP+MySQL, javascript, jquery, AJAX, e-commerce, magento, wordpress, shopify, open cart, API integration, XML java, dotnet, e-commerce, shopify, big commerce, opencart, curl, zoey commerce, wo commerce, nop commerce; We have done big and complex projects with quality and most of our business comes with repeat hires because of that, so looking forward to build a long term working relationship with you. Let’s have a chat session!!! We are having expertise team to give you very good support. Best regards Shikha

£24 GBP in 1 day

5.0

(2 reviews)

1.8

@cubeheap

Hello Mate We are a young team that is focused on growth through doing things differently. Since inception we have focused on delivering projects which are benchmarked by its quality. We say what we can deliver and deliver what we commit. We have understand your requirement based on that we have dedicated team to serve your project needs. We have accomplished such tasks in the past also though its a new venture for us on this platform so you wont be able to find many reviews. But we assure you as your project needs to get transformed from good to great, we hopefully will not let your expectation down.

£23 GBP in 1 day

5.0

(1 review)

0.0

@manishwebapp

Hello, I believe in client satisfaction and on time delivery . I have gained 7+ years of experience and profound knowledge in the field of web development . I can show you my all previous works done of several types in different different technologies. The price that i mentioned in bid is not fixed we can mutually decide it over chat. I am new to freelancer but it does not mean that I am new in this industry. I am hoping to have a positive reply from you. Regards, Manish

£80 GBP in 1 day