PostgreSQL conflict [#774324]

Hello, I'm having a problem integrating this module with PgSQL as I have had with a couple other modules. One of the modules had a fix and a patch, but I haven't seen anything for this one. Although it may be from having no activity, here is the error I get from my Personal Heartbeat:

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "'hid'" LINE 2: hm.hid AS 'hid', hm.message AS 'message_orig', ^ in /.../includes/database.pgsql.inc on line 139.
    * user warning: query: SELECT hm.hid AS 'hid', hm.message AS 'message_orig', hm.message_concat AS 'message_concat_orig', hm.attachments AS 'attachments', hm.concat_args, hm.custom AS 'custom', hm.description as 'description', hm.perms, hm.variables AS 'variables_orig', 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 < 1271561751 AND ua.timestamp > 1268883351 ) AND ((ua.uid = 3 AND hm.perms > 0 ) OR (ua.uid_target = 3 AND ua.access > 0) ) ORDER BY timestamp DESC LIMIT 30 OFFSET 0 in on line .

Comments

Comment #1

Stalski CreditAttribution: Stalski commented 18 April 2010 at 09:38

Status:

Active

» Needs work

I don't know postgress yet.
Are you willing to patch this for me or provide a sollution to it?

Comment #2

handheld_car CreditAttribution: handheld_car commented 18 April 2010 at 12:07

Yes, of course I'd be willing, but I don't know that much either. This is the problem that someone fixed - viewing private message on postgres fails. Maybe those things would work for this module. I'm assuming you don't have a Pg db, so I'll tinker around and see if there's somewhere I can insert these lines. If I fix it, I'll report back with the solution.