Dear Silverstripers,
i'm struggling with a weird issue that only appears on my live machine and
not on my local machine. I added some fields in mysite/code/ProjectPage.php
and run dev/build. On my local machine Silverstripe adds the fields to the database.
If I deploy ProjectPage.php to my live machine and run dev/build Silverstripe gives
me the message that all fields were added successfully but then I go back on my
home page I get the following:
[User Error] Couldn't run query: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" WHERE ("ProjectPage"."ID" = 7) AND ("SiteTree_Live"."ClassName" IN ('ProjectPage')) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 Unknown column 'ProjectPage.ID' in 'where clause'
GET /
Line 598 in /www/htdocs/w00c0dec/new.hermanndettmann.com/framework/model/MySQLDatabase.php
Source
589 }
590
591 public function databaseError($msg, $errorLevel = E_USER_ERROR) {
592 // try to extract and format query
593 if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
594 $formatter = new SQLFormatter();
595 $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
596 }
597
598 user_error($msg, $errorLevel);
599 }
600
601 /**
602 * Return a boolean type-formatted string
603 *
604 * @param array $values Contains a tokenised list of info about this data type
Trace
Couldn't run query: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" WHERE ("ProjectPage"."ID" = 7) AND ("SiteTree_Live"."ClassName" IN ('ProjectPage')) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 Unknown column 'ProjectPage.ID' in 'where clause'
MySQLDatabase.php:598
MySQLDatabase->databaseError(Couldn't run query: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" WHERE ("ProjectPage"."ID" = 7) AND ("SiteTree_Live"."ClassName" IN ('ProjectPage')) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 | Unknown column 'ProjectPage.ID' in 'where clause',256)
MySQLDatabase.php:150
MySQLDatabase->query(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" WHERE ("ProjectPage"."ID" = 7) AND ("SiteTree_Live"."ClassName" IN ('ProjectPage')) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1,256)
DB.php:208
DB::query(SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."Created", "SiteTree_Live"."LastEdited", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" WHERE ("ProjectPage"."ID" = 7) AND ("SiteTree_Live"."ClassName" IN ('ProjectPage')) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1,256)
SQLQuery.php:951
SQLQuery->execute()
DataQuery.php:327
DataQuery->execute()
DataObject.php:2209
DataObject->loadLazyFields(ProjectPage)
DataObject.php:2127
DataObject->getField(TeaserImageID)
DataObject.php:1419
DataObject->getComponent(TeaserImage)
call_user_func_array(Array,Array)
Object.php:749
Object->__call(TeaserImage,Array)
ViewableData.php:361
ProjectPage->TeaserImage()
ViewableData.php:361
ViewableData->obj(TeaserImage,,1,,)
SSViewer.php:91
SSViewer_Scope->getObj(TeaserImage,,1,,)
SSViewer.php:504
SSViewer_DataPresenter->getObj(TeaserImage,,1,,)
SSViewer.php:111
SSViewer_Scope->obj(TeaserImage,,1)
.cache.themes.hermanndettmann2014.templates.Layout.Start.ss:68
include(/tmp/silverstripe-cache-php5.5.26-nmm1-www-htdocs-w00c0dec-new.hermanndettmann.com/w00c0dec/.cache.themes.hermanndettmann2014.templates.Layout.Start.ss)
SSViewer.php:1031
SSViewer->includeGeneratedTemplate(/tmp/silverstripe-cache-php5.5.26-nmm1-www-htdocs-w00c0dec-new.hermanndettmann.com/w00c0dec/.cache.themes.hermanndettmann2014.templates.Layout.Start.ss,Start_Controller,,Array,)
SSViewer.php:1098
SSViewer->process(Start_Controller,)
SSViewer.php:1094
SSViewer->process(Start_Controller)
Controller.php:203
Controller->handleAction(SS_HTTPRequest,index)
RequestHandler.php:200
RequestHandler->handleRequest(SS_HTTPRequest,DataModel)
Controller.php:153
Controller->handleRequest(SS_HTTPRequest,DataModel)
ContentController.php:198
ContentController->handleRequest(SS_HTTPRequest,DataModel)
ModelAsController.php:78
ModelAsController->handleRequest(SS_HTTPRequest,DataModel)
RootURLController.php:130
RootURLController->handleRequest(SS_HTTPRequest,DataModel)
Director.php:370
Director::handleRequest(SS_HTTPRequest,Session,DataModel)
Director.php:153
Director::direct(/,DataModel)
main.php:177
I already tried to run /dev/build/?flush=1 or /dev/build/?flush=all without
any success.
Hope some of you can help as I am pretty desperate about this problem
and found nothing on google search or in the forum.