Database upgrade bugs

Posts: 6
Joined: 11/25/2007

I have just upgraded from ubercart alpha 8 to the betas.

After I run database update, I got a few errors.

If I upgrade directly from alpha 8 to beta 2, I got 3 item FAILED.
(attached as Drupal database update.pdf)

uc_flatrate module
Update #2
ALTER TABLE {uc_flatrate_products} CHANGE rate rate
decimal(10,2) NOT NULL default 0.00
ALTER TABLE {uc_flatrate_products} ADD COLUMN mid
mediumint(9) unsigned NOT NULL default 0 AFTER nid
CREATE TABLE {uc_flatrate_methods} ( `mid` mediumint(9)
unsigned NOT NULL default 0, `title` varchar(255) NOT NULL
default '', `label` varchar(255) NOT NULL default '', `base_rate`
decimal(10,2) NOT NULL default 0.00, `product_rate` decimal(10,2)
NOT NULL default 0.00, PRIMARY KEY (`mid`) ) /*!40100
DEFAULT CHARACTER SET UTF8 */ ;
Failed: INSERT INTO {uc_flatrate_methods} (mid, title, label,
base_rate, product_rate) VALUES (1, 'Flat rate per product', 'Shipping
rate', 0, )
UPDATE {uc_flatrate_products} SET mid = 1
Failed: UPDATE {workflow_ng_cfgs} SET name = '', data = 'N;'
WHERE name = 'uc_flatrate_get_quote'
INSERT INTO {uc_flatrate_methods} (mid, title, label, base_rate)
VALUES (2, 'Flat rate per order', 'Shipping rate', 5)
Failed: UPDATE {workflow_ng_cfgs} SET name = '', data = 'N;'
WHERE name = 'uc_flatrate_get_quote_by_order'

If I revert back to original database and upgrade to beta 1, I have one item FAILED. (no failure in uc_flatrate update #3 if I continue to upgrade to Beta 2.)
(attached as beta 1 update.pdf)

uc_flatrate module
Update #2
ALTER TABLE {uc_flatrate_products} CHANGE rate rate
decimal(10,2) NOT NULL default 0.00
ALTER TABLE {uc_flatrate_products} ADD COLUMN mid
mediumint(9) unsigned NOT NULL default 0 AFTER nid
CREATE TABLE {uc_flatrate_methods} ( `mid` mediumint(9)
unsigned NOT NULL default 0, `title` varchar(255) NOT NULL
default '', `label` varchar(255) NOT NULL default '', `base_rate`
decimal(10,2) NOT NULL default 0.00, `product_rate` decimal(10,2)
NOT NULL default 0.00, PRIMARY KEY (`mid`) ) /*!40100
DEFAULT CHARACTER SET UTF8 */ ;
Failed: INSERT INTO {uc_flatrate_methods} (mid, title, label,
base_rate, product_rate) VALUES (1, 'Flat rate per product', 'Shipping
rate', 0, )
UPDATE {uc_flatrate_products} SET mid = 1
INSERT INTO {uc_flatrate_methods} (mid, title, label, base_rate)
VALUES (2, 'Flat rate per order', 'Shipping rate', 5)

Anyone would like to tell me whether I should do something about it? or I can continue to use beta 2 ubercart as if it is running perfectly?

(I am going to test the beta 2 now and would post more if found more errors...)

Thanks
Eric

AttachmentSize
beta 1 update.pdf9.86 KB
Drupal database update.pdf8.97 KB
I've got beta things to do... By: Ryan (34 replies) Wed, 01/16/2008 - 18:19