{"action":"closed","issue":{"url":"https://api.github.com/repos/SBFspot/SBFspot/issues/154","repository_url":"https://api.github.com/repos/SBFspot/SBFspot","labels_url":"https://api.github.com/repos/SBFspot/SBFspot/issues/154/labels{/name}","comments_url":"https://api.github.com/repos/SBFspot/SBFspot/issues/154/comments","events_url":"https://api.github.com/repos/SBFspot/SBFspot/issues/154/events","html_url":"https://github.com/SBFspot/SBFspot/issues/154","id":271199113,"number":154,"title":"SBFspotUploadDeamon not uploading","user":{"login":"SBFspot","id":32780911,"avatar_url":"https://avatars2.githubusercontent.com/u/32780911?v=4","gravatar_id":"","url":"https://api.github.com/users/SBFspot","html_url":"https://github.com/SBFspot","followers_url":"https://api.github.com/users/SBFspot/followers","following_url":"https://api.github.com/users/SBFspot/following{/other_user}","gists_url":"https://api.github.com/users/SBFspot/gists{/gist_id}","starred_url":"https://api.github.com/users/SBFspot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SBFspot/subscriptions","organizations_url":"https://api.github.com/users/SBFspot/orgs","repos_url":"https://api.github.com/users/SBFspot/repos","events_url":"https://api.github.com/users/SBFspot/events{/privacy}","received_events_url":"https://api.github.com/users/SBFspot/received_events","type":"User","site_admin":false},"labels":[{"id":740400781,"url":"https://api.github.com/repos/SBFspot/SBFspot/labels/CodePlexMigrationInitiated","name":"CodePlexMigrationInitiated","color":"ededed","default":false},{"id":740400782,"url":"https://api.github.com/repos/SBFspot/SBFspot/labels/Impact:%20Unassigned","name":"Impact: Unassigned","color":"ededed","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":18,"created_at":"2017-11-04T15:13:16Z","updated_at":"2017-11-04T15:17:16Z","closed_at":"2017-11-04T15:17:16Z","author_association":"OWNER","body":"Hi,\r\n\nAfter upgrading to Ubuntu 16.04 I can not get SBFspotUploadDeamon to start uploading.\r\nIf I start the deamon manually I get only:\r\n[13:08:40] INFO: Starting SBFspotUploadDeamon Version 1.0.1\r\n[13:08:40] INFO: Starting Daemon...\r\n\nin the log, if I reboot the server I get:\r\n[13:13:09] INFO: Starting SBFspotUploadDeamon Version 1.0.1\r\n[13:13:09] ERROR: Unable to open database. Check configuration.\r\n\nI'm using Mysql: Server version: 5.7.12-0ubuntu1 (Ubuntu)\r\nThe database gets populated correctly.\r\n\nWhen I start the deamon the mysql query log on (turned it on temporarily) it showed:\r\nSELECT DATE_FORMAT(Timestamp,'%Y%m%d,%H:%i'),V1,V2,V3,V4,V5,V6,V7,V8,V9,V10,V11,V12 FROM vwPvoData WHERE TimeStamp>NOW()-INTERVAL 13 DAY AND PVoutput IS NULL AND Serial=2120110081 ORDER BY TimeStamp LIMIT 30\r\n\nWhen I tried this query in PHPmyadmin I stumbled into this problem:\r\n1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vwConsumption.Timestamp' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by\r\n\nThe deamon started uploading after I removed the 'only_full_group_by' from sql_mode. \r\n\n\nBR,\r\nHubert\n\r\n\r\n#### This work item was migrated from CodePlex\r\nCodePlex work item ID: '150'\r\nVote count: '1'\r\n"}}
{"actor":{"display_login":"SBFspot"}}