Magento SQLSTATE[23000]: Integrity constraint violation

Closed

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

Skills: eCommerce, HTML, Shopping Carts, Website Design

See more: 3d max in library, max in sql, max in matlab, magento developer company in germany, freelance 3d max in london, companies need a freelance autocad and 3ds max in saudi arabia, required magento developers freelance in pune, magento developer freelancer in kuala lumpur, freelancer for 3ds max in bangalore, magento backorders separate order, integrity constraint violation 1062 duplicate entry magento product, integrity constraint violation 1062 duplicate entry magento, magento shipping max weight, magento backorders, magento image max size

Project ID: #11714447

14 freelancers are bidding on average £47 for this job

nmans

We are highly interested to work with you on this project and can assure you quality results ready to start immediately some of our developed websites are listed below E-commerce http://kocostar.ca/ http://w More

£210 GBP in 3 days
(381 Reviews)
8.3
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
(270 Reviews)
7.0
VnBestSolutions

Dear Sir. We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Lo More

£61 GBP in 1 day
(139 Reviews)
6.7
TakeReal

Hello, My name is Sergey. I am Freelancer from St.Petersburg, Russia. I can help you as Magento expert to fix "Integrity constraint violation:" issue. So, you can be able to save and duplicate products without err More

£50 GBP in 1 day
(131 Reviews)
6.1
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 More

£77 GBP in 1 day
(4 Reviews)
5.3
shreetec14

Hello I had 11+ years of expereience in web design and development and i am sure that i can do whatever custom works on webstore. Kindly view some of my own designed / developed Magento stores here that can esta More

£15 GBP in 1 day
(16 Reviews)
4.9
vishal89

Hello, Thank you for submitting your requirements!!! I was looking through your project requirements and I do believe it's something I have experience in previous development and I can complete in a reasonable am More

£33 GBP in 1 day
(16 Reviews)
4.3
meghrajtech

Hello, Thank you for the Opportunity I am a senior Magento developer. I have gone through your requirements in brief and understand your idea and preference for job as you are looking for. I have 5 year experienc More

£24 GBP in 0 days
(22 Reviews)
4.5
crystalhitesh

Hello, Thanks for sharing this job!!!! I have more than 6 year experience in Web Development/Design,Working in Magento,Wp,OpenCart,IOS APP,Android APP. in these tech doing any level custom work. like custom theme, cu More

£18 GBP in 1 day
(9 Reviews)
3.5
shuaibullah

Hello Sir, I have been in this industry for 5 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I do not have any ratings/testimonials to show you. My name is Shua More

£18 GBP in 1 day
(9 Reviews)
3.3
nilu007

Thanks for share details for job.. This job is best match for my profile. we are small team of magento developer having more then 5 years of experience in magento extension development,customization, speed optimizat More

£13 GBP in 1 day
(3 Reviews)
2.0
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, More

£24 GBP in 1 day
(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 d More

£23 GBP in 1 day
(1 Review)
0.0
gtated

Wordpress Hello, I have more than 6 years of experience in website development(PHP/MySQL/JS/JQuery) and in website designing (adobe photoshop, adobe illustrator, coral draw)like-PSD to HTML, logos, banners, layouts a More

£18 GBP in 1 day
(0 Reviews)
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 More

£80 GBP in 1 day
(0 Reviews)
0.0