Mikepo

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

Hi there

You state you have used and made changes to the postcode shipping contribution

I tried to reply on the thread but its been archived

I am in UK and use counties to ship by, not the standard format but it works for me

The problem i have currently is using Paypal Express, many of older Paypal users do not have a county specified or wrongly spelt on there account so i was thinking maybe by postcode

I see that you say you have spilt the postcode to first section and pricing on that, ie se18 ****

Couple of questions

you say you have made some changes to work in later additions, i have 2.3.4bs and php 5.4+

Can you see any other issues  in your experience

and do you think it will be suitable for what i want to achieve

if so I would love to receive the amendments you made so i can test

Kindest regards

David

Hi there

You state you have used and made changes to the postcode shipping contribution

I tried to reply on the thread but its been archived

I am in UK and use counties to ship by, not the standard format but it works for me

The problem i have currently is using Paypal Express, many of older Paypal users do not have a county specified or wrongly spelt on there account so i was thinking maybe by postcode

I see that you say you have spilt the postcode to first section and pricing on that, ie se18 ****

Couple of questions

you say you have made some changes to work in later additions, i have 2.3.4bs and php 5.4+

Can you see any other issues  in your experience

and do you think it will be suitable for what i want to achieve

if so I would love to receive the amendments you made so i can test

Kindest regards

David