Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 291]
Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 291]
Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 292]
Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 292]
Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 300]
Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 300]
Notice (8): Trying to access array offset on value of type null [APP/Controller/UsersController.php, line 310]
If you've forgotten your password, type your email address here.
You will be sent a link to reset your password.
If you have any questions or problems using the system, please get in touch at the email or phone number listed below.
Nr | Query | Error | Affected | Num. rows | Took (ms) |
---|---|---|---|---|---|
1 | SELECT `UserAclLeaf`.`id`, `UserAclLeaf`.`user_id`, `UserAclLeaf`.`acl_alias`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`change_pw_flag`, `User`.`clinic_id`, `User`.`language`, `User`.`last4ssn`, `User`.`registered`, `User`.`study_group`, `User`.`email_confirmed`, `User`.`phone1`, `User`.`birthdate`, `User`.`agreed_to_terms`, `User`.`phone1_confirmed`, `User`.`alt_contact_email`, `User`.`comm_pref`, `User`.`external_id`, (IFNULL(`User`.`email`, `User`.`phone1`)) AS `User__email_or_phone` FROM `cpro`.`user_acl_leafs` AS `UserAclLeaf` LEFT JOIN `cpro`.`users` AS `User` ON (`UserAclLeaf`.`user_id` = `User`.`id`) WHERE `UserAclLeaf`.`user_id` IS NULL | 0 | 0 | 0 | |
2 | SELECT `Clinic`.`id`, `Clinic`.`site_id`, `Clinic`.`name`, `Clinic`.`friendly_name`, `Clinic`.`support_name`, `Clinic`.`state`, `Clinic`.`irb_contact`, `Clinic`.`support_email`, `Clinic`.`support_phone`, `Clinic`.`patient_status_email`, `Clinic`.`one_usual_care_session`, `Site`.`id`, `Site`.`name`, `Site`.`friendly_name`, `Site`.`timezone`, `Site`.`research_staff_email_alias`, `Site`.`research_staff_signature`, `Site`.`new_aim_consent_mod_date` FROM `cpro`.`clinics` AS `Clinic` LEFT JOIN `cpro`.`sites` AS `Site` ON (`Clinic`.`site_id` = `Site`.`id`) WHERE 1 = 1 | 1 | 1 | 1 | |
3 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`change_pw_flag`, `User`.`clinic_id`, `User`.`language`, `User`.`last4ssn`, `User`.`registered`, `User`.`study_group`, `User`.`email_confirmed`, `User`.`phone1`, `User`.`birthdate`, `User`.`agreed_to_terms`, `User`.`phone1_confirmed`, `User`.`alt_contact_email`, `User`.`comm_pref`, `User`.`external_id`, (IFNULL(`User`.`email`, `User`.`phone1`)) AS `User__email_or_phone` FROM `cpro`.`users` AS `User` WHERE `User`.`clinic_id` = (1) | 40 | 40 | 1 | |
4 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `cpro`.`aros` AS `Aro` WHERE `Aro`.`alias` = 'aroPatientTechSupport' LIMIT 1 | 1 | 1 | 5 | |
5 | SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, `Aco`.`foreign_key`, `Aco`.`alias`, `Aco`.`lft`, `Aco`.`rght`, `Permission`.`id`, `Permission`.`aro_id`, `Permission`.`aco_id`, `Permission`.`_create`, `Permission`.`_read`, `Permission`.`_update`, `Permission`.`_delete` FROM `cpro`.`acos` AS `Aco` JOIN `cpro`.`aros_acos` AS `Permission` ON (`Permission`.`aro_id` = 26 AND `Permission`.`aco_id` = `Aco`.`id`) | 4 | 4 | 1 | |
6 | SELECT `Aro`.`lft`, `Aro`.`rght` FROM `cpro`.`aros` AS `Aro` WHERE 1 = 1 AND `Aro`.`id` = 26 LIMIT 1 | 1 | 1 | 0 | |
7 | SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias`, `Aro`.`lft`, `Aro`.`rght` FROM `cpro`.`aros` AS `Aro` WHERE 1 = 1 AND `Aro`.`rght` < 55 AND `Aro`.`lft` > 54 ORDER BY `Aro`.`lft` asc | 0 | 0 | 0 | |
8 | SELECT `UserAclLeaf`.`id`, `UserAclLeaf`.`user_id`, `UserAclLeaf`.`acl_alias`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`change_pw_flag`, `User`.`clinic_id`, `User`.`language`, `User`.`last4ssn`, `User`.`registered`, `User`.`study_group`, `User`.`email_confirmed`, `User`.`phone1`, `User`.`birthdate`, `User`.`agreed_to_terms`, `User`.`phone1_confirmed`, `User`.`alt_contact_email`, `User`.`comm_pref`, `User`.`external_id`, (IFNULL(`User`.`email`, `User`.`phone1`)) AS `User__email_or_phone` FROM `cpro`.`user_acl_leafs` AS `UserAclLeaf` LEFT JOIN `cpro`.`users` AS `User` ON (`UserAclLeaf`.`user_id` = `User`.`id`) WHERE `UserAclLeaf`.`user_id` IS NULL | 0 | 0 | 0 |