Bug Can't unthank and Stats screen not working

[Jason Butler]

When I click on the "Unthank" button I get the following message: Invalid Server Response.

When I click to see the Stats I get a error screen:

Invalid SQL:
SELECT
thanks_given AS value,
userid,
username,
user.usergroupid,
infractiongroupid,
displaygroupid
FROM dbtech_thanks_statistics AS dbtech_thanks_statistics
LEFT JOIN user AS user USING(userid)
LEFT JOIN usergroup AS usergroup ON (usergroup.usergroupid = user.usergroupid)
WHERE (usergroup.genericoptions & 32)
GROUP BY userid
ORDER BY value DESC, username ASC
LIMIT 5;

MySQL Error : Column 'userid' in field list is ambiguous
Error Number : 1052
Request Date : Wednesday, February 16th 2011 @ 01:54:26 AM
Error Date : Wednesday, February 16th 2011 @ 01:54:26 AM
Script : http://www.filmmakersnetwork.ie/forums/thanks.php?do=statistics
IP Address : 109.255.111.80
Classname : vB_Database
MySQL Version : 4.1.22-standard

Obviously I have disabled the plug-in until this can be fixed. If not, refund?

 

[Fillip H.]

Can you please PM me with an FTP account and an AdminCP account for your forum? If so, I'll have this fixed ASAP

Also, could you please update MySQL on your server to 5.0.19 or greater? Your version only barely meets the minimum requirements, but it's been EOL (End-Of-Life, unsupported) by MySQL themselves for several years now

 

[Fillip H.]

Both problems have been taken care of on your site, and patched into the release files