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   1102 Views

Avatar
Velocy

Community Member, 3 Posts

19 March 2011 at 6:39am

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

Community Member, 3 Posts

23 March 2011 at 11:04pm

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

Community Member, 2 Posts

28 March 2011 at 9:24am

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