Hi.

I sometimes get one error in User Activity module:
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 '1272038227, timestamp=1264337651 WHERE uid=3' at line 1 query: UPDATE portal_user_activity SET idx=12,1272038227, timestamp=1264337651 WHERE uid=3 in /home7/piotrgli/public_html/portalkibicow/modules/user_activity/user_activity.module on line 344.

It looks like var idx has value 12,1272038227 in this case, which is not correct for float type. I mean there should be dot (.) instead of comma (,).

Any ideas how to fix it?

My user activity settings are:
Page impressions: 1
User logins: 1
Nodes created: 10
Comments created: 5

Comments

gumol’s picture

gumol commented

One mistake in code above. I addes few lines to debug problem, so line where the problem appears is 341 in modules/user_activity/user_activity.module in clear 6.x-1.1 version:

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 '1272038227, timestamp=1264337651 WHERE uid=3' at line 1 query: UPDATE portal_user_activity SET idx=12,1272038227, timestamp=1264337651 WHERE uid=3 in /home7/piotrgli/public_html/portalkibicow/modules/user_activity/user_activity.module on line 341.