I got following error after upgrading from 6.x-1.0 to 6.x-1.1

Drupal database update
    * user warning: Duplicate column name 'changed' query: ALTER TABLE userpoints_txn ADD `changed` INT NOT NULL DEFAULT 0 in /web/htdocs/www.snowpedia.it/home/includes/database.mysql-common.inc on line 298.
    * user warning: Duplicate key name 'changed' query: ALTER TABLE userpoints_txn ADD INDEX changed (changed) in /web/htdocs/www.snowpedia.it/home/includes/database.mysql-common.inc on line 434.

The following queries were executed
userpoints module
Update #6011
    * Failed: ALTER TABLE {userpoints_txn} ADD `changed` INT NOT NULL DEFAULT 0
    * Failed: ALTER TABLE {userpoints_txn} ADD INDEX changed (changed)
    * UPDATE {userpoints_txn} SET changed = time_stamp

Comments

kbahey’s picture

kbahey commented
Component: Code: userpoints_basic » Code: userpoints API
Status: Active » Closed (won't fix)

This is harmless, since the column and key exists already. It is trying to create them again by mistake.

vitis’s picture

vitis commented

just re-installed ubercart. got similar message:

Duplicate key name 'cart_id' query: ALTER TABLE uc_cart_products ADD INDEX cart_id (cart_id) in (my files)\includes\database.mysql-common.inc on line 434.

going to ignore - unless advised otherwise, or something fishy happens

sterg17’s picture

sterg17 commented
Component: Code: userpoints API » Code: userpoints

I got the same messages after upgrading my version of Ubercart to the latest update. These are my messages:

user warning: Duplicate column name 'changed' query: ALTER TABLE uc_shipments ADD `changed` INT NOT NULL DEFAULT 0 in /home3/madefrom/public_html/includes/database.mysql-common.inc on line 306.
warning: array_merge() [function.array-merge]: Argument #2 is not an array in /home3/madefrom/public_html/update.php on line 173.
user warning: Duplicate column name 'currency' query: ALTER TABLE uc_orders ADD `currency` CHAR(3) NOT NULL DEFAULT '' in /home3/madefrom/public_html/includes/database.mysql-common.inc on line 306.
user warning: Duplicate key name 'qty' query: ALTER TABLE uc_order_products ADD INDEX qty (qty) in /home3/madefrom/public_html/includes/database.mysql-common.inc on line 442.
user warning: Duplicate key name 'nid' query: ALTER TABLE uc_order_products ADD INDEX nid (nid) in /home3/madefrom/public_html/includes/database.mysql-common.inc on line 442.
user warning: Duplicate column name 'weight' query: ALTER TABLE uc_countries ADD `weight` TINYINT NOT NULL DEFAULT 0 in /home3/madefrom/public_html/includes/database.mysql-common.inc on line 306.
warning: Invalid argument supplied for foreach() in /home3/madefrom/public_html/update.php on line 337

Unfortunately, while the website works fine, after a completed order is placed - the following message appears to the customer:

"Unable to send e-mail. Please contact the site administrator if the problem persists"

Even worse, the address, name and order information is NOT captured and the credit cards are NOT charged. HELP!