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 ')' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 666]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 COUNT(*) AS `count` FROM `news` AS `News` WHERE `News`.`status` = 1 AND `News`.`published` <= '2012-02-04' AND `News`.`id` NOT IN () " $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 ')' at line 1" $out = nullDboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 666 DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 256 DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 400 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 805 Model::find() - CORE/cake/libs/model/model.php, line 2084 Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1204 NewsController::archive() - APP/controllers/news_controller.php, line 49 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 Object::requestAction() - CORE/cake/libs/object.php, line 95 include - APP/views/themed/default/pages/display.ctp, line 173 View::_render() - CORE/cake/libs/view/view.php, line 723 View::render() - CORE/cake/libs/view/view.php, line 419 Controller::render() - CORE/cake/libs/controller/controller.php, line 909 AppController::render() - APP/app_controller.php, line 56 PagesController::display() - APP/controllers/pages_controller.php, line 74
Query: SELECT COUNT(*) AS `count` FROM `news` AS `News` WHERE `News`.`status` = 1 AND `News`.`published` <= '2012-02-04' AND `News`.`id` NOT IN ()
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 `News`.`published` desc LIMIT 5' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 666]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 `News`.`id`, `News`.`published`, `News`.`title`, `News`.`alias`, `News`.`text`, `News`.`extension`, `News`.`document_extension`, `News`.`document_title`, `News`.`status`, `News`.`created`, `News`.`modified` FROM `news` AS `News` WHERE `News`.`status` = 1 AND `News`.`published` <= '2012-02-04' AND `News`.`id` NOT IN () ORDER BY `News`.`published` desc LIMIT 5" $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 `News`.`published` desc LIMIT 5' at line 1" $out = nullDboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 666 DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 256 DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 400 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 805 Model::find() - CORE/cake/libs/model/model.php, line 2084 Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1224 NewsController::archive() - APP/controllers/news_controller.php, line 49 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 Object::requestAction() - CORE/cake/libs/object.php, line 95 include - APP/views/themed/default/pages/display.ctp, line 173 View::_render() - CORE/cake/libs/view/view.php, line 723 View::render() - CORE/cake/libs/view/view.php, line 419 Controller::render() - CORE/cake/libs/controller/controller.php, line 909 AppController::render() - APP/app_controller.php, line 56 PagesController::display() - APP/controllers/pages_controller.php, line 74
Query: SELECT `News`.`id`, `News`.`published`, `News`.`title`, `News`.`alias`, `News`.`text`, `News`.`extension`, `News`.`document_extension`, `News`.`document_title`, `News`.`status`, `News`.`created`, `News`.`modified` FROM `news` AS `News` WHERE `News`.`status` = 1 AND `News`.`published` <= '2012-02-04' AND `News`.`id` NOT IN () ORDER BY `News`.`published` desc LIMIT 5
- Page 0 of 1
-
Archive
Warning (2): Invalid argument supplied for foreach() [APP/views/themed/default/news/archive.ctp, line 54]Code | Context</div><?php echo $this->element('misc/shadow/bottom') ?><?php foreach($data as $item): ?>$___viewFn = "/var/www/vhosts/stratalondon.com/httpdocs/app/views/themed/default/news/archive.ctp" $___dataForView = array( "data" => false, "crumbs" => null, "app_title" => "Strata London", "app_email" => "support@stratalondon.com", "default_app" => "/dashboard", "current_page" => array( "Page" => array(), "Layout" => array(), "Content" => array(), "Box" => array() ), "archive_page" => array( "Page" => array(), "Layout" => array(), "Content" => array(), "Box" => array() ) ) $loadHelpers = true $cached = false $paginator = PaginatorHelper PaginatorHelper::$helpers = array PaginatorHelper::$__defaultModel = "News" PaginatorHelper::$_ajaxHelperClass = "Js" PaginatorHelper::$options = array PaginatorHelper::$base = "" PaginatorHelper::$webroot = "/" PaginatorHelper::$theme = "default" PaginatorHelper::$here = "/news/archive" PaginatorHelper::$params = array PaginatorHelper::$action = "archive" PaginatorHelper::$plugin = NULL PaginatorHelper::$data = NULL PaginatorHelper::$namedArgs = NULL PaginatorHelper::$argSeparator = NULL PaginatorHelper::$validationErrors = NULL PaginatorHelper::$tags = array PaginatorHelper::$__tainted = NULL PaginatorHelper::$__cleaned = NULL PaginatorHelper::$Html = HtmlHelper object PaginatorHelper::$Js = JsHelper object $jqueryEngine = JqueryEngineHelper JqueryEngineHelper::$_optionMap = array JqueryEngineHelper::$_callbackArguments = array JqueryEngineHelper::$jQueryObject = "$" JqueryEngineHelper::$useNative = true JqueryEngineHelper::$selection = NULL JqueryEngineHelper::$bufferedMethods = array JqueryEngineHelper::$helpers = NULL JqueryEngineHelper::$base = "" JqueryEngineHelper::$webroot = "/" JqueryEngineHelper::$theme = "default" JqueryEngineHelper::$here = "/news/archive" JqueryEngineHelper::$params = array JqueryEngineHelper::$action = "archive" JqueryEngineHelper::$plugin = NULL JqueryEngineHelper::$data = NULL JqueryEngineHelper::$namedArgs = NULL JqueryEngineHelper::$argSeparator = NULL JqueryEngineHelper::$validationErrors = NULL JqueryEngineHelper::$tags = array JqueryEngineHelper::$__tainted = NULL JqueryEngineHelper::$__cleaned = NULL $js = JsHelper JsHelper::$bufferScripts = true JsHelper::$helpers = array JsHelper::$__jsVars = array JsHelper::$__bufferedScripts = array JsHelper::$__engineName = "JqueryEngine" JsHelper::$setVariable = "app" JsHelper::$base = "" JsHelper::$webroot = "/" JsHelper::$theme = "default" JsHelper::$here = "/news/archive" JsHelper::$params = array JsHelper::$action = "archive" JsHelper::$plugin = NULL JsHelper::$data = NULL JsHelper::$namedArgs = NULL JsHelper::$argSeparator = NULL JsHelper::$validationErrors = NULL JsHelper::$tags = array JsHelper::$__tainted = NULL JsHelper::$__cleaned = NULL JsHelper::$Html = HtmlHelper object JsHelper::$Form = FormHelper object JsHelper::$JqueryEngine = JqueryEngineHelper object $customPaginator = CustomPaginatorHelper CustomPaginatorHelper::$options = array CustomPaginatorHelper::$parameters = "" CustomPaginatorHelper::$helpers = array CustomPaginatorHelper::$__defaultModel = "News" CustomPaginatorHelper::$_ajaxHelperClass = "Js" CustomPaginatorHelper::$base = "" CustomPaginatorHelper::$webroot = "/" CustomPaginatorHelper::$theme = "default" CustomPaginatorHelper::$here = "/news/archive" CustomPaginatorHelper::$params = array CustomPaginatorHelper::$action = "archive" CustomPaginatorHelper::$plugin = NULL CustomPaginatorHelper::$data = NULL CustomPaginatorHelper::$namedArgs = NULL CustomPaginatorHelper::$argSeparator = NULL CustomPaginatorHelper::$validationErrors = NULL CustomPaginatorHelper::$tags = array CustomPaginatorHelper::$__tainted = NULL CustomPaginatorHelper::$__cleaned = NULL CustomPaginatorHelper::$Html = HtmlHelper object CustomPaginatorHelper::$Js = JsHelper object $number = NumberHelper NumberHelper::$_currencies = array NumberHelper::$_currencyDefaults = array NumberHelper::$helpers = NULL NumberHelper::$base = "" NumberHelper::$webroot = "/" NumberHelper::$theme = "default" NumberHelper::$here = "/news/archive" NumberHelper::$params = array NumberHelper::$action = "archive" NumberHelper::$plugin = NULL NumberHelper::$data = NULL NumberHelper::$namedArgs = NULL NumberHelper::$argSeparator = NULL NumberHelper::$validationErrors = NULL NumberHelper::$tags = array NumberHelper::$__tainted = NULL NumberHelper::$__cleaned = NULL $pagination = PaginationHelper PaginationHelper::$helpers = array PaginationHelper::$_pageDetails = array PaginationHelper::$total = "0" PaginationHelper::$style = NULL PaginationHelper::$link = "" PaginationHelper::$show = array PaginationHelper::$page = "1" PaginationHelper::$total_page = NULL PaginationHelper::$update = "ajax-list" PaginationHelper::$loading = "loading" PaginationHelper::$base = "" PaginationHelper::$webroot = "/" PaginationHelper::$theme = "default" PaginationHelper::$here = "/news/archive" PaginationHelper::$params = array PaginationHelper::$action = "archive" PaginationHelper::$plugin = NULL PaginationHelper::$data = NULL PaginationHelper::$namedArgs = NULL PaginationHelper::$argSeparator = NULL PaginationHelper::$validationErrors = NULL PaginationHelper::$tags = array PaginationHelper::$__tainted = NULL PaginationHelper::$__cleaned = NULL PaginationHelper::$Html = HtmlHelper object PaginationHelper::$Ajax = AjaxHelper object $time = TimeHelper TimeHelper::$helpers = NULL TimeHelper::$base = "" TimeHelper::$webroot = "/" TimeHelper::$theme = "default" TimeHelper::$here = "/news/archive" TimeHelper::$params = array TimeHelper::$action = "archive" TimeHelper::$plugin = NULL TimeHelper::$data = NULL TimeHelper::$namedArgs = NULL TimeHelper::$argSeparator = NULL TimeHelper::$validationErrors = NULL TimeHelper::$tags = array TimeHelper::$__tainted = NULL TimeHelper::$__cleaned = NULL $text = TextHelper TextHelper::$helpers = NULL TextHelper::$base = "" TextHelper::$webroot = "/" TextHelper::$theme = "default" TextHelper::$here = "/news/archive" TextHelper::$params = array TextHelper::$action = "archive" TextHelper::$plugin = NULL TextHelper::$data = NULL TextHelper::$namedArgs = NULL TextHelper::$argSeparator = NULL TextHelper::$validationErrors = NULL TextHelper::$tags = array TextHelper::$__tainted = NULL TextHelper::$__cleaned = NULL $form = FormHelper FormHelper::$helpers = array FormHelper::$fieldset = array FormHelper::$__options = array FormHelper::$fields = array FormHelper::$requestType = NULL FormHelper::$defaultModel = NULL FormHelper::$_inputDefaults = array FormHelper::$base = "" FormHelper::$webroot = "/" FormHelper::$theme = "default" FormHelper::$here = "/news/archive" FormHelper::$params = array FormHelper::$action = "archive" 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::$Html = HtmlHelper object $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::$theme = "default" JavascriptHelper::$here = "/news/archive" JavascriptHelper::$params = array JavascriptHelper::$action = "archive" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = 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::$theme = "default" AjaxHelper::$here = "/news/archive" AjaxHelper::$params = array AjaxHelper::$action = "archive" 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::$Form = FormHelper object $html = HtmlHelper HtmlHelper::$tags = array HtmlHelper::$_crumbs = array HtmlHelper::$__includedScripts = array HtmlHelper::$_scriptBlockOptions = array HtmlHelper::$__docTypes = array HtmlHelper::$helpers = NULL HtmlHelper::$base = "" HtmlHelper::$webroot = "/" HtmlHelper::$theme = "default" HtmlHelper::$here = "/news/archive" HtmlHelper::$params = array HtmlHelper::$action = "archive" HtmlHelper::$plugin = NULL HtmlHelper::$data = NULL HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL $data = false $crumbs = null $app_title = "Strata London" $app_email = "support@stratalondon.com" $default_app = "/dashboard" $current_page = array( "Page" => array( "id" => "266", "parent_id" => "252", "lft" => "60", "rght" => "61", "level" => "1", "title" => "Latest News", "alias" => "latest-news", "alias_path" => "news/latest-news", "link_id" => null, "external_url" => "", "layout_id" => "8", "nav_main" => "0", "nav_footer" => "0", "nav_header" => "0", "addon" => "1", "return_link" => "0", "suppress_sitemap" => "0", "meta_description" => "", "meta_keywords" => "", "sorting" => "2", "status" => "1", "created" => "2009-03-03 12:38:30", "modified" => "2009-03-09 11:03:51" ), "Layout" => array( "id" => "8", "title" => "Default", "alias" => "default", "created" => "2008-06-20 13:21:06", "modified" => "2008-06-20 13:21:06" ), "Content" => array( array(), array() ), "Box" => array() ) $archive_page = array( "Page" => array( "id" => "265", "parent_id" => "252", "lft" => "62", "rght" => "63", "level" => "1", "title" => "News Archive", "alias" => "news-archive", "alias_path" => "news/news-archive", "link_id" => null, "external_url" => "", "layout_id" => "8", "nav_main" => "0", "nav_footer" => "0", "nav_header" => "0", "addon" => "2", "return_link" => "0", "suppress_sitemap" => "0", "meta_description" => "", "meta_keywords" => "", "sorting" => "1", "status" => "1", "created" => "2009-03-02 17:41:11", "modified" => "2009-03-09 14:05:00" ), "Layout" => array( "id" => "8", "title" => "Default", "alias" => "default", "created" => "2008-06-20 13:21:06", "modified" => "2008-06-20 13:21:06" ), "Content" => array( array(), array() ), "Box" => array() ) $params = array() $val = "/news/archive" $key = "url" $params_string = "" $page = 0include - APP/views/themed/default/news/archive.ctp, line 54 View::_render() - CORE/cake/libs/view/view.php, line 723 View::render() - CORE/cake/libs/view/view.php, line 419 Controller::render() - CORE/cake/libs/controller/controller.php, line 909 AppController::render() - APP/app_controller.php, line 56 NewsController::archive() - APP/controllers/news_controller.php, line 50 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 Object::requestAction() - CORE/cake/libs/object.php, line 95 include - APP/views/themed/default/pages/display.ctp, line 173 View::_render() - CORE/cake/libs/view/view.php, line 723 View::render() - CORE/cake/libs/view/view.php, line 419 Controller::render() - CORE/cake/libs/controller/controller.php, line 909 AppController::render() - APP/app_controller.php, line 56 PagesController::display() - APP/controllers/pages_controller.php, line 74 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204
- Page 0 of 1
-