KonaKart Community Forum

Installation / Configuration => Programming of KonaKart => Topic started by: nclemeur on December 05, 2007, 06:02:54 am

Title: Database column orders_products.products_model has the wrong size
Post by: nclemeur on December 05, 2007, 06:02:54 am

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
Title: Re: Database column orders_products.products_model has the wrong size
Post by: ming on December 05, 2007, 06:11:26 am
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.