Hello there,
I have a SilverStripe installation that worked fine for roughly 10 days... then the server rebooted last night and I can't log in any more.
None of the users, even the default admin, work.
I get this message (sorry it's German but basically says converting a varchar to a datetime thing fails because the value is out of range)
I have no idea how to fix this (guess I changed the date/time display format for the users I added).
I'm not a PHP/SQL pro, so if you have any hint I guess I'll need step by step instructions.
It would suck having to redo all of the copy-paste work I did in the last 10 days (basically putting content from PDFs into web pages to build our QM system).
[User Error] 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 gltigen Bereichs.01000, 3621, [Microsoft][SQL Server Native Client 10.0][SQL Server]Die Anweisung wurde beendet.): UPDATE "Member" SET "NumVisit" = 7, "RememberLoginToken" = null, "LockedOutUntil" = null, "LastEdited" = '2012-04-13 13:25:04' where "ID" = 1: [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 gltigen Bereichs.; [Microsoft][SQL Server Native Client 10.0][SQL Server]Die Anweisung wurde beendet.
POST /QM/Security/LoginForm
Line 620 in C:\inetpub\wwwroot\QM\sapphire\core\model\Database.php
Source
611 /**
612 * Error handler for database errors.
613 * All database errors will call this function to report the error. It isn't a static function;
614 * it will be called on the object itself and as such can be overridden in a subclass.
615 * @todo hook this into a more well-structured error handling system.
616 * @param string $msg The error message.
617 * @param int $errorLevel The level of the error to throw.
618 */
619 function databaseError($msg, $errorLevel = E_USER_ERROR) {
620 user_error($msg, $errorLevel);
621 }
622
623 /**
624 * Enable supression of database messages.
625 */
626 function quiet() {
Trace
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 gltigen Bereichs.01000, 3621, [Microsoft][SQL Server Native Client 10.0][SQL Server]Die Anweisung wurde beendet.): UPDATE "Member" SET "NumVisit" = 7, "RememberLoginToken" = null, "LockedOutUntil" = null, "LastEdited" = '2012-04-13 13:25:04' where "ID" = 1: [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 gltigen 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 gltigen Bereichs.01000, 3621, [Microsoft][SQL Server Native Client 10.0][SQL Server]Die Anweisung wurde beendet.): UPDATE "Member" SET "NumVisit" = 7, "RememberLoginToken" = null, "LockedOutUntil" = null, "LastEdited" = '2012-04-13 13:25:04' where "ID" = 1: [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 gltigen 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 gltigen Bereichs.01000, 3621, [Microsoft][SQL Server Native Client 10.0][SQL Server]Die Anweisung wurde beendet.): UPDATE "Member" SET "NumVisit" = 7, "RememberLoginToken" = null, "LockedOutUntil" = null, "LastEdited" = '2012-04-13 13:25:04' where "ID" = 1,256)
Line 310 of MSSQLDatabase.php
MSSQLDatabase->query(UPDATE "Member" SET "NumVisit" = 7, "RememberLoginToken" = null, "LockedOutUntil" = null, "LastEdited" = '2012-04-13 13:25:04' where "ID" = 1)
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 350 of Member.php
Member->logIn()
Line 210 of MemberLoginForm.php
MemberLoginForm->performLogin(Array)
Line 125 of MemberLoginForm.php
MemberLoginForm->dologin(Array,MemberLoginForm,SS_HTTPRequest)
Line 332 of Form.php
Form->httpSubmission(SS_HTTPRequest)
Line 143 of RequestHandler.php
RequestHandler->handleRequest(SS_HTTPRequest)
Line 161 of RequestHandler.php
RequestHandler->handleRequest(SS_HTTPRequest)
Line 147 of Controller.php
Controller->handleRequest(SS_HTTPRequest)
Line 282 of Director.php
Director::handleRequest(SS_HTTPRequest,Session)
Line 125 of Director.php
Director::direct(Security/LoginForm)
Line 127 of main.php