Silverstripe3.2.0- Delete Pages

Silverstripe3.2.0- Delete Pages



  • Major Changes
  • Deprecated classes/methods
  • New and changed API
  • Bugfixes
  • Upgrading Notes

Major changes

  • Minimum PHP version raised to 5.3.3
  • Introduction of new parameterised ORM
  • Default support for PDO
  • Moved SS_Report and ReportAdmin out to a separate module. If you're using composer or downloading a release, this module should be included for you. Otherwise, you'll need to include the module yourself (
  • Moved SiteConfig also out to its own module. This will be included by default if you include the CMS module. (
  • Implementation of new "Archive" concept for page removal, which supercedes "delete from draft". Where deletion removed pages only from draft, archiving removes from both draft and live simultaneously.
  • Most of the Image manipulation methods have been renamed

Deprecated classes/methods

The following functionality deprecated in 3.0 has been removed:

  • DataList::getRange() removed. Use limit() instead.
  • SQLMap removed. Call map() on a DataList or use SS_Map directly instead.
  • SQLQuery methods select(), limit(), orderby(), groupby(), having(), from(), leftjoin(), innerjoin(), where() and whereAny() removed. Use set*() and add*() methods instead.

New and changed API

  • Implementation of a parameterised query framework eliminating the need to manually escape variables for use in SQL queries. This has been integrated into nearly every level of the database ORM.
  • Refactor of database connectivity classes into separate components linked together through dependency injection
  • Refactor of SQLQuery into separate objects for each query type: SQLSelect, SQLDelete, SQLUpdate and SQLInsert
  • PDO is now a standard connector, and is available for all database interfaces
  • DataObject::doValidate() method visibility added to access DataObject::validate externally
  • NumericField now uses HTML5 "number" type instead of "text"
  • UploadField "Select from files" shows files in all folders by default
  • UploadField won't display an overwrite warning unless Upload::replaceFile is true
  • HtmlEditorField no longer substitutes <blockquote /> for indented text
  • ClassInfo::dataClassesFor now returns classes which should have tables, regardless of whether those tables actually exist.
  • SS_Filterable, SS_Limitable and SS_Sortable now explicitly extend SS_List
  • Convert::html2raw no longer wraps text by default and can decode single quotes.
  • Mailer no longer calls xml2raw on all email subject line, and now must be passed in via plain text.
  • ErrorControlChain now supports reload on exceptions
  • FormField::validate now requires an instance of Validator
  • API: Removed URL routing by controller name
  • Security: The multiple authenticator login page should now be styled manually - i.e. without the default jQuery UI layout. A new template, is available.
  • Security: This controller's templates can be customised by overriding the getTemplatesFor function.
  • Deprecation::set_enabled() or SS_DEPRECATION_ENABLED can now be used to enable or disable deprecation notices. Deprecation notices are no longer displayed on test.
  • API: Form and FormField ID attributes rewritten.
  • SearchForm::getSearchQuery no longer pre-escapes search keywords and must be cast in your template
  • Helper function DB::placeholders can be used to generate a comma separated list of placeholders useful for creating "WHERE ... IN (?,...)" SQL fragments
  • Implemented Convert::symbol2sql to safely encode database and table names and identifiers. E.g. Convert::symbol2sql('table.column') => '"table"."column"';
  • Convert::raw2sql may now quote the escaped value, as well as safely escape it, according to the current database adaptor's preference.
  • DB class has been updated and many static methods have been renamed to conform to coding convention.
  • Renamed API:
  • affectedRows -> affected_rows
  • checkAndRepairTable -> check_and_repair_table
  • createDatabase -> create_database
  • createField -> create_field
  • createTable -> create_table
  • dontRequireField -> dont_require_field
  • dontRequireTable -> dont_require_table
  • fieldList -> field_list
  • getConn -> get_conn
  • getGeneratedID -> get_generated_id
  • isActive -> is_active
  • requireField -> require_field
  • requireIndex -> require_index
  • requireTable -> require_table
  • setConn -> set_conn
  • tableList -> table_list
  • Deprecated API:
  • getConnect (Was placeholder for PDO connection string building code, but is made redundant after the PDOConnector being fully abstracted)
  • New API:
  • build_sql - Hook into new SQL generation code
  • get_connector (Nothing to do with getConnect)
  • get_schema
  • placeholders
  • prepared_query
  • SS_Database class has been updated and many functions have been deprecated, or refactored into the various other database classes. Most of the database management classes remain in the database controller, due to individual databases (changing, creating of, etc) varying quite a lot from API to API, but schema updates within a database itself is managed by an attached DBSchemaManager
  • Refactored into DBSchemaManager:
  • createTable
  • alterTable
  • renameTable
  • createField
  • renameField
  • fieldList
  • tableList
  • hasTable
  • enumValuesForField
  • beginSchemaUpdate and endSchemaUpdate -> Use schemaUpdate with a callback
  • cancelSchemaUpdate
  • isSchemaUpdating
  • doesSchemaNeedUpdating
  • transCreateTable
  • transAlterTable
  • transCreateField
  • transCreateField
  • transCreateIndex
  • transAlterField
  • transAlterIndex
  • requireTable
  • dontRequireTable
  • requireIndex
  • hasField
  • requireField
  • dontRequireField
  • Refactored into DBQueryBuilder
  • sqlQueryToString
  • Deprecated:
  • getConnect - Was intended for use with PDO, but was never implemented, and is now redundant, now that there is a stand-alone PDOConnector
  • prepStringForDB - Use quoteString instead
  • dropDatabase - Use dropSelectedDatabase
  • createDatabase - Use selectDatabase with the second parameter set to true instead
  • allDatabaseNames - Use databaseList instead
  • currentDatabase - Use getSelectedDatabase instead
  • addslashes - Use escapeString instead
  • LogErrorEmailFormatter now better displays SQL queries in errors by respecting line breaks
  • Installer has been majorly upgraded to handle the new database configuration options and additional PDO functionality.
  • Created SS_DatabaseException to emit database errors. Query information such as SQL and any relevant parameters may be used by error handling user code that catches this exception.
  • The SQLConditionGroup interface has been created to represent dynamically evaluated SQL conditions. This may be used to wrap a class that generates a custom SQL clause(s) to be evaluated at the time of execution.
  • DataObject constants CHANGE_NONE, CHANGE_STRICT, and CHANGE_VALUE have been created to provide more verbosity to field modification detection. This replaces the use of various magic numbers with the same meaning.
  • create_table_options now uses constants as API specific filters rather than strings. This is in order to promote better referencing of elements across the codebase. See FulltextSearchable->enable for example.
  • $FromEnd iterator variable now available in templates.
  • Support for multiple HtmlEditorConfigs on the same page.
  • Object::singleton() method for better type-friendly singleton generation
  • New Image methods CropWidth and CropHeight added
  • 'Max' versions of Image methods introduced to prevent up-sampling
  • Update Image method names in PHP code and templates
  • SetRatioSize -> Fit
  • CroppedImage -> Fill
  • PaddedImage -> Pad
  • SetSize -> Pad
  • SetWidth -> ScaleWidth
  • SetHeight -> ScaleHeight


  • Reduced database regeneration chances on subsequent rebuilds after the initial dev/build
  • Elimination of various SQL injection vulnerability points
  • DataObject::writeComponents() now called correctly during DataObject::write()
  • Fixed missing theme declaration in installer
  • Fixed incorrect use of non-existing exception classes (e.g. HTTPResponse_exception)
  • GridState fixed to distinguish between check for missing values, and creation of nested state values, in order to prevent non-empty values being returned for missing keys. This was breaking DataObject::get_by_id by passing in an object for the ID.
  • Fixed order of File fulltext searchable fields to use same order as actual fields. This is required to prevent unnecessary rebuild of MS SQL databases when fulltext searching is enabled.
  • In the past E_RECOVERABLE_ERROR would be ignored, and now correctly appear as warnings.

Upgrading Notes

Enable PDO

Although this is not a mandatory upgrade step, the new [api:PDOConnector] class offers improved database performance and security, and should be integrated into any project using 3.2.

In order to update your connector you can do so in one of two ways, depending on whether or not your project is using _ss_environment.php to configure your database, or via mysite/_config.php

If using _ss_environment.php:

define('SS_DATABASE_CLASS', 'MySQLPDODatabase');

If using mysite/_config.php:

global $databaseConfig;

$databaseConfig = array(

"type" => "MySQLPDODatabase"

// other config settings


Disable LastVisited and NumVisits counter

These fields were deprecated in 3.1 due to performance concerns, and should be disabled unless required by your application.

In order to disable these functions you can add the following yml to your configuration:


Name: disablevisits



log_num_visits: false

log_last_visited: false

This functionality will be removed in 4.0

Howto: Track Member Logins to restore functionality as custom code

UploadField "Select from files" shows files in all folders by default

In order to list files in a single folder by default (previous default behaviour), use setDisplayFolderName() with a folder path relative to assets/:


UploadField won't display an overwrite warning unless Upload:replaceFile is true

The configuration setting UploadField:overwriteWarning is dependent on Upload:replaceFile which is set to false by default.

To display a warning before overwriting a file:

Via config:



# Replace an existing file rather than renaming the new one.

replaceFile: true


# Warning before overwriting existing file (only relevant when Upload: replaceFile is true)

overwriteWarning: true

Or per instance:




File.allowed_extensions restrictions

Certain file types such as swf, html, htm, xhtml and xml have been removed from the list of allowable file uploads. If your application requires the ability to upload these, you will need to append these to the File.allowed_extensions config as necessary. Also if uploading other file types, it's necessary to ensure that File.allowed_extensions includes that extension, as extensions passed to [api:UploadField] will be filtered against this list.

Removed format detection in i18n::$date_format and i18n::$time_format

Localized dates cause inconsistencies in client-side vs. server-side formatting and validation, particularly in abbreviated month names. The default date format has been changed to "yyyy-MM-dd" (e.g. 2014-12-31). New users will continue to have the option for a localized date format in their profile (based on their chosen locale). If you have existing users with Member.DateFormat set to a format including "MMM" or "MMMM", consider deleting those formats to fall back to the global (and more stable) default.

Cookies set via Cookie::set() are now HTTP only by default

Cookies set through Cookie::set() now default to "HTTP only". This means that scripting languages like JavaScript won't be able to read them.

To set it back to be non-HTTP only, you need to set the $httpOnly argument to false when calling Cookie::set().

API: Removed URL routing by controller name

The auto-routing of controller class names to URL endpoints has been removed (rule: '$Controller//$Action/$ID/$OtherID': '*'). This increases clarity in routing since it makes URL entpoints explicit, and thereby simplifies system and security reviews.

Please access any custom controllers exclusively through self-defined routes. For controllers extending Page_Controller, simply use the provided page URLs.

class MyController extends Controller {

static $allowed_actions = array('myaction');

public function myaction($request) {

// ...



Create a new file mysite/_config/routes.yml (read more about the config format). Your controller is now available on after refreshing the configuration cache through ?flush=all.


Name: my-routes

After: framework/routes#coreroutes




'my-controller-endpoint//$Action' : 'MyController'

The auto-routing is still in place for unit tests, since its a frequently used feature there. Although we advise against it, you can reinstate the old behaviour through a director rule:


Name: my-routes

After: framework/routes#coreroutes




'$Controller//$Action/$ID/$OtherID': '*'

API: Default Form and FormField ID attributes rewritten.

Previously the automatic generation of ID attributes throughout the Form API could generate invalid ID values such as Password[ConfirmedPassword] as well as duplicate ID values between forms on the same page. For example, if you created a field called Email on more than one form on the page, the resulting HTML would have multiple instances of #Email. ID should be a unique identifier for a single element within the document.

This rewrite has several angles, each of which is described below. If you rely on ID values in your CSS files, Javascript code or application unit tests you will need to update your code.

Conversion of invalid form ID values

ID attributes on Form and Form Fields will now follow the HTML specification. Generating ID attributes is now handled by the new FormTemplateHelper class.

Please test each of your existing site forms to ensure that they work correctly in particular, javascript and css styles which rely on specific ID values.

Invalid ID attributes stripped

ID attributes will now be run through Convert::raw2htmlid. Invalid characters are replaced with a single underscore character. Duplicate, leading and trailing underscores are removed. Custom ID attributes (set through setHTMLID) will not be altered.


<form id="MyForm[Form]"

<div id="MyForm[Form][ID]">


<form id="MyForm_Form">

<div id="MyForm_Form_ID">

Namespaced FormField ID's

Form Field ID values will now be namespaced with the parent form ID.


<div id="Email">


<div id="MyForm_Email">

FormField wrapper containers suffixed with _Holder

Previously both the container div and FormField tag shared the same ID in certain cases. Now, the wrapper div in the default FormField template will be suffixed with _Holder.


<div id="Email">

<input id="Email" />


<div id="MyForm_Email_Holder"

<input id="MyForm_Email" />

Reverting to the old specification

If upgrading existing forms is not feasible, developers can opt out of the new specifications by using the FormTemplateHelper_Pre32 class rules instead of the default ones.




class: FormTemplateHelper_Pre32

Update code that uses SQLQuery

SQLQuery has been changed. Previously this class was used for both selecting and deleting, but deletion is now handled by the new SQLDelete class.

Additionally, 3.2 now provides SQLUpdate and SQLInsert to generate parameterised query friendly data updates.

SQLQuery, SQLDelete and SQLUpdate all inherit from SQLConditionalExpression, which implements toSelect, toDelete, and toUpdate to generate basic transformations between query types.

In the past SQLQuery->setDelete(true) would be used to turn a select into a delete, although now a new SQLDelete object should be created from the original SQLQuery.



$query = new SQLQuery('*');


$query->setWhere('"SiteTree"."ShowInMenus" = 0');





$query = SQLDelete::create()


->setWhere(array('"SiteTree"."ShowInMenus"' => 0));


When working with SQLQuery passed into user code, it is advisable to strictly cast it into either a SQLSelect or SQLDelete. This can be done by using the new SQLQuery::toAppropriateExpression() method, which will automatically convert to the correct type based on whether the SQLQuery is set to delete or not.

If a SQLQuery is not converted, then the result of getWhere will not be parameterised. This is because user code written for 3.1 expects this list to be a flat array of strings. This format is inherently unsafe, and should be avoided where possible.


public function augmentSQL(SQLQuery &$query) {

$query->getWhere(); // Will be flattened (unsafe 3.1 compatible format)

$expression = $query->toAppropriateExpression(); // Either SQLSelect or SQLDelete

$expression->getWhere(); // Will be parameterised (preferred 3.2 compatible format)




$query = SQLQuery::create()


->setWhere(array('"SiteTree"."ShowInMenus"' => 0))




Update code that interacts with SQL strings to use parameters

The Silverstripe ORM (object relation model) has moved from using escaped SQL strings to query the database, to a combination of parameterised SQL expressions alongside a related list of parameter values. As a result of this, it is necessary to assume that any SQLQuery object may, and will usually, have un-injected parameters.

All database queries performed through DataList, DataQuery and SQLQuery will continue to work, as will those through DataObject::get() (which returns a filterable DataList). However, any conditional expression that includes values escaped with Convert::raw2sql() should use the new standard syntax. This new querying standard method enforces a much higher level of security than was previously available, and all code using manual escaping should be upgraded.

See the security topic for details on why this is necessary, or the databamodel topic for more information.

As a result of this upgrade there are now very few cases where Convert::raw2sql needs to be used.

Examples of areas where queries should be upgraded are below:

1. Querying the database directly through DB, including non-SELECT queries



// Note: No deprecation notices will be caused here

DB::query("UPDATE \"SiteTree\" SET \"Title\" LIKE '%" . Convert::raw2sql($myTitle) . "%' WHERE \"ID\" = 1");

$myPages = DB::query(sprintf('SELECT "ID" FROM "MyObject" WHERE "Title" = \'%s\'', Convert::raw2sql($parentTitle)));




'UPDATE "SiteTree" SET "Title" LIKE ? WHERE "ID" = ?',

array("%{$myTitle}%", 1)


$myPages = DB::prepared_query(

'SELECT "ID" FROM "MyObject" WHERE "Title" = ?',



2. Querying the database through DataList, DataQuery, SQLQuery, and DataObject



$items = DataObject::get_one('MyObject', '"Details" = \''.Convert::raw2sql($details).'\'');

$things = MyObject::get()->where('"Name" = \''.Convert::raw2sql($name).'\'');

$list = DataList::create('Banner')->where(array(

'"ParentID" IS NOT NULL',

'"Title" = \'' . Convert::raw2sql($title) . '\''




$items = DataObject::get_one('MyObject', array('"MyObject"."Details"' => $details));

$things = MyObject::get()->where(array('"MyObject"."Name" = ?' => $name));

$list = DataList::create('Banner')->where(array(

'"ParentID" IS NOT NULL',

'"Title" = ?' => $title,


3. Interaction with DataList::sql(), DataQuery::sql(), SQLQuery::sql(), or SQLQuery::getJoins() methods

The place where legacy code would almost certainly fail is any code that calls DataList::sql,DataQuery::sql,SQLQuery::sqlorSQLQuery::getJoins()`, as the api requires that user code passes in an argument here to retrieve SQL parameters by value.