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
Cc:

Description

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.