Details
Description
Total amount for order is hardcoded to 99999.99.
Steps:
- Log in to the commerce shop on frontend.
- Add to basket some products, the total value must be at least 100 000.
- Go to checkout.
- Try to complete checkout.
Actual result: At the end of checkout an error occurs informing that the order exceeded the maximum allowed amount of 99 999,99.
Expected result: The maximum amount can be altered in configuration beyond 100 000.
Remarks: At this moment this seems to be hardcoded on database level. See below exception.
An exception occurred while executing 'INSERT INTO payment_instructions (amount, approved_amount, approving_amount, created_at, credited_amount, crediting_amount, currency, deposited_amount, depositing_amount, extended_data, payment_system_name, reversing_approved_amount, reversing_credited_amount, reversing_deposited_amount, state, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [336134.45, 0, 0, "2021-04-09 09:42:34", 0, 0, "EUR", 0, 0, "a:0:{}", "invoice", 0, 0, 0, 4, "2021-04-09 09:42:34"]: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'amount' at row 1