Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#1789 closed defect (fixed)

Product Options Prices Are Stored With Orders as Unsigned

Reported by: reto.kohli Owned by: comvation
Priority: high Milestone: unknown
Component: Shop Version: 3.1 Hotfix 1
Severity: normal Keywords: shop order item attribute price unsigned


Prices for any options ordered with any item are stored as "unsigned" in the database. To fix the issue, run the following query on your database:

ALTER TABLE contrexx_module_shop_order_attributes CHANGE price price DECIMAL(9, 2) NOT NULL DEFAULT '0.00';

Change History (2)

comment:1 Changed 7 years ago by reto.kohli

  • Resolution set to fixed
  • Status changed from new to closed

Updated database structure in contrexx_trunk and contrexx_3_1_1

Note: See TracTickets for help on using tickets.