Data: 31/12/1969
Por: |
|
|
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 `Forumpost`.`id` ASC' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 525]
Code |
Context$sql = "SELECT `Forumpost`.`id`, `Forumpost`.`forumtopic_id`, `Forumpost`.`client_id`, `Forumpost`.`forumsituation_id`, `Forumpost`.`description`, `Forumpost`.`image`, `Forumpost`.`created`, `Forumpost`.`modified`, `Forumtopic`.`id`, `Forumtopic`.`forumcategory_id`, `Forumtopic`.`client_id`, `Forumtopic`.`forumsituation_id`, `Forumtopic`.`title`, `Forumtopic`.`description`, `Forumtopic`.`image`, `Forumtopic`.`created`, `Forumtopic`.`modified`, `Client`.`id`, `Client`.`name`, `Client`.`cpf`, `Client`.`address`, `Client`.`number`, `Client`.`email`, `Client`.`banking`, `Client`.`access`, `Client`.`created`, `Client`.`modified`, `Client`.`password`, `Client`.`acess_number`, `Client`.`acess_date`, `Forumsituation`.`id`, `Forumsituation`.`title` FROM `forumposts` AS `Forumpost` LEFT JOIN `forumtopics` AS `Forumtopic` ON (`Forumpost`.`forumtopic_id` = `Forumtopic`.`id`) LEFT JOIN `clients` AS `Client` ON (`Forumpost`.`client_id` = `Client`.`id`) LEFT JOIN `forumsituations` AS `Forumsituation` ON (`Forumpost`.`forumsituation_id` = `Forumsituation`.`id`) WHERE forumtopic_id = ORDER BY `Forumpost`.`id` 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 'ORDER BY `Forumpost`.`id` ASC' 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 336
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 653
Model::find() - CORE/cake/libs/model/model.php, line 1988
ForumpostsController::list_home() - APP/controllers/forumposts_controller.php, line 46
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
Object::requestAction() - CORE/cake/libs/object.php, line 101
include - APP/views/forumtopics/index.ctp, line 33
View::_render() - CORE/cake/libs/view/view.php, line 666
View::render() - CORE/cake/libs/view/view.php, line 376
Controller::render() - CORE/cake/libs/controller/controller.php, line 803
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 230
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
Query: SELECT `Forumpost`.`id`, `Forumpost`.`forumtopic_id`, `Forumpost`.`client_id`, `Forumpost`.`forumsituation_id`, `Forumpost`.`description`, `Forumpost`.`image`, `Forumpost`.`created`, `Forumpost`.`modified`, `Forumtopic`.`id`, `Forumtopic`.`forumcategory_id`, `Forumtopic`.`client_id`, `Forumtopic`.`forumsituation_id`, `Forumtopic`.`title`, `Forumtopic`.`description`, `Forumtopic`.`image`, `Forumtopic`.`created`, `Forumtopic`.`modified`, `Client`.`id`, `Client`.`name`, `Client`.`cpf`, `Client`.`address`, `Client`.`number`, `Client`.`email`, `Client`.`banking`, `Client`.`access`, `Client`.`created`, `Client`.`modified`, `Client`.`password`, `Client`.`acess_number`, `Client`.`acess_date`, `Forumsituation`.`id`, `Forumsituation`.`title` FROM `forumposts` AS `Forumpost` LEFT JOIN `forumtopics` AS `Forumtopic` ON (`Forumpost`.`forumtopic_id` = `Forumtopic`.`id`) LEFT JOIN `clients` AS `Client` ON (`Forumpost`.`client_id` = `Client`.`id`) LEFT JOIN `forumsituations` AS `Forumsituation` ON (`Forumpost`.`forumsituation_id` = `Forumsituation`.`id`) WHERE forumtopic_id = ORDER BY `Forumpost`.`id` ASC
Warning (2): Invalid argument supplied for foreach() [APP/views/forumtopics/index.ctp, line 34]
Code |
Context$___viewFn = "/home/blackpixel1/public_html/app/views/forumtopics/index.ctp"
$___dataForView = array(
"forumtopic" => false
)
$loadHelpers = true
$cached = false
$loadedHelpers = array(
"Html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/forumtopics/index/33"
HtmlHelper::$params = array
HtmlHelper::$action = "index"
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 = "/forumtopics/index/33"
FormHelper::$params = array
FormHelper::$action = "index"
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,
"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 = "/forumtopics/index/33"
JavascriptHelper::$params = array
JavascriptHelper::$action = "index"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
"html" => HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/forumtopics/index/33"
HtmlHelper::$params = array
HtmlHelper::$action = "index"
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,
"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 = "/forumtopics/index/33"
AjaxHelper::$params = array
AjaxHelper::$action = "index"
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,
"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 = "/forumtopics/index/33"
JavascriptHelper::$params = array
JavascriptHelper::$action = "index"
JavascriptHelper::$plugin = NULL
JavascriptHelper::$data = NULL
JavascriptHelper::$namedArgs = NULL
JavascriptHelper::$argSeparator = NULL
JavascriptHelper::$validationErrors = NULL
JavascriptHelper::$__tainted = NULL
JavascriptHelper::$__cleaned = NULL
JavascriptHelper::$_log = NULL,
"Session" => SessionHelper
SessionHelper::$helpers = NULL
SessionHelper::$__active = true
SessionHelper::$valid = false
SessionHelper::$error = false
SessionHelper::$_userAgent = "fa3a5f938ed3d7398e9e84f354a42036"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1337526361
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/forumtopics/index/33"
SessionHelper::$params = array
SessionHelper::$action = "index"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
)
$helper = "Session"
$camelBackedHelper = "session"
$html = HtmlHelper
HtmlHelper::$tags = array
HtmlHelper::$base = ""
HtmlHelper::$here = "/forumtopics/index/33"
HtmlHelper::$params = array
HtmlHelper::$action = "index"
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 = "/forumtopics/index/33"
FormHelper::$params = array
FormHelper::$action = "index"
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
$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 = "/forumtopics/index/33"
JavascriptHelper::$params = array
JavascriptHelper::$action = "index"
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 = "/forumtopics/index/33"
AjaxHelper::$params = array
AjaxHelper::$action = "index"
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 = "fa3a5f938ed3d7398e9e84f354a42036"
SessionHelper::$path = "/"
SessionHelper::$lastError = NULL
SessionHelper::$security = NULL
SessionHelper::$time = 1337526361
SessionHelper::$sessionTime = false
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_log = NULL
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/forumtopics/index/33"
SessionHelper::$params = array
SessionHelper::$action = "index"
SessionHelper::$data = NULL
SessionHelper::$themeWeb = NULL
SessionHelper::$plugin = NULL
$forumtopic = false
$posts = false
<?
$posts = $this->requestAction('forumposts/list_home/'.$forumtopic['Forumtopic']['id']);
foreach($posts as $post):
include - APP/views/forumtopics/index.ctp, line 34
View::_render() - CORE/cake/libs/view/view.php, line 666
View::render() - CORE/cake/libs/view/view.php, line 376
Controller::render() - CORE/cake/libs/controller/controller.php, line 803
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 230
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88
