User Points doesn't seem to be working....I installed it on an upgraded site (that didn't use user points). At one point I did get this error message:

user warning: Unknown column 'event' in 'field list' query: SELECT points, time_stamp, event, description, status FROM userpoints_txn WHERE uid = 13 ORDER BY time_stamp DESC LIMIT 0, 10 in /var/www/vhosts/goflyxc.com/httpdocs/includes/database.mysql.inc on line 172.

But now the error doesn't show.

It isn't increasing the points with new content submitted. I also did the retroactive points calculation and I think it worked as it gave user totals but when you try to view where they got those points from (userpoints/uid) it didn't give a history, it came up blank and it doesn't even show their current total (even tho their total DOES show on their uesr profile page).

I also configured it to NOT show the admim role but it is showing it in the standings...maybe just from the retroactive points it calculated.

I also tried to subtract all points that the admin user has in hopes it would remove them from the list and let the setting take over not to give them any more points but that didn't work either. I successfully filled otu the form to remove points from the user and it didn't give errors but it didn't take the points away. (how can you see the log for taking away (or giving) points?)

The tables were installed in the dbase so I'm not sure where to turn to.

Comments

jredding’s picture

jredding commented

user warning: Unknown column 'event' in 'field list' query: SELECT points, time_stamp, event, description, status FROM userpoints_txn WHERE uid = 13 ORDER BY time_stamp DESC LIMIT 0, 10 in /var/www/vhosts/goflyxc.com/httpdocs/includes/database.mysql.inc on line 172.

make sure that the fields have been correctly created. From this error your DB appears incorrect.

It isn't increasing the points with new content submitted.

it won't until the DB is fixed..

I also did the retroactive points calculation and I think it worked as it gave user totals but when you try to view where they got those points from (userpoints/uid) it didn't give a history.

retroactive doesn't currently display a history only a single SUM of past points (i.e one point entry). It makes sense that its showing on the profile page but not on the detail page because of your DB error. The userpoints_txn table has to be created i full, check out the table.

you might want to disable, uninstall and reinstall to recreate the userpoints_txn table.

by chance are you using postgres? or are you using mysql?

mdowsett’s picture

mdowsett commented
Status: Active » Fixed

I started fresh...deleted the tables, deactivated the modules, uninstalled the modules, deleted the files over FTP, re-uploaded, re-installed, reactivated...and I only did the userpoints module this time - last time I did both that and the userpoints_contrib modules at the same time (shame on me for being excited!).

No errors and I think it all worked.

The reason I couldn't take away points from the admin user was that I had that role as exempt in the settings but the retroactive step gave the admin it's points but then you couldn't remove them since they were exempt. I changed that setting, took their points away and re-exempted them.

So I think it's all a go!

thx

jredding’s picture

jredding commented

don't forget to ensure that the versions of the contributed module match that of the API, v3 doesn't work with v2 and vice versa. I don't know the current status of the contributed modules but they are being worked on.

mdowsett’s picture

mdowsett commented

thanks for that tip. I have the v2.0 of the contrib installed. I usually steer away from the dev versions but would you recommend using them in this case? I am using v3.3 of the userpoints module

jredding’s picture

jredding commented

that's fine to steer away from dev version but I'm telling you, again (in addition its on the frontpage of both userpoints & userpoints contrib) that contributed modules v2 is NOT compatible with v3 of userpoints. I'm sorry but they are not compatible, if they work its a miracle but they shouldn't be relied upon.

I'm sorry that all of the contributed modules haven't been upgraded but you could help speed that process along by helping to debug the dev modules.

so, again, you are using incompatible modules.

jredding’s picture

jredding commented

and no I wouldn't recommend using them they are incompatible.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.

tom-knox’s picture

tom-knox commented
Version: 5.x-3.3 » 6.x-1.x-dev
Assigned: Unassigned » tom-knox
Priority: Normal » Critical
Status: Closed (fixed) » Postponed (maintainer needs more info)

How do i set-up how many points will be assigned for new content? When i (superadmin) create new content i'm not being assigned any points at all. I've tried comments and forum threads, no hope.

Nothing happens at all. I'm wondering if there is something i was supposed to set-up specially, im running drupal v6.5.

jredding’s picture

jredding commented

Please do not reopen thread that have been closed. If you have a support request simply open a new ticket.

I don't know what's up with version 6, its in dev and at the moment I'm only working on making sure it passes test. Have you enabled the userpoints_basic module? if not then you can't assign points to anything.

jredding’s picture

jredding commented
Version: 6.x-1.x-dev » 5.x-3.3
Assigned: tom-knox » Unassigned
Priority: Critical » Normal
Status: Postponed (maintainer needs more info) » Fixed

Changing everything back.

Anonymous’s picture

Anonymous (not verified) commented
Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.