índice del sitio
Inicio | Películas contadas | Perfiles | Canon | Blog | Sobre DQVlapeli | Contacto | Política de la comunidad | Aviso legal© 2022 Dequevalapeli.com
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`.`pais_id`, `Unidad`.`paises` FROM `unidades_cine` AS `Unidad` WHERE (`Unidad`.`unidad_tipo_id` = 14 OR `Unidad`.`unidad_tipo_id` = 16) AND `Unidad`.`activo` = "S" AND `Unidad`.`pais_id` in (1,7,15,21,24,28,29,32,33,35,51,59,82,86,93,94,95,98,99,101,123,125,142,143) 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
$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 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::paises() - APP/controllers/peliculas_controller.php, line 916 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`.`pais_id`, `Unidad`.`paises` FROM `unidades_cine` AS `Unidad` WHERE (`Unidad`.`unidad_tipo_id` = 14 OR `Unidad`.`unidad_tipo_id` = 16) AND `Unidad`.`activo` = "S" AND `Unidad`.`pais_id` in (1,7,15,21,24,28,29,32,33,35,51,59,82,86,93,94,95,98,99,101,123,125,142,143) 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 919]
$iberoamerica = array( array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ), array( "Pais" => array() ) ) $paisIDs = array( "1", "7", "15", "21", "24", "28", "29", "32", "33", "35", "51", "59", "82", "86", "93", "94", "95", "98", "99", "101", "123", "125", "142", "143" ) $item = array( "Pais" => array( "id" => "143", "pais" => "BOLIVIA", "slug" => "bolivia", "cod_pais" => "", "prefijo_telefono" => "", "iberoamerica" => "S", "descritura" => "1" ) ) $rs = false $list = array()
$list = array();
foreach ($rs as $item) :
PeliculasController::paises() - APP/controllers/peliculas_controller.php, line 919 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]
$array = null $subkey = "pais" $sort_ascending = "asc"
function sksort(&$array, $subkey="id", $sort_ascending=false) {
if (count($array))
AppController::sksort() - CORE/cake/libs/controller/app_controller.php, line 156 PeliculasController::paises() - APP/controllers/peliculas_controller.php, line 939 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]
$array = null $subkey = "pais" $sort_ascending = "asc"
$temp_array[key($array)] = array_shift($array);
foreach($array as $key => $val){
AppController::sksort() - CORE/cake/libs/controller/app_controller.php, line 159 PeliculasController::paises() - APP/controllers/peliculas_controller.php, line 939 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
Notice (8): Undefined variable: temp_array [CORE/cake/libs/controller/app_controller.php, line 177]
$array = null $subkey = "pais" $sort_ascending = "asc"
}
if ($sort_ascending) $array = array_reverse($temp_array);
AppController::sksort() - CORE/cake/libs/controller/app_controller.php, line 177 PeliculasController::paises() - APP/controllers/peliculas_controller.php, line 939 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_reverse() expects parameter 1 to be array, null given [CORE/cake/libs/controller/app_controller.php, line 177]
$array = null $subkey = "pais" $sort_ascending = "asc"
array_reverse - [internal], line ?? AppController::sksort() - CORE/cake/libs/controller/app_controller.php, line 177 PeliculasController::paises() - APP/controllers/peliculas_controller.php, line 939 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() [APP/views/peliculas/paises.ctp, line 10]
$___viewFn = "/var/www/dequevalapeli.com/app/views/peliculas/paises.ctp" $___dataForView = array( "widgets" => array( array(), array(), array(), array(), array() ), "paises" => null ) $loadHelpers = true $cached = false $loadedHelpers = array( "Text" => TextHelper TextHelper::$helpers = NULL TextHelper::$base = "" TextHelper::$webroot = "/" TextHelper::$themeWeb = NULL TextHelper::$here = "/peliculas/paises/" TextHelper::$params = array TextHelper::$action = "paises" TextHelper::$plugin = NULL TextHelper::$data = NULL TextHelper::$namedArgs = NULL TextHelper::$argSeparator = NULL TextHelper::$validationErrors = NULL TextHelper::$tags = array TextHelper::$__tainted = NULL TextHelper::$__cleaned = NULL TextHelper::$_log = NULL, "Time" => TimeHelper TimeHelper::$helpers = NULL TimeHelper::$base = "" TimeHelper::$webroot = "/" TimeHelper::$themeWeb = NULL TimeHelper::$here = "/peliculas/paises/" TimeHelper::$params = array TimeHelper::$action = "paises" TimeHelper::$plugin = NULL TimeHelper::$data = NULL TimeHelper::$namedArgs = NULL TimeHelper::$argSeparator = NULL TimeHelper::$validationErrors = NULL TimeHelper::$tags = array TimeHelper::$__tainted = NULL TimeHelper::$__cleaned = NULL TimeHelper::$_log = NULL, "Html" => HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/peliculas/paises/" HtmlHelper::$params = array HtmlHelper::$action = "paises" HtmlHelper::$data = NULL HtmlHelper::$_crumbs = array HtmlHelper::$__docTypes = array HtmlHelper::$helpers = NULL HtmlHelper::$webroot = "/" HtmlHelper::$themeWeb = NULL HtmlHelper::$plugin = NULL HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL HtmlHelper::$_log = NULL, "Javascript" => JavascriptHelper JavascriptHelper::$useNative = true JavascriptHelper::$enabled = true JavascriptHelper::$safe = false JavascriptHelper::$tags = array JavascriptHelper::$_blockOptions = array JavascriptHelper::$_cachedEvents = array JavascriptHelper::$_cacheEvents = false JavascriptHelper::$_cacheToFile = false JavascriptHelper::$_cacheAll = false JavascriptHelper::$_rules = array JavascriptHelper::$__scriptBuffer = NULL JavascriptHelper::$helpers = NULL JavascriptHelper::$base = "" JavascriptHelper::$webroot = "/" JavascriptHelper::$themeWeb = NULL JavascriptHelper::$here = "/peliculas/paises/" JavascriptHelper::$params = array JavascriptHelper::$action = "paises" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL JavascriptHelper::$_log = NULL, "Form" => FormHelper FormHelper::$helpers = array FormHelper::$fieldset = array FormHelper::$__options = array FormHelper::$fields = array FormHelper::$requestType = NULL FormHelper::$base = "" FormHelper::$webroot = "/" FormHelper::$themeWeb = NULL FormHelper::$here = "/peliculas/paises/" FormHelper::$params = array FormHelper::$action = "paises" FormHelper::$plugin = NULL FormHelper::$data = NULL FormHelper::$namedArgs = NULL FormHelper::$argSeparator = NULL FormHelper::$validationErrors = NULL FormHelper::$tags = array FormHelper::$__tainted = NULL FormHelper::$__cleaned = NULL FormHelper::$_log = NULL FormHelper::$Html = HtmlHelper object, "Session" => SessionHelper SessionHelper::$helpers = NULL SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "a66b6a95138c08e40615e49b34226d5b" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "high" SessionHelper::$time = 1653519882 SessionHelper::$sessionTime = 1653521082 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$host = NULL SessionHelper::$_log = NULL SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/peliculas/paises/" SessionHelper::$params = array SessionHelper::$action = "paises" SessionHelper::$data = NULL SessionHelper::$themeWeb = NULL SessionHelper::$plugin = NULL ) $helper = "Session" $camelBackedHelper = "session" $text = TextHelper TextHelper::$helpers = NULL TextHelper::$base = "" TextHelper::$webroot = "/" TextHelper::$themeWeb = NULL TextHelper::$here = "/peliculas/paises/" TextHelper::$params = array TextHelper::$action = "paises" TextHelper::$plugin = NULL TextHelper::$data = NULL TextHelper::$namedArgs = NULL TextHelper::$argSeparator = NULL TextHelper::$validationErrors = NULL TextHelper::$tags = array TextHelper::$__tainted = NULL TextHelper::$__cleaned = NULL TextHelper::$_log = NULL $time = TimeHelper TimeHelper::$helpers = NULL TimeHelper::$base = "" TimeHelper::$webroot = "/" TimeHelper::$themeWeb = NULL TimeHelper::$here = "/peliculas/paises/" TimeHelper::$params = array TimeHelper::$action = "paises" TimeHelper::$plugin = NULL TimeHelper::$data = NULL TimeHelper::$namedArgs = NULL TimeHelper::$argSeparator = NULL TimeHelper::$validationErrors = NULL TimeHelper::$tags = array TimeHelper::$__tainted = NULL TimeHelper::$__cleaned = NULL TimeHelper::$_log = NULL $html = HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/peliculas/paises/" HtmlHelper::$params = array HtmlHelper::$action = "paises" HtmlHelper::$data = NULL HtmlHelper::$_crumbs = array HtmlHelper::$__docTypes = array HtmlHelper::$helpers = NULL HtmlHelper::$webroot = "/" HtmlHelper::$themeWeb = NULL HtmlHelper::$plugin = NULL HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL HtmlHelper::$_log = NULL $javascript = JavascriptHelper JavascriptHelper::$useNative = true JavascriptHelper::$enabled = true JavascriptHelper::$safe = false JavascriptHelper::$tags = array JavascriptHelper::$_blockOptions = array JavascriptHelper::$_cachedEvents = array JavascriptHelper::$_cacheEvents = false JavascriptHelper::$_cacheToFile = false JavascriptHelper::$_cacheAll = false JavascriptHelper::$_rules = array JavascriptHelper::$__scriptBuffer = NULL JavascriptHelper::$helpers = NULL JavascriptHelper::$base = "" JavascriptHelper::$webroot = "/" JavascriptHelper::$themeWeb = NULL JavascriptHelper::$here = "/peliculas/paises/" JavascriptHelper::$params = array JavascriptHelper::$action = "paises" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL JavascriptHelper::$_log = NULL $form = FormHelper FormHelper::$helpers = array FormHelper::$fieldset = array FormHelper::$__options = array FormHelper::$fields = array FormHelper::$requestType = NULL FormHelper::$base = "" FormHelper::$webroot = "/" FormHelper::$themeWeb = NULL FormHelper::$here = "/peliculas/paises/" FormHelper::$params = array FormHelper::$action = "paises" FormHelper::$plugin = NULL FormHelper::$data = NULL FormHelper::$namedArgs = NULL FormHelper::$argSeparator = NULL FormHelper::$validationErrors = NULL FormHelper::$tags = array FormHelper::$__tainted = NULL FormHelper::$__cleaned = NULL FormHelper::$_log = NULL FormHelper::$Html = HtmlHelper object $session = SessionHelper SessionHelper::$helpers = NULL SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "a66b6a95138c08e40615e49b34226d5b" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "high" SessionHelper::$time = 1653519882 SessionHelper::$sessionTime = 1653521082 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$host = NULL SessionHelper::$_log = NULL SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/peliculas/paises/" SessionHelper::$params = array SessionHelper::$action = "paises" SessionHelper::$data = NULL SessionHelper::$themeWeb = NULL SessionHelper::$plugin = NULL $widgets = array( array( "Widget" => array() ), array( "Widget" => array() ), array( "Widget" => array() ), array( "Widget" => array() ), array( "Widget" => array() ) ) $paises = null
<h1>Por paises</h1>
<?php foreach ($paises as $item) : ?>
include - APP/views/peliculas/paises.ctp, line 10 View::_render() - CORE/cake/libs/view/view.php, line 665 View::render() - CORE/cake/libs/view/view.php, line 375 Controller::render() - CORE/cake/libs/controller/controller.php, line 808 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 229 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193 [main] - APP/webroot/index.php, line 88