ERROR [User Error]: Couldn't run query:
SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."SlideEffect", "Page"."SlideDuration", "Page"."TransitionDuration", "Page"."TransitionDurationOnUserEvent", "Page"."AutoPlay", "Page"."Loop", "Page"."PauseOnHover", "Page"."NextPrevButtons", "Page"."SlideButtons", "Page"."ShowThumbnails", "Page"."FeatureImage1ID", "Page"."FeatureImage2ID", "Page"."FeatureImage3ID", "Page"."FeatureImage4ID", "Page"."FeatureImage5ID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName"
FROM "SiteTree"
LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID"
WHERE ("SiteTree"."ClassName" IN ('HomePage')) AND (`HomePage`.`ID` <> 1)
ORDER BY LastEdited DESC
LIMIT 1
Unknown column 'HomePage.ID' in 'where clause'
IN POST /admin/getitem?ID=1&ajax=1
Line 525 in /home/soundsma/public_html/sapphire/core/model/MySQLDatabase.php
Source
======
516: }
517:
518: function databaseError($msg, $errorLevel = E_USER_ERROR) {
519: // try to extract and format query
520: if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
521: $formatter = new SQLFormatter();
522: $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
523: }
524:
* 525: user_error($msg, $errorLevel);
526: }
527:
528: /**
529: * Return a boolean type-formatted string
530: *
531: * @param array $values Contains a tokenised list of info about this data type
Trace
=====
user_error(Couldn't run query:
SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."SlideEffect", "Page"."SlideDuration", "Page"."TransitionDuration", "Page"."TransitionDurationOnUserEvent", "Page"."AutoPlay", "Page"."Loop", "Page"."PauseOnHover", "Page"."NextPrevButtons", "Page"."SlideButtons", "Page"."ShowThumbnails", "Page"."FeatureImage1ID", "Page"."FeatureImage2ID", "Page"."FeatureImage3ID", "Page"."FeatureImage4ID", "Page"."FeatureImage5ID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName"
FROM "SiteTree"
LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID"
WHERE ("SiteTree"."ClassName" IN ('HomePage')) AND (`HomePage`.`ID` <> 1)
ORDER BY LastEdited DESC
LIMIT 1
Unknown column 'HomePage.ID' in 'where clause',256)
line 525 of MySQLDatabase.php
MySQLDatabase->databaseError(Couldn't run query: SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."SlideEffect", "Page"."SlideDuration", "Page"."TransitionDuration", "Page"."TransitionDurationOnUserEvent", "Page"."AutoPlay", "Page"."Loop", "Page"."PauseOnHover", "Page"."NextPrevButtons", "Page"."SlideButtons", "Page"."ShowThumbnails", "Page"."FeatureImage1ID", "Page"."FeatureImage2ID", "Page"."FeatureImage3ID", "Page"."FeatureImage4ID", "Page"."FeatureImage5ID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("SiteTree"."ClassName" IN ('HomePage')) AND (`HomePage`.`ID` <> 1) ORDER BY LastEdited DESC LIMIT 1 | Unknown column 'HomePage.ID' in 'where clause',256)
line 123 of MySQLDatabase.php
MySQLDatabase->query(SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."SlideEffect", "Page"."SlideDuration", "Page"."TransitionDuration", "Page"."TransitionDurationOnUserEvent", "Page"."AutoPlay", "Page"."Loop", "Page"."PauseOnHover", "Page"."NextPrevButtons", "Page"."SlideButtons", "Page"."ShowThumbnails", "Page"."FeatureImage1ID", "Page"."FeatureImage2ID", "Page"."FeatureImage3ID", "Page"."FeatureImage4ID", "Page"."FeatureImage5ID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("SiteTree"."ClassName" IN ('HomePage')) AND (`HomePage`.`ID` <> 1) ORDER BY LastEdited DESC LIMIT 1,256)
line 129 of DB.php
DB::query(SELECT "SiteTree"."ClassName", "SiteTree"."Created", "SiteTree"."LastEdited", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaTitle", "SiteTree"."MetaDescription", "SiteTree"."MetaKeywords", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."HomepageForDomain", "SiteTree"."ProvideComments", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."Status", "SiteTree"."ReportClass", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."ToDo", "SiteTree"."Version", "SiteTree"."Priority", "SiteTree"."ParentID", "Page"."SlideEffect", "Page"."SlideDuration", "Page"."TransitionDuration", "Page"."TransitionDurationOnUserEvent", "Page"."AutoPlay", "Page"."Loop", "Page"."PauseOnHover", "Page"."NextPrevButtons", "Page"."SlideButtons", "Page"."ShowThumbnails", "Page"."FeatureImage1ID", "Page"."FeatureImage2ID", "Page"."FeatureImage3ID", "Page"."FeatureImage4ID", "Page"."FeatureImage5ID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" LEFT JOIN "Page" ON "Page"."ID" = "SiteTree"."ID" WHERE ("SiteTree"."ClassName" IN ('HomePage')) AND (`HomePage`.`ID` <> 1) ORDER BY LastEdited DESC LIMIT 1,256)
line 400 of SQLQuery.php
SQLQuery->execute()
line 2884 of DataObject.php
DataObject->instance_get_one(`HomePage`.`ID` <> 1,LastEdited DESC)
line 2808 of DataObject.php
DataObject::get_one(HomePage,`HomePage`.`ID` <> 1,,LastEdited DESC)
line 165 of Slideshow.php
Slideshow->setDefaults()
line 68 of Slideshow.php
Slideshow->updateCMSFields(FieldSet,,,,,,)
line 963 of Object.php
Object->extend(updateCMSFields,FieldSet)
line 1892 of SiteTree.php
SiteTree->getCMSFields()
line 17 of Page.php
Page->getCMSFields(CMSMain)
line 441 of CMSMain.php
CMSMain->getEditForm(1)
line 1039 of LeftAndMain.php
LeftAndMain->EditForm()
line 389 of LeftAndMain.php
LeftAndMain->getitem(SS_HTTPRequest)
line 193 of Controller.php
Controller->handleAction(SS_HTTPRequest)
line 143 of RequestHandler.php
RequestHandler->handleRequest(SS_HTTPRequest)
line 147 of Controller.php
Controller->handleRequest(SS_HTTPRequest)
line 282 of Director.php
Director::handleRequest(SS_HTTPRequest,Session)
line 125 of Director.php
Director::direct(/admin/getitem)
line 127 of main.php