Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Installing SilverStripe /

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

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

Problem using Windows Installer with win2008rc2+mssql


Go to End


11 Posts   3312 Views

Avatar
Sean

Forum Moderator, 922 Posts

20 November 2012 at 1:48pm

Edited: 20/11/2012 2:22pm

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

Avatar
bb-drummer

Community Member, 14 Posts

4 December 2012 at 11:55pm

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

never the less thanks a lot for your help :)

Avatar
Sean

Forum Moderator, 922 Posts

5 December 2012 at 10:40am

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

Go to Top