Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
session_start - [internal], line ??
CakeSession::__startSession() - CORE/cake/libs/cake_session.php, line 587
CakeSession::start() - CORE/cake/libs/cake_session.php, line 219
SessionComponent::__start() - CORE/cake/libs/controller/components/session.php, line 287
SessionComponent::read() - CORE/cake/libs/controller/components/session.php, line 137
ToolbarComponent::initialize() - CORE/plugins/debug_kit/controllers/components/toolbar.php, line 116
Component::initialize() - CORE/cake/libs/controller/component.php, line 98
Controller::startupProcess() - CORE/cake/libs/controller/controller.php, line 521
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 187
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83
The police stopped the driver and asked him to pay GH 5.00 without which he could not be allowed to continue his journey.
Status note
After GSA staff's second attempt, the driver was released.
Progress update note
GSA staff tried to speak to the Police but the officers refused to cooperate. After some times, GSA staff made another attempt to speak with the Police in vain. GSA staff then gave their Focal Person in the Police Service, Dr. Sasu Mensah's number to the driver.
Dr. Sasu Mensah also tried to speak to his colleagues in vain. His colleagues refused to collaborate.
After another attempt from the GSA staff to speak to the officers, the driver was released
SELECT `Complaint`.`id`, `Complaint`.`unique_number`, `Complaint`.`user_id`, `Complaint`.`user_details`, `Complaint`.`user_email`, `Complaint`.`complaint`, `Complaint`.`original_complaint`, `Complaint`.`country_id`, `Complaint`.`town_id`, `Complaint`.`imposing_region_id`, `Complaint`.`reporting_country_id`, `Complaint`.`reporting_region_id`, `Complaint`.`location_type_id`, `Complaint`.`location_id`, `Complaint`.`location_other`, `Complaint`.`date_of_incident`, `Complaint`.`ntb_type_id`, `Complaint`.`ntb_type_other`, `Complaint`.`ntm_code_id`, `Complaint`.`status_id`, `Complaint`.`product_description`, `Complaint`.`country_origin_id`, `Complaint`.`currency_id`, `Complaint`.`value`, `Complaint`.`original_locale`, `Complaint`.`is_spam`, `Complaint`.`resolved_date`, `Complaint`.`created`, `Complaint`.`created_by`, `Complaint`.`modified`, `Complaint`.`modified_by`, `Complaint`.`progress_update`, `Complaint`.`offline`, `Complaint`.`offline_comment`, `Complaint`.`policy`, `User`.`id`, `User`.`email`, `User`.`email_authenticated`, `User`.`email_token`, `User`.`email_token_expires`, `User`.`passwd`, `User`.`password_token`, `User`.`first_name`, `User`.`last_name`, `User`.`gender`, `User`.`country_id`, `User`.`telephone_number`, `User`.`cellphone_number`, `User`.`fax_number`, `User`.`sector_id`, `User`.`sector_other`, `User`.`locale`, `User`.`active`, `User`.`role_id`, `User`.`login_count`, `User`.`last_login`, `User`.`created`, `User`.`modified`, (concat(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__name`, `Country`.`id`, `Country`.`name`, `Country`.`short_name`, `Country`.`fre_name`, `Country`.`fre_short_name`, `Country`.`por_name`, `Country`.`por_short_name`, `Country`.`currency`, `Country`.`member`, `Town`.`id`, `Town`.`country_id`, `Town`.`name`, `ImposingRegion`.`id`, `ImposingRegion`.`name`, `ReportingCountry`.`id`, `ReportingCountry`.`name`, `ReportingCountry`.`short_name`, `ReportingCountry`.`fre_name`, `ReportingCountry`.`fre_short_name`, `ReportingCountry`.`por_name`, `ReportingCountry`.`por_short_name`, `ReportingCountry`.`currency`, `ReportingCountry`.`member`, `ReportingRegion`.`id`, `ReportingRegion`.`name`, `Currency`.`id`, `Currency`.`name`, `Currency`.`short_name`, `Currency`.`fre_name`, `Currency`.`fre_short_name`, `Currency`.`por_name`, `Currency`.`por_short_name`, `Currency`.`currency`, `Currency`.`member`, `Location`.`id`, `Location`.`name`, `Location`.`location_type_id`, `Location`.`country_id`, `NtbType`.`id`, `NtbType`.`name`, `NtbType`.`short_name`, `NtbType`.`description`, `NtbType`.`parent_id`, `NtbType`.`heading_number`, `NtbType`.`allow`, `NtbType`.`link_id`, `NtbType`.`ntm_code_id`, `NtbType`.`position`, (CONCAT(`NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, '.0. ', '. '), `NtbType`.`name`)) AS `NtbType__headingName`, (CONCAT(IF(`NtbType`.`parent_id` is null, 'Category ', ''), `NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, ': ', '. '), `NtbType`.`name`)) AS `NtbType__fullName`, `NtmCode`.`id`, `NtmCode`.`level`, `NtmCode`.`code`, `NtmCode`.`description`, `NtmCode`.`parent_id`, `OriginatingCountry`.`id`, `OriginatingCountry`.`name`, `OriginatingCountry`.`short_name`, `OriginatingCountry`.`fre_name`, `OriginatingCountry`.`fre_short_name`, `OriginatingCountry`.`por_name`, `OriginatingCountry`.`por_short_name`, `OriginatingCountry`.`currency`, `OriginatingCountry`.`member`, `LocationType`.`id`, `LocationType`.`name`, `LocationType`.`order`, `LocationType`.`select_box`, `Status`.`id`, `Status`.`name`, `Status`.`order`, `Status`.`default`, `Status`.`rejected`, `Status`.`resolved`, `Status`.`nonactionable`, `ResolutionComment`.`id`, `ResolutionComment`.`complaint_id`, `ResolutionComment`.`user_id`, `ResolutionComment`.`comment`, `ResolutionComment`.`resolution`, `ResolutionComment`.`created`, `ResolutionComment`.`modified` FROM `complaints` AS `Complaint` LEFT JOIN `users` AS `User` ON (`Complaint`.`user_id` = `User`.`id`) LEFT JOIN `countries` AS `Country` ON (`Complaint`.`country_id` = `Country`.`id`) LEFT JOIN `towns` AS `Town` ON (`Complaint`.`town_id` = `Town`.`id`) LEFT JOIN `regions` AS `ImposingRegion` ON (`Complaint`.`imposing_region_id` = `ImposingRegion`.`id`) LEFT JOIN `countries` AS `ReportingCountry` ON (`Complaint`.`reporting_country_id` = `ReportingCountry`.`id`) LEFT JOIN `regions` AS `ReportingRegion` ON (`Complaint`.`reporting_region_id` = `ReportingRegion`.`id`) LEFT JOIN `countries` AS `Currency` ON (`Complaint`.`currency_id` = `Currency`.`id`) LEFT JOIN `locations` AS `Location` ON (`Complaint`.`location_id` = `Location`.`id`) LEFT JOIN `ntb_types` AS `NtbType` ON (`Complaint`.`ntb_type_id` = `NtbType`.`id`) LEFT JOIN `ntm_codes` AS `NtmCode` ON (`Complaint`.`ntm_code_id` = `NtmCode`.`id`) LEFT JOIN `countries` AS `OriginatingCountry` ON (`Complaint`.`country_origin_id` = `OriginatingCountry`.`id`) LEFT JOIN `location_types` AS `LocationType` ON (`Complaint`.`location_type_id` = `LocationType`.`id`) LEFT JOIN `statuses` AS `Status` ON (`Complaint`.`status_id` = `Status`.`id`) LEFT JOIN `comments` AS `ResolutionComment` ON (`ResolutionComment`.`complaint_id` = `Complaint`.`id` AND `ResolutionComment`.`resolution` = 1) WHERE `Complaint`.`id` = '60b4dced-1ec0-4eb6-b2ae-ac11c5bdc882' ORDER BY `Complaint`.`modified` DESC LIMIT 1
1
1
2
maybe slow
SELECT `Country`.`id`, `Country`.`name`, `Country`.`short_name`, `Country`.`fre_name`, `Country`.`fre_short_name`, `Country`.`por_name`, `Country`.`por_short_name`, `Country`.`currency`, `Country`.`member` FROM `countries` AS `Country` WHERE `Country`.`id` = 'GH'
1
1
0
SELECT `ReportingCountry`.`id`, `ReportingCountry`.`name`, `ReportingCountry`.`short_name`, `ReportingCountry`.`fre_name`, `ReportingCountry`.`fre_short_name`, `ReportingCountry`.`por_name`, `ReportingCountry`.`por_short_name`, `ReportingCountry`.`currency`, `ReportingCountry`.`member` FROM `countries` AS `ReportingCountry` WHERE `ReportingCountry`.`id` = 'BF'
1
1
0
SELECT `NtbType`.`id`, `NtbType`.`name`, `NtbType`.`short_name`, `NtbType`.`description`, `NtbType`.`parent_id`, `NtbType`.`heading_number`, `NtbType`.`allow`, `NtbType`.`link_id`, `NtbType`.`ntm_code_id`, `NtbType`.`position`, (CONCAT(`NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, '.0. ', '. '), `NtbType`.`name`)) AS `NtbType__headingName`, (CONCAT(IF(`NtbType`.`parent_id` is null, 'Category ', ''), `NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, ': ', '. '), `NtbType`.`name`)) AS `NtbType__fullName` FROM `ntb_types` AS `NtbType` WHERE `NtbType`.`id` = 'other'
0
0
0
SELECT `LocationType`.`id`, `LocationType`.`name`, `LocationType`.`order`, `LocationType`.`select_box` FROM `location_types` AS `LocationType` WHERE `LocationType`.`id` = '4ca35901-cc64-46fe-bc12-1e79c0a80305'
1
1
0
SELECT `Status`.`id`, `Status`.`name`, `Status`.`order`, `Status`.`default`, `Status`.`rejected`, `Status`.`resolved`, `Status`.`nonactionable` FROM `statuses` AS `Status` WHERE `Status`.`id` = '4cc5a0e4-33ec-4f36-a85c-4278c0a80305'
1
1
0
SELECT `ResolutionComment`.`id`, `ResolutionComment`.`complaint_id`, `ResolutionComment`.`user_id`, `ResolutionComment`.`comment`, `ResolutionComment`.`resolution`, `ResolutionComment`.`created`, `ResolutionComment`.`modified` FROM `comments` AS `ResolutionComment` WHERE `ResolutionComment`.`complaint_id` = '60b4dced-1ec0-4eb6-b2ae-ac11c5bdc882' AND `ResolutionComment`.`resolution` = 1
1
1
0
SELECT `ComplaintsLocale`.`trans_id`, `ComplaintsLocale`.`id`, `ComplaintsLocale`.`complaint`, `ComplaintsLocale`.`locale` FROM `complaints_locales` AS `ComplaintsLocale` WHERE `ComplaintsLocale`.`id` = ('60b4dced-1ec0-4eb6-b2ae-ac11c5bdc882')
0
0
0
SELECT `Comment`.`id`, `Comment`.`complaint_id`, `Comment`.`user_id`, `Comment`.`comment`, `Comment`.`resolution`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`resolution` = 0 AND `Comment`.`complaint_id` = ('60b4dced-1ec0-4eb6-b2ae-ac11c5bdc882')
0
0
0
SELECT `Sms`.`id`, `Sms`.`number`, `Sms`.`user_id`, `Sms`.`complaint_id`, `Sms`.`message`, `Sms`.`incoming`, `Sms`.`read`, `Sms`.`response`, `Sms`.`language`, `Sms`.`parent_id`, `Sms`.`thread_closed`, `Sms`.`created`, `Sms`.`modified` FROM `sms` AS `Sms` WHERE `Sms`.`parent_id` IS NULL AND `Sms`.`complaint_id` = ('60b4dced-1ec0-4eb6-b2ae-ac11c5bdc882')
0
0
0
SELECT `Attachment`.`id`, `Attachment`.`class`, `Attachment`.`foreign_key`, `Attachment`.`description`, `Attachment`.`original_file`, `Attachment`.`saved_file`, `Attachment`.`created`, `Attachment`.`modified` FROM `attachments` AS `Attachment` WHERE `Attachment`.`class` = 'Complaint' AND `Attachment`.`foreign_key` = ('60b4dced-1ec0-4eb6-b2ae-ac11c5bdc882')
0
0
0
SELECT `TariffCode`.`id`, `TariffCode`.`heading`, `TariffCode`.`description`, `TariffCode`.`parent_id`, `TariffCode`.`lft`, `TariffCode`.`rght`, (concat(`TariffCode`.`heading`, ": ", `TariffCode`.`description`)) AS `TariffCode__name`, `ComplaintsTariffCode`.`id`, `ComplaintsTariffCode`.`complaint_id`, `ComplaintsTariffCode`.`tariff_code_id` FROM `tariff_codes` AS `TariffCode` JOIN `complaints_tariff_codes` AS `ComplaintsTariffCode` ON (`ComplaintsTariffCode`.`complaint_id` = '60b4dced-1ec0-4eb6-b2ae-ac11c5bdc882' AND `ComplaintsTariffCode`.`tariff_code_id` = `TariffCode`.`id`)
0
0
0
SELECT `Region`.`id`, `Region`.`name`, `ComplaintsRegion`.`id`, `ComplaintsRegion`.`complaint_id`, `ComplaintsRegion`.`region_id` FROM `regions` AS `Region` JOIN `complaints_regions` AS `ComplaintsRegion` ON (`ComplaintsRegion`.`complaint_id` = '60b4dced-1ec0-4eb6-b2ae-ac11c5bdc882' AND `ComplaintsRegion`.`region_id` = `Region`.`id`)
2
2
0
SELECT `FocalPoint`.`id`, `FocalPoint`.`country_id`, `FocalPoint`.`national_address`, `FocalPoint`.`national_contact_number`, `FocalPoint`.`national_email_address`, `FocalPoint`.`private_address`, `FocalPoint`.`private_contact_number`, `FocalPoint`.`private_email_address`, `ComplaintsFocalPoint`.`id`, `ComplaintsFocalPoint`.`complaint_id`, `ComplaintsFocalPoint`.`focal_point_id` FROM `focal_points` AS `FocalPoint` JOIN `complaints_focal_points` AS `ComplaintsFocalPoint` ON (`ComplaintsFocalPoint`.`complaint_id` = '60b4dced-1ec0-4eb6-b2ae-ac11c5bdc882' AND `ComplaintsFocalPoint`.`focal_point_id` = `FocalPoint`.`id`)
2
2
0
SELECT `Country`.`id`, `Country`.`name`, `Country`.`short_name`, `Country`.`fre_name`, `Country`.`fre_short_name`, `Country`.`por_name`, `Country`.`por_short_name`, `Country`.`currency`, `Country`.`member` FROM `countries` AS `Country` WHERE `Country`.`id` = 'BF'
1
1
0
SELECT `NtbType`.`id`, `NtbType`.`name`, `NtbType`.`short_name`, `NtbType`.`description`, `NtbType`.`parent_id`, `NtbType`.`heading_number`, `NtbType`.`allow`, `NtbType`.`link_id`, `NtbType`.`ntm_code_id`, `NtbType`.`position`, (CONCAT(`NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, '.0. ', '. '), `NtbType`.`name`)) AS `NtbType__headingName`, (CONCAT(IF(`NtbType`.`parent_id` is null, 'Category ', ''), `NtbType`.`heading_number`, IF(`NtbType`.`parent_id` is null, ': ', '. '), `NtbType`.`name`)) AS `NtbType__fullName` FROM `ntb_types` AS `NtbType` WHERE `NtbType`.`allow` = 1 ORDER BY `NtbType`.`position` ASC
77
77
0
SELECT `Status`.`id`, `Status`.`name` FROM `statuses` AS `Status` WHERE 1 = 1 ORDER BY `Status`.`order` ASC
7
7
0
Query Explain:
Click an "Explain" link above, to see the query explanation.
progress_updateGSA staff tried to speak to the Police but the officers refused to cooperate. After some times, GSA staff made another attempt to speak with the Police in vain. GSA staff then gave their Focal Person in the Police Service, Dr. Sasu Mensah's number to the driver.
Dr. Sasu Mensah also tried to speak to his colleagues in vain. His colleagues refused to collaborate.
After another attempt from the GSA staff to speak to the officers, the driver was released
offline0
offline_comment
policy0
complaint_languageThe police stopped the driver and asked him to pay GH 5.00 without which he could not be allowed to continue his journey.
User
id(null)
email(null)
email_authenticated(null)
email_token(null)
email_token_expires(null)
passwd(null)
password_token(null)
first_name(null)
last_name(null)
gender(null)
country_id(null)
telephone_number(null)
cellphone_number(null)
fax_number(null)
sector_id(null)
sector_other(null)
locale(null)
active(null)
role_id(null)
login_count(null)
last_login(null)
created(null)
modified(null)
name(null)
Country
idGH
nameGhana
short_name
fre_nameGhana
fre_short_name
por_nameGana
por_short_name
currencyCedi
member1
Town
id(null)
country_id(null)
name(null)
ImposingRegion
id(null)
name(null)
ReportingCountry
idBF
nameBurkina Faso
short_name
fre_nameBurkina Faso
fre_short_name
por_nameBurkina Faso
por_short_name
currency
member1
ReportingRegion
id(null)
name(null)
Currency
id(null)
name(null)
short_name(null)
fre_name(null)
fre_short_name(null)
por_name(null)
por_short_name(null)
currency(null)
member(null)
Location
id(null)
name(null)
location_type_id(null)
country_id(null)
NtbType
id(null)
name(null)
short_name(null)
description(null)
parent_id(null)
heading_number(null)
allow(null)
link_id(null)
ntm_code_id(null)
position(null)
headingName(null)
fullName(null)
NtmCode
id(null)
level(null)
code(null)
description(null)
parent_id(null)
OriginatingCountry
id(null)
name(null)
short_name(null)
fre_name(null)
fre_short_name(null)
por_name(null)
por_short_name(null)
currency(null)
member(null)
LocationType
id4ca35901-cc64-46fe-bc12-1e79c0a80305
nameOther
order100
select_box0
Status
id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
nameResolved
order5
default0
rejected0
resolved1
nonactionable0
ResolutionComment
id60b4dd78-2058-4d97-83e0-abfdc5bdc882
complaint_id60b4dced-1ec0-4eb6-b2ae-ac11c5bdc882
user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
commentAfter GSA staff's second attempt, the driver was released.
Debugger::handleError() - CORE/cake/libs/debugger.php, line 306
[main] - [internal], line ??
Warning: Illegal string offset 'file' in /var/www/common/frameworks/cake1.3/plugins/debug_kit/vendors/debug_kit_debugger.php on line 358
Warning: Illegal string offset 'line' in /var/www/common/frameworks/cake1.3/plugins/debug_kit/vendors/debug_kit_debugger.php on line 358
Warning (2): Unknown: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (/opt/remi/php56/root/var/lib/php/session) [Unknown, line ??]