CakePHP: the rapid development php framework: Errors

Missing View

Error: The view for PagesController::insuranceCompanies() was not found.

Error: Confirm you have created the file: /home/elventails/Sites/deployments/deploy-2024-aug-14_16_04_29/app-panda7-staging/views/pages/insurance_companies/sunlife.ctp

Notice: If you want to customize this error message, create app-panda7-staging/views/errors/missing_view.ctp

(default) 49 queries took 68 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SHOW FULL COLUMNS FROM `settings`	6	6	2
2	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb4_general_ci';	1	1	2
3	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'Permissions_Policy_header_status' LIMIT 1	1	1	1
4	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'Permissions_Policy_header_value' LIMIT 1	1	1	1
5	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_PROJECT_ID' LIMIT 1	1	1	2
6	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_APIKEY' LIMIT 1	1	1	1
7	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_DEFAULT_NAMESPACE' LIMIT 1	1	1	1
8	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_ADDITIONAL_NAMESPACES' LIMIT 1	1	1	1
9	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_PROJECT_ID' LIMIT 1	1	1	1
10	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_APIKEY' LIMIT 1	1	1	1
11	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_DEFAULT_NAMESPACE' LIMIT 1	1	1	1
12	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_ADDITIONAL_NAMESPACES' LIMIT 1	1	1	1
13	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_PROJECT_ID' LIMIT 1	1	1	2
14	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_APIKEY' LIMIT 1	1	1	1
15	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_DEFAULT_NAMESPACE' LIMIT 1	1	1	1
16	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_ADDITIONAL_NAMESPACES' LIMIT 1	1	1	1
17	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_PROJECT_ID' LIMIT 1	1	1	1
18	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_APIKEY' LIMIT 1	1	1	1
19	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_DEFAULT_NAMESPACE' LIMIT 1	1	1	1
20	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_ADDITIONAL_NAMESPACES' LIMIT 1	1	1	1
21	SHOW FULL COLUMNS FROM `emaillogs`	22	22	3
22	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_unicode_ci';	1	1	2
23	SHOW FULL COLUMNS FROM `short_urls`	5	5	2
24	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci';	1	1	2
25	SHOW FULL COLUMNS FROM `emailsmstemplates`	10	10	2
26	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'EMAIL_SUBJECT_PREFIX' LIMIT 1	1	1	1
27	SHOW FULL COLUMNS FROM `products`	12	12	2
28	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'cookie_consent_banner_state' LIMIT 1	1	1	1
29	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'block_ips' LIMIT 1	1	1	2
30	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'user_ip_header' LIMIT 1	1	1	1
31	SHOW FULL COLUMNS FROM `blockips`	7	7	2
32	SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';	1	1	2
33	SHOW FULL COLUMNS FROM `whitelist_ips`	7	7	2
34	SELECT * FROM whitelist_ips WHERE "216.73.216.97" RLIKE `ipaddress` AND `status`="active"	0	0	1
35	SELECT * FROM blockips AS Blockip WHERE "216.73.216.97" RLIKE `ipaddress` AND `status`="active"	0	0	1
36	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_PROJECT_ID' LIMIT 1	1	1	1
37	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_APIKEY' LIMIT 1	1	1	1
38	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_DEFAULT_NAMESPACE' LIMIT 1	1	1	1
39	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_ADDITIONAL_NAMESPACES' LIMIT 1	1	1	1
40	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_PROJECT_ID' LIMIT 1	1	1	1
41	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_APIKEY' LIMIT 1	1	1	1
42	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_DEFAULT_NAMESPACE' LIMIT 1	1	1	1
43	SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'TARJIM_ADDITIONAL_NAMESPACES' LIMIT 1	1	1	2
44	SELECT `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`status`, `Product`.`online_forms_status`, `Product`.`order`, `Product`.`quotes_button_state`, `Product`.`db_table`, `Product`.`react_icon`, `Product`.`img`, `Product`.`created`, `Product`.`modified` FROM `products` AS `Product` WHERE `Product`.`status` = 'active' ORDER BY `order` ASC	7	7	2
45	SELECT `Settings`.`id`, `Settings`.`key`, `Settings`.`value`, `Settings`.`description`, `Settings`.`created`, `Settings`.`modified` FROM `settings` AS `Settings` WHERE `Settings`.`key` = 'giveback_page_is_active' LIMIT 1	1	1	1
46	SELECT `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`status`, `Product`.`online_forms_status`, `Product`.`order`, `Product`.`quotes_button_state`, `Product`.`db_table`, `Product`.`react_icon`, `Product`.`img`, `Product`.`created`, `Product`.`modified` FROM `products` AS `Product` WHERE `Product`.`status` = 'active' ORDER BY `order` ASC	7	7	2
47	SELECT `Settings`.`id`, `Settings`.`key`, `Settings`.`value`, `Settings`.`description`, `Settings`.`created`, `Settings`.`modified` FROM `settings` AS `Settings` WHERE `Settings`.`key` = 'giveback_page_is_active' LIMIT 1	1	1	1
48	SELECT `Settings`.`id`, `Settings`.`key`, `Settings`.`value`, `Settings`.`description`, `Settings`.`created`, `Settings`.`modified` FROM `settings` AS `Settings` WHERE `Settings`.`key` = 'adblock_modal' LIMIT 1	1	1	1
49	SELECT `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`status`, `Product`.`online_forms_status`, `Product`.`order`, `Product`.`quotes_button_state`, `Product`.`db_table`, `Product`.`react_icon`, `Product`.`img`, `Product`.`created`, `Product`.`modified` FROM `products` AS `Product` WHERE 1 = 1 ORDER BY `order` ASC	13	13	2

(default) 49 queries took 68 ms

Query

Error

Affected

Num. rows

Took (ms)

SHOW FULL COLUMNS FROM `settings`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb4_general_ci';

SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'Permissions_Policy_header_status' LIMIT 1

SHOW FULL COLUMNS FROM `emaillogs`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_unicode_ci';

SHOW FULL COLUMNS FROM `short_urls`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8mb3_general_ci';

SHOW FULL COLUMNS FROM `emailsmstemplates`

SHOW FULL COLUMNS FROM `products`

SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description`, `Setting`.`created`, `Setting`.`modified` FROM `settings` AS `Setting` WHERE `Setting`.`key` = 'block_ips' LIMIT 1

SHOW FULL COLUMNS FROM `blockips`

SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';

SHOW FULL COLUMNS FROM `whitelist_ips`

SELECT * FROM whitelist_ips WHERE "216.73.216.97" RLIKE `ipaddress` AND `status`="active"

SELECT * FROM blockips AS Blockip WHERE "216.73.216.97" RLIKE `ipaddress` AND `status`="active"

SELECT `Product`.`id`, `Product`.`name`, `Product`.`description`, `Product`.`status`, `Product`.`online_forms_status`, `Product`.`order`, `Product`.`quotes_button_state`, `Product`.`db_table`, `Product`.`react_icon`, `Product`.`img`, `Product`.`created`, `Product`.`modified` FROM `products` AS `Product` WHERE `Product`.`status` = 'active' ORDER BY `order` ASC

SELECT `Settings`.`id`, `Settings`.`key`, `Settings`.`value`, `Settings`.`description`, `Settings`.`created`, `Settings`.`modified` FROM `settings` AS `Settings` WHERE `Settings`.`key` = 'giveback_page_is_active' LIMIT 1