Teatro Comunale di ferrara

Warning (512): SQL Error: 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 'ORDER BY `Schedule`.`start_time` ASC' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 684]

Code | Context

            $out = null;
            if ($error) {
                trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);

$sql	=	"SELECT `Schedule`.`id`, `Schedule`.`navigation_id`, `Schedule`.`start_time`, `Schedule`.`location`, `Schedule`.`created`, `Schedule`.`modified`, `Navigation`.`id`, `Navigation`.`parent_id`, `Navigation`.`navigation_category_id`, `Navigation`.`language_id`, `Navigation`.`contact_form`, `Navigation`.`is_calendar`, `Navigation`.`stored`, `Navigation`.`name`, `Navigation`.`custom`, `Navigation`.`external`, `Navigation`.`link_title`, `Navigation`.`title`, `Navigation`.`short_title`, `Navigation`.`description`, `Navigation`.`body`, `Navigation`.`author`, `Navigation`.`director`, `Navigation`.`start`, `Navigation`.`end`, `Navigation`.`calendar_date`, `Navigation`.`meta_title`, `Navigation`.`meta_keywords`, `Navigation`.`meta_description`, `Navigation`.`meta_abstract`, `Navigation`.`meta_robot`, `Navigation`.`position`, `Navigation`.`active`, `Navigation`.`home`, `Navigation`.`publication`, `Navigation`.`created`, `Navigation`.`modified` FROM `schedules` AS `Schedule` LEFT JOIN `navigations` AS `Navigation` ON (`Schedule`.`navigation_id` = `Navigation`.`id`)  WHERE YEAR(`Schedule`.`start_time`)>=2012 AND YEAR(`Schedule`.`start_time`)<=2013 AND MONTH(`Schedule`.`start_time`)=   ORDER BY `Schedule`.`start_time` ASC "
$error	=	"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 'ORDER BY `Schedule`.`start_time` ASC' at line 1"
$out	=	null

DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 684
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 266
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 410
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 823
Model::find() - CORE/cake/libs/model/model.php, line 2127
NavigationsController::display() - APP/controllers/navigations_controller.php, line 63
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

Query: SELECT `Schedule`.`id`, `Schedule`.`navigation_id`, `Schedule`.`start_time`, `Schedule`.`location`, `Schedule`.`created`, `Schedule`.`modified`, `Navigation`.`id`, `Navigation`.`parent_id`, `Navigation`.`navigation_category_id`, `Navigation`.`language_id`, `Navigation`.`contact_form`, `Navigation`.`is_calendar`, `Navigation`.`stored`, `Navigation`.`name`, `Navigation`.`custom`, `Navigation`.`external`, `Navigation`.`link_title`, `Navigation`.`title`, `Navigation`.`short_title`, `Navigation`.`description`, `Navigation`.`body`, `Navigation`.`author`, `Navigation`.`director`, `Navigation`.`start`, `Navigation`.`end`, `Navigation`.`calendar_date`, `Navigation`.`meta_title`, `Navigation`.`meta_keywords`, `Navigation`.`meta_description`, `Navigation`.`meta_abstract`, `Navigation`.`meta_robot`, `Navigation`.`position`, `Navigation`.`active`, `Navigation`.`home`, `Navigation`.`publication`, `Navigation`.`created`, `Navigation`.`modified` FROM `schedules` AS `Schedule` LEFT JOIN `navigations` AS `Navigation` ON (`Schedule`.`navigation_id` = `Navigation`.`id`) WHERE YEAR(`Schedule`.`start_time`)>=2012 AND YEAR(`Schedule`.`start_time`)<=2013 AND MONTH(`Schedule`.`start_time`)= ORDER BY `Schedule`.`start_time` ASC

FERRARA – CORSO MARTIRI DELLA LIBERTÀ 5 – biglietteria.teatro@comune.fe.it – P. IVA 01772640387

Warning (2): Cannot modify header information - headers already sent by (output started at /var/www/virtual/teatrocomunaleferrara.it/vhosts/www/htdocs/cake/libs/debugger.php:673) [CORE/cake/libs/controller/components/request_handler.php, line 758]Code | Context$header	=	"Content-type: text/html; charset=UTF-8"
header - [internal], line ??
RequestHandlerComponent::_header() - CORE/cake/libs/controller/components/request_handler.php, line 758
RequestHandlerComponent::respondAs() - CORE/cake/libs/controller/components/request_handler.php, line 742
RequestHandlerComponent::startup() - CORE/cake/libs/controller/components/request_handler.php, line 243
Component::triggerCallback() - CORE/cake/libs/controller/component.php, line 186
Controller::startupProcess() - CORE/cake/libs/controller/controller.php, line 527
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 187
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
Object::requestAction() - CORE/cake/libs/object.php, line 95
include - APP/views/layouts/default.ctp, line 37
View::_render() - CORE/cake/libs/view/view.php, line 724
View::renderLayout() - CORE/cake/libs/view/view.php, line 482
View::render() - CORE/cake/libs/view/view.php, line 428
Controller::render() - CORE/cake/libs/controller/controller.php, line 913
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171
[main] - APP/webroot/index.php, line 83

Nessuno spettacolo presente per la data selezionata.

Grazie.