Blank calendar page

StuRegan · 4 June 2020 14:10

As the subject says I’m unable to view the Calendar page, it just returns a blank page.
I have added a meeting, a task and an event with no issues but the calendar page is just blank.
Log file is showing no errors and when I view the page source I can see all the relevant data has been grabbed from the DB. There are no javascript errors being logged in the browser either. Have tried in Firefox and Edge.
Have tried a rebuild.
SuiteCRM Version 7.11.10 on IIS with MS SQL DB.
Any idea what I could be doing wrong?!
CRMCalendar|690x146

pgr · 4 June 2020 14:36

You need to check two server logs, it looks like you’re getting a PHP Fatal

StuRegan · 4 June 2020 14:59

Thanks.
php error log showing “PHP Notice: Undefined index: view in \SuiteCRM\include\utils\activity_utils.php on line 62”

pgr · 4 June 2020 15:24

A simple Notice wouldn’t break your screen, maybe there’s something else?

Also, to me that Notice doesn’t make sense coming from this line…

github.com

salesagility/SuiteCRM/blob/master/include/utils/activity_utils.php#L62


        $auto_where = ' WHERE ';
        if (!empty($where)) {
            $auto_where .= $where . ' AND ';
        }


        $auto_where .= " {$bean->rel_users_table}.{$bean_id_name}={$bean->table_name}.id AND {$bean->rel_users_table}.user_id='{$user_id}' AND {$bean->table_name}.deleted=0 AND {$bean->rel_users_table}.deleted=0";




        $query = $select . $auto_where;


        $result = $bean->db->query($query, true);


        $list = array();


        while ($row = $bean->db->fetchByAssoc($result)) {
            $row = $bean->convertRow($row);
            $bean->fetched_row = $row;
            $bean->fromArray($row);
//        foreach($bean->column_fields as $field) {
//            if(isset($row[$field])) {
//                $bean->$field = $row[$field];

Is that what you have in your file, or is it customized?

Please keep an eye on the time while you launch the Calendar view, and confirm that that Notice is appearing at the exact same time. The same goes for any messages you might have in suitecrm.log

StuRegan · 4 June 2020 15:52

Hi, no I have the SecuritySuite add-on installed which makes my line 62

        $cal_view = $_REQUEST['view'];

Will do a little more digging about as you suggest and see what I can find. Thanks for your input so far.

cherub-chum · 4 June 2020 19:16

Is the Security Suite Restricting user from viewing calendar? Can you create a Full Privileges role and assign it to your user to test.
Have you turned off the Display Errors for PHP ?
Do you see any errors in your Browser console (Press F12 to open up inspect panel and click on Console TAB to check errors)

StuRegan · 5 June 2020 14:21

Okay, no idea what happened with this but I decided to uninstall SuiteSecurity add-on and that completely broke my installation! ie blank page after login.
Had to completely rebuild from the ground up and now the Calendar page is working fine along with everything else including SuiteSecurity. I’m guessing something got corrupted in the DB somewhere.