Notice (8): Undefined offset: 0 [APP/controllers/annunci_controller.php, line 1437]
$passedid = "0" $querybanner = "select DISTINCT annuncio_id from payments where date_add(created, INTERVAL days DAY) >NOW() order by annuncio_id asc" $res = array() $allids = array() $totalid = 0 $lastid = 0
if($totalid-1<=$lastid or $totalid == $lastid)$lastid = 0 ;else $lastid++;
//echo $lastid ;
$showid = $allids[$lastid];
AnnunciController::getItemBanner() - APP/controllers/annunci_controller.php, line 1437 Object::dispatchMethod() - CORE/cake/libs/object.php, line 117 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 Object::requestAction() - CORE/cake/libs/object.php, line 100 include - APP/views/elements/bannerpay.ctp, line 19 View::_render() - CORE/cake/libs/view/view.php, line 662 View::element() - CORE/cake/libs/view/view.php, line 343 include - APP/views/layouts/default.ctp, line 156 View::_render() - CORE/cake/libs/view/view.php, line 662 View::renderLayout() - CORE/cake/libs/view/view.php, line 450 View::render() - CORE/cake/libs/view/view.php, line 388 Controller::render() - CORE/cake/libs/controller/controller.php, line 799 UsersController::login() - APP/controllers/users_controller.php, line 113 Object::dispatchMethod() - CORE/cake/libs/object.php, line 115 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 88
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 `created` desc LIMIT 1' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
$sql = "SELECT `Annuncio`.`id`, `Annuncio`.`title`, `Annuncio`.`created`, `Annuncio`.`updated`, `Annuncio`.`privatoazienda`, `Annuncio`.`offrocerco`, `Annuncio`.`vendoaffitto`, `Annuncio`.`enabled`, `Annuncio`.`region_id`, `Annuncio`.`province_id`, `Annuncio`.`town_id`, `Annuncio`.`quartiere`, `Annuncio`.`prezzo`, `Annuncio`.`urlname`, `Annuncio`.`description`, `Annuncio`.`removed`, `Annuncio`.`trattabile`, `Annuncio`.`views`, `Annuncio`.`telefono`, `Annuncio`.`email`, `Annuncio`.`emailvisible`, `Annuncio`.`telefonovisible`, `Annuncio`.`nomeutente`, `Annuncio`.`nomeazienda`, `Annuncio`.`category_id`, `Annuncio`.`via`, `Annuncio`.`lavorocontratto`, `Annuncio`.`lavoroorario`, `Annuncio`.`lavorolivello`, `Annuncio`.`foto1`, `Annuncio`.`foto2`, `Annuncio`.`foto3`, `Annuncio`.`foto4`, `Annuncio`.`durata`, `Annuncio`.`password`, `Annuncio`.`immnumcamere`, `Annuncio`.`immmetratura`, `Annuncio`.`autokm`, `Annuncio`.`automarca`, `Annuncio`.`automodello`, `Annuncio`.`autoanno`, `Annuncio`.`IP`, `Annuncio`.`enabledadmin`, `Annuncio`.`rating1`, `Annuncio`.`votes1`, `Annuncio`.`donekey`, `Annuncio`.`user_id`, `Annuncio`.`isreported`, `Annuncio`.`ispremium`, `Annuncio`.`adult`, `Province`.`Codice_Regione`, `Province`.`Codice_Provincia`, `Province`.`Denominazione_Regione`, `Province`.`Denominazione_Provincia`, `Category`.`urlname`, `Category`.`id`, `Category`.`name` FROM `annunci` AS `Annuncio` LEFT JOIN `provinces` AS `Province` ON (`Annuncio`.`province_id` = `Province`.`id`) LEFT JOIN `categories` AS `Category` ON (`Annuncio`.`category_id` = `Category`.`id`) WHERE enabled=1 and enabledadmin=1 and `Annuncio`.`id`= ORDER BY `created` desc LIMIT 1" $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 `created` desc LIMIT 1' 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 337 DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 647 Model::find() - CORE/cake/libs/model/model.php, line 1961 AnnunciController::getItemBanner() - APP/controllers/annunci_controller.php, line 1445 Object::dispatchMethod() - CORE/cake/libs/object.php, line 117 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 Object::requestAction() - CORE/cake/libs/object.php, line 100 include - APP/views/elements/bannerpay.ctp, line 19 View::_render() - CORE/cake/libs/view/view.php, line 662 View::element() - CORE/cake/libs/view/view.php, line 343 include - APP/views/layouts/default.ctp, line 156 View::_render() - CORE/cake/libs/view/view.php, line 662 View::renderLayout() - CORE/cake/libs/view/view.php, line 450 View::render() - CORE/cake/libs/view/view.php, line 388
Query: SELECT `Annuncio`.`id`, `Annuncio`.`title`, `Annuncio`.`created`, `Annuncio`.`updated`, `Annuncio`.`privatoazienda`, `Annuncio`.`offrocerco`, `Annuncio`.`vendoaffitto`, `Annuncio`.`enabled`, `Annuncio`.`region_id`, `Annuncio`.`province_id`, `Annuncio`.`town_id`, `Annuncio`.`quartiere`, `Annuncio`.`prezzo`, `Annuncio`.`urlname`, `Annuncio`.`description`, `Annuncio`.`removed`, `Annuncio`.`trattabile`, `Annuncio`.`views`, `Annuncio`.`telefono`, `Annuncio`.`email`, `Annuncio`.`emailvisible`, `Annuncio`.`telefonovisible`, `Annuncio`.`nomeutente`, `Annuncio`.`nomeazienda`, `Annuncio`.`category_id`, `Annuncio`.`via`, `Annuncio`.`lavorocontratto`, `Annuncio`.`lavoroorario`, `Annuncio`.`lavorolivello`, `Annuncio`.`foto1`, `Annuncio`.`foto2`, `Annuncio`.`foto3`, `Annuncio`.`foto4`, `Annuncio`.`durata`, `Annuncio`.`password`, `Annuncio`.`immnumcamere`, `Annuncio`.`immmetratura`, `Annuncio`.`autokm`, `Annuncio`.`automarca`, `Annuncio`.`automodello`, `Annuncio`.`autoanno`, `Annuncio`.`IP`, `Annuncio`.`enabledadmin`, `Annuncio`.`rating1`, `Annuncio`.`votes1`, `Annuncio`.`donekey`, `Annuncio`.`user_id`, `Annuncio`.`isreported`, `Annuncio`.`ispremium`, `Annuncio`.`adult`, `Province`.`Codice_Regione`, `Province`.`Codice_Provincia`, `Province`.`Denominazione_Regione`, `Province`.`Denominazione_Provincia`, `Category`.`urlname`, `Category`.`id`, `Category`.`name` FROM `annunci` AS `Annuncio` LEFT JOIN `provinces` AS `Province` ON (`Annuncio`.`province_id` = `Province`.`id`) LEFT JOIN `categories` AS `Category` ON (`Annuncio`.`category_id` = `Category`.`id`) WHERE enabled=1 and enabledadmin=1 and `Annuncio`.`id`= ORDER BY `created` desc LIMIT 1
Warning (2): Invalid argument supplied for foreach() [APP/views/elements/bannerpay.ctp, line 23]
$___viewFn = "/web/htdocs/www.annunciefree.com/home/app/views/elements/bannerpay.ctp" $___dataForView = array( "adult" => true, "completeurl" => "https://www.annunciefree.com/users/login", "text" => TextHelper TextHelper::$helpers = NULL TextHelper::$base = "" TextHelper::$webroot = "/" TextHelper::$themeWeb = NULL TextHelper::$here = "/users/login" TextHelper::$params = array TextHelper::$action = "login" 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 = "/users/login" TimeHelper::$params = array TimeHelper::$action = "login" 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 = "/users/login" HtmlHelper::$params = array HtmlHelper::$action = "login" 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 = "/users/login" JavascriptHelper::$params = array JavascriptHelper::$action = "login" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL JavascriptHelper::$_log = NULL, "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 = "/users/login" AjaxHelper::$params = array AjaxHelper::$action = "login" 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, "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 = "/users/login" FormHelper::$params = array FormHelper::$action = "login" 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, "emo" => EmoHelper EmoHelper::$helpers = array EmoHelper::$base = "" EmoHelper::$webroot = "/" EmoHelper::$themeWeb = NULL EmoHelper::$here = "/users/login" EmoHelper::$params = array EmoHelper::$action = "login" EmoHelper::$plugin = NULL EmoHelper::$data = NULL EmoHelper::$namedArgs = NULL EmoHelper::$argSeparator = NULL EmoHelper::$validationErrors = NULL EmoHelper::$tags = array EmoHelper::$__tainted = NULL EmoHelper::$__cleaned = NULL EmoHelper::$_log = NULL EmoHelper::$html = HtmlHelper object, "session" => SessionHelper SessionHelper::$helpers = NULL SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = array SessionHelper::$_userAgent = "deb7e67b535d350c7dab354dcc80735a" SessionHelper::$path = "/" SessionHelper::$lastError = 2 SessionHelper::$security = NULL SessionHelper::$time = 1714963220 SessionHelper::$sessionTime = false SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_log = NULL SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/users/login" SessionHelper::$params = array SessionHelper::$action = "login" SessionHelper::$data = NULL SessionHelper::$themeWeb = NULL SessionHelper::$plugin = NULL ) $loadHelpers = false $cached = false $loadedHelpers = array() $adult = true $completeurl = "https://www.annunciefree.com/users/login" $text = TextHelper TextHelper::$helpers = NULL TextHelper::$base = "" TextHelper::$webroot = "/" TextHelper::$themeWeb = NULL TextHelper::$here = "/users/login" TextHelper::$params = array TextHelper::$action = "login" 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 = "/users/login" TimeHelper::$params = array TimeHelper::$action = "login" 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 = "/users/login" HtmlHelper::$params = array HtmlHelper::$action = "login" 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 = "/users/login" JavascriptHelper::$params = array JavascriptHelper::$action = "login" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL JavascriptHelper::$_log = NULL $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 = "/users/login" AjaxHelper::$params = array AjaxHelper::$action = "login" 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 $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 = "/users/login" FormHelper::$params = array FormHelper::$action = "login" 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 $emo = EmoHelper EmoHelper::$helpers = array EmoHelper::$base = "" EmoHelper::$webroot = "/" EmoHelper::$themeWeb = NULL EmoHelper::$here = "/users/login" EmoHelper::$params = array EmoHelper::$action = "login" EmoHelper::$plugin = NULL EmoHelper::$data = NULL EmoHelper::$namedArgs = NULL EmoHelper::$argSeparator = NULL EmoHelper::$validationErrors = NULL EmoHelper::$tags = array EmoHelper::$__tainted = NULL EmoHelper::$__cleaned = NULL EmoHelper::$_log = NULL EmoHelper::$html = HtmlHelper object $session = SessionHelper SessionHelper::$helpers = NULL SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = array SessionHelper::$_userAgent = "deb7e67b535d350c7dab354dcc80735a" SessionHelper::$path = "/" SessionHelper::$lastError = 2 SessionHelper::$security = NULL SessionHelper::$time = 1714963220 SessionHelper::$sessionTime = false SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_log = NULL SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/users/login" SessionHelper::$params = array SessionHelper::$action = "login" SessionHelper::$data = NULL SessionHelper::$themeWeb = NULL SessionHelper::$plugin = NULL $currid = 0 $annunci = false $counter = 0
<?//debug($annunci);?>
<?$counter=0;?>
<?foreach($annunci as $annuncio):?>
include - APP/views/elements/bannerpay.ctp, line 23 View::_render() - CORE/cake/libs/view/view.php, line 662 View::element() - CORE/cake/libs/view/view.php, line 343 include - APP/views/layouts/default.ctp, line 156 View::_render() - CORE/cake/libs/view/view.php, line 662 View::renderLayout() - CORE/cake/libs/view/view.php, line 450 View::render() - CORE/cake/libs/view/view.php, line 388 Controller::render() - CORE/cake/libs/controller/controller.php, line 799 UsersController::login() - APP/controllers/users_controller.php, line 113 Object::dispatchMethod() - CORE/cake/libs/object.php, line 115 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194 [main] - APP/webroot/index.php, line 88