{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/core/issues/18420","labels_url":"https://api.github.com/repos/owncloud/core/issues/18420/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/core/issues/18420/comments","events_url":"https://api.github.com/repos/owncloud/core/issues/18420/events","html_url":"https://github.com/owncloud/core/issues/18420","id":101844311,"number":18420,"title":"Exception when updating storage availability","user":{"login":"PVince81","id":277525,"avatar_url":"https://avatars.githubusercontent.com/u/277525?v=3","gravatar_id":"","url":"https://api.github.com/users/PVince81","html_url":"https://github.com/PVince81","followers_url":"https://api.github.com/users/PVince81/followers","following_url":"https://api.github.com/users/PVince81/following{/other_user}","gists_url":"https://api.github.com/users/PVince81/gists{/gist_id}","starred_url":"https://api.github.com/users/PVince81/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/PVince81/subscriptions","organizations_url":"https://api.github.com/users/PVince81/orgs","repos_url":"https://api.github.com/users/PVince81/repos","events_url":"https://api.github.com/users/PVince81/events{/privacy}","received_events_url":"https://api.github.com/users/PVince81/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/owncloud/core/labels/app:files_external","name":"app:files_external","color":"02d7e1"},{"url":"https://api.github.com/repos/owncloud/core/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/owncloud/core/labels/sev2-high","name":"sev2-high","color":"fc2929"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/owncloud/core/milestones/37","html_url":"https://github.com/owncloud/core/milestones/8.2-current","labels_url":"https://api.github.com/repos/owncloud/core/milestones/37/labels","id":993629,"number":37,"title":"8.2-current","description":"","creator":{"login":"craigpg","id":160667,"avatar_url":"https://avatars.githubusercontent.com/u/160667?v=3","gravatar_id":"","url":"https://api.github.com/users/craigpg","html_url":"https://github.com/craigpg","followers_url":"https://api.github.com/users/craigpg/followers","following_url":"https://api.github.com/users/craigpg/following{/other_user}","gists_url":"https://api.github.com/users/craigpg/gists{/gist_id}","starred_url":"https://api.github.com/users/craigpg/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/craigpg/subscriptions","organizations_url":"https://api.github.com/users/craigpg/orgs","repos_url":"https://api.github.com/users/craigpg/repos","events_url":"https://api.github.com/users/craigpg/events{/privacy}","received_events_url":"https://api.github.com/users/craigpg/received_events","type":"User","site_admin":false},"open_issues":642,"closed_issues":397,"state":"open","created_at":"2015-02-24T16:19:37Z","updated_at":"2015-08-19T09:21:17Z","due_on":"2015-10-20T04:00:00Z","closed_at":null},"comments":1,"created_at":"2015-08-19T09:21:05Z","updated_at":"2015-08-19T09:25:11Z","closed_at":null,"body":"### Steps\r\n\r\n1. Enable external storage\r\n1. Configure a SMB mount with invalid values (I used my usual local SMB storage's settings but have shut down smbd before adding this)\r\n\r\n### Expected result\r\nNo errors in log\r\n\r\n### Actual result\r\n```\r\n{\"reqId\":\"F5ovzkrcLYIpYvTyG+JF\",\"remoteAddr\":\"192.168.177.239\",\"app\":\"files_external\",\"message\":\"Exception: {\\\"Exception\\\":\\\"Doctrine\\\\\\\\DBAL\\\\\\\\Exception\\\\\\\\DriverException\\\",\\\"Message\\\":\\\"An exception occurred while executing 'UPDATE `oc_storages` SET `available` = ?, `last_checked` = ? WHERE `id` = ?' with params [false, 1439975924, \\\\\\\"smb::vincent@localhost\\\\\\\\\\\\\\/\\\\\\\\\\\\\\/shared\\\\\\\\\\\\\\/\\\\\\\\\\\\\\/\\\\\\\"]:\\\\n\\\\nSQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'available' at row 1\\\",\\\"Code\\\":0,\\\"Trace\\\":\\\"\r\n#0 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/DBALException.php(116): Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException))\\\\n\r\n#1 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Statement.php(172): Doctrine\\\\\\\\DBAL\\\\\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOMySql\\\\\\\\Driver), Object(Doctrine\\\\\\\\DBAL\\\\\\\\Driver\\\\\\\\PDOException), 'UPDATE `oc_stor...', Array)\\\\n\r\n#2 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/db\\\\\\/statementwrapper.php(73): Doctrine\\\\\\\\DBAL\\\\\\\\Statement->execute(Array)\\\\n\r\n#3 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/db.php(147): OC_DB_StatementWrapper->execute(Array)\\\\n\r\n#4 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/files\\\\\\/cache\\\\\\/storage.php(157): OC_DB::executeAudited('UPDATE `*PREFIX...', Array)\\\\n\r\n#5 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/files\\\\\\/storage\\\\\\/common.php(670): OC\\\\\\\\Files\\\\\\\\Cache\\\\\\\\Storage->setAvailability(false)\\\\n\r\n#6 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/apps\\\\\\/files_external\\\\\\/lib\\\\\\/config.php(507): OC\\\\\\\\Files\\\\\\\\Storage\\\\\\\\Common->setAvailability(false)\\\\n\r\n#7 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/apps\\\\\\/files_external\\\\\\/controller\\\\\\/storagescontroller.php(123): OC_Mount_Config::getBackendStatus('\\\\\\\\\\\\\\\\OC\\\\\\\\\\\\\\\\Files\\\\\\\\\\\\\\\\Stora...', Array, false)\\\\n\r\n#8 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/apps\\\\\\/files_external\\\\\\/controller\\\\\\/globalstoragescontroller.php(100): OCA\\\\\\\\Files_External\\\\\\\\Controller\\\\\\\\StoragesController->updateStorageStatus(Object(OCA\\\\\\\\Files_external\\\\\\\\Lib\\\\\\\\StorageConfig))\\\\n\r\n#9 [internal function]: OCA\\\\\\\\Files_External\\\\\\\\Controller\\\\\\\\GlobalStoragesController->create('smb', '\\\\\\\\\\\\\\\\OC\\\\\\\\\\\\\\\\Files\\\\\\\\\\\\\\\\Stora...', Array, NULL, Array, Array, 100)\\\\n\r\n#10 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/appframework\\\\\\/http\\\\\\/dispatcher.php(159): call_user_func_array(Array, Array)\\\\n\r\n#11 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/appframework\\\\\\/http\\\\\\/dispatcher.php(89): OC\\\\\\\\AppFramework\\\\\\\\Http\\\\\\\\Dispatcher->executeController(Object(OCA\\\\\\\\Files_External\\\\\\\\Controller\\\\\\\\GlobalStoragesController), 'create')\\\\n\r\n#12 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/appframework\\\\\\/app.php(108): OC\\\\\\\\AppFramework\\\\\\\\Http\\\\\\\\Dispatcher->dispatch(Object(OCA\\\\\\\\Files_External\\\\\\\\Controller\\\\\\\\GlobalStoragesController), 'create')\\\\n\r\n#13 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/appframework\\\\\\/routing\\\\\\/routeactionhandler.php(45): OC\\\\\\\\AppFramework\\\\\\\\App::main('GlobalStoragesC...', 'create', Object(OC\\\\\\\\AppFramework\\\\\\\\DependencyInjection\\\\\\\\DIContainer), Array)\\\\n\r\n#14 [internal function]: OC\\\\\\\\AppFramework\\\\\\\\routing\\\\\\\\RouteActionHandler->__invoke(Array)\\\\n\r\n#15 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/lib\\\\\\/private\\\\\\/route\\\\\\/router.php(280): call_user_func(Object(OC\\\\\\\\AppFramework\\\\\\\\routing\\\\\\\\RouteActionHandler), Array)\\\\n\r\n#16 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/lib\\\\\\/base.php(879): OC\\\\\\\\Route\\\\\\\\Router->match('\\\\\\/apps\\\\\\/files_ext...')\\\\n\r\n#17 \\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/index.php(40): OC::handleRequest()\\\\n\r\n#18 {main}\\\",\\\"File\\\":\\\"\\\\\\/srv\\\\\\/www\\\\\\/htdocs\\\\\\/owncloud\\\\\\/3rdparty\\\\\\/doctrine\\\\\\/dbal\\\\\\/lib\\\\\\/Doctrine\\\\\\/DBAL\\\\\\/Driver\\\\\\/AbstractMySQLDriver.php\\\",\\\"Line\\\":115}\",\"level\":4,\"time\":\"2015-08-19T09:18:44+00:00\",\"method\":\"POST\",\"url\":\"\\/owncloud\\/index.php\\/apps\\/files_external\\/globalstorages\"}\r\n```\r\n\r\n### Versions\r\nownCloud 8.2 pre-alpha git master 0b37004808c22792dab350eebfc763db6408b440\r\n\r\n@Xenopathic please have a look.\r\nNote that I also observed this on your branch https://github.com/owncloud/core/pull/15914 during testing"},"comment":{"url":"https://api.github.com/repos/owncloud/core/issues/comments/132507274","html_url":"https://github.com/owncloud/core/issues/18420#issuecomment-132507274","issue_url":"https://api.github.com/repos/owncloud/core/issues/18420","id":132507274,"user":{"login":"Xenopathic","id":2016878,"avatar_url":"https://avatars.githubusercontent.com/u/2016878?v=3","gravatar_id":"","url":"https://api.github.com/users/Xenopathic","html_url":"https://github.com/Xenopathic","followers_url":"https://api.github.com/users/Xenopathic/followers","following_url":"https://api.github.com/users/Xenopathic/following{/other_user}","gists_url":"https://api.github.com/users/Xenopathic/gists{/gist_id}","starred_url":"https://api.github.com/users/Xenopathic/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Xenopathic/subscriptions","organizations_url":"https://api.github.com/users/Xenopathic/orgs","repos_url":"https://api.github.com/users/Xenopathic/repos","events_url":"https://api.github.com/users/Xenopathic/events{/privacy}","received_events_url":"https://api.github.com/users/Xenopathic/received_events","type":"User","site_admin":false},"created_at":"2015-08-19T09:25:11Z","updated_at":"2015-08-19T09:25:11Z","body":"What DB type are you using?"}}