{"action":"created","issue":{"url":"https://api.github.com/repos/propelorm/Propel2/issues/1265","repository_url":"https://api.github.com/repos/propelorm/Propel2","labels_url":"https://api.github.com/repos/propelorm/Propel2/issues/1265/labels{/name}","comments_url":"https://api.github.com/repos/propelorm/Propel2/issues/1265/comments","events_url":"https://api.github.com/repos/propelorm/Propel2/issues/1265/events","html_url":"https://github.com/propelorm/Propel2/issues/1265","id":174995330,"number":1265,"title":"Microsoft SQL platform problems with DATE & TIME types.  ","user":{"login":"mhaisley","id":413583,"avatar_url":"https://avatars.githubusercontent.com/u/413583?v=3","gravatar_id":"","url":"https://api.github.com/users/mhaisley","html_url":"https://github.com/mhaisley","followers_url":"https://api.github.com/users/mhaisley/followers","following_url":"https://api.github.com/users/mhaisley/following{/other_user}","gists_url":"https://api.github.com/users/mhaisley/gists{/gist_id}","starred_url":"https://api.github.com/users/mhaisley/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mhaisley/subscriptions","organizations_url":"https://api.github.com/users/mhaisley/orgs","repos_url":"https://api.github.com/users/mhaisley/repos","events_url":"https://api.github.com/users/mhaisley/events{/privacy}","received_events_url":"https://api.github.com/users/mhaisley/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":4,"created_at":"2016-09-05T04:54:50Z","updated_at":"2016-10-21T12:18:40Z","closed_at":null,"body":"The Microsoft SQL platform file currently results in errors when writing a date or time field (but not DATETIME, those are working fine).  \r\n\r\n\"[S0001][241] Conversion failed when converting date and/or time from character string.\"\r\n\r\nPR #1250 fixes this issue. "},"comment":{"url":"https://api.github.com/repos/propelorm/Propel2/issues/comments/255365049","html_url":"https://github.com/propelorm/Propel2/issues/1265#issuecomment-255365049","issue_url":"https://api.github.com/repos/propelorm/Propel2/issues/1265","id":255365049,"user":{"login":"MDT-FGI","id":21058652,"avatar_url":"https://avatars.githubusercontent.com/u/21058652?v=3","gravatar_id":"","url":"https://api.github.com/users/MDT-FGI","html_url":"https://github.com/MDT-FGI","followers_url":"https://api.github.com/users/MDT-FGI/followers","following_url":"https://api.github.com/users/MDT-FGI/following{/other_user}","gists_url":"https://api.github.com/users/MDT-FGI/gists{/gist_id}","starred_url":"https://api.github.com/users/MDT-FGI/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/MDT-FGI/subscriptions","organizations_url":"https://api.github.com/users/MDT-FGI/orgs","repos_url":"https://api.github.com/users/MDT-FGI/repos","events_url":"https://api.github.com/users/MDT-FGI/events{/privacy}","received_events_url":"https://api.github.com/users/MDT-FGI/received_events","type":"User","site_admin":false},"created_at":"2016-10-21T12:18:40Z","updated_at":"2016-10-21T12:18:40Z","body":"I have set up MonoLog and all corresponding debug stuff in the config but there is no additional output for that specific query.\r\n\r\n> 'defaultLogger' => [\r\n>                     'type' => 'stream',\r\n>                     'path' => 'H:\\htdocs\\vendor\\propel\\propel.log',\r\n>                     'level' => 100\r\n>                 ]\r\n\r\nOutput:\r\n> [2016-10-21 14:00:20] defaultLogger.ERROR: SQLSTATE[22007]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Conversion failed when converting date and/or time from character string. [] []\r\n\r\nThere is just two SELECTS before that error and they are for loading the page and have nothing to do with timestamps or anything.\r\nNo INSERTs are shown.\r\n\r\nI also tried to set the debug on the specific query but that didn't output anything neither. So I tried to output the query myself with some rudimentary debug-output:\r\n> INSERT INTO [Note] (value,ObjectUID,created_at,updated_at) VALUES (:p1,:p2,:p3,:p4)\r\n> \r\n> Array (\r\n> \t[0] => Array (\r\n> \t\t[column] => value\r\n> \t\t[table] => Note\r\n> \t\t[value] => TEST )\r\n> \t[1] => Array (\r\n> \t\t[column] => ObjectUID\r\n> \t\t[table] => Note\r\n> \t\t[value] => 543 )\r\n> \t[2] => Array (\r\n> \t\t[column] => created_at\r\n> \t\t[table] => Note\r\n> \t\t[value] => DateTime Object (\r\n> \t\t\t\t\t[date] => 2016-10-21 14:15:00.986604\r\n> \t\t\t\t\t[timezone_type] => 3\r\n> \t\t\t\t\t[timezone] => Europe/Berlin\r\n> \t\t\t\t\t)\r\n> \t\t\t\t)\r\n> \t[3] => Array (\r\n> \t\t[column] => updated_at\r\n> \t\t[table] => Note\r\n> \t\t[value] => DateTime Object (\r\n> \t\t\t\t\t[date] => 2016-10-21 14:15:00.986604\r\n> \t\t\t\t\t[timezone_type] => 3\r\n> \t\t\t\t\t[timezone] => Europe/Berlin\r\n> \t\t\t\t\t)\r\n> \t\t\t\t)\r\n> )\r\n\r\nI hope this helps. Otherwise just give me a hint how to provide better information."}}
{"actor":{"display_login":"MDT-FGI"}}