Line 237 in C:\xampp\htdocs\Test3\SilverStripe\postgresql\code
Werbung
[Warning] pg_query(): Query failed:
FEHLER: fehlender Eintrag in FROMKlausel für Tabelle »post« LINE 1:
...ame" FROM "Post" WHERE
("ForumID" = '7') ORDER BY Post.ID
DE... ^
GET /Test3/Silverstripe/index.php/forums/
Line 237 in
C:\xampp\htdocs\Test3\SilverStripe\postgresql\code\PostgreSQLDatabase.php
Source
228
if(isset($_REQUEST['previewwrite']) &&
in_array(strtolower(substr($sql,0,strpos($sql,' '))),
array('insert','update','delete','replace'))) {
229
Debug::message("Will execute: $sql");
230
return;
231
}
232
233
if(isset($_REQUEST['showqueries'])) {
234
$starttime = microtime(true);
235
}
236
237
$handle = pg_query($this->dbConn, $sql);
238
239
if(isset($_REQUEST['showqueries'])) {
240
1000, 1);
$endtime = round((microtime(true) - $starttime) *
241
Debug::message("\n$sql\n{$endtime}ms\n", false);
242
}
243
Trace
pg_query(Resource id #106,SELECT DISTINCT "Post"."ClassName",
"Post"."Created", "Post"."LastEdited", "Post"."Content", "Post"."Status",
"Post"."AuthorID", "Post"."ThreadID", "Post"."ForumID", "Post"."ID",
CASE WHEN "Post"."ClassName" IS NOT NULL THEN "Post"."ClassName"
ELSE 'Post' END AS "RecordClassName" FROM "Post" WHERE ("ForumID"
= '7') ORDER BY Post.ID DESC LIMIT 1)
PostgreSQLDatabase.php:237
PostgreSQLDatabase->query(SELECT DISTINCT "Post"."ClassName",
"Post"."Created", "Post"."LastEdited", "Post"."Content", "Post"."Status",
"Post"."AuthorID", "Post"."ThreadID", "Post"."ForumID", "Post"."ID",
CASE WHEN "Post"."ClassName" IS NOT NULL THEN "Post"."ClassName"
ELSE 'Post' END AS "RecordClassName" FROM "Post" WHERE ("ForumID"
= '7') ORDER BY Post.ID DESC LIMIT 1,256)
DB.php:130
DB::query(SELECT DISTINCT "Post"."ClassName", "Post"."Created",
"Post"."LastEdited", "Post"."Content", "Post"."Status", "Post"."AuthorID",
"Post"."ThreadID", "Post"."ForumID", "Post"."ID", CASE WHEN
"Post"."ClassName" IS NOT NULL THEN "Post"."ClassName" ELSE 'Post'
END AS "RecordClassName" FROM "Post" WHERE ("ForumID" = '7')
ORDER BY Post.ID DESC LIMIT 1,256)
SQLQuery.php:930
SQLQuery->execute()
DataList.php:716
DataList->first()
Forum.php:358
Forum->getLatestPost()
ViewableData.php:106
ViewableData->__get(LatestPost)
ViewableData.php:368
ViewableData->obj(LatestPost,,,1,)
ViewableData.php:408
ViewableData->cachedCall(LatestPost,)
ViewableData.php:421
ViewableData->hasValue(LatestPost,,1)
DataObject.php:3570
DataObject->hasValue(LatestPost,,1)
call_user_func_array(Array,Array)
SSViewer.php:144
SSViewer_Scope->__call(hasValue,Array)
SSViewer.php:490
SSViewer_DataPresenter->__call(hasValue,Array)
.cache.forum.templates.Includes.ForumHolder_List.ss:72
SSViewer_DataPresenter->hasValue(LatestPost,,1)
.cache.forum.templates.Includes.ForumHolder_List.ss:72
include(C:\Users\Kerstin\AppData\Local\Temp\silverstripe-cacheC--xampphtdocs-Test3-SilverStripe\.cache.forum.templates.Includes.ForumHolder_List.ss)
SSViewer.php:838
SSViewer>includeGeneratedTemplate(C:\Users\Kerstin\AppData\Local\Temp/silverstripecacheC--xampp-htdocs-Test3SilverStripe/.cache.forum.templates.Includes.ForumHolder_List.ss,Forum,Array
,Array)
SSViewer.php:910
SSViewer->process(Forum,Array)
SSViewer.php:944
SSViewer::execute_template(ForumHolder_List,Forum,Array)
.cache.forum.templates.Layout.ForumHolder.ss:122
include(C:\Users\Kerstin\AppData\Local\Temp\silverstripe-cacheC--xampphtdocs-Test3-SilverStripe\.cache.forum.templates.Layout.ForumHolder.ss)
SSViewer.php:838
SSViewer>includeGeneratedTemplate(C:\Users\Kerstin\AppData\Local\Temp/silverstripecacheC--xampp-htdocs-Test3SilverStripe/.cache.forum.templates.Layout.ForumHolder.ss,ForumHolder_Cont
roller,,Array)
SSViewer.php:910
SSViewer->process(ForumHolder_Controller,)
SSViewer.php:906
SSViewer->process(ForumHolder_Controller)
Controller.php:214
Controller->handleAction(SS_HTTPRequest)
RequestHandler.php:184
RequestHandler->handleRequest(SS_HTTPRequest,DataModel)
Controller.php:153
Controller->handleRequest(SS_HTTPRequest,DataModel)
ContentController.php:197
ContentController->handleRequest(SS_HTTPRequest,DataModel)
ModelAsController.php:68
ModelAsController->handleRequest(SS_HTTPRequest,DataModel)
Director.php:307
Director::handleRequest(SS_HTTPRequest,Session,DataModel)
Director.php:119
Director::direct(forums/,DataModel)
main.php:126
require_once(C:\xampp\htdocs\Test3\SilverStripe\framework\main.php)
index.php:66
[User Error] Couldn't run query: SELECT
DISTINCT "Post"."ClassName",
"Post"."Created", "Post"."LastEdited",
"Post"."Content", "Post"."Status",
"Post"."AuthorID", "Post"."ThreadID",
"Post"."ForumID", "Post"."ID", CASE
WHEN "Post"."ClassName" IS NOT
NULL THEN "Post"."ClassName" ELSE
'Post' END AS "RecordClassName" FROM
"Post" WHERE ("ForumID" = '7')
ORDER BY Post.ID DESC LIMIT 1 |
FEHLER: fehlender Eintrag in FROMKlausel für Tabelle »post« LINE 1:
...ame" FROM "Post" WHERE
("ForumID" = '7') ORDER BY Post.ID
DE... ^
GET /Test3/Silverstripe/index.php/forums/
Line 693 in C:\xampp\htdocs\Test3\SilverStripe\framework\model\Database.php
Source
684
685
/**
* Error handler for database errors.
686
* All database errors will call this function to report the error.
It isn't a static function;
687
* it will be called on the object itself and as such can be
overridden in a subclass.
688
* @todo hook this into a more well-structured error handling
system.
689
* @param string $msg The error message.
690
* @param int $errorLevel The level of the error to throw.
691
*/
692
693
public function databaseError($msg, $errorLevel = E_USER_ERROR) {
user_error($msg, $errorLevel);
694
}
695
696
/**
697
* Enable supression of database messages.
698
*/
699
public function quiet() {
Trace
Couldn't run query: SELECT DISTINCT "Post"."ClassName", "Post"."Created",
"Post"."LastEdited", "Post"."Content", "Post"."Status", "Post"."AuthorID", "Post"."ThreadID",
"Post"."ForumID", "Post"."ID", CASE WHEN "Post"."ClassName" IS NOT NULL THEN
"Post"."ClassName" ELSE 'Post' END AS "RecordClassName" FROM "Post" WHERE
("ForumID" = '7') ORDER BY Post.ID DESC LIMIT 1 | FEHLER: fehlender Eintrag in FROMKlausel für Tabelle »post« LINE 1: ...ame" FROM "Post" WHERE ("ForumID" = '7') ORDER BY
Post.ID DE... ^
Database.php:693
SS_Database->databaseError(Couldn't run query: SELECT DISTINCT "Post"."ClassName",
"Post"."Created", "Post"."LastEdited", "Post"."Content", "Post"."Status", "Post"."AuthorID",
"Post"."ThreadID", "Post"."ForumID", "Post"."ID", CASE WHEN "Post"."ClassName" IS NOT
NULL THEN "Post"."ClassName" ELSE 'Post' END AS "RecordClassName" FROM "Post"
WHERE ("ForumID" = '7') ORDER BY Post.ID DESC LIMIT 1 | FEHLER: fehlender Eintrag in
FROM-Klausel für Tabelle »post« LINE 1: ...ame" FROM "Post" WHERE ("ForumID" = '7')
ORDER BY Post.ID DE... ^,256)
PostgreSQLDatabase.php:246
PostgreSQLDatabase->query(SELECT DISTINCT "Post"."ClassName", "Post"."Created",
"Post"."LastEdited", "Post"."Content", "Post"."Status", "Post"."AuthorID", "Post"."ThreadID",
"Post"."ForumID", "Post"."ID", CASE WHEN "Post"."ClassName" IS NOT NULL THEN
"Post"."ClassName" ELSE 'Post' END AS "RecordClassName" FROM "Post" WHERE
("ForumID" = '7') ORDER BY Post.ID DESC LIMIT 1,256)
DB.php:130
DB::query(SELECT DISTINCT "Post"."ClassName", "Post"."Created", "Post"."LastEdited",
"Post"."Content", "Post"."Status", "Post"."AuthorID", "Post"."ThreadID", "Post"."ForumID",
"Post"."ID", CASE WHEN "Post"."ClassName" IS NOT NULL THEN "Post"."ClassName" ELSE
'Post' END AS "RecordClassName" FROM "Post" WHERE ("ForumID" = '7') ORDER BY
Post.ID DESC LIMIT 1,256)
SQLQuery.php:930
SQLQuery->execute()
DataList.php:716
DataList->first()
Forum.php:358
Forum->getLatestPost()
ViewableData.php:106
ViewableData->__get(LatestPost)
ViewableData.php:368
ViewableData->obj(LatestPost,,,1,)
ViewableData.php:408
ViewableData->cachedCall(LatestPost,)
ViewableData.php:421
ViewableData->hasValue(LatestPost,,1)
DataObject.php:3570
DataObject->hasValue(LatestPost,,1)
call_user_func_array(Array,Array)
SSViewer.php:144
SSViewer_Scope->__call(hasValue,Array)
SSViewer.php:490
SSViewer_DataPresenter->__call(hasValue,Array)
.cache.forum.templates.Includes.ForumHolder_List.ss:72
SSViewer_DataPresenter->hasValue(LatestPost,,1)
.cache.forum.templates.Includes.ForumHolder_List.ss:72
include(C:\Users\Kerstin\AppData\Local\Temp\silverstripe-cacheC--xampp-htdocs-Test3SilverStripe\.cache.forum.templates.Includes.ForumHolder_List.ss)
SSViewer.php:838
SSViewer->includeGeneratedTemplate(C:\Users\Kerstin\AppData\Local\Temp/silverstripe-cacheC-xampp-htdocs-Test3SilverStripe/.cache.forum.templates.Includes.ForumHolder_List.ss,Forum,Array,Array)
SSViewer.php:910
SSViewer->process(Forum,Array)
SSViewer.php:944
SSViewer::execute_template(ForumHolder_List,Forum,Array)
.cache.forum.templates.Layout.ForumHolder.ss:122
include(C:\Users\Kerstin\AppData\Local\Temp\silverstripe-cacheC--xampp-htdocs-Test3SilverStripe\.cache.forum.templates.Layout.ForumHolder.ss)
SSViewer.php:838
SSViewer->includeGeneratedTemplate(C:\Users\Kerstin\AppData\Local\Temp/silverstripe-cacheC-xampp-htdocs-Test3SilverStripe/.cache.forum.templates.Layout.ForumHolder.ss,ForumHolder_Controller,,Array)
SSViewer.php:910
SSViewer->process(ForumHolder_Controller,)
SSViewer.php:906
SSViewer->process(ForumHolder_Controller)
Controller.php:214
Controller->handleAction(SS_HTTPRequest)
RequestHandler.php:184
RequestHandler->handleRequest(SS_HTTPRequest,DataModel)
Controller.php:153
Controller->handleRequest(SS_HTTPRequest,DataModel)
ContentController.php:197
ContentController->handleRequest(SS_HTTPRequest,DataModel)
ModelAsController.php:68
ModelAsController->handleRequest(SS_HTTPRequest,DataModel)
Director.php:307
Director::handleRequest(SS_HTTPRequest,Session,DataModel)
Director.php:119
Director::direct(forums/,DataModel)
main.php:126
require_once(C:\xampp\htdocs\Test3\SilverStripe\framework\main.php)
index.php:66