Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » 2.1 RC1 install errors

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

Page: 1
Go to End
Author Topic: 2144 Views
  • Nathan Cox
    Avatar
    Community Member
    99 Posts

    2.1 RC1 install errors Link to this post

    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?

  • xeraa
    Avatar
    Google Summer of Code Hacker
    58 Posts

    Re: 2.1 RC1 install errors Link to this post

    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...

  • Nathan Cox
    Avatar
    Community Member
    99 Posts

    Re: 2.1 RC1 install errors Link to this post

    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()");

  • xeraa
    Avatar
    Google Summer of Code Hacker
    58 Posts

    Re: 2.1 RC1 install errors Link to this post

    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...

  • Nathan Cox
    Avatar
    Community Member
    99 Posts

    Re: 2.1 RC1 install errors Link to this post

    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.

  • xeraa
    Avatar
    Google Summer of Code Hacker
    58 Posts

    Re: 2.1 RC1 install errors Link to this post

    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 = "";
       }


    won't apply anyway.

  • Matt
    Avatar
    Core Development Team
    84 Posts

    Re: 2.1 RC1 install errors Link to this post

    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.

    2144 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.