Sugar 6.1 - no reminders, calendar empty, calls_users table empty

[tomkerswill]

Hi

We have two new installs of Sugar 6.1.

We are noticing that the calendar does not show any calls. Also call reminder popups are not working.

I've taken a look at the database queries that are run by when populating the calendar and when creating reminders.

All these queries rely on matching the user to the call, using the calls_users table.

But in both my new Sugar installs, even after creating lots of calls for different users, I notice that the calls_users table is empty:

mysql> select * from calls_users;
Empty set (0.00 sec)

Is this a bug? Or has something changed in the DB architecture for the latest Sugar?

Tom

[tomkerswill]

Hi

From looking quite closely at this, I think this may be a bug in Sugar --- call reminders and calendars just aren't working out the box. I guess the database schema changed. As a work around (to fix reminders), I updated the code in include/javascript/jsAlerts.php

This is the updated SQL query, code added into prep calls:

// Prep Calls Query
if ($db->dbType == 'mysql') {

$selectCalls = "

SELECT calls.id, name, reminder_time, description, date_start
FROM calls
WHERE assigned_user_id ='".$current_user->id."'
AND calls.reminder_time != -1
AND deleted != 1
AND calls.status != 'Held'
and date_start >= '".$dateTimeNow."'";

Tom

[tomkerswill]

Hi

I'm just wondering if anyone else who's using Sugar 6.1 has noticed reminders working out of the box? It looks to me like they just don't work at all without changing the database queries above, but maybe something strange is happening in my environment to stop this working.

Is the calls_users table used in Sugar 6.1, or has something changed to simplify / update the database schema?

Tom

[davidboris]

Hello,

Follow this thread and do it for calls and you will find everything working well.