Hi all,

On the stock page for all of my products whenever I click save I get a duplicate entry error. I was not getting this before upgrading to the latest Ubercart. Any help would be much appreciated.

issue

Here is the error again:

user warning: Duplicate entry 'ROB001' for key 1 query: INSERT INTO uc_product_stock (sku, nid, active, stock, threshold) VALUES ('ROB001', 136, 0, 0, 0) in /usr/www/users/eclosguaxd/sites/all/modules/ubercart/uc_stock/uc_stock.admin.inc on line 253.
user warning: Duplicate entry 'ROB001_01' for key 1 query: INSERT INTO uc_product_stock (sku, nid, active, stock, threshold) VALUES ('ROB001_01', 136, 1, 1, 0) in /usr/www/users/eclosguaxd/sites/all/modules/ubercart/uc_stock/uc_stock.admin.inc on line 253.

Thanks!!

CommentFileSizeAuthor
stock_issue.PNG35.47 KBratinakage

Comments

Aleksey Zubko’s picture

Aleksey Zubko commented

same issue

longwave’s picture

longwave
he/him
Primary language English
Location UK
commented
Priority: Critical » Normal
Status: Active » Fixed

The error is only cosmetic; the stock levels are still being saved and updated correctly.

Fix committed: http://drupalcode.org/project/ubercart.git/commitdiff/51bd11b
(based on #805858-3: Affected rows inconsistent across database engines)

Aleksey Zubko’s picture

Aleksey Zubko commented

thanks, longwave

ratinakage’s picture

ratinakage commented

Thanks longwave!!

Problem resolved...

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

ratinakage’s picture

ratinakage commented
Version: 6.x-2.6 » 6.x-2.7
Status: Closed (fixed) » Needs work

Hi,

Was this fix committed?

I am still seeing it in Ubercart 2.7.

longwave’s picture

longwave
he/him
Primary language English
Location UK
commented
Status: Needs work » Closed (fixed)

This was committed after 2.7 was released, it will be in 2.8.

ratinakage’s picture

ratinakage commented

Ah - my bad...

Thanks!

ratinakage’s picture

ratinakage commented
Issue summary: View changes

fixed issue path