Using 10% percentage coupon gives errors to the pricing.
A £19.95 item becomes £17.95 but the cart total finishes up as £2.22 total??? And the Coupon granted amount £0.24.

Trying to remove an item from the shopping cart gives:

PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_commerce_coupon_reference0.commerce_coupon_reference_' in 'where clause': SELECT field_data_commerce_coupon_reference0.entity_type AS entity_type, field_data_commerce_coupon_reference0.entity_id AS entity_id, field_data_commerce_coupon_reference0.revision_id AS revision_id, field_data_commerce_coupon_reference0.bundle AS bundle FROM {field_data_commerce_coupon_reference} field_data_commerce_coupon_reference0 INNER JOIN {commerce_line_item} commerce_line_item ON commerce_line_item.line_item_id = field_data_commerce_coupon_reference0.entity_id WHERE (field_data_commerce_coupon_reference0.comm

To remove item from cart need to completely uninstall coupon modules.

CommentFileSizeAuthor
Coupon_error.png49.03 KBtjb74

Comments

tjb74’s picture

tjb74 commented

Managed to clear errors by manually deleting any reference to coupons in the database as the uninstall of modules was not removing field references to coupons and the errors where around from previously trying and testing the modules.

Then reinstalled.

pcambra’s picture

pcambra
he/him
Primary language Spanish
commented
Project: Commerce Coupon (D7) » Commerce coupon percentage
Status: Active » Fixed

Moving to the right queue.

This should not happen after fixing #1547440: Kill coupon log entity

Status: Fixed » Closed (fixed)

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