Warning (2): ini_set() [<a href='http://php.net/function.ini-set'>function.ini-set</a>]: Headers already sent. You cannot change the session module's ini settings at this time [CORE/Cake/Model/Datasource/CakeSession.php, line 553]
CakePHP: the rapid development php framework: Errors

SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

Error: An Internal Error Has Occurred.

Stack Trace

  • CORE/Cake/Model/Datasource/DboSource.php line 470PDOStatement->execute(array)
  • CORE/Cake/Model/Datasource/DboSource.php line 436DboSource->_execute(string, array)
  • CORE/Cake/Model/Datasource/DboSource.php line 673DboSource->execute(string, array, array)
  • CORE/Cake/Model/Datasource/DboSource.php line 609DboSource->fetchAll(string, array)
  • CORE/Cake/Model/Model.php line 3470DboSource->query(string, boolean)
  • APP/Controller/IgfsController.php line 70Model->query(string)
  • [internal function]IgfsController->edition(string)
  • CORE/Cake/Controller/Controller.php line 491ReflectionMethod->invokeArgs(IgfsController, array)
  • CORE/Cake/Routing/Dispatcher.php line 193Controller->invokeAction(CakeRequest)
  • CORE/Cake/Routing/Dispatcher.php line 167Dispatcher->_invoke(IgfsController, CakeRequest)
  • APP/webroot/index.php line 110Dispatcher->dispatch(CakeRequest, CakeResponse)
