Ran into this problem when updating
* user warning: Unknown column 'notify' in 'uc_order_statuses' query: ALTER TABLE uc_order_statuses CHANGE notify state VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '' in C:\xampp\htdocs\demetech\store\includes\database.mysql.inc on line 172.
* user warning: Duplicate column name 'weight' query: ALTER TABLE uc_order_statuses ADD weight MEDIUMINT(9) NOT NULL in C:\xampp\htdocs\demetech\store\includes\database.mysql.inc on line 172.
* user warning: Duplicate column name 'locked' query: ALTER TABLE uc_order_statuses ADD locked TINYINT NOT NULL DEFAULT '0' in C:\xampp\htdocs\demetech\store\includes\database.mysql.inc on line 172.
* user warning: Table 'demetech_webpage.content_type_kit' doesn't exist query: ALTER TABLE content_type_kit RENAME TO content_type_product_kit in C:\xampp\htdocs\demetech\store\includes\database.mysql.inc on line 172.The following queries were executed
uc_paypal module
Update #1
* 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 ''
* Failed: ALTER TABLE {uc_order_statuses} CHANGE notify state VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default ''
* Failed: ALTER TABLE {uc_order_statuses} ADD weight MEDIUMINT(9) NOT NULL
* Failed: 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 ('paypal_pending', 'PayPal pending', 'payment_received', 7, 1);
uc_product module
Update #9
* CREATE TABLE {uc_product_features} ( `pfid` mediumint(9) NOT NULL default 0, `nid` mediumint(9) NOT NULL default 0, `fid` varchar(32) NOT NULL, `description` text, PRIMARY KEY (`pfid`), KEY nid (nid) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ;
uc_product_kit module
Update #4
* Failed: ALTER TABLE {content_type_kit} RENAME TO {content_type_product_kit}
Joined: 08/17/2007