I am getting this error each time cron runs.
Have a made a mistake with one of my activity messages or rules that use them perhaps. ( I mean does this error suggest that?)
The only other oddity that I may have changed is that I needed to put a patch in place to make hearbeat work with VIews 3.
Unfortunatly I did not notice when this error first started so I am finding it very difficult to narrow down what may have happened.
I have the latest Dev 6x. 4x version installed.
I have gone through your issue que to no avail and I can't find forums that can help me either.
To clarrify this is not stopping the heartbeat stream from working. It does seem to effect the sort table for comments though as I have chosen newsest to the bottom of the list but they are appearing at the top. Also sometimes comments won't work until I reload the web browser (clearing the cache also)
Sorry if this is long winded and vauge.

    warning: array_fill() [function.array-fill]: Number of elements must be positive in /var/www/clients/client1/web1/web/includes/database.inc on line 253.
    warning: implode() [function.implode]: Invalid arguments passed in /var/www/clients/client1/web1/web/includes/database.inc on line 253.
    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 ') GROUP BY t1.uid, t1.uaid HAVING COUNT(t2.uid) <= 20 ORDER BY t1.ui' at line 11 query: SELECT t1.uid, t1.uaid as 'uaid', COUNT(*) as 'rows_per_user', t1.timestamp as 'real_date', MIN(t2.timestamp) as 'oldest_date', count(t2.uid) AS 'count' FROM heartbeat_activity AS t1 INNER JOIN heartbeat_activity AS t2 ON t1.uid = t2.uid AND t2.timestamp >= t1.timestamp WHERE (t1.timestamp, t1.uaid) < (t2.timestamp, t2.uaid) AND t1.message_id NOT IN () GROUP BY t1.uid, t1.uaid HAVING COUNT(t2.uid) <= 20 ORDER BY t1.uid, t1.uaid, t1.timestamp DESC in /var/www/clients/client1/web1/web/sites/all/modules/heartbeat/heartbeat.module on line 483.

Comments

NickAT’s picture

Had the same issue, this seems to work for me http://drupal.org/node/1482696

BIGREDPAUL’s picture

Thank you for the response. Sorry about the long delay in checking things as I have been on holiday.
I followed the link and tried the fix but had no luck. I'm living with it for now due to time constraints but again thanks for the help. If I find out what's going on I'll post it here.