Jump to:

4938 Posts in 16484 Topics by 1490 members

Installing SilverStripe

SilverStripe Forums » Installing SilverStripe » MSSQL Fatal Error on fresh install

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

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

Page: 1
Go to End
Author Topic: 1053 Views
  • Velocy
    Avatar
    Community Member
    3 Posts

    MSSQL Fatal Error on fresh install Link to this post

    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

  • Velocy
    Avatar
    Community Member
    3 Posts

    Re: MSSQL Fatal Error on fresh install Link to this post

    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?

  • justbql
    Avatar
    Community Member
    2 Posts

    Re: MSSQL Fatal Error on fresh install Link to this post

    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

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