Hi, I'm having some troubles installing 2.1 (on Windows) - on the "Installing SilverStripe..." page I get the error:

Building database schema...

Fatal error: DATABASE ERROR: Couldn't run query: insert into `SiteTree_versions` SET `ShowInMenus` = '0', `ShowInSearch` = '0', `Status` = '', `Viewers` = 'Anyone', `Editors` = 'LoggedInUsers', `Title` = '', `Content` = '', `URLSegment` = '', `LastEdited` = '', `Created` = '2007-09-17 20:13:12', `ClassName` = 'SiteTree', `MenuTitle` = '', `MetaTitle` = '', `MetaDescription` = '', `MetaKeywords` = '', `HomepageForDomain` = '', `ProvideComments` = '0', `Sort` = '0', `LegacyURL` = '', `HasBrokenFile` = '0', `HasBrokenLink` = '0', `ReportClass` = '', `ViewersGroup` = '0', `EditorsGroup` = '0', `ParentID` = '0', `Version` = 1, `RecordID` = 1, `AuthorID` = 0 | Incorrect datetime value: '' for column 'LastEdited' at row 1 in C:\webserver\sites\www.blog.local\sapphire\core\model\Database.php on line 368

If I refresh it enough it goes to rewritetest.php, and just sits at a blank page. I think this one is a windows problem breaking the rewrite test - if I change line rewritetest.php line 41 from

	if($baseURL == "/") {

to

	if($baseURL == DIRECTORY_SEPARATOR) {

it works fine.

Once it gets to /home/successfullyinstalled, it just says "The requested page couldn't be found." The problem seems to be that it's looking for the home page in SiteTree_Live, but there's nothing in SiteTree_Live, it's just in SiteTree. This might be related to the database error earlier, I don't know. Trying to go to /admin/publishall just gets another blank page.

Any wisdom? Do I have something really wrong here?

It's a known bug - patch: http://open.silverstripe.com/changeset/42173
Also described at http://www.silverstripe.com/general-discussion/flat/5050 (end of page and second page)

Your change to the rewrite test is interesting - it's failing on Windows, but if you just force it to continue, it's normally fine. I'll give it another look...

Thanks, not sure how I missed that...my fix was to change DataObject::write() on line 432(ish) from

DB::query("INSERT INTO `{$baseTable}` SET Created = NOW()");

to

DB::query("INSERT INTO `{$baseTable}` SET Created = NOW(), LastEdited = NOW()");

Yep, changing DataObject is another solution, but I'm not sure that's how it should be.
Matt thought it should be set to NOW(), but Andy's fix just replaced the empty strings with null (actually my quick'n'dirty approach). I guess it won't matter later on so both ways should be fine.

DIRECTORY_SEPARATOR didn't help on my system (Vista 64bit, Apache 2.2.6, PHP 5.2.4) - I still get the error that mod_rewrite is not working correctly but when forcing it to continue it's all fine...

That's interesting, it worked for me...although the second time around I made the same change to a few places in install.php as well. Maybe you could try that (I think there are three places with the same line as above), although I didn't check to see if they made a difference. I remember having the same issue in the older versions of SS as well, and had to change a few slashes in the installer to make it work properly.

Anyway, I'm just happy it's going now - I've been hanging out to play with the blog module.

I don't think that's fixing it, because dirname($_SERVER['SCRIPT_NAME']) just gets the folder from where you are calling it. And on my Windows box Apache uses / in the path and not \ (which DIRECTORY_SEPARATOR returns). So for example if I'm just echoing dirname($_SERVER['SCRIPT_NAME']) from wwwroot/test/index.php I get "/test".
And as I'm generally installing SS in a subdirectory

	$baseURL = dirname($_SERVER['SCRIPT_NAME']);
	if($baseURL == "/") {
		$baseURL = "";
	}

Matt thought it should be set to NOW() - That's just what it did in the past, after thinking about it for a bit it makes more sense to leave it null - that way you know when a page has been newly-created and not changed yet, if you want to know that state for a page.