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
Driver was stooped by the Police who claimed he was speeding at 65 km/h whilst the driver said he was going at 55km/h. Therefore the Police asked the driver to pay GH 10.00.
Status note
After the discussion with the Inspector, the driver was released
Progress update note
When called, GSA staff spoke with a certain Inspector Dzotsi from Kintapo MTTD who affirmed what the Police said but denied asking for money.
He later told GSA staff that even if the driver was not speeding his tires are warned out.
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` = '5d2edade-9f88-43bf-b2a6-ccf6c5bdc882' 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` = '13c9ccfe-9813-11e1-be2a-00e08128b071'
1
1
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` = '5d2edade-9f88-43bf-b2a6-ccf6c5bdc882' 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` = ('5d2edade-9f88-43bf-b2a6-ccf6c5bdc882')
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` = ('5d2edade-9f88-43bf-b2a6-ccf6c5bdc882')
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` = ('5d2edade-9f88-43bf-b2a6-ccf6c5bdc882')
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` = ('5d2edade-9f88-43bf-b2a6-ccf6c5bdc882')
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` = '5d2edade-9f88-43bf-b2a6-ccf6c5bdc882' 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` = '5d2edade-9f88-43bf-b2a6-ccf6c5bdc882' 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` = '5d2edade-9f88-43bf-b2a6-ccf6c5bdc882' 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.
complaintDriver was stooped by the Police who claimed he was speeding at 65 km/h whilst the driver said he was going at 55km/h. Therefore the Police asked the driver to pay GH 10.00.
original_complaintDriver was stooped by the Police who claimed he was speeding at 65 km/h whilst the driver said he was going at 55km/h. Therefore the Police asked the driver to pay GH 10.00.
progress_updateWhen called, GSA staff spoke with a certain Inspector Dzotsi from Kintapo MTTD who affirmed what the Police said but denied asking for money.
He later told GSA staff that even if the driver was not speeding his tires are warned out.
offline0
offline_comment
policy0
complaint_languageDriver was stooped by the Police who claimed he was speeding at 65 km/h whilst the driver said he was going at 55km/h. Therefore the Police asked the driver to pay GH 10.00.
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
id13c9ccfe-9813-11e1-be2a-00e08128b071
name8.4. Transport related corruption
short_nameTransport related corruption
description
parent_id4fa77314-d5b4-4f30-8fc8-43da42c5ea45
heading_number8.4
allow1
link_id
ntm_code_id(null)
position85
headingName8.4. Transport related corruption
fullName8.4. Transport related corruption
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
id5d2edb6d-f370-4ce9-bc27-cd02c5bdc882
complaint_id5d2edade-9f88-43bf-b2a6-ccf6c5bdc882
user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
commentAfter the discussion with the Inspector, 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 ??]