At the moment I activate the module User Stats I begin getting the following SQL Errors when I add a post to my site:

user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT fid FROM burg_profile_fields WHERE name = 'user_post_cou query: UPDATE burg_profile_values SET value=86 WHERE fid = (SELECT fid FROM burg_profile_fields WHERE name = 'user_post_count') AND uid=1 in F:\webspace\disk15\Burgman\www\includes\database.mysql.inc on line 174. 

user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT fid FROM burg_profile_fields WHERE name = 'user_ip_addre query: UPDATE burg_profile_values SET value='10.0.0.6' WHERE fid = (SELECT fid FROM burg_profile_fields WHERE name = 'user_ip_address') AND uid=1 in F:\webspace\disk15\Burgman\www\includes\database.mysql.inc on line 174

I am using Drupal 5.12, PHP 4.4.2, and MySQL 4.0.25.

When I disable the module at Admin>Site building>Modules the SQL errors disappear.

Most strange is that the same fields in the burg_profile_values table continue being updated also after the module is disabled.... and there are no error messages.... so what kind of mess is it doing there?