Error messages: warning: implode() [function.implode] [#637954]

I just installed heartbeat. After i activated "Heartbeat relational activity" i get this error message:

warning: implode() [function.implode]: Invalid arguments passed in /var/www/vhosts/mypage.com/httpdocs/sites/default/modules/heartbeat/includes/connectedheartbeat.inc on line 26.
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 ') AND ua.access >= 0 ) OR ( ua.uid_target = 0 AND ua.nid <>' at line 14 query: SELECT hm.message AS 'message_orig', hm.message_concat AS 'message_concat_orig', hm.attachments AS 'attachments', hm.concat_args, hm.perms, ua.*, 1 AS 'count' FROM heartbeat_activity ua LEFT JOIN heartbeat_messages hm ON ua.message_id = hm.message_id WHERE ua.language = 'en' AND (ua.timestamp < 1258682833 AND ua.timestamp > 1256004433 ) AND ( (ua.uid in( ) AND ua.access >= 0 ) OR ( ua.uid_target = 0 AND ua.nid <> 0 ) ) ORDER BY timestamp DESC in on line .
warning: implode() [function.implode]: Invalid arguments passed in /var/www/vhosts/mypage.com/httpdocs/sites/default/modules/heartbeat/includes/connectedheartbeat.inc on line 26.
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 ') AND ua.access >= 0 ) OR ( ua.uid_target = 0 AND ua.nid <>' at line 14 query: SELECT hm.message AS 'message_orig', hm.message_concat AS 'message_concat_orig', hm.attachments AS 'attachments', hm.concat_args, hm.perms, ua.*, 1 AS 'count' FROM heartbeat_activity ua LEFT JOIN heartbeat_messages hm ON ua.message_id = hm.message_id WHERE ua.language = 'en' AND (ua.timestamp < 1258682836 AND ua.timestamp > 1256004436 ) AND ( (ua.uid in( ) AND ua.access >= 0 ) OR ( ua.uid_target = 0 AND ua.nid <> 0 ) ) ORDER BY timestamp DESC in on line .

Here i have the recent log entries:

Type php
Date Friday, 20 November, 2009 - 13:07
User admin
Location http://www.mypage.com/admin/build/pages/nojs/operation/user_view/handler...
Referrer http://www.mypage.com/admin/build/pages/nojs/operation/user_view/handler...
Message 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 ') AND ua.access >= 0 ) OR ( ua.uid_target = 0 AND ua.nid <>' at line 14 query: SELECT hm.message AS 'message_orig', hm.message_concat AS 'message_concat_orig', hm.attachments AS 'attachments', hm.concat_args, hm.perms, ua.*, 1 AS 'count' FROM heartbeat_activity ua LEFT JOIN heartbeat_messages hm ON ua.message_id = hm.message_id WHERE ua.language = 'en' AND (ua.timestamp < 1258682836 AND ua.timestamp > 1256004436 ) AND ( (ua.uid in( ) AND ua.access >= 0 ) OR ( ua.uid_target = 0 AND ua.nid <> 0 ) ) ORDER BY timestamp DESC in on line .
Severity error
Hostname -------------------
Operations

and

I don't know if this is a bug or if the mistake is on my side. Any idea anyone?
Regards
honorfield

Comments

Comment #1

Stalski commented 24 November 2009 at 10:23

Hey,

I tthink this is a bug in heartbeat_views module. I will fix this, but i would suggest to use the heartbeat pages and blocks. These have much much more nice features than when using views.
Heartbeat is in fact a module that covers display as much as possible.

Try them out and let me know

Comment #2

netrom commented 1 December 2009 at 19:23

Hi,

I get the same error. I have testet it both with the views and the block. I used the view with Panels and got the error. Then I used the block by setting it in a page region. And got the error. I don't know how to make it work now.

You say "...i would suggest to use the heartbeat pages and blocks." What do you mean by this? The block I can find, but what "pages" do you mean?

Well, I am a little confused and lost now.

Any suggestions?

Regards, Morten

Comment #3

Stalski commented 2 December 2009 at 13:13

The blocks can hold (cfr settings) a more link to the older messages. If you don't choose the ajax way, then the page that will load will be the page for that stream.
You are right there is no documentation on that. I sometimes assume people are checking the menu hook but that assumption is not good.
So i will write documentation on this.
For now, just know you can use the pages at url: /heartbeat/
E.g. http://mysite/heartbeat/publicheartbeat where publicheartbeat is the stream name (or access type)

The error of implode will be fixed in next release.

Regards,
Stalski