Notice (8): Undefined index: School [APP/Controller/Component/SmsComponent.php, line 123]
No post data.
No querystring data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SHOW TABLES FROM `classera_g2` | 1112 | 1112 | 4 | |
SHOW FULL COLUMNS FROM `classera_g2`.`roles` | 12 | 12 | 2 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME = ? [ utf8_bin ] | 1 | 1 | 3 | maybe slow |
SELECT `Role`.`id`, `Role`.`prefix` FROM `classera_g2`.`roles` AS `Role` WHERE 1 = 1 | 35 | 35 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`permissions` | 16 | 16 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`default_all_school_settings` | 6 | 6 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`school_groups` | 22 | 22 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`countries` | 11 | 11 | 3 | maybe slow |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME = ? [ utf8_unicode_ci ] | 1 | 1 | 1 | |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME = ? [ utf8_general_ci ] | 1 | 1 | 1 | |
SHOW FULL COLUMNS FROM `classera_g2`.`users` | 108 | 108 | 2 | |
SHOW FULL COLUMNS FROM `classera_g2`.`schools` | 127 | 127 | 2 | |
SELECT `School`.`id`, `School`.`parent_id`, `School`.`name`, `School`.`english_name`, `School`.`prefix`, `School`.`city`, `School`.`country_id`, `School`.`city_id`, `School`.`school_group_id`, `School`.`management`, `School`.`number`, `School`.`address`, `School`.`about_school`, `School`.`phone_number`, `School`.`fax_number`, `School`.`email`, `School`.`website`, `School`.`logo`, `School`.`lang`, `School`.`timezone`, `School`.`date_format`, `School`.`type`, `School`.`squigl_sync_history_id`, `School`.`registration_open`, `School`.`parents_registration_open`, `School`.`created`, `School`.`modified`, `School`.`pioneer_id`, `School`.`facebook_account`, `School`.`twitter_account`, `School`.`google_plus_account`, `School`.`instagram_account`, `School`.`linkedin_account`, `School`.`allow_users_open_publicprofile`, `School`.`allow_users_upload_eportfolios`, `School`.`allow_users_upload_posts`, `School`.`publicprofiles_privecy_level_id`, `School`.`allow_students_change_password`, `School`.`allow_teachers_change_password`, `School`.`allow_others_change_password`, `School`.`allow_students_change_login_name`, `School`.`allow_teachers_change_login_name`, `School`.`allow_others_change_login_name`, `School`.`allow_students_change_profile_pic`, `School`.`show_american_question_bank`, `School`.`allow_smart_mate_generation`, `School`.`allow_teacher_to_link_preparation_standards`, `School`.`deleted`, `School`.`id_hash`, `School`.`gpa_base`, `School`.`allow_students_change_phone_number`, `School`.`allow_parents_change_phone_number`, `School`.`sms_sender_name`, `School`.`allow_tsupv_approve_preparation`, `School`.`allow_discussion_board`, `School`.`allow_students_create_discussions`, `School`.`allow_students_create_topics_in_discussions`, `School`.`absences_notification_limit`, `School`.`lectures_absences_notification_limit`, `School`.`absences_notification_excused`, `School`.`lectures_absences_notification_excused`, `School`.`absences_notification`, `School`.`lectures_absences_notification`, `School`.`allow_tsupv_show_messages_between_teachers_and_students`, `School`.`send_to_school_group_staff`, `School`.`is_mawhiba_olympics_exam_school`, `School`.`mawhiba_portal_exam_id`, `School`.`allow_managers_add_announcements`, `School`.`approved_attachments_in_library_only`, `School`.`allow_reset_password_via_sms`, `School`.`allow_school_chat`, `School`.`gender`, `School`.`noor_id`, `School`.`hide_weekends_in_weekly_plan`, `School`.`allow_students_requests`, `School`.`school_pdf_zoom`, `School`.`absences_letter`, `School`.`absences_letter_excused`, `School`.`allow_graduated_students_login`, `School`.`allow_parent_access_to_smart_class`, `School`.`implementation_phase`, `School`.`max_number_of_replies_discussion_rooms`, `School`.`educational_office_id`, `School`.`take_evidences`, `School`.`is_premium`, `School`.`is_lite`, `School`.`students_section_messages`, `School`.`acf_check`, `School`.`enabled`, `School`.`allow_students_change_email`, `School`.`allow_students_change_face`, `School`.`allow_internally_tickets`, `School`.`unit_plan_allow`, `School`.`is_mawhiba_scan_exam_school`, `School`.`show_weekends_in_schedule`, `School`.`working_days`, `School`.`manager_approve_content_publish`, `School`.`starting_day`, `School`.`simultaneous_sessions_limit`, `School`.`graduates_club_allow`, `School`.`allow_hijri_date`, `School`.`registration_age_start`, `School`.`normal_english_curriculum`, `School`.`muqrarrat_english_curriculum`, `School`.`summer_period`, `School`.`is_muqararat_school`, `School`.`clever_id`, `School`.`translation_version`, `School`.`international`, `School`.`automatically_set_full_day_absences`, `School`.`show_late_bills_warning_message`, `School`.`hide_exam_due_date`, `School`.`require_attachments`, `School`.`attachments_description`, `School`.`allow_teacher_hide_exam`, `School`.`is_edumall_school`, `School`.`mawhiba_create_automatic_stages`, `School`.`longitude`, `School`.`latitude`, `School`.`allow_student_register_course`, `School`.`activation_manager_id`, `School`.`show_contact_information_credential`, `School`.`allow_payment`, `School`.`psp_config`, `School`.`share_content`, `School`.`distance_in_kilometers`, `School`.`allow_smart_mate_attachment_generation`, `SchoolGroup`.`id`, `SchoolGroup`.`parent_id`, `SchoolGroup`.`title`, `SchoolGroup`.`logo`, `SchoolGroup`.`registration_link`, `SchoolGroup`.`registration_message`, `SchoolGroup`.`user_id`, `SchoolGroup`.`prefix`, `SchoolGroup`.`mawhiba_department_id`, `SchoolGroup`.`created`, `SchoolGroup`.`modified`, `SchoolGroup`.`deleted`, `SchoolGroup`.`send_only_from_template`, `SchoolGroup`.`template_controller_admin`, `SchoolGroup`.`clever_id`, `SchoolGroup`.`vcr_limit`, `SchoolGroup`.`allow_teacher_vcr_meeting`, `SchoolGroup`.`school_has_ad`, `SchoolGroup`.`isolated_group`, `SchoolGroup`.`activation_manager_id`, `SchoolGroup`.`number_of_license`, `SchoolGroup`.`sms_provider` FROM `classera_g2`.`schools` AS `School` LEFT JOIN `classera_g2`.`school_groups` AS `SchoolGroup` ON (`SchoolGroup`.`id` = `School`.`school_group_id`) WHERE `School`.`id` IS NULL LIMIT 1 | 0 | 0 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`stages` | 12 | 12 | 6 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`years` | 10 | 10 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`absences_notified_roles` | 5 | 5 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`absence_letters_triggers` | 5 | 5 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`lectures_absences_notified_roles` | 5 | 5 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`diagnosis` | 22 | 22 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`schools_users` | 7 | 7 | 1 | maybe slow |
SELECT `DefaultAllSchoolSetting`.`id`, `DefaultAllSchoolSetting`.`key_setting`, `DefaultAllSchoolSetting`.`value_setting`, `DefaultAllSchoolSetting`.`active`, `DefaultAllSchoolSetting`.`created`, `DefaultAllSchoolSetting`.`modified` FROM `classera_g2`.`default_all_school_settings` AS `DefaultAllSchoolSetting` WHERE `DefaultAllSchoolSetting`.`key_setting` = 'default_sms_provider' LIMIT 1 | 1 | 1 | 2 | maybe slow |
SELECT `SchoolGroup`.`id`, `SchoolGroup`.`parent_id`, `SchoolGroup`.`title`, `SchoolGroup`.`logo`, `SchoolGroup`.`registration_link`, `SchoolGroup`.`registration_message`, `SchoolGroup`.`user_id`, `SchoolGroup`.`prefix`, `SchoolGroup`.`mawhiba_department_id`, `SchoolGroup`.`created`, `SchoolGroup`.`modified`, `SchoolGroup`.`deleted`, `SchoolGroup`.`send_only_from_template`, `SchoolGroup`.`template_controller_admin`, `SchoolGroup`.`clever_id`, `SchoolGroup`.`vcr_limit`, `SchoolGroup`.`allow_teacher_vcr_meeting`, `SchoolGroup`.`school_has_ad`, `SchoolGroup`.`isolated_group`, `SchoolGroup`.`activation_manager_id`, `SchoolGroup`.`number_of_license`, `SchoolGroup`.`sms_provider` FROM `classera_g2`.`school_groups` AS `SchoolGroup` WHERE `id` IS NULL LIMIT 1 | 0 | 0 | 3 | maybe slow |
SELECT `Country`.`ID`, `Country`.`Name_English`, `Country`.`Name_Arabic`, `Country`.`Name_French`, `Country`.`Code`, `Country`.`Code2`, `Country`.`Continent`, `Country`.`Region`, `Country`.`Phone_Code`, `Country`.`Mobile_Length`, `Country`.`sms_provider` FROM `classera_g2`.`countries` AS `Country` WHERE `id` IS NULL LIMIT 1 | 0 | 0 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`teachers` | 6 | 6 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`content_reviewers` | 7 | 7 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`voices_preferences` | 5 | 5 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`badges_users` | 6 | 6 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`badges` | 8 | 8 | 2 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`fg_teachers_office_accounts` | 6 | 6 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`onlines3` | 7 | 7 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`developers_settings` | 10 | 10 | 4 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`success_partners` | 31 | 31 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`admission_exams_creators` | 5 | 5 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`accreditation_factors` | 7 | 7 | 1 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`tickets_senders` | 19 | 19 | 3 | maybe slow |
SHOW FULL COLUMNS FROM `classera_g2`.`tickets_recipients` | 5 | 5 | 1 | maybe slow |
Peak Memory Use 4.30 MB
Message | Memory use |
---|---|
Component initialization | 1.67 MB |
Controller action start | 3.42 MB |
Controller render start | 3.48 MB |
View render complete | 4.14 MB |
Total Request Time: 340 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 60.87 | |
Event: Controller.initialize | 161.90 | |
Event: Controller.startup | 3.15 | |
Controller action | 0.59 | |
Event: Controller.beforeRender | 9.96 | |
» Processing toolbar data | 9.62 | |
Rendering View | 61.13 | |
» Event: View.beforeRender | 0.17 | |
» Rendering APP/View/Users/login.ctp | 19.37 | |
» Event: View.afterRender | 0.07 | |
» Event: View.beforeLayout | 0.07 | |
» Rendering APP/View/Layouts/login.ctp #2 | 39.51 | |
» » Rendering APP/View/Elements/switch_language.ctp | 19.93 | |
» » Rendering APP/View/Elements/footer.ctp | 17.06 | |
» » » Rendering APP/View/Elements/table_export.ctp | 0.48 | |
» » » Rendering APP/View/Elements/terms_conditions.ctp | 2.90 | |
» » » Rendering APP/View/Elements/national_days.ctp | 0.50 | |
» » » Rendering APP/View/Elements/edumall_popup_element.ctp | 0.97 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
CONFIG | '/var/www/lalfawaz/app/Config/' |
HTMLPURIFIER_PREFIX | '/var/www/lalfawaz/app/Vendor/ezyang/htmlpurifier/library' |
ClasseraCardUrl | 'https://cards.classera.com/' |
PHP_FLOAT_DIG | (int) 15 |
PHP_FLOAT_EPSILON | (float) 2.2204460492503E-16 |
PHP_FLOAT_MIN | (float) 2.2250738585072E-308 |
PHP_FLOAT_MAX | (float) 1.7976931348623E+308 |
PHP_OS_FAMILY | 'Linux' |
HOA | true |
SUCCEED | true |
FAILED | false |
… | '__hoa_core_fill' |
PS | ':' |
ROOT_SEPARATOR | ';' |
RS | ';' |
CRLF | '' |
OS_WIN | false |
S_64_BITS | true |
S_32_BITS | false |
π | (float) 3.1415926535898 |
nil | null |
_public | (int) 1 |
_protected | (int) 2 |
_private | (int) 4 |
_static | (int) 8 |
_abstract | (int) 16 |
_pure | (int) 32 |
_final | (int) 64 |
_dynamic | (int) -9 |
_concrete | (int) -17 |
_overridable | (int) -65 |
WITH_COMPOSER | true |
JSON_DECODE_FOURTH_ARG | true |
PHAR_UPDATE_MANIFEST_SCHEMA | '/var/www/lalfawaz/app/Vendor/msgraph-sdk-php/vendor/herrera-io/phar-update/src/lib/../../res/schema.json' |
Constant | Value |
---|---|
APP | '/var/www/lalfawaz/app/' |
APP_DIR | 'app' |
APPLIBS | '/var/www/lalfawaz/app/Lib/' |
CACHE | '/var/www/lalfawaz/app/tmp/cache/' |
CAKE | '/var/www/lalfawaz/lib/Cake/' |
CAKE_CORE_INCLUDE_PATH | '/var/www/lalfawaz/lib' |
CORE_PATH | '/var/www/lalfawaz/lib/' |
CAKE_VERSION | '2.10.19' |
CSS | '/var/www/lalfawaz/app/webroot/css/' |
CSS_URL | 'css/' |
DS | '/' |
FULL_BASE_URL | 'https://lalfawaz.classera.com' |
IMAGES | '/var/www/lalfawaz/app/webroot/img/' |
IMAGES_URL | 'img/' |
JS | '/var/www/lalfawaz/app/webroot/js/' |
JS_URL | 'js/' |
LOGS | '/var/www/lalfawaz/app/tmp/logs/' |
ROOT | '/var/www/lalfawaz' |
TESTS | '/var/www/lalfawaz/app/Test/' |
TMP | '/var/www/lalfawaz/app/tmp/' |
VENDORS | '/var/www/lalfawaz/vendors/' |
WEBROOT_DIR | 'webroot' |
WWW_ROOT | '/var/www/lalfawaz/app/webroot/' |
Environment Variable | Value |
---|---|
Php Version | '7.1.33-48+ubuntu18.04.1+deb.sury.org+1' |
User | 'www-data' |
Home | '/var/www' |
Http Connection | 'Keep-Alive' |
Http Host | 'lalfawaz.classera.com' |
Http Accept Encoding | 'br,gzip' |
Http If Modified Since | 'Sun, 03 Jul 2022 22:56:16 GMT' |
Http Accept Language | 'en-US,en;q=0.5' |
Http Accept | 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8' |
Http User Agent | 'CCBot/2.0 (https://commoncrawl.org/faq/)' |
Application Env | 'ME' |
Redirect Status | '200' |
Server Name | 'lalfawaz.classera.com' |
Server Port | '443' |
Server Addr | '10.3.1.13' |
Remote Port | '53846' |
Remote Addr | '34.236.192.4' |
Server Software | 'nginx/1.14.0' |
Gateway Interface | 'CGI/1.1' |
Https | 'on' |
Request Scheme | 'https' |
Server Protocol | 'HTTP/1.1' |
Document Root | '/var/www/lalfawaz/app/webroot' |
Document Uri | '/index.php' |
Request Uri | '/' |
Script Name | '/index.php' |
Content Length | '' |
Content Type | '' |
Request Method | 'GET' |
Query String | '' |
Script Filename | '/var/www/lalfawaz/app/webroot/index.php' |
Path Info | '' |
Fcgi Role | 'RESPONDER' |
Php Self | '/index.php' |
Request Time Float | (float) 1660038475.8689 |
Request Time | (int) 1660038475 |