SecuritySuite - SuiteCRM and CE Teams

I looked into what the Calendar is doing and I can't see how you would be running out of memory with PHP. If there is any load it will be on the database side, but even then it should only be the same as if a non-admin went to the list view of any of those modules (meetings, calls, tasks).

If your calendar is at a stand still and needs to work right this minute then I'd advise finding a blank 6.5.17 instance and copying these 4 files into your system (reverts the calendar to work as it does without SecuritySuite installed):

• include/utils/activity_utils.php
• modules/Calendar/CalendarActivity.php
• modules/Calendar/CalendarDisplay.php
• modules/Calendar/tpls/shared_users.tpl

-Jason

Found the issue, blame lies with Sugar. In case you hear of anyone else with this issue, I located the solution here: http://www.sugaruk.co.uk/blog/sugar-6516-calendar-speed-issues. It was related to 6.5.16, but issue persists in 6.5.17.

Hello Jason,

we have the exact same Issue witch suitecrm taht usees the core sugarcrm 6.5.20, is there a solution for this problem?

we are currently using SecurityGroups - Full Edition 2.8.1

Looks like the link to the solution is broken. The problem is in the Calendar module, file: modules/Calendar/CalendarActivity.php on line 187.

change: ~~~ $where = self::get_occurs_until_where_clause($meeting->table_name, $meeting->rel_users_table, $view_start_time, $view_end_time, 'date_start', $view);

to: ~~~
$where = self::get_occurs_within_where_clause($meeting->table_name, $meeting->rel_users_table, $view_start_time, $view_end_time, 'date_start', $view);

Looks like I cannot edit my comment and the previous formatting looks bad, so to clarify:

on or around line 187 in modules/Calendar/CalendarActivity.php change: $where = self::get_occurs_until_where_clause($meeting->table_name, $meeting->rel_users_table, $view_start_time, $view_end_time, 'date_start', $view); to: $where = self::get_occurs_within_where_clause($meeting->table_name, $meeting->rel_users_table, $view_start_time, $view_end_time, 'date_start', $view);

the function get_occurs_until_where_clause does not take the start date into consideration and pulls all events until the end date. So a new user will not notice this issue, it only affects users after they have entered a few hundred meetings. changing the function to get_occurs_within_where_clause uses the calendar date range reducing the number of records the form has to process.

Thank you very much for a quick solution

The solution worked perfectly, thanks again