Bug Database error/Recalculating points

[gamaken]

Recalculating points does not work for all members. Some are being ignored by the script.
I'm also getting the following error when one of my admins tries to run the script:

Database error in vBulletin 4.2.2:

Invalid SQL:

			INSERT INTO opbbb_dbtech_vbactivity_points
				(userid)
			VALUES (
				'969'
			);

MySQL Error   : Duplicate entry '969' for key 'PRIMARY'
Error Number  : 1062
Request Date  : Monday, January 13th 2014 @ 08:35:23 PM
Error Date    : Monday, January 13th 2014 @ 09:41:06 PM
Script        : http://www.onepiecebay.net/forums/admincp/vbactivity.php?do=maintenance
Referrer      : http://www.onepiecebay.net/forums/admincp/vbactivity.php?do=maintenance
IP Address    : *********
Username      : Blizzard
Classname     : vB_Database_MySQLi
MySQL Version : 5.1.63-0+squeeze1

 

[Fillip H.]

Two people should not attempt to run it at the same time, if that's what's happening. Also, can you make sure your MySQL user has the TRUNCATE TABLE permission? That may be the cause of this.

 

[gamaken]

Two people should not attempt to run it at the same time, if that's what's happening. Also, can you make sure your MySQL user has the TRUNCATE TABLE permission? That may be the cause of this.

Thanks for the reply. He was the only admin running the script. The db user has DROP and ALTER permissions.
As far as I can tell, this was the only error, and I haven't been able to reproduce it myself. I'm more concerned with some members being ignored by the point recalculation script.

 

[Fillip H.]

Are you sure their usergroups, or their individual users, are not set to Excluded?