Email Reminders on OpenGoo don't work.

[ras]

Hello,

Email reminders aren't working and this is a critical issue for me.

I have the cron.php on the crontab, and this is the output:

When no reminders are to be sent:
2009-10-16 12:12:01 - Sending notifications...
2009-10-16 12:12:01 -  notifications sent.
2009-10-16 12:13:01 - Sending notifications...
2009-10-16 12:13:01 -  notifications sent.

When reminders are to be sent:
2009-10-16 12:11:02 - Sending reminders...
PHP Fatal error:  Call to a member function getColumnValue() on a non-object in /servers/opengoo/application/hooks/opengoo_hooks.php on line 120

I went for some debugging and this is what I came up with:
these are lines 118-120 on the offending file:

   118  function opengoo_reminder_email($reminder, &$ret) {
   119          $object = $reminder->getObject();
   120          $date = $object->getColumnValue($reminder->getContext());

A var_dump of the $object after line 119 gives out "NULL"
A var_dump of the $reminder gives out a huge structure with over 400000 lines

[a2opinion]

wow, that's a new one on me.  This problem only shows up when triggered by the cron job?  Do notifications go out ok, when pushed by a user?

[ras]

Hi,

Opengoo sends emails properly when assigning tasks, etc. I just doesn't send reminders.

The problem is with the kind of reminders that are supposed to be sent *5 minutes before appointment*, etc.

Those that are sent using cron.php.

Best regards,
ras

[ras]

Hello,

Any ideas on how to fix this?

Any other debug I can help with?

Best regards,
ras

[ras]

*fixed* I had a problem with a reminder, possibly malformed, and was blocking all other reminders.

Some other problems came up - I still wasn't able to send reminders.

Changes were made to the following files in order to fix this:

opengoo/application/models/object_subscriptions/ObjectSubscriptions.class.php
Replaced the line
    //$user_object_workspaces = $object->getWorkspaces(logged_user()->getWorkspacesQuery());
with
    $user_object_workspaces = $object->getWorkspaces($user->getWorkspacesQuery());

opengoo/cron.php (probably not the best place to place this):
Added the line
include APPLICATION_PATH . "/helpers/permissions.php";

Attached is the diff file