Userpoints stopped working [#708388]

For some unknown reason, userpoints stopped working on my site. It was working fine. I don't know when it stopped, it was reported to me by a user. How can I go about troubleshooting the source of the issue? The module is activated, nothing was changed in regards to setup.

Any ideas or tips are appreciated. I've already tried uninstalling and reinstalling, but with no success. Is there a way to "reset" userpoints so that its fresh? One thing I noticed when I deactivated the module, removed the module folder and reinstalled / reactivated - all the old points for users prior to the issue were present. Is there somewhere else other than the userpoints folder that I can look to modify / research?

Comments

Comment #1

kbahey commented 8 February 2010 at 22:08

Status:

Active

» Postponed (maintainer needs more info)

Try upgrading to 6.x-1.x-dev. Remove the entire userpoints folder and all its contents, and then put the new version instead of it. Follow that by running update.php.

If the problem persists, then check if there are there any error messages in the logs Check under Admin -> Reports.

Comment #2

oskizzle commented 10 February 2010 at 14:30

I disabled userpoints, removed the folder from the modules folder, put the new version in, enabled userpoints, ran update.php.

The problem continued, so I went to Admin > Reports, and no errors. It looks like its not even going in to userpoints - shouldn't the Admin > Reports > Recent log entries show userpoints being assigned?

I can manually add / remove points to a user without error.

Comment #3

kbahey commented 10 February 2010 at 15:26

I don't think the log shows points being assigned. I was hoping there would be an error there that would tell us what is going on (e.g. missing table, missing table columns, ...etc.)

Can you please do a disable, then an uninstall. After that, make sure that the userpoints and userpoints_txn tables are NOT in the database, then enable the module again, and make sure that the two tables are created and are empty. Then try something that earns points, then see if there are data in these tables.

Comment #4

oskizzle commented 16 February 2010 at 17:23

I'm going to lose some credibility here, but I'd rather admit I don't know something so I can learn AND get this fixed...but...

How do I verify the tables are gone in the database? I use the GUI on my site, and FTP to get the files in, I don't know how to check the database to verify the tables are truly gone.