20 August 2010 at 3:34am
(Last edited: 20 August 2010 3:34am),
I have coded the Video page and built the database with success.
I can create a Video Page and attach a FLV file.
But when I want to see it, I have a SQL error with ParentID column does not exist.
Here is the error :
[User Error] Couldn't run query : SELECT "Video"."ClassName", "Video"."Created", "Video"."LastEdited", "Video"."Title", "Video"."Description", "Video"."VideoID", "Video"."ID", CASE WHEN "Video"."ClassName" IS NOT NULL THEN "Video"."ClassName" ELSE "Video" END AS "RecordClassName" FROM "Video" WHERE ("ParentID"=xx) Unknown column 'ParentID' in 'where clause'
I have checked the db and the Video : it did not contains ParentID field.
How do I solve my problem ? (Adding a Parent in Video.php)
public function getCMSFields()
$fields = parent::getCMSFields();
$fields->addFieldToTab("Root.Content.Videos", new FileDataObjectManager(
class VideoPage_Controller extends Page_Controller
I'd like to change and embed the video in the page, rather than have the pop up.
There was a line of code to use rather than $VideoPopup(160x160, 500x400) for this to happen, but I can't find it in my files anywhere.
Can anyone remind me of what to add / change please or do I have a false memory that it existed?