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 `Calendar`.`start_date` <= "2010-09-30 23:59:59" and `Calendar`.`start_date`' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 527]
Code |
Context$sql = "SELECT `Calendar`.`id`, `Calendar`.`user_id`, `Calendar`.`start_date`, `Calendar`.`end_date`, `Calendar`.`repeat_time`, `Calendar`.`title`, `Calendar`.`place`, `Calendar`.`description`, `Calendar`.`category_id`, `Calendar`.`created`, `Calendar`.`modified`, `CalendarCategory`.`id`, `CalendarCategory`.`name`, `CalendarCategory`.`color`, `CalendarCategory`.`repeat_time`, `CalendarCategory`.`created`, `CalendarCategory`.`modified`, `User`.`id`, `User`.`username`, `User`.`passwd`, `User`.`cookie_key`, `User`.`email`, `User`.`activation_string`, `User`.`admin`, `User`.`created`, `User`.`modified` FROM `calendars` AS `Calendar` LEFT JOIN `calendar_categories` AS `CalendarCategory` ON (`Calendar`.`category_id` = `CalendarCategory`.`id`) LEFT JOIN `users` AS `User` ON (`Calendar`.`user_id` = `User`.`id`) WHERE user_id = AND `Calendar`.`start_date` <= "2010-09-30 23:59:59" and `Calendar`.`start_date` >= "2010-09-01 00:00:00" and `Calendar`.`repeat_time` = 0
OR user_id = AND `Calendar`.`end_date` <= "2010-09-30 23:59:59" and `Calendar`.`end_date` >= "2010-09-01 00:00:00" and `Calendar`.`repeat_time` = 0
OR user_id = AND `Calendar`.`end_date` > "2010-09-30 23:59:59" and `Calendar`.`start_date` < "2010-09-01 00:00:00" and `Calendar`.`repeat_time` = 0 ORDER BY `Calendar`.`start_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 `Calendar`.`start_date` <= "2010-09-30 23:59:59" and `Calendar`.`start_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 527
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 203
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 338
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 655
Model::find() - CORE/cake/libs/model/model.php, line 2031
Model::findAll() - CORE/cake/libs/model/model.php, line 2946
CalendarsController::month() - APP/controllers/calendars_controller.php, line 112
Object::dispatchMethod() - CORE/cake/libs/object.php, line 120
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
Query: SELECT `Calendar`.`id`, `Calendar`.`user_id`, `Calendar`.`start_date`, `Calendar`.`end_date`, `Calendar`.`repeat_time`, `Calendar`.`title`, `Calendar`.`place`, `Calendar`.`description`, `Calendar`.`category_id`, `Calendar`.`created`, `Calendar`.`modified`, `CalendarCategory`.`id`, `CalendarCategory`.`name`, `CalendarCategory`.`color`, `CalendarCategory`.`repeat_time`, `CalendarCategory`.`created`, `CalendarCategory`.`modified`, `User`.`id`, `User`.`username`, `User`.`passwd`, `User`.`cookie_key`, `User`.`email`, `User`.`activation_string`, `User`.`admin`, `User`.`created`, `User`.`modified` FROM `calendars` AS `Calendar` LEFT JOIN `calendar_categories` AS `CalendarCategory` ON (`Calendar`.`category_id` = `CalendarCategory`.`id`) LEFT JOIN `users` AS `User` ON (`Calendar`.`user_id` = `User`.`id`) WHERE user_id = AND `Calendar`.`start_date` <= "2010-09-30 23:59:59" and `Calendar`.`start_date` >= "2010-09-01 00:00:00" and `Calendar`.`repeat_time` = 0
OR user_id = AND `Calendar`.`end_date` <= "2010-09-30 23:59:59" and `Calendar`.`end_date` >= "2010-09-01 00:00:00" and `Calendar`.`repeat_time` = 0
OR user_id = AND `Calendar`.`end_date` > "2010-09-30 23:59:59" and `Calendar`.`start_date` < "2010-09-01 00:00:00" and `Calendar`.`repeat_time` = 0 ORDER BY `Calendar`.`start_date` ASC
| Mo | Di | Mi | Do | Fr | Sa | So | KW |
|---|
| |
Warning (2): Invalid argument supplied for foreach() [APP/views/calendars/month.ctp, line 50]
Code |
Context$___viewFn = "/www/htdocs/w007f93a/sites/mywebload.de/app/views/calendars/month.ctp"
$___dataForView = array(
"design" => "green",
"dayname" => "Montag",
"day" => "6",
"monthname" => "Februar",
"year" => "2012",
"weeknum" => "06",
"monthnr" => "2",
"monthdays" => "30",
"firstday" => "3",
"firstweek" => 35,
"lastweek" => "39",
"viewyear" => 2010,
"viewmonthname" => "September",
"viewmonthnr" => 9,
"nextmonth" => 10,
"nextyear" => 2010,
"prevmonth" => 8,
"prevyear" => 2010,
"eventsMonth" => false,
"publicHolydays" => null
)
$loadHelpers = true
$cached = false
$loadedHelpers = array(
"ajax" => AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/Calendars/month/9/2010"
AjaxHelper::$params = array
AjaxHelper::$action = "month"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object,
"Html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/Calendars/month/9/2010"
HtmlHelper::$params = array
HtmlHelper::$action = "month"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL,
"Javascript" => JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/Calendars/month/9/2010"
JavascriptHelper::$params = array
JavascriptHelper::$action = "month"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
"Form" => FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/Calendars/month/9/2010"
FormHelper::$params = array
FormHelper::$action = "month"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object,
"calendar" => CalendarHelper
CalendarHelper::$helpers = array
CalendarHelper::$base = ""
CalendarHelper::$webroot = "/"
CalendarHelper::$themeWeb = NULL
CalendarHelper::$here = "/Calendars/month/9/2010"
CalendarHelper::$params = array
CalendarHelper::$action = "month"
CalendarHelper::$plugin = NULL
CalendarHelper::$data = NULL
CalendarHelper::$namedArgs = NULL
CalendarHelper::$argSeparator = NULL
CalendarHelper::$validationErrors = NULL
CalendarHelper::$tags = array
CalendarHelper::$__tainted = NULL
CalendarHelper::$__cleaned = NULL
CalendarHelper::$_log = NULL
CalendarHelper::$ajax = AjaxHelper object,
"time" => TimeHelper
TimeHelper::$helpers = NULL
TimeHelper::$base = ""
TimeHelper::$webroot = "/"
TimeHelper::$themeWeb = NULL
TimeHelper::$here = "/Calendars/month/9/2010"
TimeHelper::$params = array
TimeHelper::$action = "month"
TimeHelper::$plugin = NULL
TimeHelper::$data = NULL
TimeHelper::$namedArgs = NULL
TimeHelper::$argSeparator = NULL
TimeHelper::$validationErrors = NULL
TimeHelper::$tags = array
TimeHelper::$__tainted = NULL
TimeHelper::$__cleaned = NULL
TimeHelper::$_log = NULL,
"Ajax" => AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/Calendars/month/9/2010"
AjaxHelper::$params = array
AjaxHelper::$action = "month"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object,
"AjaxForm" => AjaxFormHelper
AjaxFormHelper::$helpers = array
AjaxFormHelper::$base = ""
AjaxFormHelper::$webroot = "/"
AjaxFormHelper::$themeWeb = NULL
AjaxFormHelper::$here = "/Calendars/month/9/2010"
AjaxFormHelper::$params = array
AjaxFormHelper::$action = "month"
AjaxFormHelper::$plugin = NULL
AjaxFormHelper::$data = NULL
AjaxFormHelper::$namedArgs = NULL
AjaxFormHelper::$argSeparator = NULL
AjaxFormHelper::$validationErrors = NULL
AjaxFormHelper::$tags = array
AjaxFormHelper::$__tainted = NULL
AjaxFormHelper::$__cleaned = NULL
AjaxFormHelper::$_log = NULL
AjaxFormHelper::$Ajax = AjaxHelper object
AjaxFormHelper::$Form = FormHelper object
AjaxFormHelper::$Javascript = JavascriptHelper object,
"Session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "fd9d3d81fdba9c78328ed158f77e140b"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "high"
SessionHelper::$time = 1328560630
SessionHelper::$sessionTime = 1329760630
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/Calendars/month/9/2010"
SessionHelper::$params = array
SessionHelper::$action = "month"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$helper = "Session"
$camelBackedHelper = "session"
$ajax = AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/Calendars/month/9/2010"
AjaxHelper::$params = array
AjaxHelper::$action = "month"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object
$html = HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/Calendars/month/9/2010"
HtmlHelper::$params = array
HtmlHelper::$action = "month"
HtmlHelper::$data = NULL
HtmlHelper::$_crumbs = array
HtmlHelper::$__docTypes = array
HtmlHelper::$helpers = NULL
HtmlHelper::$webroot = "/"
HtmlHelper::$themeWeb = NULL
HtmlHelper::$plugin = NULL
HtmlHelper::$namedArgs = NULL
HtmlHelper::$argSeparator = NULL
HtmlHelper::$validationErrors = NULL
HtmlHelper::$__tainted = NULL
HtmlHelper::$__cleaned = NULL
HtmlHelper::$_log = NULL
$javascript = JavascriptHelper
JavascriptHelper::$useNative = true
JavascriptHelper::$enabled = true
JavascriptHelper::$safe = false
JavascriptHelper::$tags = array
JavascriptHelper::$_blockOptions = array
JavascriptHelper::$_cachedEvents = array
JavascriptHelper::$_cacheEvents = false
JavascriptHelper::$_cacheToFile = false
JavascriptHelper::$_cacheAll = false
JavascriptHelper::$_rules = array
JavascriptHelper::$__scriptBuffer = NULL
JavascriptHelper::$helpers = NULL
JavascriptHelper::$base = ""
JavascriptHelper::$webroot = "/"
JavascriptHelper::$themeWeb = NULL
JavascriptHelper::$here = "/Calendars/month/9/2010"
JavascriptHelper::$params = array
JavascriptHelper::$action = "month"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$form = FormHelper
FormHelper::$helpers = array
FormHelper::$fieldset = array
FormHelper::$__options = array
FormHelper::$fields = array
FormHelper::$requestType = NULL
FormHelper::$base = ""
FormHelper::$webroot = "/"
FormHelper::$themeWeb = NULL
FormHelper::$here = "/Calendars/month/9/2010"
FormHelper::$params = array
FormHelper::$action = "month"
FormHelper::$plugin = NULL
FormHelper::$data = NULL
FormHelper::$namedArgs = NULL
FormHelper::$argSeparator = NULL
FormHelper::$validationErrors = NULL
FormHelper::$tags = array
FormHelper::$__tainted = NULL
FormHelper::$__cleaned = NULL
FormHelper::$_log = NULL
FormHelper::$Html = HtmlHelper object
$calendar = CalendarHelper
CalendarHelper::$helpers = array
CalendarHelper::$base = ""
CalendarHelper::$webroot = "/"
CalendarHelper::$themeWeb = NULL
CalendarHelper::$here = "/Calendars/month/9/2010"
CalendarHelper::$params = array
CalendarHelper::$action = "month"
CalendarHelper::$plugin = NULL
CalendarHelper::$data = NULL
CalendarHelper::$namedArgs = NULL
CalendarHelper::$argSeparator = NULL
CalendarHelper::$validationErrors = NULL
CalendarHelper::$tags = array
CalendarHelper::$__tainted = NULL
CalendarHelper::$__cleaned = NULL
CalendarHelper::$_log = NULL
CalendarHelper::$ajax = AjaxHelper object
$time = TimeHelper
TimeHelper::$helpers = NULL
TimeHelper::$base = ""
TimeHelper::$webroot = "/"
TimeHelper::$themeWeb = NULL
TimeHelper::$here = "/Calendars/month/9/2010"
TimeHelper::$params = array
TimeHelper::$action = "month"
TimeHelper::$plugin = NULL
TimeHelper::$data = NULL
TimeHelper::$namedArgs = NULL
TimeHelper::$argSeparator = NULL
TimeHelper::$validationErrors = NULL
TimeHelper::$tags = array
TimeHelper::$__tainted = NULL
TimeHelper::$__cleaned = NULL
TimeHelper::$_log = NULL
$ajaxForm = AjaxFormHelper
AjaxFormHelper::$helpers = array
AjaxFormHelper::$base = ""
AjaxFormHelper::$webroot = "/"
AjaxFormHelper::$themeWeb = NULL
AjaxFormHelper::$here = "/Calendars/month/9/2010"
AjaxFormHelper::$params = array
AjaxFormHelper::$action = "month"
AjaxFormHelper::$plugin = NULL
AjaxFormHelper::$data = NULL
AjaxFormHelper::$namedArgs = NULL
AjaxFormHelper::$argSeparator = NULL
AjaxFormHelper::$validationErrors = NULL
AjaxFormHelper::$tags = array
AjaxFormHelper::$__tainted = NULL
AjaxFormHelper::$__cleaned = NULL
AjaxFormHelper::$_log = NULL
AjaxFormHelper::$Ajax = AjaxHelper object
AjaxFormHelper::$Form = FormHelper object
AjaxFormHelper::$Javascript = JavascriptHelper object
$session = SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "fd9d3d81fdba9c78328ed158f77e140b"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = "high"
SessionHelper::$time = 1328560630
SessionHelper::$sessionTime = 1329760630
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/Calendars/month/9/2010"
SessionHelper::$params = array
SessionHelper::$action = "month"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$design = "green"
$dayname = "Montag"
$day = "6"
$monthname = "Februar"
$year = "2012"
$weeknum = "06"
$monthnr = "2"
$monthdays = "30"
$firstday = "3"
$firstweek = 35
$lastweek = "39"
$viewyear = 2010
$viewmonthname = "September"
$viewmonthnr = 9
$nextmonth = 10
$nextyear = 2010
$prevmonth = 8
$prevyear = 2010
$eventsMonth = false
$publicHolydays = null
$i = 3
$start_day = 1
$class = " class='"
$curEvent = 0
$z = 1
$ph = null
$d = 35
$wd = 3
$dayEvents = array()
$daytitle = null
}
}
foreach ($eventsMonth as $eventMonth) {
include - APP/views/calendars/month.ctp, line 50
View::_render() - CORE/cake/libs/view/view.php, line 666
View::render() - CORE/cake/libs/view/view.php, line 376
Controller::render() - CORE/cake/libs/controller/controller.php, line 806
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 230
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
1 | 2 | 3 | 4 | 5 | 35 |
| 6 | 7 | 8 | 9 | 10 | 11 | 12 | 36 |
| 13 | 14 | 15 | 16 | 17 | 18 | 19 | 37 |
| 20 | 21 | 22 | 23 | 24 | 25 | 26 | 38 |
| 27 | 28 | 29 | 30 | | | | 39 |
|
« |
September 2010 |
» |
|---|