Notice (8): Undefined index: CategoriaProjeto [APP/Plugin/Projetos/Controller/ProjetosController.php, line 10]
Notice (8): Undefined index: CategoriaProjeto [APP/Plugin/Projetos/Controller/ProjetosController.php, line 14]
CakePHP: the rapid development php framework: NBC Arquitetura

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'sessao' cannot be null

Error: An Internal Error Has Occurred.

Stack Trace

(default) 37 queries took 63 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `SeoKeyword`.`id`, `SeoKeyword`.`keyword` FROM `nbcarquitetura_01`.`seo_keywords` AS `SeoKeyword` WHERE 1 = 1112
2SELECT `SeoConfig`.`id`, `SeoConfig`.`title`, `SeoConfig`.`author`, `SeoConfig`.`description`, `SeoConfig`.`analytics`, `SeoConfig`.`created`, `SeoConfig`.`modified` FROM `nbcarquitetura_01`.`seo_configs` AS `SeoConfig` WHERE 1 = 1 LIMIT 1113
3SELECT `Pagina`.`title`, `Pagina`.`slug`, `Pagina`.`id` FROM `nbcarquitetura_01`.`tb_paginas_historico` AS `Pagina` WHERE 1 = 1 ORDER BY `Pagina`.`order_registro` ASC, `Pagina`.`created` DESC443
4SELECT `Video`.`id`, `Video`.`reference_id`, `Video`.`title`, `Video`.`yid`, `Video`.`order`, `Video`.`created`, (CONCAT('https://img.youtube.com/vi/',yid,'/mqdefault.jpg')) AS `Video__default`, (CONCAT('https://www.youtube.com/watch?v=',yid)) AS `Video__link`, (CONCAT('https://www.youtube.com/embed/',yid)) AS `Video__embed` FROM `nbcarquitetura_01`.`pnn_videos` AS `Video` WHERE `Video`.`reference_id` IN ('5ee8fc90-74fc-4745-b13b-1d683e7806ff', '5ee8f949-9e24-4abd-bebd-1d683e7806ff', '5eeba26a-24c0-4822-ae56-462dc0b9d524', '5ee8fd81-9428-4616-9d17-1d683e7806ff') ORDER BY `Video`.`order` ASC004
5SELECT DISTINCT gallery FROM pnn_galleries WHERE reference_id='5ee8fc90-74fc-4745-b13b-1d683e7806ff'114
6SELECT `Gallery`.`id`, `Gallery`.`reference_id`, `Gallery`.`legend`, `Gallery`.`path`, `Gallery`.`gallery`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`expires`, (CONCAT('/',path)) AS `Gallery__fullPath` FROM `nbcarquitetura_01`.`pnn_galleries` AS `Gallery` WHERE `reference_id` = '5ee8fc90-74fc-4745-b13b-1d683e7806ff' AND `gallery` = 'images' ORDER BY `Gallery`.`order` ASC, `Gallery`.`id` ASC331
7SELECT DISTINCT gallery FROM pnn_galleries WHERE reference_id='5ee8f949-9e24-4abd-bebd-1d683e7806ff'001
8SELECT DISTINCT gallery FROM pnn_galleries WHERE reference_id='5eeba26a-24c0-4822-ae56-462dc0b9d524'001
9SELECT DISTINCT gallery FROM pnn_galleries WHERE reference_id='5ee8fd81-9428-4616-9d17-1d683e7806ff'001
10SELECT `CategoriaProjeto`.`title`, `CategoriaProjeto`.`slug` FROM `nbcarquitetura_01`.`tb_projetos_categoria` AS `CategoriaProjeto` WHERE 1 = 1 ORDER BY `CategoriaProjeto`.`order_registro` ASC, `CategoriaProjeto`.`created` DESC662
11SELECT `Premio`.`title`, `Premio`.`slug`, `Premio`.`id` FROM `nbcarquitetura_01`.`tb_premios` AS `Premio` WHERE 1 = 1 ORDER BY `Premio`.`order_registro` ASC, `Premio`.`created` DESC664
12SELECT `Video`.`id`, `Video`.`reference_id`, `Video`.`title`, `Video`.`yid`, `Video`.`order`, `Video`.`created`, (CONCAT('https://img.youtube.com/vi/',yid,'/mqdefault.jpg')) AS `Video__default`, (CONCAT('https://www.youtube.com/watch?v=',yid)) AS `Video__link`, (CONCAT('https://www.youtube.com/embed/',yid)) AS `Video__embed` FROM `nbcarquitetura_01`.`pnn_videos` AS `Video` WHERE `Video`.`reference_id` IN ('5f2ab80f-e0fc-4ace-bbf9-1c29bffc3d9f', '5f2ab7ce-0f98-4f91-aa2c-1b3cbffc3d9f', '5f2ab1b6-5764-4042-a796-0c58bffc3d9f', '5f2ab170-b770-43bc-bee9-0b61bffc3d9f', '5f2ab0d2-7f4c-45c5-95ff-09fdbffc3d9f', '5f2aa128-2718-463d-88e6-645abffc3d9f') ORDER BY `Video`.`order` ASC001
13SELECT DISTINCT gallery FROM pnn_galleries WHERE reference_id='5f2ab80f-e0fc-4ace-bbf9-1c29bffc3d9f'001
14SELECT DISTINCT gallery FROM pnn_galleries WHERE reference_id='5f2ab7ce-0f98-4f91-aa2c-1b3cbffc3d9f'001
15SELECT DISTINCT gallery FROM pnn_galleries WHERE reference_id='5f2ab1b6-5764-4042-a796-0c58bffc3d9f'001
16SELECT DISTINCT gallery FROM pnn_galleries WHERE reference_id='5f2ab170-b770-43bc-bee9-0b61bffc3d9f'001
17SELECT DISTINCT gallery FROM pnn_galleries WHERE reference_id='5f2ab0d2-7f4c-45c5-95ff-09fdbffc3d9f'001
18SELECT DISTINCT gallery FROM pnn_galleries WHERE reference_id='5f2aa128-2718-463d-88e6-645abffc3d9f'001
19SELECT `Numero`.`id`, `Numero`.`numero_projetos`, `Numero`.`m_projetos`, `Numero`.`obras_executadas`, `Numero`.`obras_execucao`, `Numero`.`created`, `Numero`.`modified`, (DATE_FORMAT(`Numero`.`created`,'%d/%m/%Y %H:%i')) AS `Numero__cdate`, (DATE_FORMAT(`Numero`.`modified`,'%d/%m/%Y %H:%i')) AS `Numero__mdate` FROM `nbcarquitetura_01`.`tb_numeros` AS `Numero` WHERE 1 = 1 LIMIT 1113
20SELECT `Video`.`id`, `Video`.`reference_id`, `Video`.`title`, `Video`.`yid`, `Video`.`order`, `Video`.`created`, (CONCAT('https://img.youtube.com/vi/',yid,'/mqdefault.jpg')) AS `Video__default`, (CONCAT('https://www.youtube.com/watch?v=',yid)) AS `Video__link`, (CONCAT('https://www.youtube.com/embed/',yid)) AS `Video__embed` FROM `nbcarquitetura_01`.`pnn_videos` AS `Video` WHERE `Video`.`reference_id` = ('5f11d701-2240-4095-b2c4-274c3e7806ff') ORDER BY `Video`.`order` ASC001
21SELECT DISTINCT gallery FROM pnn_galleries WHERE reference_id='5f11d701-2240-4095-b2c4-274c3e7806ff'001
22SELECT `CategoriaProjeto`.`id`, `CategoriaProjeto`.`title`, `CategoriaProjeto`.`slug`, `CategoriaProjeto`.`created`, `CategoriaProjeto`.`modified`, `CategoriaProjeto`.`order_registro`, (DATE_FORMAT(`CategoriaProjeto`.`created`,'%d/%m/%Y')) AS `CategoriaProjeto__cdate`, (DATE_FORMAT(`CategoriaProjeto`.`modified`,'%d/%m/%Y')) AS `CategoriaProjeto__mdate` FROM `nbcarquitetura_01`.`tb_projetos_categoria` AS `CategoriaProjeto` WHERE `CategoriaProjeto`.`slug` = 'publico' LIMIT 1001
23SELECT `Projeto`.`id`, `Projeto`.`title`, `Projeto`.`texto`, `Projeto`.`imagem`, `Projeto`.`slug`, `Projeto`.`created`, `Projeto`.`modified`, `Projeto`.`order_registro`, `Projeto`.`premiado`, `Projeto`.`categoria_id`, `Projeto`.`cidade`, (DATE_FORMAT(`Projeto`.`created`,'%d/%m/%Y %H:%i')) AS `Projeto__cdate`, (DATE_FORMAT(`Projeto`.`modified`,'%d/%m/%Y %H:%i')) AS `Projeto__mdate`, `CategoriaProjeto`.`id`, `CategoriaProjeto`.`title`, `CategoriaProjeto`.`slug`, `CategoriaProjeto`.`created`, `CategoriaProjeto`.`modified`, `CategoriaProjeto`.`order_registro`, (DATE_FORMAT(`CategoriaProjeto`.`created`,'%d/%m/%Y')) AS `CategoriaProjeto__cdate`, (DATE_FORMAT(`CategoriaProjeto`.`modified`,'%d/%m/%Y')) AS `CategoriaProjeto__mdate` FROM `nbcarquitetura_01`.`tb_projetos` AS `Projeto` LEFT JOIN `nbcarquitetura_01`.`tb_projetos_categoria` AS `CategoriaProjeto` ON (`Projeto`.`categoria_id` = `CategoriaProjeto`.`id`) WHERE `Projeto`.`categoria_id` IS NULL ORDER BY `Projeto`.`order_registro` ASC, `Projeto`.`created` DESC004
24BEGIN004
25ROLLBACK004
26SELECT `SeoKeyword`.`id`, `SeoKeyword`.`keyword` FROM `nbcarquitetura_01`.`seo_keywords` AS `SeoKeyword` WHERE 1 = 1111
27SELECT `SeoConfig`.`id`, `SeoConfig`.`title`, `SeoConfig`.`author`, `SeoConfig`.`description`, `SeoConfig`.`analytics`, `SeoConfig`.`created`, `SeoConfig`.`modified` FROM `nbcarquitetura_01`.`seo_configs` AS `SeoConfig` WHERE 1 = 1 LIMIT 1111
28SELECT `Pagina`.`title`, `Pagina`.`slug`, `Pagina`.`id` FROM `nbcarquitetura_01`.`tb_paginas_historico` AS `Pagina` WHERE 1 = 1 ORDER BY `Pagina`.`order_registro` ASC, `Pagina`.`created` DESC441
29SELECT `Video`.`id`, `Video`.`reference_id`, `Video`.`title`, `Video`.`yid`, `Video`.`order`, `Video`.`created`, (CONCAT('https://img.youtube.com/vi/',yid,'/mqdefault.jpg')) AS `Video__default`, (CONCAT('https://www.youtube.com/watch?v=',yid)) AS `Video__link`, (CONCAT('https://www.youtube.com/embed/',yid)) AS `Video__embed` FROM `nbcarquitetura_01`.`pnn_videos` AS `Video` WHERE `Video`.`reference_id` IN ('5ee8fc90-74fc-4745-b13b-1d683e7806ff', '5ee8f949-9e24-4abd-bebd-1d683e7806ff', '5eeba26a-24c0-4822-ae56-462dc0b9d524', '5ee8fd81-9428-4616-9d17-1d683e7806ff') ORDER BY `Video`.`order` ASC001
30SELECT `Gallery`.`id`, `Gallery`.`reference_id`, `Gallery`.`legend`, `Gallery`.`path`, `Gallery`.`gallery`, `Gallery`.`order`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`expires`, (CONCAT('/',path)) AS `Gallery__fullPath` FROM `nbcarquitetura_01`.`pnn_galleries` AS `Gallery` WHERE `reference_id` = '5ee8fc90-74fc-4745-b13b-1d683e7806ff' AND `gallery` = 'images' ORDER BY `Gallery`.`order` ASC, `Gallery`.`id` ASC331
31SELECT `CategoriaProjeto`.`title`, `CategoriaProjeto`.`slug` FROM `nbcarquitetura_01`.`tb_projetos_categoria` AS `CategoriaProjeto` WHERE 1 = 1 ORDER BY `CategoriaProjeto`.`order_registro` ASC, `CategoriaProjeto`.`created` DESC661
32SELECT `Premio`.`title`, `Premio`.`slug`, `Premio`.`id` FROM `nbcarquitetura_01`.`tb_premios` AS `Premio` WHERE 1 = 1 ORDER BY `Premio`.`order_registro` ASC, `Premio`.`created` DESC661
33SELECT `Video`.`id`, `Video`.`reference_id`, `Video`.`title`, `Video`.`yid`, `Video`.`order`, `Video`.`created`, (CONCAT('https://img.youtube.com/vi/',yid,'/mqdefault.jpg')) AS `Video__default`, (CONCAT('https://www.youtube.com/watch?v=',yid)) AS `Video__link`, (CONCAT('https://www.youtube.com/embed/',yid)) AS `Video__embed` FROM `nbcarquitetura_01`.`pnn_videos` AS `Video` WHERE `Video`.`reference_id` IN ('5f2ab80f-e0fc-4ace-bbf9-1c29bffc3d9f', '5f2ab7ce-0f98-4f91-aa2c-1b3cbffc3d9f', '5f2ab1b6-5764-4042-a796-0c58bffc3d9f', '5f2ab170-b770-43bc-bee9-0b61bffc3d9f', '5f2ab0d2-7f4c-45c5-95ff-09fdbffc3d9f', '5f2aa128-2718-463d-88e6-645abffc3d9f') ORDER BY `Video`.`order` ASC001
34SELECT `Numero`.`id`, `Numero`.`numero_projetos`, `Numero`.`m_projetos`, `Numero`.`obras_executadas`, `Numero`.`obras_execucao`, `Numero`.`created`, `Numero`.`modified`, (DATE_FORMAT(`Numero`.`created`,'%d/%m/%Y %H:%i')) AS `Numero__cdate`, (DATE_FORMAT(`Numero`.`modified`,'%d/%m/%Y %H:%i')) AS `Numero__mdate` FROM `nbcarquitetura_01`.`tb_numeros` AS `Numero` WHERE 1 = 1 LIMIT 1111
35SELECT `Video`.`id`, `Video`.`reference_id`, `Video`.`title`, `Video`.`yid`, `Video`.`order`, `Video`.`created`, (CONCAT('https://img.youtube.com/vi/',yid,'/mqdefault.jpg')) AS `Video__default`, (CONCAT('https://www.youtube.com/watch?v=',yid)) AS `Video__link`, (CONCAT('https://www.youtube.com/embed/',yid)) AS `Video__embed` FROM `nbcarquitetura_01`.`pnn_videos` AS `Video` WHERE `Video`.`reference_id` = ('5f11d701-2240-4095-b2c4-274c3e7806ff') ORDER BY `Video`.`order` ASC001
36BEGIN001
37ROLLBACK001