I just had to repair a minor database problem at MacMegasite related to user points. I noticed that points weren’t being awarded properly for some members, so when I checked the database I saw lots of duplicate key errors in the userpoints table. The easiest way to fix it was to uninstall userpoints, install the latest version, and have it reassign points retroactively.