Follow Us
Warning (512): SQL Error: 1052: Column 'created' in order clause is ambiguous [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 `Blog`.`id`, `Blog`.`blog_category_id`, `Blog`.`created`, `Blog`.`title`, `Blog`.`slug`, `Blog`.`body`, `Blog`.`user_id`, `Blog`.`image_image`, `Blog`.`modified`, `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`slug`, `BlogCategory`.`blurb`, `User`.`id`, `User`.`email`, `User`.`password`, `User`.`name`, `User`.`status`, `User`.`created`, `User`.`modified` FROM `blogs` AS `Blog` LEFT JOIN `blog_categories` AS `BlogCategory` ON (`Blog`.`blog_category_id` = `BlogCategory`.`id`) LEFT JOIN `users` AS `User` ON (`Blog`.`user_id` = `User`.`id`) WHERE `blog_category_id` = 2 ORDER BY `created` DESC LIMIT 20" $error = "1052: Column 'created' in order clause is ambiguous" $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 BlogsController::ShowCategory() - APP/controllers/blogs_controller.php, line 59 BlogsController::index() - APP/controllers/blogs_controller.php, line 16 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 `Blog`.`id`, `Blog`.`blog_category_id`, `Blog`.`created`, `Blog`.`title`, `Blog`.`slug`, `Blog`.`body`, `Blog`.`user_id`, `Blog`.`image_image`, `Blog`.`modified`, `BlogCategory`.`id`, `BlogCategory`.`name`, `BlogCategory`.`slug`, `BlogCategory`.`blurb`, `User`.`id`, `User`.`email`, `User`.`password`, `User`.`name`, `User`.`status`, `User`.`created`, `User`.`modified` FROM `blogs` AS `Blog` LEFT JOIN `blog_categories` AS `BlogCategory` ON (`Blog`.`blog_category_id` = `BlogCategory`.`id`) LEFT JOIN `users` AS `User` ON (`Blog`.`user_id` = `User`.`id`) WHERE `blog_category_id` = 2 ORDER BY `created` DESC LIMIT 20
Warning (2): Invalid argument supplied for foreach() [APP/views/blogs/show_index.ctp, line 6]Code | Context<?phpforeach($Posts as $Post){$___viewFn = "/home/dswares/public_html/app/views/blogs/show_index.ctp" $___dataForView = array( "Auth" => null, "title" => "Blog - D&S Wares", "MenuSelected" => "blog", "Posts" => false, "from" => "From D&S Wares", "title_for_layout" => "Blog - D&S Wares » BigCMS v4" ) $loadHelpers = true $cached = false $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 = NULL JqueryEngineHelper::$here = "/blog/dands-wares" JqueryEngineHelper::$params = array JqueryEngineHelper::$action = "show_index" 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 = NULL JsHelper::$here = "/blog/dands-wares" JsHelper::$params = array JsHelper::$action = "show_index" 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 $paginator = PaginatorHelper PaginatorHelper::$helpers = array PaginatorHelper::$__defaultModel = NULL PaginatorHelper::$_ajaxHelperClass = "Js" PaginatorHelper::$options = array PaginatorHelper::$base = "" PaginatorHelper::$webroot = "/" PaginatorHelper::$theme = NULL PaginatorHelper::$here = "/blog/dands-wares" PaginatorHelper::$params = array PaginatorHelper::$action = "show_index" 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 $admin = AdminHelper AdminHelper::$helpers = NULL AdminHelper::$base = "" AdminHelper::$webroot = "/" AdminHelper::$theme = NULL AdminHelper::$here = "/blog/dands-wares" AdminHelper::$params = array AdminHelper::$action = "show_index" AdminHelper::$plugin = NULL AdminHelper::$data = NULL AdminHelper::$namedArgs = NULL AdminHelper::$argSeparator = NULL AdminHelper::$validationErrors = NULL AdminHelper::$tags = array AdminHelper::$__tainted = NULL AdminHelper::$__cleaned = NULL $ui = UiHelper UiHelper::$helpers = NULL UiHelper::$base = "" UiHelper::$webroot = "/" UiHelper::$theme = NULL UiHelper::$here = "/blog/dands-wares" UiHelper::$params = array UiHelper::$action = "show_index" UiHelper::$plugin = NULL UiHelper::$data = NULL UiHelper::$namedArgs = NULL UiHelper::$argSeparator = NULL UiHelper::$validationErrors = NULL UiHelper::$tags = array UiHelper::$__tainted = NULL UiHelper::$__cleaned = NULL $session = SessionHelper SessionHelper::$helpers = array SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "bcbddb0cf90371487b9b24f7b19938af" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "medium" SessionHelper::$time = 1337465178 SessionHelper::$sessionTime = 1337477178 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = true SessionHelper::$host = NULL SessionHelper::$cookieLifeTime = 604800 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/blog/dands-wares" SessionHelper::$params = array SessionHelper::$action = "show_index" SessionHelper::$data = NULL SessionHelper::$theme = NULL SessionHelper::$plugin = NULL $text = TextHelper TextHelper::$helpers = NULL TextHelper::$base = "" TextHelper::$webroot = "/" TextHelper::$theme = NULL TextHelper::$here = "/blog/dands-wares" TextHelper::$params = array TextHelper::$action = "show_index" TextHelper::$plugin = NULL TextHelper::$data = NULL TextHelper::$namedArgs = NULL TextHelper::$argSeparator = NULL TextHelper::$validationErrors = NULL TextHelper::$tags = array TextHelper::$__tainted = NULL TextHelper::$__cleaned = NULL $time = TimeHelper TimeHelper::$helpers = NULL TimeHelper::$base = "" TimeHelper::$webroot = "/" TimeHelper::$theme = NULL TimeHelper::$here = "/blog/dands-wares" TimeHelper::$params = array TimeHelper::$action = "show_index" TimeHelper::$plugin = NULL TimeHelper::$data = NULL TimeHelper::$namedArgs = NULL TimeHelper::$argSeparator = NULL TimeHelper::$validationErrors = NULL TimeHelper::$tags = array TimeHelper::$__tainted = NULL TimeHelper::$__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 = NULL FormHelper::$here = "/blog/dands-wares" FormHelper::$params = array FormHelper::$action = "show_index" 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 $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 = NULL HtmlHelper::$here = "/blog/dands-wares" HtmlHelper::$params = array HtmlHelper::$action = "show_index" HtmlHelper::$plugin = NULL HtmlHelper::$data = NULL HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL $Auth = null $title = "Blog - D&S Wares" $MenuSelected = "blog" $Posts = false $from = "From D&S Wares" $title_for_layout = "Blog - D&S Wares » BigCMS v4"include - APP/views/blogs/show_index.ctp, line 6 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 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 [main] - APP/webroot/index.php, line 83