Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Enabling Special Pricing in admin (B2B) Causes Duplicate entry sql error. #702

Open
geraldbullard opened this issue Sep 18, 2015 · 0 comments

Comments

@geraldbullard
Copy link
Contributor

Loaded 7.003.4.1 (B2B Installed)
http://dev2.thereactorworks.com/bcseeds/70/admin/

When attempting to enable special pricing in admin from product edit screen >> pricing tab

we get the folowing sql error: 1062: Duplicate entry '309-0-0.0000' for key 'products_id'; insert into lc_products_pricing (products_id, qty_break, price_break, group_id, tax_class_id, special_status, special_price, special_start, special_end, date_added) values (309, -1, 0, 0, 0, '0', '0.00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', now())

I checked the database immediately after this attempt and found that there were 2 identical entries in the lc_products_pricing table as the following grabilla shows:

http://grabilla.com/05912-0d1c0dde-9060-47fd-8162-ccd8e84a06bc.png

Want to back this issue? Post a bounty on it! We accept bounties via Bountysource.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant