Warning (512): SQL Error: 1054: Unknown column 'Product.name' in 'order clause' [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 `Product`.`id`, `Product`.`category_id`, `Product`.`brand_id`, `Product`.`title`, `Product`.`url_slug`, `Product`.`content`, `Product`.`price`, `Product`.`sale_price`, `Product`.`use_sale_price`, `Product`.`url`, `Product`.`image`, `Product`.`meta_title`, `Product`.`meta_kw`, `Product`.`meta_desc`, `Category`.`id`, `Category`.`name`, `Category`.`url_slug`, `Category`.`parent_id`, `Category`.`sort`, `Brand`.`id`, `Brand`.`name`, `Brand`.`url_slug`, `Brand`.`logo`, `Brand`.`url`, `Brand`.`meta_title`, `Brand`.`meta_kw`, `Brand`.`meta_desc` FROM `products` AS `Product` LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `brands` AS `Brand` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE 1 = 1 ORDER BY `Product`.`name` DESC " $error = "1054: Unknown column 'Product.name' in 'order clause'" $out = nullDboSource::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 2119 ProductsController::index() - APP/controllers/products_controller.php, line 45 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 `Product`.`id`, `Product`.`category_id`, `Product`.`brand_id`, `Product`.`title`, `Product`.`url_slug`, `Product`.`content`, `Product`.`price`, `Product`.`sale_price`, `Product`.`use_sale_price`, `Product`.`url`, `Product`.`image`, `Product`.`meta_title`, `Product`.`meta_kw`, `Product`.`meta_desc`, `Category`.`id`, `Category`.`name`, `Category`.`url_slug`, `Category`.`parent_id`, `Category`.`sort`, `Brand`.`id`, `Brand`.`name`, `Brand`.`url_slug`, `Brand`.`logo`, `Brand`.`url`, `Brand`.`meta_title`, `Brand`.`meta_kw`, `Brand`.`meta_desc` FROM `products` AS `Product` LEFT JOIN `categories` AS `Category` ON (`Product`.`category_id` = `Category`.`id`) LEFT JOIN `brands` AS `Brand` ON (`Product`.`brand_id` = `Brand`.`id`) WHERE 1 = 1 ORDER BY `Product`.`name` DESC
Error: The view for ProductsController::index() was not found.
Error: Confirm you have created the file: /home/manscoot/public_html/app/views/products/index.ctp
Notice: If you want to customize this error message, create app/views/errors/missing_view.ctp
Notice (8): Undefined variable: settings [APP/views/layouts/default.ctp, line 139]. All Rights Reserved.Code | Context<div class="footer_right">DL: 17534<br />© <?php echo date('Y'); ?> <?php echo $settings['Setting']['copyright']; ?>. All Rights Reserved.<br />$___viewFn = "/home/manscoot/public_html/app/views/layouts/default.ctp" $___dataForView = array( "controller" => "Products", "action" => "index", "file" => "/home/manscoot/public_html/app/views/products/index.ctp", "title" => "Missing View", "content_for_layout" => "<h2>Missing View</h2> <p class="error"> <strong>Error: </strong> The view for <em>ProductsController::</em><em>index()</em> was not found.</p> <p class="error"> <strong>Error: </strong> Confirm you have created the file: /home/manscoot/public_html/app/views/products/index.ctp</p> <p class="notice"> <strong>Notice: </strong> If you want to customize this error message, create app/views/errors/missing_view.ctp</p>", "scripts_for_layout" => "", "title_for_layout" => "Errors", "session" => SessionHelper SessionHelper::$helpers = array SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "b3835e5daa589e395a9b93070c92f786" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "medium" SessionHelper::$time = 1328582281 SessionHelper::$sessionTime = 1328594281 SessionHelper::$cookieLifeTime = false SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$host = NULL SessionHelper::$timeout = NULL SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/products" SessionHelper::$params = array SessionHelper::$action = NULL SessionHelper::$data = array SessionHelper::$theme = NULL SessionHelper::$plugin = 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 = NULL AjaxHelper::$here = "/products" AjaxHelper::$params = array AjaxHelper::$action = NULL AjaxHelper::$plugin = NULL AjaxHelper::$data = array AjaxHelper::$namedArgs = NULL AjaxHelper::$argSeparator = NULL AjaxHelper::$validationErrors = NULL AjaxHelper::$tags = array AjaxHelper::$__tainted = NULL AjaxHelper::$__cleaned = NULL AjaxHelper::$Form = FormHelper 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 = NULL JavascriptHelper::$here = "/products" JavascriptHelper::$params = array JavascriptHelper::$action = NULL JavascriptHelper::$plugin = NULL JavascriptHelper::$data = array JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__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 = "/products" FormHelper::$params = array FormHelper::$action = NULL FormHelper::$plugin = NULL FormHelper::$data = array 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 = "/products" HtmlHelper::$params = array HtmlHelper::$action = NULL HtmlHelper::$plugin = NULL HtmlHelper::$data = array HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL ) $loadHelpers = false $cached = true $loadedHelpers = array() $controller = "Products" $action = "index" $file = "/home/manscoot/public_html/app/views/products/index.ctp" $title = "Missing View" $content_for_layout = "<h2>Missing View</h2> <p class="error"> <strong>Error: </strong> The view for <em>ProductsController::</em><em>index()</em> was not found.</p> <p class="error"> <strong>Error: </strong> Confirm you have created the file: /home/manscoot/public_html/app/views/products/index.ctp</p> <p class="notice"> <strong>Notice: </strong> If you want to customize this error message, create app/views/errors/missing_view.ctp</p>" $scripts_for_layout = "" $title_for_layout = "Errors" $session = SessionHelper SessionHelper::$helpers = array SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "b3835e5daa589e395a9b93070c92f786" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "medium" SessionHelper::$time = 1328582281 SessionHelper::$sessionTime = 1328594281 SessionHelper::$cookieLifeTime = false SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$host = NULL SessionHelper::$timeout = NULL SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/products" SessionHelper::$params = array SessionHelper::$action = NULL SessionHelper::$data = array SessionHelper::$theme = NULL SessionHelper::$plugin = 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 = NULL AjaxHelper::$here = "/products" AjaxHelper::$params = array AjaxHelper::$action = NULL AjaxHelper::$plugin = NULL AjaxHelper::$data = array AjaxHelper::$namedArgs = NULL AjaxHelper::$argSeparator = NULL AjaxHelper::$validationErrors = NULL AjaxHelper::$tags = array AjaxHelper::$__tainted = NULL AjaxHelper::$__cleaned = NULL AjaxHelper::$Form = FormHelper 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 = NULL JavascriptHelper::$here = "/products" JavascriptHelper::$params = array JavascriptHelper::$action = NULL JavascriptHelper::$plugin = NULL JavascriptHelper::$data = array JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__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 = "/products" FormHelper::$params = array FormHelper::$action = NULL FormHelper::$plugin = NULL FormHelper::$data = array 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 = "/products" HtmlHelper::$params = array HtmlHelper::$action = NULL HtmlHelper::$plugin = NULL HtmlHelper::$data = array HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULLinclude - APP/views/layouts/default.ctp, line 139 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 ErrorHandler::_outputMessage() - CORE/cake/libs/error.php, line 458 ErrorHandler::missingView() - CORE/cake/libs/error.php, line 294 Object::dispatchMethod() - CORE/cake/libs/object.php, line 112 ErrorHandler::__construct() - CORE/cake/libs/error.php, line 125 Object::cakeError() - CORE/cake/libs/object.php, line 201 View::_missingView() - CORE/cake/libs/view/view.php, line 931 View::_getViewFileName() - CORE/cake/libs/view/view.php, line 881 View::render() - CORE/cake/libs/view/view.php, line 418 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