{"action":"closed","issue":{"url":"https://api.github.com/repos/nerzhul/ocsms/issues/55","labels_url":"https://api.github.com/repos/nerzhul/ocsms/issues/55/labels{/name}","comments_url":"https://api.github.com/repos/nerzhul/ocsms/issues/55/comments","events_url":"https://api.github.com/repos/nerzhul/ocsms/issues/55/events","html_url":"https://github.com/nerzhul/ocsms/issues/55","id":58077118,"number":55,"title":"An exception occurred while executing INSERT INTO oc_ocsms_smsdatas","user":{"login":"eyesoftsys","id":3406052,"avatar_url":"https://avatars.githubusercontent.com/u/3406052?v=3","gravatar_id":"","url":"https://api.github.com/users/eyesoftsys","html_url":"https://github.com/eyesoftsys","followers_url":"https://api.github.com/users/eyesoftsys/followers","following_url":"https://api.github.com/users/eyesoftsys/following{/other_user}","gists_url":"https://api.github.com/users/eyesoftsys/gists{/gist_id}","starred_url":"https://api.github.com/users/eyesoftsys/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/eyesoftsys/subscriptions","organizations_url":"https://api.github.com/users/eyesoftsys/orgs","repos_url":"https://api.github.com/users/eyesoftsys/repos","events_url":"https://api.github.com/users/eyesoftsys/events{/privacy}","received_events_url":"https://api.github.com/users/eyesoftsys/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/nerzhul/ocsms/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/nerzhul/ocsms/milestones/5","html_url":"https://github.com/nerzhul/ocsms/milestones/1.5","labels_url":"https://api.github.com/repos/nerzhul/ocsms/milestones/5/labels","id":940627,"number":5,"title":"1.5","description":null,"creator":{"login":"nerzhul","id":119752,"avatar_url":"https://avatars.githubusercontent.com/u/119752?v=3","gravatar_id":"","url":"https://api.github.com/users/nerzhul","html_url":"https://github.com/nerzhul","followers_url":"https://api.github.com/users/nerzhul/followers","following_url":"https://api.github.com/users/nerzhul/following{/other_user}","gists_url":"https://api.github.com/users/nerzhul/gists{/gist_id}","starred_url":"https://api.github.com/users/nerzhul/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nerzhul/subscriptions","organizations_url":"https://api.github.com/users/nerzhul/orgs","repos_url":"https://api.github.com/users/nerzhul/repos","events_url":"https://api.github.com/users/nerzhul/events{/privacy}","received_events_url":"https://api.github.com/users/nerzhul/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":6,"state":"open","created_at":"2015-01-18T16:06:53Z","updated_at":"2015-03-02T12:59:06Z","due_on":null,"closed_at":null},"comments":0,"created_at":"2015-02-18T14:50:33Z","updated_at":"2015-03-02T12:59:06Z","closed_at":"2015-03-02T12:59:06Z","body":"solved in file apps/ocsms/db/smsmapper.php by adding :\r\non line +262 $today = date(\"Y-m-d H:i:s\");\r\nand change on line +264 \"NOW()\",\"NOW()\" with $today, $today\r\n\r\nServer\r\n\r\nownCloud version: 7.0.4 (stable)\r\nPHP version: PHP 5.6.5 \r\nHTTPd server: Apache/2.4.10\r\nHTTPS: Apache/2.4.10\r\nmysqld : 5.6.17\r\n\r\nClient\r\n\r\nAndroid version: 4.2.2\r\nPhone: - \r\nownCloud SMS app version: 0.17.0\r\n\r\nContent of /owncloud/data/owncloud.log\r\n\r\n{\"reqId\":\"54e48640cdc96\",\"app\":\"index\",\"message\":\"Doctrine\\\\DBAL\\\\DBALException: An exception occurred while executing 'INSERT INTO oc_ocsms_smsdatas (user_id, added, lastmodified, sms_flags, sms_date, sms_id,sms_address, sms_msg, sms_mailbox, sms_type) VALUES (?,?,?,?,?,?,?,?,?,?)':\\n\\nSQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: 'now()' for column 'added' at row 1\",\"level\":4,\"time\":\"2015-02-18T12:32:00+00:00\",\"method\":\"POST\",\"url\":\"\\/index.php\\/apps\\/ocsms\\/push?format=json\"}\r\n{\"reqId\":\"54e486415309f\",\"app\":\"index\",\"message\":\"Doctrine\\\\DBAL\\\\DBALException: An exception occurred while executing 'INSERT INTO oc_ocsms_smsdatas (user_id, added, lastmodified, sms_flags, sms_date, sms_id,sms_address, sms_msg, sms_mailbox, sms_type) VALUES (?,?,?,?,?,?,?,?,?,?)':\\n\\nSQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: 'now()' for column 'added' at row 1\",\"level\":4,\"time\":\"2015-02-18T12:32:01+00:00\",\"method\":\"POST\",\"url\":\"\\/index.php\\/apps\\/ocsms\\/push?format=json\"}\r\n{\"reqId\":\"54e48641a272d\",\"app\":\"index\",\"message\":\"Doctrine\\\\DBAL\\\\DBALException: An exception occurred while executing 'INSERT INTO oc_ocsms_smsdatas (user_id, added, lastmodified, sms_flags, sms_date, sms_id,sms_address, sms_msg, sms_mailbox, sms_type) VALUES (?,?,?,?,?,?,?,?,?,?)':\\n\\nSQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: 'now()' for column 'added' at row 1\",\"level\":4,\"time\":\"2015-02-18T12:32:01+00:00\",\"method\":\"POST\",\"url\":\"\\/index.php\\/apps\\/ocsms\\/push?format=json\"}\r\n\r\n"}}