I'm having a slightly weird problem. I'm trying to create a dataobject that will appear as a page in the site tree.
The basic code is like this:
$product = new Product(); $product->Title = "Example"; $product->ProductNumber = 666; $product->writeToStage('Stage'); $product->publish('Stage', 'Live');
If I do that and then go and watch the site tree everything looks all peachy. The new product has been added as a new published page.
But if I have a look in the database tables I realize that while the Product draft table looks like its intended to all fields except the ID field in the Product_Live table is set to NULL.
So if I do a:
DataObject::get_one("Product", "ProductNumber = '666'");
It will return nothing as ProductNumber is NULL in the _Live table.