Hi,

the module is very practical, but, unfortunately, I have the following problem:

If I activate the module, the posts of the user are counted once. However, new posts are not counted any more. The counter freezes. Starting the cron changes nothing in this situation.

In addition, I receive consecutively the following error messages:

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 uid FROM thema_profile_values WHERE fid=11 ) query: SELECT uid FROM thema_users WHERE uid NOT IN ( SELECT uid FROM thema_profile_values WHERE fid=11 ) LIMIT 0, 25 in /htdocs/drupal/includes/database.mysql.inc in Zeile 172.

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 thema_profile_fields WHERE name = 'user query: UPDATE thema_profile_values SET value=21 WHERE fid = (SELECT fid FROM thema_profile_fields WHERE name = 'user_post_count') AND uid=1  in /htdocs/drupal/includes/database.mysql.inc in Zeile 172.

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 thema_profile_fields WHERE name = 'user query: UPDATE thema_profile_values SET value='79.198.44.184' WHERE fid = (SELECT fid FROM thema_profile_fields WHERE name = 'user_ip_address') AND uid=1  in /htdocs/drupal/includes/database.mysql.inc in Zeile 172.

How can this mistake be repaired?

Many Thanks
Frank

Comments

frank.dev’s picture

frank.dev commented

To information:

I use MySQL v 4.0.27 and PHP 4.4.8.

jaydub’s picture

jaydub commented

You have a pretty darn old version of MySQL running there...

user_stats uses subselect (subqueries) which were not supported
in MySQL until 4.1 despite being a standard database feature in
every other _real_ database.

MySQL 4.0 is still an offically supported database for Drupal 5 in
terms of core functionality but contrib modules should not really
be expected to support such old versions of MySQL. Drupal 6
makes MySQL 4.1 a minimum requirement so really you should
ask yourself what is keeping you from upgrading...

http://drupal.org/requirements

liam mcdermott’s picture

liam mcdermott commented
Status: Active » Closed (works as designed)

Thanks Jaydub, I wouldn't have caught that. :)