CheckboxSetField Saving As Array

Silverstripe Version: 4.2.1
PHP 7.0.8


I have a dataobject page that has a varchar(100) field called DropOffLocations for saving of CheckboxSetField selections.

The selections were getting saved in the database as comma delimited i.e. 1,2,3

Now suddenly the values are saving as [“1”,“2”,“3”].

But the weird thing is, on the development test server, same code, the values are getting stored as 1,2,3

This breaks a query using the following where statement:

$filter = "ID IN(".$getlocation->DropOffLocations.")";
$page = VehicleLocations::get()->where($filter);

Debug output:

FROM “VehicleLocations” WHERE (ID IN([“1”,“3”,“8”])) 42000-1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘[“1”,“3”,“8”]))’ at line 5

Appears this is a issue from upgrading from silverstripe 3.x to silverstripe 4.x. Not a bug. In 4.x, data is saved as a JSON object. So a gotcha. Was only a issue when I updated checkbox selections…


My solution was to add relation object to save into.