Re: Alpha 7d is out there!

Posts: 42
Joined: 08/08/2007

Just updated from 7c to 7d with no problem

update result

Drupal database update

Updates were attempted. If you see no failures below, you may proceed happily to the administration pages. Otherwise, you may need to update your database manually. All errors have been logged.

* main page
* administration pages

The following queries were executed
uc_payment module
Update #2

* ALTER TABLE {uc_order_statuses} CHANGE order_status_id order_status_id VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ''
* ALTER TABLE {uc_order_statuses} CHANGE title title VARCHAR(48) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ''
* ALTER TABLE {uc_order_statuses} CHANGE notify state VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ''
* ALTER TABLE {uc_order_statuses} ADD weight MEDIUMINT(9) NOT NULL
* ALTER TABLE {uc_order_statuses} ADD locked TINYINT NOT NULL DEFAULT '0'
* DELETE FROM {uc_order_statuses} WHERE order_status_id LIKE '_'
* INSERT INTO {uc_order_statuses} (order_status_id, title, state, weight, locked) VALUES ('payment_received', 'Payment received', 'payment_received', 10, 1);

uc_paypal module
Update #1

* INSERT INTO {uc_order_statuses} (order_status_id, title, state, weight, locked) VALUES ('paypal_pending', 'PayPal pending', 'payment_received', 7, 1);

uc_flatrate module
Update #1

* ALTER TABLE {uc_flatrate_products} ADD COLUMN vid mediumint(9) unsigned NOT NULL default 0 FIRST
* ALTER TABLE {uc_flatrate_products} DROP INDEX nid
* ALTER TABLE {uc_flatrate_products} ADD PRIMARY KEY (vid)

uc_quote module
Update #3

* ALTER TABLE {uc_quote_manufacturer_locations} CHANGE COLUMN address1 street1 varchar(255) NOT NULL default ''
* ALTER TABLE {uc_quote_manufacturer_locations} CHANGE COLUMN address2 street2 varchar(255) NOT NULL default ''
* ALTER TABLE {uc_quote_product_locations} CHANGE COLUMN address1 street1 varchar(255) NOT NULL default ''
* ALTER TABLE {uc_quote_product_locations} CHANGE COLUMN address2 street2 varchar(255) NOT NULL default ''

uc_order module
Update #3

* ALTER TABLE {uc_orders} CHANGE order_status order_status VARCHAR(32) NOT NULL
* UPDATE {uc_orders} SET order_status = 'in_checkout' WHERE order_status = '0'
* UPDATE {uc_orders} SET order_status = 'pending' WHERE order_status = '1'
* UPDATE {uc_orders} SET order_status = 'processing' WHERE order_status = '2' OR order_status = '3'
* UPDATE {uc_orders} SET order_status = 'completed' WHERE order_status = '4'
* ALTER TABLE {uc_order_comments} CHANGE order_status order_status VARCHAR(32) NOT NULL
* UPDATE {uc_order_comments} SET order_status = 'in_checkout' WHERE order_status = '0'
* UPDATE {uc_order_comments} SET order_status = 'pending' WHERE order_status = '1'
* UPDATE {uc_order_comments} SET order_status = 'processing' WHERE order_status = '2' OR order_status = '3'
* UPDATE {uc_order_comments} SET order_status = 'completed' WHERE order_status = '4'
* INSERT INTO {uc_order_statuses} (order_status_id, title, state, weight, locked) VALUES ('canceled', 'Canceled', 'canceled', -20, 1), ('in_checkout', 'In checkout', 'in_checkout', -10, 1), ('pending', 'Pending', 'post_checkout', 0, 1), ('processing', 'Processing', 'post_checkout', 5, 1), ('completed', 'Completed', 'completed', 20, 1);

uc_product module
Update #6

* ALTER TABLE {uc_products} ADD COLUMN ordering smallint(2) NOT NULL default 0

Update #7

* ALTER TABLE {uc_products} CHANGE units weight_units varchar(255) NOT NULL default 'lb'
* ALTER TABLE {uc_products} ADD length float unsigned NOT NULL default 0 AFTER weight_units
* ALTER TABLE {uc_products} ADD width float unsigned NOT NULL default 0 AFTER length
* ALTER TABLE {uc_products} ADD height float unsigned NOT NULL default 0 AFTER width
* ALTER TABLE {uc_products} ADD length_units varchar(255) NOT NULL default 'in' AFTER height
* ALTER TABLE {uc_products} ADD pkg_qty smallint unsigned NOT NULL default 1 AFTER length_units

Update #8

* ALTER TABLE {uc_products} ADD vid mediumint(9) NOT NULL default 0 FIRST
* ALTER TABLE {uc_products} DROP PRIMARY KEY
* ALTER TABLE {uc_products} ADD PRIMARY KEY (vid)

uc_product_kit module
Update #3

* ALTER TABLE {uc_product_kits} ADD COLUMN vid mediumint(9) NOT NULL default 0 FIRST
* ALTER TABLE {uc_product_kits} DROP PRIMARY KEY
* ALTER TABLE {uc_product_kits} ADD PRIMARY KEY (vid, product_id)

--

www.taggedcheap.co.uk The cheapest price shop

Alpha 7d is out there! By: Ryan (35 replies) Tue, 10/02/2007 - 15:07