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 'ASC LIMIT 10' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
$sql = "SELECT `Content`.`id`, `Content`.`url`, `Content`.`img_pic`, `Content`.`price`, `Content`.`old_price`, `Content`.`end_time_action`, `I18n__title__rus`.`content`, `I18n__description__rus`.`content`, `I18n__saving__rus`.`content` FROM `contents` AS `Content` LEFT JOIN `i18n` AS `I18n__title__rus` ON (`Content`.`id` = `I18n__title__rus`.`foreign_key` AND `I18n__title__rus`.`model` = 'Content' AND `I18n__title__rus`.`field` = 'title' AND `I18n__title__rus`.`locale` = 'rus') LEFT JOIN `i18n` AS `I18n__description__rus` ON (`Content`.`id` = `I18n__description__rus`.`foreign_key` AND `I18n__description__rus`.`model` = 'Content' AND `I18n__description__rus`.`field` = 'description' AND `I18n__description__rus`.`locale` = 'rus') LEFT JOIN `i18n` AS `I18n__saving__rus` ON (`Content`.`id` = `I18n__saving__rus`.`foreign_key` AND `I18n__saving__rus`.`model` = 'Content' AND `I18n__saving__rus`.`field` = 'saving' AND `I18n__saving__rus`.`locale` = 'rus') LEFT JOIN `users` AS `User` ON (`User`.`id`=`Content`.`user_id`) WHERE `Content`.`type`=0 AND `Content`.`enabled`=1 AND (`Content`.`lft`>=3775 and `Content`.`rght`<=4026) ORDER BY ASC LIMIT 10"
$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 'ASC LIMIT 10' at line 1"
$out = null
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 1988
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1088
PagesController::display() - APP/controllers/pages_controller.php, line 989
Object::dispatchMethod() - CORE/cake/libs/object.php, line 118
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
Query: SELECT `Content`.`id`, `Content`.`url`, `Content`.`img_pic`, `Content`.`price`, `Content`.`old_price`, `Content`.`end_time_action`, `I18n__title__rus`.`content`, `I18n__description__rus`.`content`, `I18n__saving__rus`.`content` FROM `contents` AS `Content` LEFT JOIN `i18n` AS `I18n__title__rus` ON (`Content`.`id` = `I18n__title__rus`.`foreign_key` AND `I18n__title__rus`.`model` = 'Content' AND `I18n__title__rus`.`field` = 'title' AND `I18n__title__rus`.`locale` = 'rus') LEFT JOIN `i18n` AS `I18n__description__rus` ON (`Content`.`id` = `I18n__description__rus`.`foreign_key` AND `I18n__description__rus`.`model` = 'Content' AND `I18n__description__rus`.`field` = 'description' AND `I18n__description__rus`.`locale` = 'rus') LEFT JOIN `i18n` AS `I18n__saving__rus` ON (`Content`.`id` = `I18n__saving__rus`.`foreign_key` AND `I18n__saving__rus`.`model` = 'Content' AND `I18n__saving__rus`.`field` = 'saving' AND `I18n__saving__rus`.`locale` = 'rus') LEFT JOIN `users` AS `User` ON (`User`.`id`=`Content`.`user_id`) WHERE `Content`.`type`=0 AND `Content`.`enabled`=1 AND (`Content`.`lft`>=3775 and `Content`.`rght`<=4026) ORDER BY ASC LIMIT 10
Warning (2): Invalid argument supplied for foreach() [APP/models/content.php, line 143]
function afterFind($results) { $fields = array_keys($this->actsAs['Translate']); foreach ($results as $key=>$row) {
Content::afterFind() - APP/models/content.php, line 143
Model::__filterResults() - CORE/cake/libs/model/model.php, line 2234
Model::find() - CORE/cake/libs/model/model.php, line 1993
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1088
PagesController::display() - APP/controllers/pages_controller.php, line 989
Object::dispatchMethod() - CORE/cake/libs/object.php, line 118
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88