{"action":"closed","issue":{"url":"https://api.github.com/repos/openhab/openhab/issues/2732","labels_url":"https://api.github.com/repos/openhab/openhab/issues/2732/labels{/name}","comments_url":"https://api.github.com/repos/openhab/openhab/issues/2732/comments","events_url":"https://api.github.com/repos/openhab/openhab/issues/2732/events","html_url":"https://github.com/openhab/openhab/issues/2732","id":88069217,"number":2732,"title":"[MySQL.persist] Saving group as string? But datatype is double!?","user":{"login":"Bubelbub","id":319352,"avatar_url":"https://avatars.githubusercontent.com/u/319352?v=3","gravatar_id":"","url":"https://api.github.com/users/Bubelbub","html_url":"https://github.com/Bubelbub","followers_url":"https://api.github.com/users/Bubelbub/followers","following_url":"https://api.github.com/users/Bubelbub/following{/other_user}","gists_url":"https://api.github.com/users/Bubelbub/gists{/gist_id}","starred_url":"https://api.github.com/users/Bubelbub/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Bubelbub/subscriptions","organizations_url":"https://api.github.com/users/Bubelbub/orgs","repos_url":"https://api.github.com/users/Bubelbub/repos","events_url":"https://api.github.com/users/Bubelbub/events{/privacy}","received_events_url":"https://api.github.com/users/Bubelbub/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/openhab/openhab/labels/bug","name":"bug","color":"fc2929"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":13,"created_at":"2015-06-13T21:35:44Z","updated_at":"2015-11-21T14:23:06Z","closed_at":"2015-11-21T14:23:06Z","body":"\t2015-06-13 23:31:01.220 [ERROR] [.p.m.i.MysqlPersistenceService] - mySQL: Could not store item 'Floor' in database with statement 'INSERT INTO Item50 (TIME, VALUE) VALUES(NOW(),'OFF') ON DUPLICATE KEY UPDATE VALUE='OFF';': Data truncated for column 'Value' at row 1\r\n\t2015-06-13 23:31:01.336 [ERROR] [.p.m.i.MysqlPersistenceService] - mySQL: Could not store item 'Kitchen' in database with statement 'INSERT INTO Item55 (TIME, VALUE) VALUES(NOW(),'OFF') ON DUPLICATE KEY UPDATE VALUE='OFF';': Data truncated for column 'Value' at row 1\r\n\t2015-06-13 23:31:01.372 [ERROR] [.p.m.i.MysqlPersistenceService] - mySQL: Could not store item 'Bath' in database with statement 'INSERT INTO Item57 (TIME, VALUE) VALUES(NOW(),'OFF') ON DUPLICATE KEY UPDATE VALUE='OFF';': Data truncated for column 'Value' at row 1\r\n\t2015-06-13 23:31:01.506 [ERROR] [.p.m.i.MysqlPersistenceService] - mySQL: Could not store item 'Livingroom' in database with statement 'INSERT INTO Item63 (TIME, VALUE) VALUES(NOW(),'OFF') ON DUPLICATE KEY UPDATE VALUE='OFF';': Data truncated for column 'Value' at row 1\r\n\t2015-06-13 23:31:01.569 [ERROR] [.p.m.i.MysqlPersistenceService] - mySQL: Could not store item 'Office' in database with statement 'INSERT INTO Item66 (TIME, VALUE) VALUES(NOW(),'OFF') ON DUPLICATE KEY UPDATE VALUE='OFF';': Data truncated for column 'Value' at row 1\r\n\r\nThey are groups!\r\n\r\n    // default.items\r\n    Group\tFloor\t\"Floor\"\r\n\tGroup\tKitchen\t\"Kitchen\"\r\n\tGroup\tBath\t\"Bathroom\"\r\n\tGroup\tLivingroom\t\"Livingroom\"\r\n\tGroup\tOffice\t\"Office\"\r\n\r\nBut they exists in database table `items`.\r\n\r\n![](http://i.imgur.com/O56qDzw.png)\r\n\r\nThank's in Advance for fixing."}}