When I try to install the module the follow error box appear:

* user warning: Unknown column 'p.tid' in 'where clause' query: SELECT p.uid, u.name, p.points FROM userpoints p INNER JOIN users u USING (uid) WHERE p.tid = 1 ORDER BY p.points DESC LIMIT 0, 5 in C:\apachefriends\xampp\htdocs\guru\includes\database.mysql.inc on line 172.
* user warning: Unknown column 'p.tid' in 'where clause' query: SELECT p.uid, u.name, p.points FROM userpoints p INNER JOIN users u USING (uid) WHERE p.tid = 0 OR p.tid IS NULL ORDER BY p.points DESC LIMIT 0, 5 in C:\apachefriends\xampp\htdocs\guru\includes\database.mysql.inc on line 172.

I'm testing the site with drupal 5.1 if you need this info

Comments

kbahey’s picture

kbahey commented
Status: Active » Postponed (maintainer needs more info)

Is this an upgrade from 5.x-2.x? If so did you run the update.php script?

jredding’s picture

jredding commented
Category: bug » support

moving to support as the query isn't wrong its simply that the tables haven't been created correctly.

update.php needs to be ran and possibly a full uninstall/reinstall performed. Unless its something unusual this question has been asked before and the module has been checked for having correct create table syntax (i.e. the .install file appears to have no bugs in it).

berdir’s picture

berdir
Primary language German
Location Switzerland
commented
Status: Postponed (maintainer needs more info) » Closed (won't fix)

Sorry for spamming the participants in this issue. Due to the release of Drupal 7 and the lack of time from the maintainers, I'm closing all remaining 5.x issues for Userpoints.

Feel free to re-open this issue or create a new one for 6.x or even better 7.x if this bug is still open or feature is missing for these versions.