After making a purchase with user points, the following two error messages appear in the log:

Location http://test.sidepotsinternational.com/cart/review
Referrer http://test.sidepotsinternational.com/cart/review
Message Duplicate entry '51-shipping-0' for key 1 query: INSERT INTO test_ec_transaction_misc (txnid, type, vid, description, price, weight) VALUES('51', 'shipping', '0', 'Shipping', '5.00', '9') in /home/darrenoh/public_html/includes/database.mysql.inc on line 120.

Location http://test.sidepotsinternational.com/cart/review
Referrer http://test.sidepotsinternational.com/cart/review
Message Duplicate entry '51-tax-0' for key 1 query: INSERT INTO test_ec_transaction_misc (txnid, type, vid, description, price, weight) VALUES('51', 'tax', '0', 'Tax', '0.5', '10') in /home/darrenoh/public_html/includes/database.mysql.inc on line 120.

Comments

drupalec-1’s picture

Priority: Minor » Critical

I get a similar error except it appears on the screen, not just in the logs. Shifting priority up to critical since this cannot be used when this error appears.

It shows the purchase is completed.

But it also says your shopping cart is empty.

It should say something like your item will be delivered to you via ....

darren oh’s picture

Priority: Critical » Normal

I believe you can prevent errors from being displayed on screen by changing the error handling section of the settings page to write errors to log only.

User will taken to the empty shopping cart page no matter which payment method they use.

drupalec-1’s picture

Thank you. I do hope this can still be fixed, because the error message makes me nervous. I worry something else can break, through interaction with other modules.

sun’s picture

Status: Active » Fixed

Not reproducable with current Ecommerce and current User Points module.

Anonymous’s picture

Status: Fixed » Closed (fixed)