Warning (512): SQL Error: 3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'conoceralautor.Unidad.fecha_publica' which is not in SELECT list; this is incompatible with DISTINCT [CORE/cake/libs/model/datasources/dbo_source.php, line 526]
$sql = "SELECT DISTINCT `Unidad`.`idiomas` FROM `unidades_cine` AS `Unidad` WHERE (`Unidad`.`unidad_tipo_id` = 14 OR `Unidad`.`unidad_tipo_id` = 16) AND `Unidad`.`activo` = "S" AND `Unidad`.`idioma_id` IS NOT NULL AND `Unidad`.`fecha_publica` is not null AND `Unidad`.`fecha_publica` <= curdate() ORDER BY `Unidad`.`fecha_publica` DESC, `Unidad`.`id` DESC "
$error = "3065: Expression #1 of ORDER BY clause is not in SELECT list, references column 'conoceralautor.Unidad.fecha_publica' which is not in SELECT list; this is incompatible with DISTINCT"
$out = null
DboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 526
DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 202
DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 337
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 654
Model::find() - CORE/cake/libs/model/model.php, line 2045
PeliculasController::idiomas() - APP/controllers/peliculas_controller.php, line 858
CakeObject::dispatchMethod() - CORE/cake/libs/cake_object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193
[main] - APP/webroot/index.php, line 88
Query: SELECT DISTINCT `Unidad`.`idiomas` FROM `unidades_cine` AS `Unidad` WHERE (`Unidad`.`unidad_tipo_id` = 14 OR `Unidad`.`unidad_tipo_id` = 16) AND `Unidad`.`activo` = "S" AND `Unidad`.`idioma_id` IS NOT NULL AND `Unidad`.`fecha_publica` is not null AND `Unidad`.`fecha_publica` <= curdate() ORDER BY `Unidad`.`fecha_publica` DESC, `Unidad`.`id` DESC
Warning (2): Invalid argument supplied for foreach() [APP/controllers/peliculas_controller.php, line 861]
//debug($rs); $list = array(); foreach ($rs as $item) :
PeliculasController::idiomas() - APP/controllers/peliculas_controller.php, line 861
CakeObject::dispatchMethod() - CORE/cake/libs/cake_object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193
[main] - APP/webroot/index.php, line 88
Warning (2): count(): Parameter must be an array or an object that implements Countable [CORE/cake/libs/controller/app_controller.php, line 156]
function sksort(&$array, $subkey="id", $sort_ascending=false) { if (count($array))
AppController::sksort() - CORE/cake/libs/controller/app_controller.php, line 156
PeliculasController::idiomas() - APP/controllers/peliculas_controller.php, line 886
CakeObject::dispatchMethod() - CORE/cake/libs/cake_object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193
[main] - APP/webroot/index.php, line 88
Warning (2): key() expects parameter 1 to be array, string given [CORE/cake/libs/controller/app_controller.php, line 157]
key - [internal], line ??
AppController::sksort() - CORE/cake/libs/controller/app_controller.php, line 157
PeliculasController::idiomas() - APP/controllers/peliculas_controller.php, line 886
CakeObject::dispatchMethod() - CORE/cake/libs/cake_object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193
[main] - APP/webroot/index.php, line 88
Warning (2): array_shift() expects parameter 1 to be array, string given [CORE/cake/libs/controller/app_controller.php, line 157]
array_shift - [internal], line ??
AppController::sksort() - CORE/cake/libs/controller/app_controller.php, line 157
PeliculasController::idiomas() - APP/controllers/peliculas_controller.php, line 886
CakeObject::dispatchMethod() - CORE/cake/libs/cake_object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193
[main] - APP/webroot/index.php, line 88
Warning (2): Invalid argument supplied for foreach() [CORE/cake/libs/controller/app_controller.php, line 159]
$temp_array[key($array)] = array_shift($array); foreach($array as $key => $val){
AppController::sksort() - CORE/cake/libs/controller/app_controller.php, line 159
PeliculasController::idiomas() - APP/controllers/peliculas_controller.php, line 886
CakeObject::dispatchMethod() - CORE/cake/libs/cake_object.php, line 115
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193
[main] - APP/webroot/index.php, line 88