I get this failure when running cron job:

user warning: Unknown column 'upt.event' in 'where clause' query: userpoints_expire_cron SELECT DISTINCT(up.uid) FROM userpoints up INNER JOIN userpoints_txn upt USING(uid) WHERE upt.event <> 'expire' AND up.points > 0 AND upt.time_stamp < 1196731748

From the 3.x install file, there isnt an 'event' column for MySQL DB table userpoints_txn but it exist for pgsql. Looking at the 2.14 version, there's an event column, so I assumed you left out the event column for version 3.x by accident reading through your updates.

Comments

jredding’s picture

jredding commented

The modules for version 3.x haven't been upgraded yet thus they will have issues like this.

Until version 3.x of userpoints is complete this will be pushed back (i.e. its going to take a while before this is fixed). Additionally I believe this module is now deprecated as the functionality was built into the core userpoints.

jredding’s picture

jredding commented
Project: User Points » User Points Contributed modules
Version: 5.x-3.x-dev » 5.x-2.x-dev
berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Status: Active » Closed (won't fix)

Sorry for pinging the participants.

Now that Drupal 7 is out, there is no support for Drupal 5 and the
corresponding modules anymore. Therefore, I'm closing all old issues
which are still open.

I suggest you upgrade to Drupal 6 or 7 and figure out if you're feature
is still needed or the bug still exists and open a new issue in that
case.