Hi,

I am using User Stats in conjunction with Advanced Forum in two websites.

The difference between the websites: one uses the theme Interactive Media; the second uses the theme Easybreeze.

The similarities: both in the same version, and both use Advanced Forum with its theme Blue_Lagoon.

Well, in the site with the theme Interactive Media, at the moment I enabled the module User Stats in Modules, immediately I was able to see the user posts count in the forums.

In the site that uses Easybreeze, this data is not being shown.

Any ideas? Installation has been identical for both.

Helio

Comments

heliod’s picture

heliod commented

One more comment: I have just found out that on the site that it is now showing the stats, activating this module causes the display of the follwoing SQL Errors when I add a comment:

•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 ppcfprofile_fields WHERE name = 'user_post_coun query: UPDATE ppcfprofile_values SET value=1290 WHERE fid = (SELECT fid FROM ppcfprofile_fields WHERE name = 'user_post_count') AND uid=2 in F:\webspace\disk15\Newfreak\www\includes\database.mysql.inc on line 172.

•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 ppcfprofile_fields WHERE name = 'user_ip_addres query: UPDATE ppcfprofile_values SET value='10.0.0.2' WHERE fid = (SELECT fid FROM ppcfprofile_fields WHERE name = 'user_ip_address') AND uid=2 in F:\webspace\disk15\Newfreak\www\includes\database.mysql.inc on line 172
heliod’s picture

heliod commented

I am beginning to think it has to do with the version of MySQL running there.... it is MySQL 4.0.25

Can someone confirm?