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 id' at line 1 [CORE/cake/libs/model/datasources/dbo_source.php, line 666]Code | Context$out = null;if ($error) {trigger_error('<span style="color:Red;text-align:left"><b>' . __('SQL Error:', true) . "</b> {$this->error}</span>", E_USER_WARNING);$sql = "select * from pages as Page where parent_id= order by id" $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 id' at line 1" $out = nullDboSource::showQuery() - CORE/cake/libs/model/datasources/dbo_source.php, line 666 DboSource::execute() - CORE/cake/libs/model/datasources/dbo_source.php, line 256 DboSource::fetchAll() - CORE/cake/libs/model/datasources/dbo_source.php, line 400 DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php, line 277 Model::query() - CORE/cake/libs/model/model.php, line 2420 PagesController::view_page() - APP/controllers/pages_controller.php, line 19 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 204 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 [main] - APP/webroot/index.php, line 83
Query: select * from pages as Page where parent_id= order by id
Warning (2): Invalid argument supplied for foreach() [APP/views/pages/view_page.ctp, line 17]TexteCode | Context$i=0;$attachment_ids = array();foreach ($page["Attachment"] as $a) {$___viewFn = "/home/www/mip.at/htdocs/app/views/pages/view_page.ctp" $___dataForView = array( "isloggedin" => false, "language" => "de", "child_pages" => false, "page" => false, "title_for_layout" => "museum in progress - " ) $loadHelpers = true $cached = false $form = FormHelper FormHelper::$helpers = array FormHelper::$fieldset = array FormHelper::$__options = array FormHelper::$fields = array FormHelper::$requestType = NULL FormHelper::$defaultModel = NULL FormHelper::$_inputDefaults = array FormHelper::$base = "" FormHelper::$webroot = "/" FormHelper::$theme = NULL FormHelper::$here = "/de/dokumente/1137-content.html" FormHelper::$params = array FormHelper::$action = "view_page" 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::$Html = HtmlHelper object $html = HtmlHelper HtmlHelper::$tags = array HtmlHelper::$_crumbs = array HtmlHelper::$__includedScripts = array HtmlHelper::$_scriptBlockOptions = array HtmlHelper::$__docTypes = array HtmlHelper::$helpers = NULL HtmlHelper::$base = "" HtmlHelper::$webroot = "/" HtmlHelper::$theme = NULL HtmlHelper::$here = "/de/dokumente/1137-content.html" HtmlHelper::$params = array HtmlHelper::$action = "view_page" HtmlHelper::$plugin = NULL HtmlHelper::$data = NULL HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL $session = SessionHelper SessionHelper::$helpers = array SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "a88d617542cd30696afb2c265b203f9d" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "high" SessionHelper::$time = 1328405555 SessionHelper::$sessionTime = 1328406755 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = true SessionHelper::$host = NULL SessionHelper::$cookieLifeTime = 0 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/de/dokumente/1137-content.html" SessionHelper::$params = array SessionHelper::$action = "view_page" SessionHelper::$data = NULL SessionHelper::$theme = NULL SessionHelper::$plugin = NULL $isloggedin = false $language = "de" $child_pages = false $page = false $title_for_layout = "museum in progress - " $i = 0 $attachment_ids = array()include - APP/views/pages/view_page.ctp, line 17 View::_render() - CORE/cake/libs/view/view.php, line 723 View::render() - CORE/cake/libs/view/view.php, line 419 Controller::render() - CORE/cake/libs/controller/controller.php, line 909 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 [main] - APP/webroot/index.php, line 83
Warning (2): Invalid argument supplied for foreach() [APP/views/pages/view_page.ctp, line 39]Code | Context<? if (sizeof($child_pages)>0) {if ($i==0) echo '<b>'.__('lbl_attachments',true).'</b><br/>';foreach ($child_pages as $p) {$___viewFn = "/home/www/mip.at/htdocs/app/views/pages/view_page.ctp" $___dataForView = array( "isloggedin" => false, "language" => "de", "child_pages" => false, "page" => false, "title_for_layout" => "museum in progress - " ) $loadHelpers = true $cached = false $form = FormHelper FormHelper::$helpers = array FormHelper::$fieldset = array FormHelper::$__options = array FormHelper::$fields = array FormHelper::$requestType = NULL FormHelper::$defaultModel = NULL FormHelper::$_inputDefaults = array FormHelper::$base = "" FormHelper::$webroot = "/" FormHelper::$theme = NULL FormHelper::$here = "/de/dokumente/1137-content.html" FormHelper::$params = array FormHelper::$action = "view_page" 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::$Html = HtmlHelper object $html = HtmlHelper HtmlHelper::$tags = array HtmlHelper::$_crumbs = array HtmlHelper::$__includedScripts = array HtmlHelper::$_scriptBlockOptions = array HtmlHelper::$__docTypes = array HtmlHelper::$helpers = NULL HtmlHelper::$base = "" HtmlHelper::$webroot = "/" HtmlHelper::$theme = NULL HtmlHelper::$here = "/de/dokumente/1137-content.html" HtmlHelper::$params = array HtmlHelper::$action = "view_page" HtmlHelper::$plugin = NULL HtmlHelper::$data = NULL HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL $session = SessionHelper SessionHelper::$helpers = array SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "a88d617542cd30696afb2c265b203f9d" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "high" SessionHelper::$time = 1328405555 SessionHelper::$sessionTime = 1328406755 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = true SessionHelper::$host = NULL SessionHelper::$cookieLifeTime = 0 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/de/dokumente/1137-content.html" SessionHelper::$params = array SessionHelper::$action = "view_page" SessionHelper::$data = NULL SessionHelper::$theme = NULL SessionHelper::$plugin = NULL $isloggedin = false $language = "de" $child_pages = false $page = false $title_for_layout = "museum in progress - " $i = 0 $attachment_ids = array()include - APP/views/pages/view_page.ctp, line 39 View::_render() - CORE/cake/libs/view/view.php, line 723 View::render() - CORE/cake/libs/view/view.php, line 419 Controller::render() - CORE/cake/libs/controller/controller.php, line 909 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 207 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 171 [main] - APP/webroot/index.php, line 83
Array
(
[Config] => Array
(
[userAgent] => a88d617542cd30696afb2c265b203f9d
[time] => 1328406755
[timeout] => 10
[language] => de
)
[redirect] => /de/dokumente/1137-content.html
)