By weke on

Hello!

Probably not the best thing to do, but this is what I´ve done when installing Userpoints:

Installed Userpoints version 5.x-3.2
Wanted to use some modules from the Userpoints contributed modules 5.x-3.2.dev.tar.gz but some of them did not work.
Uninstalled and installed Userpoints version 5.x-2.16 with some contributed modules from that version. Run update php. Got warning messages.

Uninstalled and reinstalled version 5.x-3.2. Update.php gave me these messages shown below. Now, I need to go to the database and manually update it, but before I do, I´d like to know what I should look after and how to proceed from this. Thanks in advance.

Drupal database update
user warning: Duplicate column name 'expirydate' query: ALTER TABLE userpoints_txn ADD expirydate INT(11) NOT NULL AFTER reference, ADD expired TINYINT(1) NOT NULL AFTER expirydate, ADD parent_txn_id INT NOT NULL AFTER expired, ADD tid INT NULL AFTER parent_txn_id in /path to/public_html/portal/includes/database.mysql.inc on line 167. 
user warning: Incorrect table definition; there can be only one auto column and it must be defined as a key query: ALTER TABLE userpoints DROP PRIMARY KEY in /path to/public_html/portal/includes/database.mysql.inc on line 167. 
user warning: Duplicate column name 'tid' query: ALTER TABLE userpoints ADD tid INT NULL AFTER last_update, ADD pid INT NOT NULL AUTO_INCREMENT PRIMARY KEY in /path to/public_html/portal/includes/database.mysql.inc on line 167. 
user warning: Duplicate column name 'entity_id' query: ALTER TABLE userpoints_txn ADD entity_id INT(11) NULL AFTER tid, ADD entity_type VARCHAR(32) NULL AFTER entity_id in /path to/public_html/portal/includes/database.mysql.inc on line 167. 
user warning: Unknown column 'event' in 'userpoints_txn' query: ALTER TABLE userpoints_txn CHANGE event operation VARCHAR(32) in /path to/public_html/portal/includes/database.mysql.inc on line 167. 
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
userpoints module
Update #6
Failed: ALTER TABLE {userpoints_txn} ADD expirydate INT(11) NOT NULL AFTER reference, ADD expired TINYINT(1) NOT NULL AFTER expirydate, ADD parent_txn_id INT NOT NULL AFTER expired, ADD tid INT NULL AFTER parent_txn_id 
Failed: ALTER TABLE {userpoints} DROP PRIMARY KEY 
Failed: ALTER TABLE {userpoints} ADD tid INT NULL AFTER last_update, ADD pid INT NOT NULL AUTO_INCREMENT PRIMARY KEY 
Update #7
Failed: ALTER TABLE {userpoints_txn} ADD entity_id INT(11) NULL AFTER tid, ADD entity_type VARCHAR(32) NULL AFTER entity_id 
Failed: ALTER TABLE {userpoints_txn} CHANGE event operation VARCHAR(32) 
Update #8
ALTER TABLE {userpoints_txn} CHANGE tid tid INT(11) NOT NULL default '0' 
ALTER TABLE {userpoints} CHANGE tid tid INT(11) NOT NULL default '0'
⋅ Categories: Drupal 5.x