{"action":"created","issue":{"url":"https://api.github.com/repos/Geeklog-Core/geeklog/issues/569","labels_url":"https://api.github.com/repos/Geeklog-Core/geeklog/issues/569/labels{/name}","comments_url":"https://api.github.com/repos/Geeklog-Core/geeklog/issues/569/comments","events_url":"https://api.github.com/repos/Geeklog-Core/geeklog/issues/569/events","html_url":"https://github.com/Geeklog-Core/geeklog/issues/569","id":125175045,"number":569,"title":"[Bugs] Postgres: HTML text mangled by Post Mode: HTML Formatted","user":{"login":"mystralkk","id":2015377,"avatar_url":"https://avatars.githubusercontent.com/u/2015377?v=3","gravatar_id":"","url":"https://api.github.com/users/mystralkk","html_url":"https://github.com/mystralkk","followers_url":"https://api.github.com/users/mystralkk/followers","following_url":"https://api.github.com/users/mystralkk/following{/other_user}","gists_url":"https://api.github.com/users/mystralkk/gists{/gist_id}","starred_url":"https://api.github.com/users/mystralkk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mystralkk/subscriptions","organizations_url":"https://api.github.com/users/mystralkk/orgs","repos_url":"https://api.github.com/users/mystralkk/repos","events_url":"https://api.github.com/users/mystralkk/events{/privacy}","received_events_url":"https://api.github.com/users/mystralkk/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/Geeklog-Core/geeklog/labels/major","name":"major","color":"ededed"}],"state":"closed","locked":false,"assignee":{"login":"dhaun","id":16507691,"avatar_url":"https://avatars.githubusercontent.com/u/16507691?v=3","gravatar_id":"","url":"https://api.github.com/users/dhaun","html_url":"https://github.com/dhaun","followers_url":"https://api.github.com/users/dhaun/followers","following_url":"https://api.github.com/users/dhaun/following{/other_user}","gists_url":"https://api.github.com/users/dhaun/gists{/gist_id}","starred_url":"https://api.github.com/users/dhaun/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dhaun/subscriptions","organizations_url":"https://api.github.com/users/dhaun/orgs","repos_url":"https://api.github.com/users/dhaun/repos","events_url":"https://api.github.com/users/dhaun/events{/privacy}","received_events_url":"https://api.github.com/users/dhaun/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/Geeklog-Core/geeklog/milestones/34","html_url":"https://github.com/Geeklog-Core/geeklog/milestones/2.0.0","labels_url":"https://api.github.com/repos/Geeklog-Core/geeklog/milestones/34/labels","id":1484685,"number":34,"title":"2.0.0","description":null,"creator":{"login":"mystralkk","id":2015377,"avatar_url":"https://avatars.githubusercontent.com/u/2015377?v=3","gravatar_id":"","url":"https://api.github.com/users/mystralkk","html_url":"https://github.com/mystralkk","followers_url":"https://api.github.com/users/mystralkk/followers","following_url":"https://api.github.com/users/mystralkk/following{/other_user}","gists_url":"https://api.github.com/users/mystralkk/gists{/gist_id}","starred_url":"https://api.github.com/users/mystralkk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mystralkk/subscriptions","organizations_url":"https://api.github.com/users/mystralkk/orgs","repos_url":"https://api.github.com/users/mystralkk/repos","events_url":"https://api.github.com/users/mystralkk/events{/privacy}","received_events_url":"https://api.github.com/users/mystralkk/received_events","type":"User","site_admin":false},"open_issues":0,"closed_issues":48,"state":"closed","created_at":"2016-01-05T12:12:45Z","updated_at":"2016-01-06T13:25:30Z","due_on":null,"closed_at":"2016-01-05T12:12:45Z"},"comments":3,"created_at":"2016-01-06T13:19:49Z","updated_at":"2016-01-06T16:18:09Z","closed_at":"2016-01-06T13:19:55Z","body":"**Reported by Eroen on 6 Feb 2012 12:31**\n\n**Version:** 1.8.1\n\n[Mantis Bugtracker #1425](http://project.geeklog.net/tracking/view.php?id=1425)"},"comment":{"url":"https://api.github.com/repos/Geeklog-Core/geeklog/issues/comments/169374993","html_url":"https://github.com/Geeklog-Core/geeklog/issues/569#issuecomment-169374993","issue_url":"https://api.github.com/repos/Geeklog-Core/geeklog/issues/569","id":169374993,"user":{"login":"mystralkk","id":2015377,"avatar_url":"https://avatars.githubusercontent.com/u/2015377?v=3","gravatar_id":"","url":"https://api.github.com/users/mystralkk","html_url":"https://github.com/mystralkk","followers_url":"https://api.github.com/users/mystralkk/followers","following_url":"https://api.github.com/users/mystralkk/following{/other_user}","gists_url":"https://api.github.com/users/mystralkk/gists{/gist_id}","starred_url":"https://api.github.com/users/mystralkk/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mystralkk/subscriptions","organizations_url":"https://api.github.com/users/mystralkk/orgs","repos_url":"https://api.github.com/users/mystralkk/repos","events_url":"https://api.github.com/users/mystralkk/events{/privacy}","received_events_url":"https://api.github.com/users/mystralkk/received_events","type":"User","site_admin":false},"created_at":"2016-01-06T16:18:09Z","updated_at":"2016-01-06T16:18:09Z","body":"**Comment posted by dhaun on 30 Jun 2012 21:39**\n\nThis fixes the immediate problem:\r\n\r\nALTER TABLE gl_postmodes ALTER COLUMN code TYPE varchar(10);\r\n\r\nThe &#039;name&#039; column should probably also be a varchar (no need for padding) and the gl_sortcodes table has the same problem. Ditto for the &#039;name&#039; columns in gl_maillist and gl_statuscodes. In other words: Don&#039;t use the char type at all, always use varchar."}}