I d/l 5.x-3.x-dev version and enable userpoints and Userpoints Basic. And i get error msgs about _txn table not being created. and table is not created and various other upoints things do not work after this point.

Comments

liquidcms’s picture

liquidcms commented

i uninstalled and tried to just enable userpoints module and this time i copied the error down:

user warning: Key column 'event' doesn't exist in table query: CREATE TABLE userpoints_txn ( txn_id INT NOT NULL AUTO_INCREMENT, uid INT(10) NOT NULL DEFAULT '0', approver_uid INT(10) NOT NULL DEFAULT '0', points INT(10) NOT NULL DEFAULT '0', time_stamp INT(11) NOT NULL DEFAULT '0', status INT(1) NOT NULL DEFAULT '0', description TEXT, reference varchar(128), expirydate int(11) NULL default '0', expired tinyint (1) NOT NULL default '0', parent_txn_id int(11) NOT NULL default '0', tid INT(11) default NULL, entity_id INT(11) default NULL, entity_type varchar(32) default NULL, operation VARCHAR(32), PRIMARY KEY (txn_id), KEY (event), KEY (reference), KEY (status) ) /*!40100 DEFAULT CHARACTER SET utf8 */; in C:\Inetpub\websites\freel\includes\database.mysql.inc on line 172.

liquidcms’s picture

liquidcms commented

tried going back to 2.14 version and this time no error when enabling module - but still no _txn table

liquidcms’s picture

liquidcms commented

ok, got it.. as of this past CVS rev the EVENTS table got dropped from the install query; but the key(event) line is still there.

not sure if the event field is still requried or not.. but i just added it back and things seem to be fine now.

jredding’s picture

jredding commented
Status: Active » Closed (duplicate)

Have you read this thread?
http://drupal.org/node/194113

The version thats checked into CVS has the corrected KEY (Which is the error on your installation). Although this was checked in day or two ago it must not have made it into the nightly builds. I'll have to check on that.

I uninstalled and reinstalled the version checked into CVS and the tables were made correctly.

jredding’s picture

jredding commented

Just checked the version available for download isn't correct but the version in CVS is. They are automatically generated so you'll have to wait until its rebuilt (or simply check out from CVS).

jredding’s picture

jredding commented

did YOU READ the thread or ANY of the documentation OR LOOK at the .install file?

Sheesh.

The event column was renamed operation but the key was overlooked (as I said before its fixed in CVS). The move from event to operation was handled in update 7 in the .install file. So you can have the event field if you want (its extraneous) but you absolutely need the operation table.