Nobody get no points! When a user ought to get points the following error returns, along with a statement "You just earned 1 point! You now have a total of 0 points."

user warning: Table 'tarheeld_drpl2.userpoints_txn' doesn't exist query: INSERT INTO userpoints_txn (uid, points, time_stamp, status, operation, description, reference, expirydate, expired, parent_txn_id, tid, entity_id, entity_type) VALUES (11, 1, 1196378761, 0, 'insert', '', '', 0, 0, 0, 0, 4, 'node') in /home/tarheeld/public_html/constructingvictory/includes/database.mysql.inc on line 172.

Comments

Jerimee’s picture

Jerimee commented

This is the error I get when I install user points.

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 /home/tarheeld/public_html/constructingvictory/includes/database.mysql.inc on line 172.

jredding’s picture

jredding commented
Status: Active » Closed (duplicate)

I'm marking this as duplicate.
http://drupal.org/node/194113