I'm upgrading to Drupal 5.2 from 4.7.6 and I get the following error in my logs after installing the 5.x official release of Userpoints and running update.php.

Table 'sandboxymb.userpoints_txn' doesn't exist query: SELECT t.txn_id, t.uid, t.time_stamp, t.points, t.event, t.status FROM userpoints_txn t WHERE t.status = 1 ORDER BY uid DESC LIMIT 0, 30 in /home/clients/ymb/public_html/sandbox/includes/database.mysql.inc on line 172.

Looking at userpoints.install the install hook contains a CREATE TABLE for userpoints_txn but none of the hook_update_N() create this table if you are coming from a prior installation of userpoints.

I didn't see anything about upgrading from 4.7.x to 5.x on the userpoints project page, README.txt, or project issue queue so I assume this to be an overlooked bug.

Comments

jredding’s picture

jredding commented
Status: Active » Closed (fixed)

update.php needs to be ran on the upgrade to create the table. All the appropriate files exist in the system and other upgrades appear to have gone OK.

If anyone else has the problem please post.

closing issue.