mfleeson
-
Posts
150 -
Joined
-
Last visited
-
Days Won
6
Everything posted by mfleeson
-
Hi Lee,
The site won't let me message you, so here's what I tried to send:
Hi Lee
http://www.burninglight.biz/oscommerce3-2020/index.php?Admin
I've disabled login so you should be able to get straight in. If you click on Products and then edit an existing you can see how Harald used variants on the Dymo. If you want to access the raw product attributes component then check it out under Mark's Debug Menu!
I've backed up the database so if anything goes wrong I can always restore it.
Cheers
Mark
- Show previous comments 1 more
-
Try this link:
http://www.burninglight.biz/oscommerce3-2020/index.php?Admin&Login
username leepassword oscommerce3
-
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 '';
cheersMark