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 'AND `I18n__name`.`locale` = 'el' ORDER BY `Category`.`lft` ASC' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 514]
$sql = "SELECT `Category`.`slug`, `Category`.`image`, `Category`.`banner`, `I18n__name`.`content`, `Category`.`id` FROM `categories` AS `Category` LEFT JOIN `i18n` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') WHERE `Category`.`published`=1 AND `Category`.`parent_id`= AND `I18n__name`.`locale` = 'el' ORDER BY `Category`.`lft` ASC "
$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 'AND `I18n__name`.`locale` = 'el' ORDER BY `Category`.`lft` ASC' at line 1"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 514
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 201
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 337
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 636
Model::find() - CORE/cake/libs/model/model.php, line 1956
Model::findAll() - CORE/cake/libs/model/model.php, line 2821
PagesController::products() - APP/controllers/pages_controller.php, line 0
Object::dispatchMethod() - CORE/cake/libs/object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 245
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 211
[main] - APP/webroot/index.php, line 0
Query: SELECT `Category`.`slug`, `Category`.`image`, `Category`.`banner`, `I18n__name`.`content`, `Category`.`id` FROM `categories` AS `Category` LEFT JOIN `i18n` AS `I18n__name` ON (`Category`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Category' AND `I18n__name`.`field` = 'name') WHERE `Category`.`published`=1 AND `Category`.`parent_id`= AND `I18n__name`.`locale` = 'el' ORDER BY `Category`.`lft` ASC