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]
Code |
Context$sql = "SELECT `Content`.`id`, `Content`.`url`, `Content`.`img_pic`, `Content`.`price`, `Content`.`old_price`, `Content`.`date`, `I18n__title__rus`.`content`, `I18n__description__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') WHERE `Content`.`type`=0 AND `Content`.`enabled`=1 AND (`Content`.`lft`>=1007 and `Content`.`rght`<=1030) 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
$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 1988
Controller::paginate() - CORE/cake/libs/controller/controller.php, line 1088
PagesController::display() - APP/controllers/pages_controller.php, line 368
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`.`date`, `I18n__title__rus`.`content`, `I18n__description__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') WHERE `Content`.`type`=0 AND `Content`.`enabled`=1 AND (`Content`.`lft`>=1007 and `Content`.`rght`<=1030) ORDER BY ASC LIMIT 10
Warning (2): Invalid argument supplied for foreach() [APP/models/content.php, line 202]
Code |
Context$results = false
$fields = array(
"title",
0,
1,
2,
3,
4,
5,
6,
7,
8,
9,
10,
11,
12,
13,
14,
15,
16
)
function afterFind($results) {
$fields = array_keys($this->actsAs['Translate']);
foreach ($results as $key=>$row) {
Content::afterFind() - APP/models/content.php, line 202
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 368
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
Missing View
Error:
The view for PagesController::display() was not found.
Error:
Confirm you have created the file: /home/www_data/agromir/data/www/agro-mir.com.ua/app/views/pages/slayder_main_category.ctp
Notice:
If you want to customize this error message, create app/views/errors/missing_view.ctp