Context |
Code$this = array("_log" => null, "connected" => true, "debug" => true, "fullDebug" => false, "error" => "1052: Column 'id' in order clause is ambiguous", "affected" => null, "numRows" => null, "took" => 0, "_result" => false, "_queriesCnt" => 0, "_queriesTime" => null, "_queriesLog" => array, "_queriesLogMax" => 200, "_queryCache" => array, "_baseConfig" => array, "__descriptions" => array, "_sources" => array, "connection" => resource, "config" => array, "configKeyName" => "default", "_transactionStarted" => false, "cacheSources" => true, "description" => "MySQL DBO Driver", "index" => array, "startQuote" => "`", "endQuote" => "`", "alias" => "AS ", "goofyLimit" => false, "__bypass" => false, "__sqlOps" => array, "columns" => array, "results" => false, "map" => array)
$sql = "SELECT `CategoriesProduct`.`category_id`, `CategoriesProduct`.`product_id`, `Category`.`id`, `Category`.`title`, `Category`.`description`, `Category`.`keywords`, `Category`.`parent_id`, `Category`.`created`, `Category`.`modified`, `Category`.`featured_product`, `Product`.`id`, `Product`.`code`, `Product`.`prodid`, `Product`.`contents`, `Product`.`options`, `Product`.`weight`, `Product`.`name`, `Product`.`headline`, `Product`.`sale_price`, `Product`.`price`, `Product`.`path_id`, `Product`.`feed_id`, `Product`.`caption`, `Product`.`instock`, `Product`.`nextavailable`, `Product`.`created`, `Product`.`modified` FROM `categories_products` AS `CategoriesProduct` LEFT JOIN `categories` AS `Category` ON (`CategoriesProduct`.`category_id` = `Category`.`id`) LEFT JOIN `products` AS `Product` ON (`CategoriesProduct`.`product_id` = `Product`.`id`) WHERE `Category`.`id` = 108 ORDER BY `id` asc LIMIT 15, 15"
$error = "1052: Column 'id' in order clause is ambiguous"
if (($this->debug || $error) && Configure::read() > 0) {
e("<p style = \"text-align:left\"><b>Query:</b> {$sql} ");
if ($error) {
trigger_error("<span style = \"color:Red;text-align:left\"><b>SQL Error:</b> {$this->error}</span>", E_USER_WARNING);
} else {
dbomysql::showquery() - CORE/cake/libs/model/datasources/dbo_source.php, line 440
dbomysql::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 166
dbomysql::fetchall() - CORE/cake/libs/model/datasources/dbo_source.php, line 297
dbomysql::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 571
categoriesproduct::find() - CORE/cake/libs/model/model.php, line 1502
categoriesproduct::debug_backtrace() - [internal], line ??
categoriesproduct::findall() - CORE/cake/libs/model/model.php, line 1540
categoriesproduct::debug_backtrace() - [internal], line ??
categoriescontroller::paginate() - CORE/cake/libs/controller/controller.php, line 1167
categoriescontroller::view() - CORE/app/controllers/categories_controller.php, line 220
dispatcher::_invoke() - CORE/cake/dispatcher.php, line 276
dispatcher::dispatch() - CORE/cake/dispatcher.php, line 248
[main] - CORE/app/webroot/index.php, line 84