Jump to:

4873 Posts in 7171 Topics by 1471 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » Problem using Windows Installer with win2008rc2+mssql

Getting SilverStripe up and running on your computer and on your web server.

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

Page: 1 2
Go to End
Author Topic: 943 Views
  • Sean
    Avatar
    Forum Moderator
    921 Posts

    Re: Problem using Windows Installer with win2008rc2+mssql Link to this post

    Hmm, that's weird... IIS URL Rewrite Module should've been installed with the Web Platform Installer...

    It really shouldn't be this hard to get SilverStripe running, the process *should* be seamless on the installer, but variations in installed software and versions of Windows seem to make the process more complicated than it should be.

    As far as I can tell, the error is about converting a varchar to datetime, and a value is out of bounds, if my translation of the error to English is correct.
    I don't know why this conversion is happening though, and the query it tries to run seems fine to me.
    Do you know which field and value it's failing on, maybe the error has more details in there than I can read?
    Could it be that because SQL Server has German as the locale that it doesn't understand the date values given to it, so it thinks they're out of bounds? Seems kind of unlikely though...

    EDIT: If you change the language to English of SQL Server, what happens?
    You can do that using SQL Server Management Studio. Once you've got it open, right click the server on the left hand panel and go to Advanced and change the language field there.
    If you can't find SQL Server Management Studio, you can install it through the Web Platform Installer, by the way.
    Alternatively, if that doesn't work, find where SilverStripe is installed, go to the mssql/code/MSSQLDatabase.php file, find the two lines:

    $this->query('SET QUOTED_IDENTIFIER ON');
    $this->query('SET TEXTSIZE 2147483647');

    and add this line above or below:

    $this->query('SET LANGUAGE us_english');

    Sean

  • bb-drummer
    Avatar
    Community Member
    13 Posts

    Re: Problem using Windows Installer with win2008rc2+mssql Link to this post

    Hello Sean,

    thank you very much for your information.

    Finally I had managed to setup this windows environment...

    Maybe an additional tip (for others):
    install SQL-Express (via M$ site) before installing SS via the web-installer,
    that way the SQLManagementStudio is able to install which its setup denied
    when just utilizing the web-installer's SQLExpress...

    well, then, porting 'that site' from my linux dev environment to that win platform is another horror story...

    never the less thanks a lot for your help

  • Sean
    Avatar
    Forum Moderator
    921 Posts

    Re: Problem using Windows Installer with win2008rc2+mssql Link to this post

    Hi bb-drummer,

    Good to see you got there in the end. I must say, the Web Platform Installer is a bit difficult to debug when things go wrong.

    I've reported the issues I've found to Microsoft, some of which I found myself and have noticed others on this forum have been having, but I don't think they've been resolved yet...

    Thanks,
    Sean

    943 Views
Page: 1 2
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.