Database column orders_products.products_model has the wrong size

[nclemeur]

Hello,

It seems that the column orders_products.products_model should have been a varchar(64) and the equivalent column in products is a varchar(64) (at least in the mysql version).  This could results in a "malfunction" at checkout which does not look very good.

Cheers

Nicolas

[ming]

Hi Nicolas,

Yes, we spotted that one as well and it's fixed in the next release which will be out within days (that will be the 2.2.1.0 version).

You can fix it safely by modifying that column:  (this is from our SQL upgrade script in the next release):

# Extend the size of the products_model column to match products table
ALTER TABLE orders_products MODIFY products_model VARCHAR(64);

Thanks for reporting the problem anyway,

Ming.