I'm getting:

# user warning: Table 'a.heartbeat_messages' doesn't exist query: SELECT event, message, message_concat, variables from heartbeat_messages in /home/webadmin/html/sites/all/modules/heartbeat/heartbeat.module on line 231.

I believe the prefix is missing.

Comments

Stalski’s picture

Stalski commented

hey,

I am working on the dev version and i dont have this problem anymore, but had it last week as well. Did you install all modules at once? or could you tell me the order of installation.
I tried to fix the problem by putting the heartbeat_messages table install in user_activity in stead of heartbeat.
Default messages themself would be inserted by the hook_enable. I ran this test several time now and it works great for me.
I will run some more but in the mean time, could you give me a little more feedback on how you installed. (Could be something was left after a previous install?)

thx in advance

Flying Drupalist’s picture

Flying Drupalist commented

I think the table installed OK. I tried installing all at once *initially, then tried to reinstall various parts at other times. I'm still getting this error and there seems to be no checkbox for the uninstall. But I see the table in my database manager.

I think I've seen errors of this sort before, and it was always because there is no database prefix when referencing it.

Thank you for this great module.

Errors when trying it out today:

user warning: Table 'a.heartbeat_messages' doesn't exist query: heartbeat_event_messages /* Miraploy : heartbeat_event_messages */ SELECT event, message, message_concat, variables from heartbeat_messages in /home/webadmin/mydai.net/html/sites/all/modules/heartbeat/heartbeat.module on line 231.

Edit:
Hi, it's very likely that it's a prefixing issue, I just tested on a non-prefixed site and it works great. Thanks.

Flying Drupalist’s picture

Flying Drupalist commented

Hi, I got the latest package.

user warning: Table 'z.heartbeat_messages' doesn't exist query: heartbeat_messages /* Miraploy : heartbeat_messages */ SELECT * FROM heartbeat_messages in /home/webadmin/mydai.net/html/sites/all/modules/heartbeat/heartbeat.module on line 228.

On heartbeat settings.

The error is somewhat different now.

on module page:

user warning: Table 'z.heartbeat_messages' doesn't exist query: heartbeat_event_messages /* Miraploy : heartbeat_event_messages */ SELECT event, message, message_concat, variables from heartbeat_messages in /home/webadmin/mydai.net/html/sites/all/modules/heartbeat/heartbeat.module on line 266.

Stalski’s picture

Stalski commented
Status: Active » Needs review

this seems fixed now :)
Thx for the great testing work

Flying Drupalist’s picture

Flying Drupalist commented

I'm getting a white screen with this error on the heartbeat/messages page:
Fatal error: Call to undefined function dsm() in /home/webadmin/html/sites/all/modules/heartbeat/heartbeat.module on line 217

This is using the 2.3 version.

Using the dev version I'm still getting this error:

# user warning: Table 'a.heartbeat_messages' doesn't exist query: SELECT * FROM heartbeat_messages in /home/webadmin/html/sites/all/modules/heartbeat/heartbeat.module on line 228.

Though the page loads. No messages displaying though.

Thanks for helping me. :) Really excited to use your module.

Stalski’s picture

Stalski commented
Assigned: Unassigned » Stalski
Status: Needs review » Needs work

Hey Miraploy,

I am working every day a little on it. The error you displayed is a stupid mistake of me. I released to early (am testing cvs as well, relatively new for me).
the development version does not have that issue. I am testing the install on a multilingual site with friendlist, og in it (a community site) and on a clean install as well. I don't get the second error (heart_messages does not exist) but i will look into this again.
Thx for so much cooperation. This really helps me move on ;)

Stalski

Flying Drupalist’s picture

Flying Drupalist commented

Hi, thanks for all your help.

Are you testing on a site installed with a prefix? Because comparison testing shows that the error only appears then. Thanks.

Flying Drupalist’s picture

Flying Drupalist commented

Hi Stalski, I got the settings page working by adding curley braces, around heartbeat_messages in a few places.

{heartbeat_messages} instead of heartbeat_messages.

But I didn't actually get the messages to work because the braces are probably still missing for other tables, and I can't tell which :).

Thanks.

Stalski’s picture

Stalski commented

Miraploy,

This is really bad practice and a stupid mistake of me. You said something about prefixes and i did not see the problem. You are completely correct ofcourse.

This is changed and will be taken with the next nightly dev.
Your testing is of unbelievable great value to me because it speeds up the development. I have taken the difficult path to build the heartbeat core in. That is: One base module (user_activity) and ONE contribute (friendlist) . I use two languages in the site and switch often to one (disabling one language). This is mainly because this is a test project and i don't even know yet if everything i want to do, is even possible the way I am handling things.
Do you program a lot yourself? In fact, if you have further idea's or have remarks about the way i am doing things, just shoot.

Thx again

Stalski!

Stalski’s picture

Stalski commented
Status: Needs work » Fixed

The bugs fixed that are listed in this issue:

- missing brackets
- missing heartbeat_messages table due to incorrect install order of modules
- missing default messages , no done through hook_heartbeat_message_info

If these errors come up again , and after you completely removed the module, you can reopen this issue or make a new one.

Thx
@Miraploy: Thx a lot

Flying Drupalist’s picture

Flying Drupalist commented
Status: Fixed » Active

Hi, thanks for all your help.

I'm still getting this.

user warning: Table 'test2.user_activity' doesn't exist query: INSERT INTO user_activity SET uid=1, uid_target=0, nid_target=2, hid=0, language='en', message='', timestamp=1227746864, event='event_node_insert', variables='' in /home/webadmin/html/sites/all/modules/heartbeat/heartbeat.module on line 159.

I can only do testing, I'm not a developer, it's just that I've seen this error loads of times. There are probably still some braces missing.

Thanks again for this module.

Flying Drupalist’s picture

Flying Drupalist commented

So I did this:

db_query("INSERT INTO user_activity SET uid=%d, uid_target=%d, nid_target=%d, hid=%d, language='%s',
->
db_query("INSERT INTO {user_activity} SET uid=%d, uid_target=%d, nid_target=%d, hid=%d, language='%s',

And it works fine.

Stalski’s picture

Stalski commented
Status: Active » Fixed

Fixed. Again, bad mistake , braces again. I fixed them all now and they will be in the next dev snapshot.
thx, Miraploy

Flying Drupalist’s picture

Flying Drupalist commented

By the way am I supposed to use the 3.x version now?

bensemmel’s picture

bensemmel commented

Hi Stalski,

Thank you for this module. This is what we needed. I don't know if it is related to this issue. But after activating the friendlist_activity module I get a white page with the following error:

Fatal error: Call to undefined function user_activity_rules_action_info() in mysite/sites/all/modules/heartbeat/user_activity/modules/friendlist_activity/friendlist_activity.rules.inc on line 13

I tried it using version 6.2.x dev as well as 6.3.x dev

Thank you

Ben

Flying Drupalist’s picture

Flying Drupalist commented

Also getting this one

user warning: Unknown column 'user_activity.uid' in 'where clause' query: heartbeat_block /* Miraploy : heartbeat_block */ SELECT * FROM prefix_user_activity WHERE (user_activity.uid = 1) AND (user_activity.language = 'en-US') AND timestamp > 1228050951 ORDER BY timestamp DESC in /home/webadmin/html/sites/all/modules/heartbeat/heartbeat.module on line 296.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.