Hi,
I just updated to Ubercart 5.x-1.0-beta1, and attempted to run the database update script.
The update fell in a screaming heap, and has left me with a nasty mess.
Can anyone point me in the direction of some kind of fix for this?
First error message is:
An HTTP error 500 occured. update.php?op=do_update
When I go to the update summary page it says:
The update process was aborted prematurely while running update #2 in uc_flatrate.module.
The details of the error message is:
* user warning: Duplicate column name 'mid' query: ALTER TABLE uc_flatrate_products ADD COLUMN mid mediumint(9) unsigned NOT NULL default 0 AFTER nid in /hsphere/local/home/salproqi/grape.net.au/includes/database.mysql.inc on line 172.
* user warning: Table 'uc_flatrate_methods' already exists query: 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 */ ; in /hsphere/local/home/salproqi/grape.net.au/includes/database.mysql.inc on line 172.
* user warning: Table 'salpro1_grape_www.workflow_ng_cfgs' doesn't exist query: SELECT data FROM workflow_ng_cfgs WHERE name = 'uc_flatrate_get_quote' in /hsphere/local/home/salproqi/grape.net.au/includes/database.mysql.inc on line 172.
* user warning: Table 'salpro1_grape_www.workflow_ng_cfgs' doesn't exist query: SELECT data FROM workflow_ng_cfgs WHERE name = 'uc_flatrate_get_quote_by_order' in /hsphere/local/home/salproqi/grape.net.au/includes/database.mysql.inc on line 172.
cheers,
Matt Harrold
