Notice (8): Undefined index: offset [APP/controllers/accessories_controller.php, line 39]
Code 'Accessory.category_id'=>$this->passedArgs['category']
),
'limit'=> $this->passedArgs['offset'].',1'
AccessoriesController::getAccessoryByCategoryId() - APP/controllers/accessories_controller.php, line 39
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - CORE/webroot/index.php, line 92
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 '1' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
Code |
Context$sql = "SELECT `Accessory`.`id`, `Accessory`.`category_id`, `Accessory`.`created`, `Accessory`.`modified`, `Accessory`.`priority`, `Accessory`.`active`, `Accessory`.`featured`, `Accessory`.`name`, `Accessory`.`article_num`, `Accessory`.`title_bg`, `Accessory`.`annotation_bg`, `Accessory`.`content_bg`, `Accessory`.`title_en`, `Accessory`.`annotation_en`, `Accessory`.`content_en`, `Accessory`.`recommend_1`, `Accessory`.`recommend_2`, `Accessory`.`recommend_3`, `AccessoryCategory`.`id`, `AccessoryCategory`.`parent_id`, `AccessoryCategory`.`created`, `AccessoryCategory`.`modified`, `AccessoryCategory`.`lft`, `AccessoryCategory`.`rght`, `AccessoryCategory`.`active`, `AccessoryCategory`.`name`, `AccessoryCategory`.`title_bg`, `AccessoryCategory`.`annotation_bg`, `AccessoryCategory`.`title_en`, `AccessoryCategory`.`annotation_en`, `Seo`.`id`, `Seo`.`class`, `Seo`.`foreign_id`, `Seo`.`created`, `Seo`.`modified`, `Seo`.`title_bg`, `Seo`.`content_bg`, `Seo`.`keywords_bg`, `Seo`.`description_bg`, `Seo`.`subject_bg`, `Seo`.`comment_bg`, `Seo`.`alt_1_bg`, `Seo`.`alt_2_bg`, `Seo`.`alt_3_bg`, `Seo`.`title_en`, `Seo`.`content_en`, `Seo`.`keywords_en`, `Seo`.`description_en`, `Seo`.`subject_en`, `Seo`.`comment_en`, `Seo`.`alt_1_en`, `Seo`.`alt_2_en`, `Seo`.`alt_3_en` FROM `accessories` AS `Accessory` LEFT JOIN `accessory_categories` AS `AccessoryCategory` ON (`Accessory`.`category_id` = `AccessoryCategory`.`id`) LEFT JOIN `seos` AS `Seo` ON (`Seo`.`foreign_id` = `Accessory`.`id` AND `Seo`.`class` = 'Accessory') WHERE `Accessory`.`id` <> 75 AND `Accessory`.`category_id` = 9 AND `Accessory`.`active` = 1 ORDER BY `Accessory`.`priority` asc LIMIT ,1"
$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 '1' 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 525
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 336
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 653
Model::find() - CORE/cake/libs/model/model.php, line 1992
AccessoriesController::getAccessoryByCategoryId() - APP/controllers/accessories_controller.php, line 41
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - CORE/webroot/index.php, line 92
Query: SELECT `Accessory`.`id`, `Accessory`.`category_id`, `Accessory`.`created`, `Accessory`.`modified`, `Accessory`.`priority`, `Accessory`.`active`, `Accessory`.`featured`, `Accessory`.`name`, `Accessory`.`article_num`, `Accessory`.`title_bg`, `Accessory`.`annotation_bg`, `Accessory`.`content_bg`, `Accessory`.`title_en`, `Accessory`.`annotation_en`, `Accessory`.`content_en`, `Accessory`.`recommend_1`, `Accessory`.`recommend_2`, `Accessory`.`recommend_3`, `AccessoryCategory`.`id`, `AccessoryCategory`.`parent_id`, `AccessoryCategory`.`created`, `AccessoryCategory`.`modified`, `AccessoryCategory`.`lft`, `AccessoryCategory`.`rght`, `AccessoryCategory`.`active`, `AccessoryCategory`.`name`, `AccessoryCategory`.`title_bg`, `AccessoryCategory`.`annotation_bg`, `AccessoryCategory`.`title_en`, `AccessoryCategory`.`annotation_en`, `Seo`.`id`, `Seo`.`class`, `Seo`.`foreign_id`, `Seo`.`created`, `Seo`.`modified`, `Seo`.`title_bg`, `Seo`.`content_bg`, `Seo`.`keywords_bg`, `Seo`.`description_bg`, `Seo`.`subject_bg`, `Seo`.`comment_bg`, `Seo`.`alt_1_bg`, `Seo`.`alt_2_bg`, `Seo`.`alt_3_bg`, `Seo`.`title_en`, `Seo`.`content_en`, `Seo`.`keywords_en`, `Seo`.`description_en`, `Seo`.`subject_en`, `Seo`.`comment_en`, `Seo`.`alt_1_en`, `Seo`.`alt_2_en`, `Seo`.`alt_3_en` FROM `accessories` AS `Accessory` LEFT JOIN `accessory_categories` AS `AccessoryCategory` ON (`Accessory`.`category_id` = `AccessoryCategory`.`id`) LEFT JOIN `seos` AS `Seo` ON (`Seo`.`foreign_id` = `Accessory`.`id` AND `Seo`.`class` = 'Accessory') WHERE `Accessory`.`id` <> 75 AND `Accessory`.`category_id` = 9 AND `Accessory`.`active` = 1 ORDER BY `Accessory`.`priority` asc LIMIT ,1