
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 'AND UNIX_TIMESTAMP(date)<=) AND `Event`.`enabled` = 1 ORDER BY `Event`.`date` ' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
$sql = "SELECT `Event`.`id`, `Event`.`date`, `Event`.`location`, `Event`.`allday`, `Event`.`headline`, `Event`.`detail`, `Event`.`enabled`, `Event`.`end_date`, `Event`.`repeat`, `Event`.`rend_date` FROM `events` AS `Event` WHERE (YEAR(date)=10055 AND MONTH(date)=7 OR YEAR(end_date)=10055 AND MONTH(end_date)=7 OR UNIX_TIMESTAMP(rend_date)>= AND UNIX_TIMESTAMP(date)<=) AND `Event`.`enabled` = 1 ORDER BY `Event`.`date` 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 'AND UNIX_TIMESTAMP(date)<=) AND `Event`.`enabled` = 1 ORDER BY `Event`.`date` ' at line 1" $out = null
$out = null;
if ($error) {
trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 526 DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 202 DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 337 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 654 Model::find() - CORE/cake/libs/model/model.php, line 2045 Event::findEvents() - APP/models/event.php, line 30 EventsController::view() - APP/controllers/events_controller.php, line 50 Object::dispatchMethod() - CORE/cake/libs/object.php, line 119 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193 [main] - ROOT/index.php, line 180
Query: SELECT `Event`.`id`, `Event`.`date`, `Event`.`location`, `Event`.`allday`, `Event`.`headline`, `Event`.`detail`, `Event`.`enabled`, `Event`.`end_date`, `Event`.`repeat`, `Event`.`rend_date` FROM `events` AS `Event` WHERE (YEAR(date)=10055 AND MONTH(date)=7 OR YEAR(end_date)=10055 AND MONTH(end_date)=7 OR UNIX_TIMESTAMP(rend_date)>= AND UNIX_TIMESTAMP(date)<=) AND `Event`.`enabled` = 1 ORDER BY `Event`.`date` ASC
Sun | Mon | Tue | Wed | Thu | Fri | Sat |
---|---|---|---|---|---|---|
1 |
2 |
3 |
||||
4 |
5 |
6 |
7 |
8 |
9 |
10 |
11 |
12 |
13 |
14 |
15 |
16 |
17 |
18 |
19 |
20 |
21 |
22 |
23 |
24 |
25 |
26 |
27 |
28 |
29 |
30 |
31 |