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
Other type: Unnecessary delay and attempt of extortion
Complaint
Police stopped the driver and claimed to have received a signal from his colleagues that the driver drove through the red light. The driver agued that he never did and suggested a check from the monitor conected to the camera.
Status note
While GSA staff was uploading the complaint unto the platform, the driver called to report that the officers asked him to pay money and go but he told them until the truth is disclosed he wouldn't pay anything. Upon hearing this the Police released the driver.
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';
1
1
1
SHOW FULL COLUMNS FROM `acos`
7
7
1
maybe slow
SHOW FULL COLUMNS FROM `aros_acos`
9
9
1
maybe slow
SHOW FULL COLUMNS FROM `complaints`
35
35
1
SHOW FULL COLUMNS FROM `users`
23
23
1
SHOW FULL COLUMNS FROM `countries`
9
9
1
maybe slow
SHOW FULL COLUMNS FROM `focal_points`
8
8
1
maybe slow
SHOW FULL COLUMNS FROM `regions`
2
2
1
maybe slow
SHOW FULL COLUMNS FROM `complaints_regions`
3
3
1
maybe slow
SHOW FULL COLUMNS FROM `regions_users`
3
3
1
maybe slow
SHOW FULL COLUMNS FROM `focal_points_regions`
3
3
0
SHOW FULL COLUMNS FROM `focal_points_users`
3
3
1
maybe slow
SHOW FULL COLUMNS FROM `complaints_focal_points`
3
3
1
maybe slow
SHOW FULL COLUMNS FROM `towns`
3
3
0
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';
1
1
1
SHOW FULL COLUMNS FROM `sectors`
2
2
0
SHOW FULL COLUMNS FROM `sectors_locales`
4
4
0
SHOW FULL COLUMNS FROM `roles`
3
3
0
SHOW FULL COLUMNS FROM `comments`
7
7
1
maybe slow
SHOW FULL COLUMNS FROM `attachments`
8
8
0
SHOW FULL COLUMNS FROM `location_types`
4
4
1
maybe slow
SHOW FULL COLUMNS FROM `locations`
4
4
0
SHOW FULL COLUMNS FROM `location_types_locales`
4
4
0
SHOW FULL COLUMNS FROM `ntb_types`
10
10
0
SHOW FULL COLUMNS FROM `ntb_types_locales`
5
5
0
SHOW FULL COLUMNS FROM `statuses`
7
7
0
SHOW FULL COLUMNS FROM `statuses_locales`
4
4
0
SHOW FULL COLUMNS FROM `ntm_codes`
5
5
1
maybe slow
SHOW FULL COLUMNS FROM `complaints_locales`
4
4
0
SHOW FULL COLUMNS FROM `sms`
13
13
0
SHOW FULL COLUMNS FROM `tariff_codes`
6
6
0
SHOW FULL COLUMNS FROM `complaints_tariff_codes`
3
3
0
SHOW FULL COLUMNS FROM `tariff_codes_locales`
4
4
0
SHOW FULL COLUMNS FROM `emails`
4
4
0
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` = '653137b3-9d30-4aee-85d3-4f23c5bdc882' ORDER BY `Complaint`.`modified` DESC LIMIT 1
1
1
1
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` = '653137b3-9d30-4aee-85d3-4f23c5bdc882' 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` = ('653137b3-9d30-4aee-85d3-4f23c5bdc882')
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` = ('653137b3-9d30-4aee-85d3-4f23c5bdc882')
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` = ('653137b3-9d30-4aee-85d3-4f23c5bdc882')
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` = ('653137b3-9d30-4aee-85d3-4f23c5bdc882')
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` = '653137b3-9d30-4aee-85d3-4f23c5bdc882' 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` = '653137b3-9d30-4aee-85d3-4f23c5bdc882' AND `ComplaintsRegion`.`region_id` = `Region`.`id`)
0
0
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` = '653137b3-9d30-4aee-85d3-4f23c5bdc882' AND `ComplaintsFocalPoint`.`focal_point_id` = `FocalPoint`.`id`)
0
0
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.
user_detailsOuedraogo Issa
1048 E203
Tel: 0595034888
user_emailgershonewman@gmail.com
complaintPolice stopped the driver and claimed to have received a signal from his colleagues that the driver drove through the red light. The driver agued that he never did and suggested a check from the monitor conected to the camera.
original_complaintPolice stopped the driver and claimed to have received a signal from his colleagues that the driver drove through the red light. The driver agued that he never did and suggested a check from the monitor conected to the camera.
ntb_type_otherUnnecessary delay and attempt of extortion
ntm_code_id(null)
status_id4cc5a0e4-33ec-4f36-a85c-4278c0a80305
product_description
country_origin_id
currency_id
value(null)
original_localeeng
is_spam0
resolved_date2023-10-19
created2023-10-19 16:05:39
created_by59831f6f-40e4-40e1-88c0-449dc5bdc882
modified2023-10-19 16:05:39
modified_by
progress_update(null)
offline0
offline_comment
policy0
complaint_languagePolice stopped the driver and claimed to have received a signal from his colleagues that the driver drove through the red light. The driver agued that he never did and suggested a check from the monitor conected to the camera.
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
id653137b3-d4a8-42a5-a283-4f23c5bdc882
complaint_id653137b3-9d30-4aee-85d3-4f23c5bdc882
user_id59831f6f-40e4-40e1-88c0-449dc5bdc882
commentWhile GSA staff was uploading the complaint unto the platform, the driver called to report that the officers asked him to pay money and go but he told them until the truth is disclosed he wouldn't pay anything. Upon hearing this the Police released the driver.
resolution1
created2023-10-19 16:05:39
modified2023-10-19 16:05:39
ComplaintsLocale(empty)
Comment(empty)
Sms(empty)
Attachment(empty)
TariffCode(empty)
Region(empty)
FocalPoint(empty)
ntbTypes
Category 1. Government participation in trade & restrictive practices tolerated by governments
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 ??]