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 'ORDER BY `Noticia`.`titol` desc LIMIT 20' at line 1 [ROOT/cake/libs/model/datasources/dbo_source.php , line 521 ]
Code |
Context $sql = "SELECT `Noticia`.`id`, `Noticia`.`titol`, `Noticia`.`descripcio`, `Noticia`.`data`, `Noticia`.`tipus`, `Noticia`.`tags`, `Noticia`.`equip_id`, `Noticia`.`foto`, `Noticia`.`visites`, `Equip`.`id`, `Equip`.`nom`, `Equip`.`lletra`, `Equip`.`diapartit`, `Equip`.`horapartit`, `Equip`.`temporada_id`, `Equip`.`camp_id`, `Equip`.`club_id`, `Equip`.`categoria_id`, `Equip`.`foto` FROM `noticias` AS `Noticia` LEFT JOIN `equips` AS `Equip` ON (`Noticia`.`equip_id` = `Equip`.`id`) WHERE equip_id IN (0,-2,-1) ORDER BY data DESC ORDER BY `Noticia`.`titol` desc LIMIT 20"
$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 'ORDER BY `Noticia`.`titol` desc LIMIT 20' 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() - ROOT/cake/libs/model/datasources/dbo_source.php, line 521
DboSource::execute() - ROOT/cake/libs/model/datasources/dbo_source.php, line 208
DboSource::fetchAll() - ROOT/cake/libs/model/datasources/dbo_source.php, line 344
DboSource::read() - ROOT/cake/libs/model/datasources/dbo_source.php, line 638
Model::find() - ROOT/cake/libs/model/model.php, line 1822
Controller::paginate() - ROOT/cake/libs/controller/controller.php, line 1025
NoticiasController::index_club() - APP/controllers/noticias_controller.php, line 184
Object::dispatchMethod() - ROOT/cake/libs/object.php, line 114
Dispatcher::_invoke() - ROOT/cake/dispatcher.php, line 262
Dispatcher::dispatch() - ROOT/cake/dispatcher.php, line 216
[main] - APP/webroot/index.php, line 85 Query: SELECT `Noticia`.`id`, `Noticia`.`titol`, `Noticia`.`descripcio`, `Noticia`.`data`, `Noticia`.`tipus`, `Noticia`.`tags`, `Noticia`.`equip_id`, `Noticia`.`foto`, `Noticia`.`visites`, `Equip`.`id`, `Equip`.`nom`, `Equip`.`lletra`, `Equip`.`diapartit`, `Equip`.`horapartit`, `Equip`.`temporada_id`, `Equip`.`camp_id`, `Equip`.`club_id`, `Equip`.`categoria_id`, `Equip`.`foto` FROM `noticias` AS `Noticia` LEFT JOIN `equips` AS `Equip` ON (`Noticia`.`equip_id` = `Equip`.`id`) WHERE equip_id IN (0,-2,-1) ORDER BY data DESC ORDER BY `Noticia`.`titol` desc LIMIT 20
:: CFBegues.com :: -
Noticias
NotÃcies del Club
PÃ gina 1 de 13, mostrant 1 registres de 243
Titol
Descripcio
Data
Warning (2) : Invalid argument supplied for foreach() [APP/views/noticias/index_club.ctp , line 17 ]
Code |
Context $___viewFn = "/home/alexrosm/cfbegues.com/app/views/noticias/index_club.ctp"
$___dataForView = array(
"noticias" => false
)
$loadHelpers = true
$cached = false
$loadedHelpers = array(
"Html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/noticias/index_club/page:1/sort:titol/direction:desc"
HtmlHelper::$params = array
HtmlHelper::$action = "index_club"
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,
"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 = "/noticias/index_club/page:1/sort:titol/direction:desc"
FormHelper::$params = array
FormHelper::$action = "index_club"
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,
"Tinymce" => TinyMceHelper
TinyMceHelper::$helpers = array
TinyMceHelper::$_script = false
TinyMceHelper::$base = ""
TinyMceHelper::$webroot = "/"
TinyMceHelper::$themeWeb = NULL
TinyMceHelper::$here = "/noticias/index_club/page:1/sort:titol/direction:desc"
TinyMceHelper::$params = array
TinyMceHelper::$action = "index_club"
TinyMceHelper::$plugin = NULL
TinyMceHelper::$data = NULL
TinyMceHelper::$namedArgs = NULL
TinyMceHelper::$argSeparator = NULL
TinyMceHelper::$validationErrors = NULL
TinyMceHelper::$tags = array
TinyMceHelper::$__tainted = NULL
TinyMceHelper::$__cleaned = NULL
TinyMceHelper::$_log = NULL
TinyMceHelper::$Javascript = JavascriptHelper object
TinyMceHelper::$Form = FormHelper object,
"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 = "/noticias/index_club/page:1/sort:titol/direction:desc"
JavascriptHelper::$params = array
JavascriptHelper::$action = "index_club"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
"Paginator" => PaginatorHelper
PaginatorHelper::$helpers = array
PaginatorHelper::$__defaultModel = "Noticia"
PaginatorHelper::$options = array
PaginatorHelper::$base = ""
PaginatorHelper::$webroot = "/"
PaginatorHelper::$themeWeb = NULL
PaginatorHelper::$here = "/noticias/index_club/page:1/sort:titol/direction:desc"
PaginatorHelper::$params = array
PaginatorHelper::$action = "index_club"
PaginatorHelper::$plugin = NULL
PaginatorHelper::$data = NULL
PaginatorHelper::$namedArgs = NULL
PaginatorHelper::$argSeparator = NULL
PaginatorHelper::$validationErrors = NULL
PaginatorHelper::$tags = array
PaginatorHelper::$__tainted = NULL
PaginatorHelper::$__cleaned = NULL
PaginatorHelper::$_log = NULL
PaginatorHelper::$Html = HtmlHelper object
PaginatorHelper::$Ajax = AjaxHelper object,
"Ajax" => AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/noticias/index_club/page:1/sort:titol/direction:desc"
AjaxHelper::$params = array
AjaxHelper::$action = "index_club"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object,
"Session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "d0a3d65e11a4b0f823b3c1085cc4c37d"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1283868105
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/noticias/index_club/page:1/sort:titol/direction:desc"
SessionHelper::$params = array
SessionHelper::$action = "index_club"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$helper = SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "d0a3d65e11a4b0f823b3c1085cc4c37d"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1283868105
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/noticias/index_club/page:1/sort:titol/direction:desc"
SessionHelper::$params = array
SessionHelper::$action = "index_club"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$camelBackedHelper = "session"
$html = HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/noticias/index_club/page:1/sort:titol/direction:desc"
HtmlHelper::$params = array
HtmlHelper::$action = "index_club"
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
$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 = "/noticias/index_club/page:1/sort:titol/direction:desc"
FormHelper::$params = array
FormHelper::$action = "index_club"
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
$tinymce = TinyMceHelper
TinyMceHelper::$helpers = array
TinyMceHelper::$_script = false
TinyMceHelper::$base = ""
TinyMceHelper::$webroot = "/"
TinyMceHelper::$themeWeb = NULL
TinyMceHelper::$here = "/noticias/index_club/page:1/sort:titol/direction:desc"
TinyMceHelper::$params = array
TinyMceHelper::$action = "index_club"
TinyMceHelper::$plugin = NULL
TinyMceHelper::$data = NULL
TinyMceHelper::$namedArgs = NULL
TinyMceHelper::$argSeparator = NULL
TinyMceHelper::$validationErrors = NULL
TinyMceHelper::$tags = array
TinyMceHelper::$__tainted = NULL
TinyMceHelper::$__cleaned = NULL
TinyMceHelper::$_log = NULL
TinyMceHelper::$Javascript = JavascriptHelper object
TinyMceHelper::$Form = FormHelper object
$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 = "/noticias/index_club/page:1/sort:titol/direction:desc"
JavascriptHelper::$params = array
JavascriptHelper::$action = "index_club"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL
$paginator = PaginatorHelper
PaginatorHelper::$helpers = array
PaginatorHelper::$__defaultModel = "Noticia"
PaginatorHelper::$options = array
PaginatorHelper::$base = ""
PaginatorHelper::$webroot = "/"
PaginatorHelper::$themeWeb = NULL
PaginatorHelper::$here = "/noticias/index_club/page:1/sort:titol/direction:desc"
PaginatorHelper::$params = array
PaginatorHelper::$action = "index_club"
PaginatorHelper::$plugin = NULL
PaginatorHelper::$data = NULL
PaginatorHelper::$namedArgs = NULL
PaginatorHelper::$argSeparator = NULL
PaginatorHelper::$validationErrors = NULL
PaginatorHelper::$tags = array
PaginatorHelper::$__tainted = NULL
PaginatorHelper::$__cleaned = NULL
PaginatorHelper::$_log = NULL
PaginatorHelper::$Html = HtmlHelper object
PaginatorHelper::$Ajax = AjaxHelper object
$ajax = AjaxHelper
AjaxHelper::$helpers = array
AjaxHelper::$Html = HtmlHelper object
AjaxHelper::$Javascript = JavascriptHelper object
AjaxHelper::$callbacks = array
AjaxHelper::$ajaxOptions = array
AjaxHelper::$dragOptions = array
AjaxHelper::$dropOptions = array
AjaxHelper::$sortOptions = array
AjaxHelper::$sliderOptions = array
AjaxHelper::$editorOptions = array
AjaxHelper::$autoCompleteOptions = array
AjaxHelper::$__ajaxBuffer = array
AjaxHelper::$base = ""
AjaxHelper::$webroot = "/"
AjaxHelper::$themeWeb = NULL
AjaxHelper::$here = "/noticias/index_club/page:1/sort:titol/direction:desc"
AjaxHelper::$params = array
AjaxHelper::$action = "index_club"
AjaxHelper::$plugin = NULL
AjaxHelper::$data = NULL
AjaxHelper::$namedArgs = NULL
AjaxHelper::$argSeparator = NULL
AjaxHelper::$validationErrors = NULL
AjaxHelper::$tags = array
AjaxHelper::$__tainted = NULL
AjaxHelper::$__cleaned = NULL
AjaxHelper::$_log = NULL
AjaxHelper::$Form = FormHelper object
$session = SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "d0a3d65e11a4b0f823b3c1085cc4c37d"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1283868105
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/noticias/index_club/page:1/sort:titol/direction:desc"
SessionHelper::$params = array
SessionHelper::$action = "index_club"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$noticias = false
$i = 0 <?php
$i = 0;
foreach ($noticias as $noticia):
include - APP/views/noticias/index_club.ctp, line 17
View::_render() - ROOT/cake/libs/view/view.php, line 654
View::render() - ROOT/cake/libs/view/view.php, line 372
Controller::render() - ROOT/cake/libs/controller/controller.php, line 744
Dispatcher::_invoke() - ROOT/cake/dispatcher.php, line 265
Dispatcher::dispatch() - ROOT/cake/dispatcher.php, line 216
[main] - APP/webroot/index.php, line 85