PostgreSQL-incompatible SQL in activity_cron()

Created on 30 November 2010, almost 15 years ago
Updated 29 October 2025, 6 days ago

query: SELECT uid, min(created) as min, count(aid) as count FROM activity GROUP BY uid HAVING min < 1275415501 AND count > 100 in /xxxxxxxxx/www/sites/all/modules/activity/activity.module on line 854.

This code :
$uid_sql = "SELECT uid, min(created) as min, count(aid) as count FROM {activity} GROUP BY uid HAVING min < %d AND count > %d";

Should be:
$uid_sql = "SELECT uid, min(created) as min, count(aid) as count FROM {activity} GROUP BY uid HAVING min(created) < %d AND count(aid) > %d";

🐛 Bug report
Status

Closed: outdated

Version

2.0

Component

Code

Created by

🇫🇷France grub3

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

No activities found.

Production build 0.71.5 2024