{"action":"created","issue":{"url":"https://api.github.com/repos/owncloud/announcementcenter/issues/31","labels_url":"https://api.github.com/repos/owncloud/announcementcenter/issues/31/labels{/name}","comments_url":"https://api.github.com/repos/owncloud/announcementcenter/issues/31/comments","events_url":"https://api.github.com/repos/owncloud/announcementcenter/issues/31/events","html_url":"https://github.com/owncloud/announcementcenter/issues/31","id":122972768,"number":31,"title":"Error when enabling app","user":{"login":"dsoap","id":11199003,"avatar_url":"https://avatars.githubusercontent.com/u/11199003?v=3","gravatar_id":"","url":"https://api.github.com/users/dsoap","html_url":"https://github.com/dsoap","followers_url":"https://api.github.com/users/dsoap/followers","following_url":"https://api.github.com/users/dsoap/following{/other_user}","gists_url":"https://api.github.com/users/dsoap/gists{/gist_id}","starred_url":"https://api.github.com/users/dsoap/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dsoap/subscriptions","organizations_url":"https://api.github.com/users/dsoap/orgs","repos_url":"https://api.github.com/users/dsoap/repos","events_url":"https://api.github.com/users/dsoap/events{/privacy}","received_events_url":"https://api.github.com/users/dsoap/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-12-18T15:53:34Z","updated_at":"2015-12-18T16:05:04Z","closed_at":null,"body":"I get the following error when trying to enable this app: \r\n```\r\nAn exception occurred while executing 'CREATE TABLE `oc_announcements` (`announcement_id` INT AUTO_INCREMENT NOT NULL, `announcement_time` INT DEFAULT 0 NOT NULL, `announcement_user` VARCHAR(64) NOT NULL, `announcement_subject` VARCHAR(512) NOT NULL, `announcement_message` VARCHAR(64000) DEFAULT NULL, PRIMARY KEY(`announcement_id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1074 Column length too big for column 'announcement_message' (max = 21845); use BLOB or TEXT instead\r\n```\r\n\r\nI have even tried to create the database myself and it has not worked to resolve this issue.\r\nmysql> desc oc_announcements;\r\n+----------------------+--------------+------+-----+---------+----------------+\r\n| Field                | Type         | Null | Key | Default | Extra          |\r\n+----------------------+--------------+------+-----+---------+----------------+\r\n| announcement_id      | int(11)      | NO   | PRI | NULL    | auto_increment |\r\n| announcement_time    | int(11)      | NO   |     | 0       |                |\r\n| announcement_user    | varchar(64)  | NO   |     | NULL    |                |\r\n| announcement_subject | varchar(512) | NO   |     | NULL    |                |\r\n| announcement_message | text         | YES  |     | NULL    |                |\r\n+----------------------+--------------+------+-----+---------+----------------+\r\n5 rows in set (0.00 sec)\r\n"},"comment":{"url":"https://api.github.com/repos/owncloud/announcementcenter/issues/comments/165816833","html_url":"https://github.com/owncloud/announcementcenter/issues/31#issuecomment-165816833","issue_url":"https://api.github.com/repos/owncloud/announcementcenter/issues/31","id":165816833,"user":{"login":"dsoap","id":11199003,"avatar_url":"https://avatars.githubusercontent.com/u/11199003?v=3","gravatar_id":"","url":"https://api.github.com/users/dsoap","html_url":"https://github.com/dsoap","followers_url":"https://api.github.com/users/dsoap/followers","following_url":"https://api.github.com/users/dsoap/following{/other_user}","gists_url":"https://api.github.com/users/dsoap/gists{/gist_id}","starred_url":"https://api.github.com/users/dsoap/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dsoap/subscriptions","organizations_url":"https://api.github.com/users/dsoap/orgs","repos_url":"https://api.github.com/users/dsoap/repos","events_url":"https://api.github.com/users/dsoap/events{/privacy}","received_events_url":"https://api.github.com/users/dsoap/received_events","type":"User","site_admin":false},"created_at":"2015-12-18T16:05:04Z","updated_at":"2015-12-18T16:05:04Z","body":"### Steps to reproduce\r\n1. Have tried multiple times to click enable on the app  \r\n2. Created the database table manually\r\n\r\n### Expected behaviour\r\nThe announcement app should enable but it is throwing an error\r\n\r\n### Actual behaviour\r\nAn exception occurred while executing 'CREATE TABLE `oc_announcements` (`announcement_id` INT AUTO_INCREMENT NOT NULL, `announcement_time` INT DEFAULT 0 NOT NULL, `announcement_user` VARCHAR(64) NOT NULL, `announcement_subject` VARCHAR(512) NOT NULL, `announcement_message` VARCHAR(64000) DEFAULT NULL, PRIMARY KEY(`announcement_id`)) DEFAULT CHARACTER SET utf8 COLLATE utf8_bin ENGINE = InnoDB': SQLSTATE[42000]: Syntax error or access violation: 1074 Column length too big for column 'announcement_message' (max = 21845); use BLOB or TEXT instead\r\n\r\n### Server configuration\r\n**Operating system**:\r\nUbuntu 14.04\r\n\r\n**Web server:**\r\nApache\r\n\r\n**Database:**\r\nmysql  Ver 14.14 Distrib 5.5.46,\r\n\r\n**PHP version:**\r\nPHP 5.5.9-1ubuntu4.14\r\n\r\n**ownCloud version:** (see ownCloud admin page)\r\n8.2.1.4 (stable)\r\n\r\n**Updated from an older ownCloud or fresh install:**\r\nUpdated from older version\r\n\r\n**List of activated apps:**\r\n- activity: 2.1.3\r\n  - calendar: 0.8.1\r\n  - contacts: 0.5.0.0\r\n  - documents: 0.11.0\r\n  - files: 1.2.0\r\n  - files_external: 0.3.0\r\n  - files_locking: \r\n  - files_pdfviewer: 0.7\r\n  - files_sharing: 0.7.0\r\n  - files_texteditor: 2.0\r\n  - files_trashbin: 0.7.0\r\n  - files_versions: 1.1.0\r\n  - files_videoviewer: 0.1.3\r\n  - firstrunwizard: 1.1\r\n  - gallery: 14.2.0\r\n  - ownnote: 1.05\r\n  - provisioning_api: 0.3.0\r\n  - qownnotesapi: 0.4.1\r\n  - templateeditor: 0.1\r\n  - updater: 0.6\r\n"}}