(default) 14 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Dayname`.`id`, `Dayname`.`name` FROM `foigf`.`daynames` AS `Dayname` WHERE 1 = 1660
2SELECT `Edition`.`id`, `Edition`.`forum_id`, `Edition`.`slug`, `Edition`.`logo_url`, `Edition`.`site`, `Edition`.`title`, `Edition`.`subtitle`, `Edition`.`edition`, `Edition`.`country`, `Edition`.`city`, `Edition`.`year`, `Edition`.`date_start`, `Edition`.`date_finish`, `Edition`.`qtd_sessions`, `Edition`.`created`, `Edition`.`modified`, (CONCAT(year," - ",city)) AS `Edition__title_local`, `Forum`.`id`, `Forum`.`title`, `Forum`.`slug`, `Forum`.`nickname`, `Forum`.`description`, `Forum`.`region_id`, `Forum`.`region`, `Forum`.`flag`, `Forum`.`country_id`, `Forum`.`created`, `Forum`.`modified` FROM `foigf`.`editions` AS `Edition` LEFT JOIN `foigf`.`foruns` AS `Forum` ON (`Edition`.`forum_id` = `Forum`.`id`) WHERE `Edition`.`forum_id` = 1 ORDER BY `Edition`.`year` desc13131
3SELECT `Day`.`id`, `Day`.`edition_id`, `Day`.`dayname_id`, `Day`.`date`, `Day`.`created`, `Day`.`modified` FROM `foigf`.`days` AS `Day` WHERE `Day`.`edition_id` IN (44, 43, 18, 15, 13, 12, 7, 6, 11, 8, 5, 4, 10)57570
4SELECT `Forum`.`id`, `Forum`.`title`, `Forum`.`slug`, `Forum`.`nickname`, `Forum`.`description`, `Forum`.`region_id`, `Forum`.`region`, `Forum`.`flag`, `Forum`.`country_id`, `Forum`.`created`, `Forum`.`modified`, `Region`.`id`, `Region`.`title`, `Region`.`created`, `Region`.`modified`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`created`, `Country`.`modified` FROM `foigf`.`foruns` AS `Forum` LEFT JOIN `foigf`.`regions` AS `Region` ON (`Forum`.`region_id` = `Region`.`id`) LEFT JOIN `foigf`.`countries` AS `Country` ON (`Forum`.`country_id` = `Country`.`id`) WHERE `Forum`.`region` = 'country' AND `Forum`.`nickname` <> 'IGF'440
5SELECT `Edition`.`id`, `Edition`.`forum_id`, `Edition`.`slug`, `Edition`.`logo_url`, `Edition`.`site`, `Edition`.`title`, `Edition`.`subtitle`, `Edition`.`edition`, `Edition`.`country`, `Edition`.`city`, `Edition`.`year`, `Edition`.`date_start`, `Edition`.`date_finish`, `Edition`.`qtd_sessions`, `Edition`.`created`, `Edition`.`modified`, (CONCAT(year," - ",city)) AS `Edition__title_local` FROM `foigf`.`editions` AS `Edition` WHERE `Edition`.`forum_id` IN (2, 4, 5, 6)12120
6SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`description`, `User`.`picture`, `User`.`role_id`, `User`.`last_login`, `User`.`last_ip`, `User`.`status_id`, `User`.`created`, `User`.`modified`, `UsersForum`.`id`, `UsersForum`.`user_id`, `UsersForum`.`forum_id`, `UsersForum`.`created`, `UsersForum`.`modified` FROM `foigf`.`users` AS `User` JOIN `foigf`.`users_foruns` AS `UsersForum` ON (`UsersForum`.`forum_id` IN (2, 4, 5, 6) AND `UsersForum`.`user_id` = `User`.`id`) 990
7SELECT `Edition`.`id`, `Edition`.`forum_id`, `Edition`.`slug`, `Edition`.`logo_url`, `Edition`.`site`, `Edition`.`title`, `Edition`.`subtitle`, `Edition`.`edition`, `Edition`.`country`, `Edition`.`city`, `Edition`.`year`, `Edition`.`date_start`, `Edition`.`date_finish`, `Edition`.`qtd_sessions`, `Edition`.`created`, `Edition`.`modified`, (CONCAT(year," - ",city)) AS `Edition__title_local`, `Forum`.`id`, `Forum`.`title`, `Forum`.`slug`, `Forum`.`nickname`, `Forum`.`description`, `Forum`.`region_id`, `Forum`.`region`, `Forum`.`flag`, `Forum`.`country_id`, `Forum`.`created`, `Forum`.`modified` FROM `foigf`.`editions` AS `Edition` LEFT JOIN `foigf`.`foruns` AS `Forum` ON (`Edition`.`forum_id` = `Forum`.`id`) WHERE `Edition`.`slug` = 'login.html' ORDER BY `Edition`.`year` desc LIMIT 1000
8SELECT `Day`.`id`, `Day`.`edition_id`, `Day`.`dayname_id`, `Day`.`date`, `Day`.`created`, `Day`.`modified`, `Edition`.`id`, `Edition`.`forum_id`, `Edition`.`slug`, `Edition`.`logo_url`, `Edition`.`site`, `Edition`.`title`, `Edition`.`subtitle`, `Edition`.`edition`, `Edition`.`country`, `Edition`.`city`, `Edition`.`year`, `Edition`.`date_start`, `Edition`.`date_finish`, `Edition`.`qtd_sessions`, `Edition`.`created`, `Edition`.`modified`, (CONCAT(year," - ",city)) AS `Edition__title_local`, `Dayname`.`id`, `Dayname`.`name`, `Dayname`.`number` FROM `foigf`.`days` AS `Day` LEFT JOIN `foigf`.`editions` AS `Edition` ON (`Day`.`edition_id` = `Edition`.`id`) LEFT JOIN `foigf`.`daynames` AS `Dayname` ON (`Day`.`dayname_id` = `Dayname`.`id`) WHERE `Day`.`edition_id` IS NULL000
9SELECT `Dayname`.`id`, `Dayname`.`name` FROM `foigf`.`daynames` AS `Dayname` WHERE 1 = 1660
10SELECT `Edition`.`id`, `Edition`.`forum_id`, `Edition`.`slug`, `Edition`.`logo_url`, `Edition`.`site`, `Edition`.`title`, `Edition`.`subtitle`, `Edition`.`edition`, `Edition`.`country`, `Edition`.`city`, `Edition`.`year`, `Edition`.`date_start`, `Edition`.`date_finish`, `Edition`.`qtd_sessions`, `Edition`.`created`, `Edition`.`modified`, (CONCAT(year," - ",city)) AS `Edition__title_local`, `Forum`.`id`, `Forum`.`title`, `Forum`.`slug`, `Forum`.`nickname`, `Forum`.`description`, `Forum`.`region_id`, `Forum`.`region`, `Forum`.`flag`, `Forum`.`country_id`, `Forum`.`created`, `Forum`.`modified` FROM `foigf`.`editions` AS `Edition` LEFT JOIN `foigf`.`foruns` AS `Forum` ON (`Edition`.`forum_id` = `Forum`.`id`) WHERE `Edition`.`forum_id` = 1 ORDER BY `Edition`.`year` desc13131
11SELECT `Day`.`id`, `Day`.`edition_id`, `Day`.`dayname_id`, `Day`.`date`, `Day`.`created`, `Day`.`modified` FROM `foigf`.`days` AS `Day` WHERE `Day`.`edition_id` IN (44, 43, 18, 15, 13, 12, 7, 6, 11, 8, 5, 4, 10)57570
12SELECT `Forum`.`id`, `Forum`.`title`, `Forum`.`slug`, `Forum`.`nickname`, `Forum`.`description`, `Forum`.`region_id`, `Forum`.`region`, `Forum`.`flag`, `Forum`.`country_id`, `Forum`.`created`, `Forum`.`modified`, `Region`.`id`, `Region`.`title`, `Region`.`created`, `Region`.`modified`, `Country`.`id`, `Country`.`code`, `Country`.`name`, `Country`.`created`, `Country`.`modified` FROM `foigf`.`foruns` AS `Forum` LEFT JOIN `foigf`.`regions` AS `Region` ON (`Forum`.`region_id` = `Region`.`id`) LEFT JOIN `foigf`.`countries` AS `Country` ON (`Forum`.`country_id` = `Country`.`id`) WHERE `Forum`.`region` = 'country' AND `Forum`.`nickname` <> 'IGF'440
13SELECT `Edition`.`id`, `Edition`.`forum_id`, `Edition`.`slug`, `Edition`.`logo_url`, `Edition`.`site`, `Edition`.`title`, `Edition`.`subtitle`, `Edition`.`edition`, `Edition`.`country`, `Edition`.`city`, `Edition`.`year`, `Edition`.`date_start`, `Edition`.`date_finish`, `Edition`.`qtd_sessions`, `Edition`.`created`, `Edition`.`modified`, (CONCAT(year," - ",city)) AS `Edition__title_local` FROM `foigf`.`editions` AS `Edition` WHERE `Edition`.`forum_id` IN (2, 4, 5, 6)12120
14SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`description`, `User`.`picture`, `User`.`role_id`, `User`.`last_login`, `User`.`last_ip`, `User`.`status_id`, `User`.`created`, `User`.`modified`, `UsersForum`.`id`, `UsersForum`.`user_id`, `UsersForum`.`forum_id`, `UsersForum`.`created`, `UsersForum`.`modified` FROM `foigf`.`users` AS `User` JOIN `foigf`.`users_foruns` AS `UsersForum` ON (`UsersForum`.`forum_id` IN (2, 4, 5, 6) AND `UsersForum`.`user_id` = `User`.`id`) 990