ecartz

Hi Mike

The database changes in 1.0.4.4 were increasing the varchars to 255. I created an update script for Gary but he's not included it in the package. You can use the following SQL.

/* Update to existing installations adjusting VARCHARs to 255 in length */

ALTER TABLE categories
CHANGE COLUMN categories_image categories_image VARCHAR(255) NOT NULL;

ALTER TABLE categories_description
CHANGE COLUMN categories_name categories_name  VARCHAR(255) NOT NULL,
CHANGE COLUMN categories_seo_keywords categories_seo_keywords VARCHAR(255) NOT NULL,
CHANGE COLUMN categories_seo_title categories_seo_title  VARCHAR(255) NOT NULL;

ALTER TABLE manufacturers
CHANGE COLUMN manufacturers_name manufacturers_name VARCHAR(255) NOT NULL,
CHANGE COLUMN manufacturers_image manufacturers_image VARCHAR(255);

ALTER TABLE manufacturers_info
CHANGE COLUMN manufacturers_seo_keywords manufacturers_seo_keywords VARCHAR(255)  NULL,
CHANGE COLUMN manufacturers_seo_title manufacturers_seo_title VARCHAR(255) NULL;

ALTER TABLE orders_products
CHANGE COLUMN products_model products_model VARCHAR(255),
CHANGE COLUMN products_name products_name VARCHAR(255) NOT NULL;

ALTER TABLE orders_products_attributes
CHANGE COLUMN products_options products_options VARCHAR(255) NOT NULL,
CHANGE COLUMN products_options_values products_options_values VARCHAR(255) NOT NULL;

ALTER TABLE products
CHANGE COLUMN products_model products_model VARCHAR(255),
CHANGE COLUMN products_image products_image VARCHAR(255);

ALTER TABLE products_description
CHANGE COLUMN products_name products_name VARCHAR(255) NOT NULL DEFAULT '',
CHANGE COLUMN products_seo_keywords products_seo_keywords VARCHAR(255) NULL ,
CHANGE COLUMN products_seo_title products_seo_title VARCHAR(255) NULL ;

ALTER TABLE products_images
CHANGE COLUMN image image VARCHAR(255);

ALTER TABLE products_options
CHANGE COLUMN products_options_name products_options_name VARCHAR(255) NOT NULL DEFAULT '';

ALTER TABLE products_options_values
CHANGE COLUMN products_options_values_name products_options_values_name VARCHAR(255) NOT NULL DEFAULT '';

cheers

Mark