Hi, I'm trying to add a dataobject to my homepage to be used as a jquery content slider containing:
- text
- image
- background
- cssID
How would I go about resizing the image in the admin area?
Also I have tried <? control slogan %> and get the follow error below when I access the homepage or visable here: http://www.web2works.co.uk
Thanks for any help.
Ben
------------- homepage.php -------------------
<?php
class Homepage extends Page {
static $singular_name = 'Homepage';
static $plural_name = 'Home';
static $has_many = array(
'Slogan' => 'Slogan'
);
static $icon = "cms/images/treeicons/home";
public function getCMSFields(){
$f = parent::getCMSFields();
$f->addFieldToTab("Root.Content.Slogan", new DataObjectManager(
$this,
'Slogan',
'Slogan',
array(
'SloganText'=> 'Text',
'CSSid' => 'CSS ID',
'SloganImage' => 'Image',
'SloganBackground' => 'Background'
),
'getCMSFields_forPopup'
));
return $f;
}
}
class Homepage_Controller extends Page_Controller {
}
?>
-------------- slogan.php -----------------
<?php
class Slogan extends DataObject {
static $db = array (
'SloganText' => 'Varchar(100)',
'CSSid' => 'Varchar(50)'
);
static $has_one = array (
'Homepage' => 'Homepage',
'SloganImage' => 'Image',
'SloganBackground' => 'Image'
);
static $singular_name = 'Slogan';
static $plural_name = 'Slogans';
public function getCMSFields_forPopup(){
return new FieldSet(
new TextField('SloganText'),
new TextField('CSSid'),
new ImageField('SloganImage'),
new ImageField('SloganBackground')
);
}
}
?>
----------- Error Page --------------
[User Error] Couldn't run query: SELECT "Slogan"."ClassName", "Slogan"."Created", "Slogan"."LastEdited", "Slogan"."SloganText", "Slogan"."CSSid", "Slogan"."SloganImageID", "Slogan"."SloganBackgroundID", "Slogan"."ID", CASE WHEN "Slogan"."ClassName" IS NOT NULL THEN "Slogan"."ClassName" ELSE 'Slogan' END AS "RecordClassName" FROM "Slogan" WHERE ("ParentID" = '1') Unknown column 'Slogan.SloganText' in 'field list'
GET /web2works/
Line 536 in C:\wamp\www\web2works\sapphire\core\model\MySQLDatabase.php
Source
527 }
528
529 function databaseError($msg, $errorLevel = E_USER_ERROR) {
530 // try to extract and format query
531 if(preg_match('/Couldn\'t run query: ([^\|]*)\|\s*(.*)/', $msg, $matches)) {
532 $formatter = new SQLFormatter();
533 $msg = "Couldn't run query: \n" . $formatter->formatPlain($matches[1]) . "\n\n" . $matches[2];
534 }
535
536 user_error($msg, $errorLevel);
537 }
538
539 /**
540 * Return a boolean type-formatted string
541 *
542 * @param array $values Contains a tokenised list of info about this data type
Trace
* Couldn't run query: SELECT "Slogan"."ClassName", "Slogan"."Created", "Slogan"."LastEdited", "Slogan"."SloganText", "Slogan"."CSSid", "Slogan"."SloganImageID", "Slogan"."SloganBackgroundID", "Slogan"."ID", CASE WHEN "Slogan"."ClassName" IS NOT NULL THEN "Slogan"."ClassName" ELSE 'Slogan' END AS "RecordClassName" FROM "Slogan" WHERE ("ParentID" = '1') Unknown column 'Slogan.SloganText' in 'field list'
Line 536 of MySQLDatabase.php
* MySQLDatabase->databaseError(Couldn't run query: SELECT "Slogan"."ClassName", "Slogan"."Created", "Slogan"."LastEdited", "Slogan"."SloganText", "Slogan"."CSSid", "Slogan"."SloganImageID", "Slogan"."SloganBackgroundID", "Slogan"."ID", CASE WHEN "Slogan"."ClassName" IS NOT NULL THEN "Slogan"."ClassName" ELSE 'Slogan' END AS "RecordClassName" FROM "Slogan" WHERE ("ParentID" = '1') | Unknown column 'Slogan.SloganText' in 'field list',256)
Line 134 of MySQLDatabase.php
* MySQLDatabase->query(SELECT "Slogan"."ClassName", "Slogan"."Created", "Slogan"."LastEdited", "Slogan"."SloganText", "Slogan"."CSSid", "Slogan"."SloganImageID", "Slogan"."SloganBackgroundID", "Slogan"."ID", CASE WHEN "Slogan"."ClassName" IS NOT NULL THEN "Slogan"."ClassName" ELSE 'Slogan' END AS "RecordClassName" FROM "Slogan" WHERE ("ParentID" = '1'),256)
Line 126 of DB.php
* DB::query(SELECT "Slogan"."ClassName", "Slogan"."Created", "Slogan"."LastEdited", "Slogan"."SloganText", "Slogan"."CSSid", "Slogan"."SloganImageID", "Slogan"."SloganBackgroundID", "Slogan"."ID", CASE WHEN "Slogan"."ClassName" IS NOT NULL THEN "Slogan"."ClassName" ELSE 'Slogan' END AS "RecordClassName" FROM "Slogan" WHERE ("ParentID" = '1'),256)
Line 386 of SQLQuery.php
* SQLQuery->execute()
Line 1262 of DataObject.php
* DataObject->getComponents(Slogan)
* call_user_func_array(Array,Array)
Line 711 of Object.php
* Object->__call(slogan,Array)
* Homepage->slogan()
* call_user_func_array(Array,Array)
Line 693 of Object.php
* Object->__call(Slogan,Array)
* Homepage_Controller->Slogan()
Line 369 of ViewableData.php
* ViewableData->obj(Slogan,,1,,)
Line 826 of ViewableData.php
* ViewableData_Customised->obj(Slogan)
Line 146 of .cacheC..wamp.www.web2works.themes.web2works.templates.Page.ss
* include(C:\WINDOWS\Temp\silverstripe-cacheC--wamp-www-web2works\.cacheC..wamp.www.web2works.themes.web2works.templates.Page.ss)
Line 392 of SSViewer.php
* SSViewer->process(Homepage_Controller)
Line 202 of Controller.php
* Controller->handleAction(SS_HTTPRequest)
Line 134 of RequestHandler.php
* RequestHandler->handleRequest(SS_HTTPRequest)
Line 147 of Controller.php
* Controller->handleRequest(SS_HTTPRequest)
Line 199 of ContentController.php
* ContentController->handleRequest(SS_HTTPRequest)
Line 67 of ModelAsController.php
* ModelAsController->handleRequest(SS_HTTPRequest)
Line 111 of RootURLController.php
* RootURLController->handleRequest(SS_HTTPRequest)
Line 283 of Director.php
* Director::handleRequest(SS_HTTPRequest,Session)
Line 127 of Director.php
* Director::direct(/)
Line 127 of main.php