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.

Installing SilverStripe

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

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

MSSQL Fatal Error on fresh install


Reply

3 Posts   1065 Views

Avatar
Velocy

19 March 2011 at 6:39am Community Member, 3 Posts

Hello everyone,

I've been searching for CMS that runs on PHP and supports MSSQL as database (due to some technical requirements here). So I tried to install Silverstripe today. I didn't manage to get a database connection at first, until I noticed I should disable the php_mssql module to load the microsoft driver. Now my Installation finally starts until a certain point:

Would be nice if anyone could give me a hint.

Server: Windows Server 2003
Webserver: Apache2 via Xampp and PHP 5.2
SQL Server 2008 (I think without SP1, still) on a external host.

Here is a full trace:

(Actually I run a German system. Basicly the SQL Nativ Client reports that during the conversion of a varchar datatype to a datetime datatype the value is outside of the valid area.

Couldn't run query (22007, 242, [Microsoft][SQL Server Native Client 10.0][SQL Server]Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert auáerhalb des g�ltigen Bereichs.01000, 3621, [Microsoft][SQL Server Native Client 10.0][SQL Server]Die Anweisung wurde beendet.): UPDATE "SiteTree" SET "ClassName" = 'Page', "ShowInMenus" = '1', "ShowInSearch" = '1', "Status" = 'Published', "CanViewType" = 'Inherit', "CanEditType" = 'Inherit', "Title" = 'Home', "Content" = '<p>Welcome to SilverStripe! This is the default homepage. You can edit this page by opening <a href="admin/">the CMS</a>. You can now access the <a href="http://doc.silverstripe.org">developer documentation</a>, or begin <a href="http://doc.silverstripe.org/doku.php?id=tutorials">the tutorials.</a></p>', "URLSegment" = 'home', "Sort" = 1, "HasBrokenLink" = '0', "HasBrokenFile" = '0', "ExtraMeta" = null, "LastEdited" = '2011-03-18 18:33:06', "Created" = '2011-03-18 18:33:06', "Version" = 1 where "ID" = 5: [Microsoft][SQL Server Native Client 10.0][SQL Server]Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert auáerhalb des g�ltigen Bereichs.; [Microsoft][SQL Server Native Client 10.0][SQL Server]Die Anweisung wurde beendet.
Line 620 of Database.php
SS_Database->databaseError(Couldn't run query (22007, 242, [Microsoft][SQL Server Native Client 10.0][SQL Server]Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert auáerhalb des g�ltigen Bereichs.01000, 3621, [Microsoft][SQL Server Native Client 10.0][SQL Server]Die Anweisung wurde beendet.): UPDATE "SiteTree" SET "ClassName" = 'Page', "ShowInMenus" = '1', "ShowInSearch" = '1', "Status" = 'Published', "CanViewType" = 'Inherit', "CanEditType" = 'Inherit', "Title" = 'Home', "Content" = '<p>Welcome to SilverStripe! This is the default homepage. You can edit this page by opening <a href="admin/">the CMS</a>. You can now access the <a href="http://doc.silverstripe.org">developer documentation</a>, or begin <a href="http://doc.silverstripe.org/doku.php?id=tutorials">the tutorials.</a></p>', "URLSegment" = 'home', "Sort" = 1, "HasBrokenLink" = '0', "HasBrokenFile" = '0', "ExtraMeta" = null, "LastEdited" = '2011-03-18 18:33:06', "Created" = '2011-03-18 18:33:06', "Version" = 1 where "ID" = 5: [Microsoft][SQL Server Native Client 10.0][SQL Server]Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert auáerhalb des g�ltigen Bereichs.; [Microsoft][SQL Server Native Client 10.0][SQL Server]Die Anweisung wurde beendet.,256)
Line 209 of MSSQLDatabase.php
MSSQLDatabase->databaseError(Couldn't run query (22007, 242, [Microsoft][SQL Server Native Client 10.0][SQL Server]Bei der Konvertierung eines varchar-Datentyps in einen datetime-Datentyp liegt der Wert auáerhalb des g�ltigen Bereichs.01000, 3621, [Microsoft][SQL Server Native Client 10.0][SQL Server]Die Anweisung wurde beendet.): UPDATE "SiteTree" SET "ClassName" = 'Page', "ShowInMenus" = '1', "ShowInSearch" = '1', "Status" = 'Published', "CanViewType" = 'Inherit', "CanEditType" = 'Inherit', "Title" = 'Home', "Content" = '<p>Welcome to SilverStripe! This is the default homepage. You can edit this page by opening <a href="admin/">the CMS</a>. You can now access the <a href="http://doc.silverstripe.org">developer documentation</a>, or begin <a href="http://doc.silverstripe.org/doku.php?id=tutorials">the tutorials.</a></p>', "URLSegment" = 'home', "Sort" = 1, "HasBrokenLink" = '0', "HasBrokenFile" = '0', "ExtraMeta" = null, "LastEdited" = '2011-03-18 18:33:06', "Created" = '2011-03-18 18:33:06', "Version" = 1 where "ID" = 5,256)
Line 315 of MSSQLDatabase.php
MSSQLDatabase->query(UPDATE "SiteTree" SET "ClassName" = 'Page', "ShowInMenus" = '1', "ShowInSearch" = '1', "Status" = 'Published', "CanViewType" = 'Inherit', "CanEditType" = 'Inherit', "Title" = 'Home', "Content" = '<p>Welcome to SilverStripe! This is the default homepage. You can edit this page by opening <a href="admin/">the CMS</a>. You can now access the <a href="http://doc.silverstripe.org">developer documentation</a>, or begin <a href="http://doc.silverstripe.org/doku.php?id=tutorials">the tutorials.</a></p>', "URLSegment" = 'home', "Sort" = 1, "HasBrokenLink" = '0', "HasBrokenFile" = '0', "ExtraMeta" = null, "LastEdited" = '2011-03-18 18:33:06', "Created" = '2011-03-18 18:33:06', "Version" = 1 where "ID" = 5)
Line 568 of Database.php
SS_Database->manipulate(Array)
Line 174 of DB.php
DB::manipulate(Array)
Line 1048 of DataObject.php
DataObject->write()
Line 1297 of SiteTree.php
SiteTree->requireDefaultRecords()
Line 235 of DatabaseAdmin.php
DatabaseAdmin->doBuild(1)
Line 1093 of install.php
Installer->install(Array)
Line 190 of install.php

Avatar
Velocy

23 March 2011 at 11:04pm Community Member, 3 Posts

To give a small update on the situation:
I've carefully read all documentations I've found and changed a few things:

- Updated SQL Server 2008 without SP to Service Pack 2 (since SP1 or R2 at least were asked).
- Switched to 2.4.2 instead of 2.4.5 as Plugin only says compatibility up to 2.4.2
- Reinstalled the SQL Native Client (R2 one)
- Got the latest Code from Github for the MSSQL Plugin.

Just... absolutly no change on the situation... error remains. It's somehow a problem with the SQL Server not liking the timestamps generated.

I also changed a function in the MSSQLDatabase.php to do a return 0; instead of returning the SQL Converted timestamp. However this only helped for the above error. Now SAME error appears a bit later while updating another table. (That was just for testing, I know it would screw up whole timestaming in Silverstripe).

Any ideas?

Avatar
justbql

28 March 2011 at 9:24am Community Member, 2 Posts

Hallo,
I have the same behavior.
Installed SS, mssql and IIS several times with the same and latest versions but alway the same error!

Thanks for help

justbql