diff options
author | Frédéric Guillot <fred@kanboard.net> | 2018-04-11 12:03:38 -0700 |
---|---|---|
committer | Frédéric Guillot <fred@kanboard.net> | 2018-04-11 13:48:13 -0700 |
commit | dd92564d221f35fc4fc7bb449c6d24cc4743247b (patch) | |
tree | fb1e46d904f0fbf1f33f1449ca24354003f5e809 | |
parent | 8c5b9925c49bc1a989cdc5e146ce79543fdf7f0a (diff) |
Increase text fields length in several tables
38 files changed, 158 insertions, 103 deletions
diff --git a/app/Helper/SubtaskHelper.php b/app/Helper/SubtaskHelper.php index 19cdf97a..0e9f9c52 100644 --- a/app/Helper/SubtaskHelper.php +++ b/app/Helper/SubtaskHelper.php @@ -105,7 +105,7 @@ class SubtaskHelper extends Base public function renderTitleField(array $values, array $errors = array(), array $attributes = array()) { - $attributes = array_merge(array('tabindex="1"', 'required', 'maxlength="255"'), $attributes); + $attributes = array_merge(array('tabindex="1"', 'required'), $attributes); $html = $this->helper->form->label(t('Title'), 'title'); $html .= $this->helper->form->text('title', $values, $errors, $attributes); diff --git a/app/Helper/TaskHelper.php b/app/Helper/TaskHelper.php index cc164ce0..3aec9368 100644 --- a/app/Helper/TaskHelper.php +++ b/app/Helper/TaskHelper.php @@ -49,7 +49,6 @@ class TaskHelper extends Base array( 'autofocus', 'required', - 'maxlength="200"', 'tabindex="1"', 'placeholder="'.t('Title').'"' ) diff --git a/app/Import/TaskImport.php b/app/Import/TaskImport.php index 8278ed26..9ed351c5 100644 --- a/app/Import/TaskImport.php +++ b/app/Import/TaskImport.php @@ -140,8 +140,8 @@ class TaskImport extends Base new Validators\Integer('project_id', t('This value must be an integer')), new Validators\Required('project_id', t('The project is required')), new Validators\Required('title', t('The title is required')), - new Validators\MaxLength('title', t('The maximum length is %d characters', 200), 200), - new Validators\MaxLength('reference', t('The maximum length is %d characters', 50), 50), + new Validators\MaxLength('title', t('The maximum length is %d characters', 65535), 65535), + new Validators\MaxLength('reference', t('The maximum length is %d characters', 255), 255), )); return $v->execute(); diff --git a/app/Import/UserImport.php b/app/Import/UserImport.php index 304a3254..1ba9144b 100644 --- a/app/Import/UserImport.php +++ b/app/Import/UserImport.php @@ -108,7 +108,7 @@ class UserImport extends Base public function validateCreation(array $values) { $v = new Validator($values, array( - new Validators\MaxLength('username', t('The maximum length is %d characters', 50), 50), + new Validators\MaxLength('username', t('The maximum length is %d characters', 255), 255), new Validators\Unique('username', t('The username must be unique'), $this->db->getConnection(), UserModel::TABLE, 'id'), new Validators\MinLength('password', t('The minimum length is %d characters', 6), 6), new Validators\Email('email', t('Email address invalid')), diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php index b73ce8c0..6adcaec1 100644 --- a/app/Schema/Mysql.php +++ b/app/Schema/Mysql.php @@ -8,7 +8,35 @@ use PDO; use Kanboard\Core\Security\Token; use Kanboard\Core\Security\Role; -const VERSION = 128; +const VERSION = 129; + +function version_129(PDO $pdo) +{ + $pdo->exec('ALTER TABLE `projects` MODIFY `name` TEXT NOT NULL'); + $pdo->exec('ALTER TABLE `projects` MODIFY `email` TEXT'); + $pdo->exec('ALTER TABLE `action_has_params` MODIFY `name` TEXT NOT NULL'); + $pdo->exec('ALTER TABLE `action_has_params` MODIFY `value` TEXT NOT NULL'); + $pdo->exec('ALTER TABLE `actions` MODIFY `event_name` TEXT NOT NULL'); + $pdo->exec('ALTER TABLE `actions` MODIFY `action_name` TEXT NOT NULL'); + $pdo->exec("ALTER TABLE `comments` MODIFY `reference` VARCHAR(255) DEFAULT ''"); + $pdo->exec("ALTER TABLE `custom_filters` MODIFY `filter` TEXT NOT NULL"); + $pdo->exec("ALTER TABLE `custom_filters` MODIFY `name` TEXT NOT NULL"); + $pdo->exec("ALTER TABLE `groups` MODIFY `name` VARCHAR(255) NOT NULL"); + $pdo->exec("ALTER TABLE `project_activities` MODIFY `event_name` TEXT NOT NULL"); + $pdo->exec("ALTER TABLE `project_has_files` MODIFY `name` TEXT NOT NULL"); + $pdo->exec("ALTER TABLE `project_has_files` MODIFY `path` TEXT NOT NULL"); + $pdo->exec("ALTER TABLE `subtasks` MODIFY `title` TEXT NOT NULL"); + $pdo->exec("ALTER TABLE `swimlanes` MODIFY `name` VARCHAR(255) NOT NULL"); + $pdo->exec("ALTER TABLE `task_has_external_links` MODIFY `title` TEXT NOT NULL"); + $pdo->exec("ALTER TABLE `task_has_external_links` MODIFY `url` TEXT NOT NULL"); + $pdo->exec("ALTER TABLE `task_has_files` MODIFY `name` TEXT NOT NULL"); + $pdo->exec("ALTER TABLE `task_has_files` MODIFY `path` TEXT NOT NULL"); + $pdo->exec("ALTER TABLE `tasks` MODIFY `title` TEXT NOT NULL"); + $pdo->exec("ALTER TABLE `tasks` MODIFY `reference` VARCHAR(255) DEFAULT ''"); + $pdo->exec("ALTER TABLE `user_has_unread_notifications` MODIFY `event_name` TEXT NOT NULL"); + $pdo->exec("ALTER TABLE `users` MODIFY `username` VARCHAR(255) NOT NULL"); + $pdo->exec("ALTER TABLE `users` MODIFY `filter` TEXT"); +} function version_128(PDO $pdo) { diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php index 50ea4850..598ea115 100644 --- a/app/Schema/Postgres.php +++ b/app/Schema/Postgres.php @@ -8,7 +8,35 @@ use PDO; use Kanboard\Core\Security\Token; use Kanboard\Core\Security\Role; -const VERSION = 107; +const VERSION = 108; + +function version_108(PDO $pdo) +{ + $pdo->exec('ALTER TABLE "projects" ALTER COLUMN "name" TYPE TEXT'); + $pdo->exec('ALTER TABLE "projects" ALTER COLUMN "email" TYPE TEXT'); + $pdo->exec('ALTER TABLE "action_has_params" ALTER COLUMN "name" TYPE TEXT'); + $pdo->exec('ALTER TABLE "action_has_params" ALTER COLUMN "value" TYPE TEXT'); + $pdo->exec('ALTER TABLE "actions" ALTER COLUMN "event_name" TYPE TEXT'); + $pdo->exec('ALTER TABLE "actions" ALTER COLUMN "action_name" TYPE TEXT'); + $pdo->exec('ALTER TABLE "comments" ALTER COLUMN "reference" TYPE TEXT'); + $pdo->exec('ALTER TABLE "custom_filters" ALTER COLUMN "filter" TYPE TEXT'); + $pdo->exec('ALTER TABLE "custom_filters" ALTER COLUMN "name" TYPE TEXT'); + $pdo->exec('ALTER TABLE "groups" ALTER COLUMN "name" TYPE TEXT'); + $pdo->exec('ALTER TABLE "project_activities" ALTER COLUMN "event_name" TYPE TEXT'); + $pdo->exec('ALTER TABLE "project_has_files" ALTER COLUMN "name" TYPE TEXT'); + $pdo->exec('ALTER TABLE "project_has_files" ALTER COLUMN "path" TYPE TEXT'); + $pdo->exec('ALTER TABLE "subtasks" ALTER COLUMN "title" TYPE TEXT'); + $pdo->exec('ALTER TABLE "swimlanes" ALTER COLUMN "name" TYPE TEXT'); + $pdo->exec('ALTER TABLE "task_has_external_links" ALTER COLUMN "title" TYPE TEXT'); + $pdo->exec('ALTER TABLE "task_has_external_links" ALTER COLUMN "url" TYPE TEXT'); + $pdo->exec('ALTER TABLE "task_has_files" ALTER COLUMN "name" TYPE TEXT'); + $pdo->exec('ALTER TABLE "task_has_files" ALTER COLUMN "path" TYPE TEXT'); + $pdo->exec('ALTER TABLE "tasks" ALTER COLUMN "title" TYPE TEXT'); + $pdo->exec('ALTER TABLE "tasks" ALTER COLUMN "reference" TYPE TEXT'); + $pdo->exec('ALTER TABLE "user_has_unread_notifications" ALTER COLUMN "event_name" TYPE TEXT'); + $pdo->exec('ALTER TABLE "users" ALTER COLUMN "username" TYPE TEXT'); + $pdo->exec('ALTER TABLE "users" ALTER COLUMN "filter" TYPE TEXT'); +} function version_107(PDO $pdo) { diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql index 199fd797..3113b4e6 100644 --- a/app/Schema/Sql/mysql.sql +++ b/app/Schema/Sql/mysql.sql @@ -15,8 +15,8 @@ DROP TABLE IF EXISTS `action_has_params`; CREATE TABLE `action_has_params` ( `id` int(11) NOT NULL AUTO_INCREMENT, `action_id` int(11) NOT NULL, - `name` varchar(50) NOT NULL, - `value` varchar(50) NOT NULL, + `name` text NOT NULL, + `value` text NOT NULL, PRIMARY KEY (`id`), KEY `action_id` (`action_id`), CONSTRAINT `action_has_params_ibfk_1` FOREIGN KEY (`action_id`) REFERENCES `actions` (`id`) ON DELETE CASCADE @@ -28,8 +28,8 @@ DROP TABLE IF EXISTS `actions`; CREATE TABLE `actions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, - `event_name` varchar(50) NOT NULL, - `action_name` varchar(255) DEFAULT NULL, + `event_name` text NOT NULL, + `action_name` text NOT NULL, PRIMARY KEY (`id`), KEY `project_id` (`project_id`), CONSTRAINT `actions_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`id`) ON DELETE CASCADE @@ -100,7 +100,7 @@ CREATE TABLE `comments` ( `user_id` int(11) DEFAULT '0', `date_creation` bigint(20) DEFAULT NULL, `comment` text, - `reference` varchar(50) DEFAULT '', + `reference` varchar(255) DEFAULT '', `date_modification` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), @@ -123,10 +123,10 @@ DROP TABLE IF EXISTS `custom_filters`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `custom_filters` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `filter` varchar(100) NOT NULL, + `filter` text NOT NULL, `project_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, - `name` varchar(100) NOT NULL, + `name` text NOT NULL, `is_shared` tinyint(1) DEFAULT '0', `append` tinyint(1) DEFAULT '0', PRIMARY KEY (`id`), @@ -154,7 +154,7 @@ DROP TABLE IF EXISTS `groups`; CREATE TABLE `groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `external_id` varchar(255) DEFAULT '', - `name` varchar(100) NOT NULL, + `name` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -239,7 +239,7 @@ DROP TABLE IF EXISTS `project_activities`; CREATE TABLE `project_activities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `date_creation` bigint(20) DEFAULT NULL, - `event_name` varchar(50) NOT NULL, + `event_name` text NOT NULL, `creator_id` int(11) DEFAULT NULL, `project_id` int(11) DEFAULT NULL, `task_id` int(11) DEFAULT NULL, @@ -306,8 +306,8 @@ DROP TABLE IF EXISTS `project_has_files`; CREATE TABLE `project_has_files` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, - `name` varchar(255) NOT NULL, - `path` varchar(255) NOT NULL, + `name` text NOT NULL, + `path` text NOT NULL, `is_image` tinyint(1) DEFAULT '0', `size` int(11) NOT NULL DEFAULT '0', `user_id` int(11) NOT NULL DEFAULT '0', @@ -400,7 +400,7 @@ DROP TABLE IF EXISTS `projects`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `projects` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `name` varchar(255) NOT NULL, + `name` text NOT NULL, `is_active` tinyint(4) DEFAULT '1', `token` varchar(255) DEFAULT NULL, `last_modified` bigint(20) DEFAULT NULL, @@ -414,7 +414,7 @@ CREATE TABLE `projects` ( `priority_default` int(11) DEFAULT '0', `priority_start` int(11) DEFAULT '0', `priority_end` int(11) DEFAULT '3', - `email` varchar(255) DEFAULT NULL, + `email` text, `predefined_email_subjects` text, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -486,7 +486,7 @@ DROP TABLE IF EXISTS `subtasks`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `subtasks` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `title` varchar(255) NOT NULL, + `title` text NOT NULL, `status` int(11) DEFAULT '0', `time_estimated` float DEFAULT NULL, `time_spent` float DEFAULT NULL, @@ -503,7 +503,7 @@ DROP TABLE IF EXISTS `swimlanes`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `swimlanes` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `name` varchar(200) NOT NULL, + `name` varchar(255) NOT NULL, `position` int(11) DEFAULT '1', `is_active` int(11) DEFAULT '1', `project_id` int(11) DEFAULT NULL, @@ -532,8 +532,8 @@ CREATE TABLE `task_has_external_links` ( `id` int(11) NOT NULL AUTO_INCREMENT, `link_type` varchar(100) NOT NULL, `dependency` varchar(100) NOT NULL, - `title` varchar(255) NOT NULL, - `url` varchar(255) NOT NULL, + `title` text NOT NULL, + `url` text NOT NULL, `date_creation` int(11) NOT NULL, `date_modification` int(11) NOT NULL, `task_id` int(11) NOT NULL, @@ -548,8 +548,8 @@ DROP TABLE IF EXISTS `task_has_files`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `task_has_files` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `name` varchar(255) NOT NULL, - `path` varchar(255) DEFAULT NULL, + `name` text NOT NULL, + `path` text NOT NULL, `is_image` tinyint(1) DEFAULT '0', `task_id` int(11) NOT NULL, `date` bigint(20) DEFAULT NULL, @@ -607,7 +607,7 @@ DROP TABLE IF EXISTS `tasks`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tasks` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `title` varchar(255) NOT NULL, + `title` text NOT NULL, `description` text, `date_creation` bigint(20) DEFAULT NULL, `date_completed` bigint(20) DEFAULT NULL, @@ -622,7 +622,7 @@ CREATE TABLE `tasks` ( `category_id` int(11) DEFAULT '0', `creator_id` int(11) DEFAULT '0', `date_modification` int(11) DEFAULT '0', - `reference` varchar(50) DEFAULT '', + `reference` varchar(255) DEFAULT '', `date_started` bigint(20) DEFAULT NULL, `time_spent` float DEFAULT '0', `time_estimated` float DEFAULT '0', @@ -718,7 +718,7 @@ CREATE TABLE `user_has_unread_notifications` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL, `date_creation` bigint(20) NOT NULL, - `event_name` varchar(50) NOT NULL, + `event_name` text NOT NULL, `event_data` text NOT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), @@ -730,7 +730,7 @@ DROP TABLE IF EXISTS `users`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `username` varchar(50) NOT NULL, + `username` varchar(255) NOT NULL, `password` varchar(255) DEFAULT NULL, `is_ldap_user` tinyint(1) DEFAULT '0', `name` varchar(255) DEFAULT NULL, @@ -752,7 +752,7 @@ CREATE TABLE `users` ( `is_active` tinyint(1) DEFAULT '1', `avatar_path` varchar(255) DEFAULT NULL, `api_access_token` varchar(255) DEFAULT NULL, - `filter` varchar(255) DEFAULT NULL, + `filter` text, PRIMARY KEY (`id`), UNIQUE KEY `users_username_idx` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; @@ -776,7 +776,7 @@ CREATE TABLE `users` ( LOCK TABLES `settings` WRITE; /*!40000 ALTER TABLE `settings` DISABLE KEYS */; -INSERT INTO `settings` VALUES ('api_token','36e88ee4ad58bc71a7879d8cadac15142fdd25550f4910b8ec8c7525730c',0,0),('application_currency','USD',0,0),('application_date_format','m/d/Y',0,0),('application_language','en_US',0,0),('application_stylesheet','',0,0),('application_timezone','UTC',0,0),('application_url','',0,0),('board_columns','',0,0),('board_highlight_period','172800',0,0),('board_private_refresh_interval','10',0,0),('board_public_refresh_interval','60',0,0),('calendar_project_tasks','date_started',0,0),('calendar_user_subtasks_time_tracking','0',0,0),('calendar_user_tasks','date_started',0,0),('cfd_include_closed_tasks','1',0,0),('default_color','yellow',0,0),('integration_gravatar','0',0,0),('password_reset','1',0,0),('project_categories','',0,0),('subtask_restriction','0',0,0),('subtask_time_tracking','1',0,0),('webhook_token','99225408c1094eead14b25dbe9f7254ec233bd54aea02b8dff7e7d25ae50',0,0),('webhook_url','',0,0); +INSERT INTO `settings` VALUES ('api_token','5e51f5e81b816fe52594c692abc6ab51c53024048953e0a312d378ebda7e',0,0),('application_currency','USD',0,0),('application_date_format','m/d/Y',0,0),('application_language','en_US',0,0),('application_stylesheet','',0,0),('application_timezone','UTC',0,0),('application_url','',0,0),('board_columns','',0,0),('board_highlight_period','172800',0,0),('board_private_refresh_interval','10',0,0),('board_public_refresh_interval','60',0,0),('calendar_project_tasks','date_started',0,0),('calendar_user_subtasks_time_tracking','0',0,0),('calendar_user_tasks','date_started',0,0),('cfd_include_closed_tasks','1',0,0),('default_color','yellow',0,0),('integration_gravatar','0',0,0),('password_reset','1',0,0),('project_categories','',0,0),('subtask_restriction','0',0,0),('subtask_time_tracking','1',0,0),('webhook_token','5739f13ff6db190c5983328d7bed8aff703b7e78236890e9030888194121',0,0),('webhook_url','',0,0); /*!40000 ALTER TABLE `settings` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; @@ -805,4 +805,4 @@ UNLOCK TABLES; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$j/bvk6WblIHAyAJEBXLgBeoOjJ1oHsuA0VTUf85lRYOJ4czssCuI6', 'app-admin');INSERT INTO schema_version VALUES ('127'); +INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$eu5txjAlmBRZYmAcWjHAx.BSCIYL6RMTIyrIWG4eqWFtf62DCJPWy', 'app-admin');INSERT INTO schema_version VALUES ('129'); diff --git a/app/Schema/Sql/postgres.sql b/app/Schema/Sql/postgres.sql index e43248c3..5a2224fb 100644 --- a/app/Schema/Sql/postgres.sql +++ b/app/Schema/Sql/postgres.sql @@ -2,8 +2,8 @@ -- PostgreSQL database dump -- --- Dumped from database version 9.6.4 --- Dumped by pg_dump version 9.6.4 +-- Dumped from database version 9.6.3 +-- Dumped by pg_dump version 9.6.3 SET statement_timeout = 0; SET lock_timeout = 0; @@ -33,8 +33,8 @@ SET default_with_oids = false; CREATE TABLE "action_has_params" ( "id" integer NOT NULL, "action_id" integer NOT NULL, - "name" character varying(50) NOT NULL, - "value" character varying(50) NOT NULL + "name" "text" NOT NULL, + "value" "text" NOT NULL ); @@ -64,8 +64,8 @@ ALTER SEQUENCE "action_has_params_id_seq" OWNED BY "action_has_params"."id"; CREATE TABLE "actions" ( "id" integer NOT NULL, "project_id" integer NOT NULL, - "event_name" character varying(50) NOT NULL, - "action_name" character varying(255) NOT NULL + "event_name" "text" NOT NULL, + "action_name" "text" NOT NULL ); @@ -197,7 +197,7 @@ CREATE TABLE "comments" ( "user_id" integer DEFAULT 0, "date_creation" bigint NOT NULL, "comment" "text", - "reference" character varying(50) DEFAULT ''::character varying, + "reference" "text" DEFAULT ''::character varying, "date_modification" bigint ); @@ -237,10 +237,10 @@ CREATE TABLE "currencies" ( CREATE TABLE "custom_filters" ( "id" integer NOT NULL, - "filter" character varying(100) NOT NULL, + "filter" "text" NOT NULL, "project_id" integer NOT NULL, "user_id" integer NOT NULL, - "name" character varying(100) NOT NULL, + "name" "text" NOT NULL, "is_shared" boolean DEFAULT false, "append" boolean DEFAULT false ); @@ -282,7 +282,7 @@ CREATE TABLE "group_has_users" ( CREATE TABLE "groups" ( "id" integer NOT NULL, "external_id" character varying(255) DEFAULT ''::character varying, - "name" character varying(100) NOT NULL + "name" "text" NOT NULL ); @@ -442,7 +442,7 @@ ALTER SEQUENCE "predefined_task_descriptions_id_seq" OWNED BY "predefined_task_d CREATE TABLE "project_activities" ( "id" integer NOT NULL, "date_creation" bigint NOT NULL, - "event_name" character varying(50) NOT NULL, + "event_name" "text" NOT NULL, "creator_id" integer, "project_id" integer, "task_id" integer, @@ -572,8 +572,8 @@ ALTER SEQUENCE "project_has_categories_id_seq" OWNED BY "project_has_categories" CREATE TABLE "project_has_files" ( "id" integer NOT NULL, "project_id" integer NOT NULL, - "name" character varying(255) NOT NULL, - "path" character varying(255) NOT NULL, + "name" "text" NOT NULL, + "path" "text" NOT NULL, "is_image" boolean DEFAULT false, "size" integer DEFAULT 0 NOT NULL, "user_id" integer DEFAULT 0 NOT NULL, @@ -732,7 +732,7 @@ ALTER SEQUENCE "project_role_has_restrictions_restriction_id_seq" OWNED BY "proj CREATE TABLE "projects" ( "id" integer NOT NULL, - "name" character varying(255) NOT NULL, + "name" "text" NOT NULL, "is_active" boolean DEFAULT true, "token" character varying(255), "last_modified" bigint DEFAULT 0, @@ -746,7 +746,7 @@ CREATE TABLE "projects" ( "priority_default" integer DEFAULT 0, "priority_start" integer DEFAULT 0, "priority_end" integer DEFAULT 3, - "email" character varying(255), + "email" "text", "predefined_email_subjects" "text" ); @@ -876,7 +876,7 @@ ALTER SEQUENCE "subtask_time_tracking_id_seq" OWNED BY "subtask_time_tracking"." CREATE TABLE "subtasks" ( "id" integer NOT NULL, - "title" character varying(255) NOT NULL, + "title" "text" NOT NULL, "status" smallint DEFAULT 0, "time_estimated" double precision DEFAULT 0, "time_spent" double precision DEFAULT 0, @@ -892,7 +892,7 @@ CREATE TABLE "subtasks" ( CREATE TABLE "swimlanes" ( "id" integer NOT NULL, - "name" character varying(200) NOT NULL, + "name" "text" NOT NULL, "position" integer DEFAULT 1, "is_active" boolean DEFAULT true, "project_id" integer, @@ -957,8 +957,8 @@ CREATE TABLE "task_has_external_links" ( "id" integer NOT NULL, "link_type" character varying(100) NOT NULL, "dependency" character varying(100) NOT NULL, - "title" character varying(255) NOT NULL, - "url" character varying(255) NOT NULL, + "title" "text" NOT NULL, + "url" "text" NOT NULL, "date_creation" integer NOT NULL, "date_modification" integer NOT NULL, "task_id" integer NOT NULL, @@ -991,8 +991,8 @@ ALTER SEQUENCE "task_has_external_links_id_seq" OWNED BY "task_has_external_link CREATE TABLE "task_has_files" ( "id" integer NOT NULL, - "name" character varying(255) NOT NULL, - "path" character varying(255), + "name" "text" NOT NULL, + "path" "text", "is_image" boolean DEFAULT false, "task_id" integer NOT NULL, "date" bigint DEFAULT 0 NOT NULL, @@ -1099,7 +1099,7 @@ CREATE TABLE "task_has_tags" ( CREATE TABLE "tasks" ( "id" integer NOT NULL, - "title" character varying(255) NOT NULL, + "title" "text" NOT NULL, "description" "text", "date_creation" bigint, "color_id" character varying(255), @@ -1114,7 +1114,7 @@ CREATE TABLE "tasks" ( "category_id" integer DEFAULT 0, "creator_id" integer DEFAULT 0, "date_modification" integer DEFAULT 0, - "reference" character varying(50) DEFAULT ''::character varying, + "reference" "text" DEFAULT ''::character varying, "date_started" bigint, "time_spent" double precision DEFAULT 0, "time_estimated" double precision DEFAULT 0, @@ -1248,7 +1248,7 @@ CREATE TABLE "user_has_unread_notifications" ( "id" integer NOT NULL, "user_id" integer NOT NULL, "date_creation" bigint NOT NULL, - "event_name" character varying(50) NOT NULL, + "event_name" "text" NOT NULL, "event_data" "text" NOT NULL ); @@ -1278,7 +1278,7 @@ ALTER SEQUENCE "user_has_unread_notifications_id_seq" OWNED BY "user_has_unread_ CREATE TABLE "users" ( "id" integer NOT NULL, - "username" character varying(50) NOT NULL, + "username" "text" NOT NULL, "password" character varying(255), "is_ldap_user" boolean DEFAULT false, "name" character varying(255), @@ -1300,7 +1300,7 @@ CREATE TABLE "users" ( "is_active" boolean DEFAULT true, "avatar_path" character varying(255), "api_access_token" character varying(255) DEFAULT NULL::character varying, - "filter" character varying(255) DEFAULT NULL::character varying + "filter" "text" DEFAULT NULL::character varying ); @@ -2624,8 +2624,8 @@ ALTER TABLE ONLY "user_has_unread_notifications" -- PostgreSQL database dump -- --- Dumped from database version 9.6.4 --- Dumped by pg_dump version 9.6.4 +-- Dumped from database version 9.6.3 +-- Dumped by pg_dump version 9.6.3 SET statement_timeout = 0; SET lock_timeout = 0; @@ -2645,8 +2645,8 @@ INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_high INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_public_refresh_interval', '60', 0, 0); INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_private_refresh_interval', '10', 0, 0); INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('board_columns', '', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('webhook_token', '1ff45d3f47d1dc00a9bd51a335d2fe705714e4c4073d486c2c8e6e161c28', 0, 0); -INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('api_token', '261e6e871a415183978e3a25f65ddb63c93e680931bef4c6b1728ed1a07c', 0, 0); +INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('webhook_token', '60a9320b2835f6fa01f6ec445212e3eb6d919887a81a0414d9928d908315', 0, 0); +INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('api_token', '5713f6ffb5fdef788497bf45e43cedaeff565135f8ad3a5015ab338f5251', 0, 0); INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('application_language', 'en_US', 0, 0); INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('application_timezone', 'UTC', 0, 0); INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('application_url', '', 0, 0); @@ -2674,8 +2674,8 @@ INSERT INTO settings (option, value, changed_by, changed_on) VALUES ('password_r -- PostgreSQL database dump -- --- Dumped from database version 9.6.4 --- Dumped by pg_dump version 9.6.4 +-- Dumped from database version 9.6.3 +-- Dumped by pg_dump version 9.6.3 SET statement_timeout = 0; SET lock_timeout = 0; @@ -2715,4 +2715,4 @@ SELECT pg_catalog.setval('links_id_seq', 11, true); -- PostgreSQL database dump complete -- -INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$j/bvk6WblIHAyAJEBXLgBeoOjJ1oHsuA0VTUf85lRYOJ4czssCuI6', 'app-admin');INSERT INTO schema_version VALUES ('106'); +INSERT INTO users (username, password, role) VALUES ('admin', '$2y$10$eu5txjAlmBRZYmAcWjHAx.BSCIYL6RMTIyrIWG4eqWFtf62DCJPWy', 'app-admin');INSERT INTO schema_version VALUES ('108'); diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php index aced61e0..99731452 100644 --- a/app/Schema/Sqlite.php +++ b/app/Schema/Sqlite.php @@ -12,7 +12,7 @@ const VERSION = 118; function version_118(PDO $pdo) { - $pdo->exec('ALTER TABLE users ADD COLUMN filter VARCHAR(255) DEFAULT NULL'); + $pdo->exec('ALTER TABLE users ADD COLUMN filter TEXT'); } function version_117(PDO $pdo) diff --git a/app/Template/category/create.php b/app/Template/category/create.php index b32a770c..f065305a 100644 --- a/app/Template/category/create.php +++ b/app/Template/category/create.php @@ -5,7 +5,7 @@ <?= $this->form->csrf() ?> <?= $this->form->label(t('Category Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="50"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required')) ?> <?= $this->modal->submitButtons() ?> </form> diff --git a/app/Template/category/edit.php b/app/Template/category/edit.php index 9ad5a9e9..08231606 100644 --- a/app/Template/category/edit.php +++ b/app/Template/category/edit.php @@ -6,7 +6,7 @@ <?= $this->form->csrf() ?> <?= $this->form->label(t('Category Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="50"', 'tabindex="1"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="255"', 'tabindex="1"')) ?> <?= $this->form->label(t('Description'), 'description') ?> <?= $this->form->textEditor('description', $values, $errors, array('tabindex' => 2)) ?> diff --git a/app/Template/column/create.php b/app/Template/column/create.php index 2b0c4641..2ea88eea 100644 --- a/app/Template/column/create.php +++ b/app/Template/column/create.php @@ -5,7 +5,7 @@ <?= $this->form->csrf() ?> <?= $this->form->label(t('Title'), 'title') ?> - <?= $this->form->text('title', $values, $errors, array('autofocus', 'required', 'maxlength="50"', 'tabindex="1"')) ?> + <?= $this->form->text('title', $values, $errors, array('autofocus', 'required', 'maxlength="255"', 'tabindex="1"')) ?> <?= $this->form->label(t('Task limit'), 'task_limit') ?> <?= $this->form->number('task_limit', $values, $errors, array('tabindex="2"')) ?> diff --git a/app/Template/column/edit.php b/app/Template/column/edit.php index 25cf60c9..2025405f 100644 --- a/app/Template/column/edit.php +++ b/app/Template/column/edit.php @@ -6,7 +6,7 @@ <?= $this->form->csrf() ?> <?= $this->form->label(t('Title'), 'title') ?> - <?= $this->form->text('title', $values, $errors, array('autofocus', 'required', 'maxlength="50"')) ?> + <?= $this->form->text('title', $values, $errors, array('autofocus', 'required', 'maxlength="255"')) ?> <?= $this->form->label(t('Task limit'), 'task_limit') ?> <?= $this->form->number('task_limit', $values, $errors) ?> diff --git a/app/Template/custom_filter/create.php b/app/Template/custom_filter/create.php index 724cbc85..df400ad2 100644 --- a/app/Template/custom_filter/create.php +++ b/app/Template/custom_filter/create.php @@ -5,10 +5,10 @@ <?= $this->form->csrf() ?> <?= $this->form->label(t('Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="100"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required')) ?> <?= $this->form->label(t('Filter'), 'filter') ?> - <?= $this->form->text('filter', $values, $errors, array('required', 'maxlength="100"')) ?> + <?= $this->form->text('filter', $values, $errors, array('required')) ?> <?php if ($this->user->hasProjectAccess('ProjectEditController', 'show', $project['id'])): ?> <?= $this->form->checkbox('is_shared', t('Share with all project members'), 1) ?> diff --git a/app/Template/custom_filter/edit.php b/app/Template/custom_filter/edit.php index 786e0c91..4b0a25a2 100644 --- a/app/Template/custom_filter/edit.php +++ b/app/Template/custom_filter/edit.php @@ -8,10 +8,10 @@ <?= $this->form->hidden('user_id', $values) ?> <?= $this->form->label(t('Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="100"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required')) ?> <?= $this->form->label(t('Filter'), 'filter') ?> - <?= $this->form->text('filter', $values, $errors, array('required', 'maxlength="100"')) ?> + <?= $this->form->text('filter', $values, $errors, array('required')) ?> <?php if ($this->user->hasProjectAccess('ProjectEditController', 'show', $project['id'])): ?> <?= $this->form->checkbox('is_shared', t('Share with all project members'), 1, $values['is_shared'] == 1) ?> diff --git a/app/Template/group_creation/show.php b/app/Template/group_creation/show.php index 9f4f5608..0b26105b 100644 --- a/app/Template/group_creation/show.php +++ b/app/Template/group_creation/show.php @@ -5,7 +5,7 @@ <?= $this->form->csrf() ?> <?= $this->form->label(t('Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="100"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="255"')) ?> <?= $this->modal->submitButtons() ?> </form> diff --git a/app/Template/group_modification/show.php b/app/Template/group_modification/show.php index df4ed01e..c314a412 100644 --- a/app/Template/group_modification/show.php +++ b/app/Template/group_modification/show.php @@ -8,7 +8,7 @@ <?= $this->form->hidden('external_id', $values) ?> <?= $this->form->label(t('Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="100"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="255"')) ?> <?= $this->modal->submitButtons() ?> </form> diff --git a/app/Template/project_creation/create.php b/app/Template/project_creation/create.php index 3317a61e..73fd4d7b 100644 --- a/app/Template/project_creation/create.php +++ b/app/Template/project_creation/create.php @@ -8,7 +8,7 @@ <?= $this->form->hidden('is_private', $values) ?> <?= $this->form->label(t('Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="50"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required')) ?> <?php if (count($projects_list) > 1): ?> <?= $this->form->label(t('Create from another project'), 'src_project_id') ?> diff --git a/app/Template/project_edit/show.php b/app/Template/project_edit/show.php index 96531007..324b2e0a 100644 --- a/app/Template/project_edit/show.php +++ b/app/Template/project_edit/show.php @@ -14,10 +14,10 @@ <legend><?= t('General') ?></legend> <?= $this->form->label(t('Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('required', 'maxlength="50"', 'autofocus', 'tabindex="1"')) ?> + <?= $this->form->text('name', $values, $errors, array('required', 'autofocus', 'tabindex="1"')) ?> <?= $this->form->label(t('Email'), 'email') ?> - <?= $this->form->email('email', $values, $errors, array('maxlength="255"', 'tabindex="2"')) ?> + <?= $this->form->email('email', $values, $errors, array('tabindex="2"')) ?> <p class="form-help"><?= t('The project email is optional and could be used by several plugins.') ?></p> <?= $this->form->label(t('Identifier'), 'identifier') ?> diff --git a/app/Template/swimlane/create.php b/app/Template/swimlane/create.php index 5ff8cbee..02825547 100644 --- a/app/Template/swimlane/create.php +++ b/app/Template/swimlane/create.php @@ -5,7 +5,7 @@ <?= $this->form->csrf() ?> <?= $this->form->label(t('Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="50"', 'tabindex="1"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="255"', 'tabindex="1"')) ?> <?= $this->form->label(t('Description'), 'description') ?> <?= $this->form->textEditor('description', $values, $errors, array('tabindex' => 2)) ?> diff --git a/app/Template/swimlane/edit.php b/app/Template/swimlane/edit.php index b1d713ee..205dc95d 100644 --- a/app/Template/swimlane/edit.php +++ b/app/Template/swimlane/edit.php @@ -6,7 +6,7 @@ <?= $this->form->csrf() ?> <?= $this->form->label(t('Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="50"', 'tabindex="1"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="255"', 'tabindex="1"')) ?> <?= $this->form->label(t('Description'), 'description') ?> <?= $this->form->textEditor('description', $values, $errors, array('tabindex' => 2)) ?> diff --git a/app/Template/user_creation/show.php b/app/Template/user_creation/show.php index 007dd701..90301dbd 100644 --- a/app/Template/user_creation/show.php +++ b/app/Template/user_creation/show.php @@ -10,7 +10,7 @@ <legend><?= t('Profile') ?></legend> <?= $this->form->label(t('Username'), 'username') ?> - <?= $this->form->text('username', $values, $errors, array('autofocus', 'required', 'maxlength="50"')) ?> + <?= $this->form->text('username', $values, $errors, array('autofocus', 'required', 'maxlength="255"')) ?> <?= $this->form->label(t('Name'), 'name') ?> <?= $this->form->text('name', $values, $errors) ?> diff --git a/app/Template/user_invite/signup.php b/app/Template/user_invite/signup.php index 51edbab7..c5c50217 100644 --- a/app/Template/user_invite/signup.php +++ b/app/Template/user_invite/signup.php @@ -9,7 +9,7 @@ <legend><?= t('Profile') ?></legend> <?= $this->form->label(t('Username'), 'username') ?> - <?= $this->form->text('username', $values, $errors, array('autofocus', 'required', 'maxlength="50"')) ?> + <?= $this->form->text('username', $values, $errors, array('autofocus', 'required', 'maxlength="255"')) ?> <?= $this->form->label(t('Name'), 'name') ?> <?= $this->form->text('name', $values, $errors) ?> diff --git a/app/Template/user_modification/show.php b/app/Template/user_modification/show.php index 6244e255..2bca6675 100644 --- a/app/Template/user_modification/show.php +++ b/app/Template/user_modification/show.php @@ -8,7 +8,7 @@ <fieldset> <legend><?= t('Profile') ?></legend> <?= $this->form->label(t('Username'), 'username') ?> - <?= $this->form->text('username', $values, $errors, array('autofocus', 'required', isset($values['is_ldap_user']) && $values['is_ldap_user'] == 1 && !$this->user->isAdmin() ? 'readonly' : '', 'maxlength="50"')) ?> + <?= $this->form->text('username', $values, $errors, array('autofocus', 'required', isset($values['is_ldap_user']) && $values['is_ldap_user'] == 1 && !$this->user->isAdmin() ? 'readonly' : '', 'maxlength="255"')) ?> <?= $this->form->label(t('Name'), 'name') ?> <?= $this->form->text('name', $values, $errors, array($this->user->hasAccess('UserModificationController', 'show/edit_name') ? '' : 'readonly')) ?> diff --git a/app/Validator/AuthValidator.php b/app/Validator/AuthValidator.php index 9abe69f0..daa913c0 100644 --- a/app/Validator/AuthValidator.php +++ b/app/Validator/AuthValidator.php @@ -37,7 +37,7 @@ class AuthValidator extends BaseValidator { $v = new Validator($values, array( new Validators\Required('username', t('The username is required')), - new Validators\MaxLength('username', t('The maximum length is %d characters', 50), 50), + new Validators\MaxLength('username', t('The maximum length is %d characters', 255), 255), new Validators\Required('password', t('The password is required')), )); diff --git a/app/Validator/CategoryValidator.php b/app/Validator/CategoryValidator.php index fc42d2e5..f5c7e0f1 100644 --- a/app/Validator/CategoryValidator.php +++ b/app/Validator/CategoryValidator.php @@ -68,7 +68,7 @@ class CategoryValidator extends BaseValidator return array( new Validators\Integer('id', t('The id must be an integer')), new Validators\Integer('project_id', t('The project id must be an integer')), - new Validators\MaxLength('name', t('The maximum length is %d characters', 50), 50) + new Validators\MaxLength('name', t('The maximum length is %d characters', 255), 255) ); } } diff --git a/app/Validator/ColumnValidator.php b/app/Validator/ColumnValidator.php index 25aa45d0..bc6af7dd 100644 --- a/app/Validator/ColumnValidator.php +++ b/app/Validator/ColumnValidator.php @@ -69,7 +69,7 @@ class ColumnValidator extends BaseValidator new Validators\Integer('task_limit', t('This value must be an integer')), new Validators\GreaterThan('task_limit', t('This value must be greater than %d', -1), -1), new Validators\Required('title', t('The title is required')), - new Validators\MaxLength('title', t('The maximum length is %d characters', 50), 50), + new Validators\MaxLength('title', t('The maximum length is %d characters', 255), 255), ); } } diff --git a/app/Validator/CommentValidator.php b/app/Validator/CommentValidator.php index 9c883c00..c5149bad 100644 --- a/app/Validator/CommentValidator.php +++ b/app/Validator/CommentValidator.php @@ -91,7 +91,7 @@ class CommentValidator extends BaseValidator new Validators\Integer('id', t('This value must be an integer')), new Validators\Integer('task_id', t('This value must be an integer')), new Validators\Integer('user_id', t('This value must be an integer')), - new Validators\MaxLength('reference', t('The maximum length is %d characters', 50), 50), + new Validators\MaxLength('reference', t('The maximum length is %d characters', 255), 255), new Validators\Required('comment', t('Comment is required')) ); } diff --git a/app/Validator/CustomFilterValidator.php b/app/Validator/CustomFilterValidator.php index 1ab9303d..eb661970 100644 --- a/app/Validator/CustomFilterValidator.php +++ b/app/Validator/CustomFilterValidator.php @@ -28,8 +28,8 @@ class CustomFilterValidator extends BaseValidator new Validators\Required('filter', t('Field required')), new Validators\Integer('user_id', t('This value must be an integer')), new Validators\Integer('project_id', t('This value must be an integer')), - new Validators\MaxLength('name', t('The maximum length is %d characters', 100), 100), - new Validators\MaxLength('filter', t('The maximum length is %d characters', 100), 100) + new Validators\MaxLength('name', t('The maximum length is %d characters', 65535), 65535), + new Validators\MaxLength('filter', t('The maximum length is %d characters', 65535), 65535) ); } diff --git a/app/Validator/ExternalLinkValidator.php b/app/Validator/ExternalLinkValidator.php index 9c017708..638e9437 100644 --- a/app/Validator/ExternalLinkValidator.php +++ b/app/Validator/ExternalLinkValidator.php @@ -61,9 +61,9 @@ class ExternalLinkValidator extends BaseValidator { return array( new Validators\Required('url', t('Field required')), - new Validators\MaxLength('url', t('The maximum length is %d characters', 255), 255), + new Validators\MaxLength('url', t('The maximum length is %d characters', 65535), 65535), new Validators\Required('title', t('Field required')), - new Validators\MaxLength('title', t('The maximum length is %d characters', 255), 255), + new Validators\MaxLength('title', t('The maximum length is %d characters', 65535), 65535), new Validators\Required('link_type', t('Field required')), new Validators\MaxLength('link_type', t('The maximum length is %d characters', 100), 100), new Validators\Required('dependency', t('Field required')), diff --git a/app/Validator/GroupValidator.php b/app/Validator/GroupValidator.php index 8b21c697..66a20eb9 100644 --- a/app/Validator/GroupValidator.php +++ b/app/Validator/GroupValidator.php @@ -62,7 +62,7 @@ class GroupValidator extends BaseValidator { return array( new Validators\Required('name', t('The name is required')), - new Validators\MaxLength('name', t('The maximum length is %d characters', 100), 100), + new Validators\MaxLength('name', t('The maximum length is %d characters', 255), 255), new Validators\Unique('name', t('The name must be unique'), $this->db->getConnection(), GroupModel::TABLE, 'id'), new Validators\MaxLength('external_id', t('The maximum length is %d characters', 255), 255), new Validators\Integer('id', t('This value must be an integer')), diff --git a/app/Validator/PasswordResetValidator.php b/app/Validator/PasswordResetValidator.php index 0a2a3cd6..3c19affe 100644 --- a/app/Validator/PasswordResetValidator.php +++ b/app/Validator/PasswordResetValidator.php @@ -55,7 +55,7 @@ class PasswordResetValidator extends BaseValidator $v = new Validator($values, array( new Validators\Required('captcha', t('This value is required')), new Validators\Required('username', t('The username is required')), - new Validators\MaxLength('username', t('The maximum length is %d characters', 50), 50), + new Validators\MaxLength('username', t('The maximum length is %d characters', 255), 255), )); return array( diff --git a/app/Validator/ProjectValidator.php b/app/Validator/ProjectValidator.php index 2fc3c28e..d23f1232 100644 --- a/app/Validator/ProjectValidator.php +++ b/app/Validator/ProjectValidator.php @@ -28,7 +28,7 @@ class ProjectValidator extends BaseValidator new Validators\Integer('priority_start', t('This value must be an integer')), new Validators\Integer('priority_end', t('This value must be an integer')), new Validators\Integer('is_active', t('This value must be an integer')), - new Validators\MaxLength('name', t('The maximum length is %d characters', 50), 50), + new Validators\MaxLength('name', t('The maximum length is %d characters', 65535), 65535), new Validators\MaxLength('identifier', t('The maximum length is %d characters', 50), 50), new Validators\MaxLength('start_date', t('The maximum length is %d characters', 10), 10), new Validators\MaxLength('end_date', t('The maximum length is %d characters', 10), 10), diff --git a/app/Validator/SubtaskValidator.php b/app/Validator/SubtaskValidator.php index b80de41d..d3e814d8 100644 --- a/app/Validator/SubtaskValidator.php +++ b/app/Validator/SubtaskValidator.php @@ -91,7 +91,7 @@ class SubtaskValidator extends BaseValidator return array( new Validators\Integer('id', t('The subtask id must be an integer')), new Validators\Integer('task_id', t('The task id must be an integer')), - new Validators\MaxLength('title', t('The maximum length is %d characters', 255), 255), + new Validators\MaxLength('title', t('The maximum length is %d characters', 65535), 65535), new Validators\Integer('user_id', t('The user id must be an integer')), new Validators\Integer('status', t('The status must be an integer')), new Validators\Numeric('time_estimated', t('The time must be a numeric value')), diff --git a/app/Validator/SwimlaneValidator.php b/app/Validator/SwimlaneValidator.php index b0302d73..fb3d5f11 100644 --- a/app/Validator/SwimlaneValidator.php +++ b/app/Validator/SwimlaneValidator.php @@ -68,7 +68,7 @@ class SwimlaneValidator extends BaseValidator return array( new Validators\Integer('id', t('The id must be an integer')), new Validators\Integer('project_id', t('The project id must be an integer')), - new Validators\MaxLength('name', t('The maximum length is %d characters', 50), 50) + new Validators\MaxLength('name', t('The maximum length is %d characters', 255), 255) ); } } diff --git a/app/Validator/TaskValidator.php b/app/Validator/TaskValidator.php index 2bf148f4..7f905b2d 100644 --- a/app/Validator/TaskValidator.php +++ b/app/Validator/TaskValidator.php @@ -40,8 +40,8 @@ class TaskValidator extends BaseValidator new Validators\Integer('recurrence_trigger', t('This value must be an integer')), new Validators\Integer('recurrence_status', t('This value must be an integer')), new Validators\Integer('priority', t('This value must be an integer')), - new Validators\MaxLength('title', t('The maximum length is %d characters', 200), 200), - new Validators\MaxLength('reference', t('The maximum length is %d characters', 50), 50), + new Validators\MaxLength('title', t('The maximum length is %d characters', 65535), 65535), + new Validators\MaxLength('reference', t('The maximum length is %d characters', 255), 255), new Validators\Date('date_due', t('Invalid date'), $this->dateParser->getParserFormats()), new Validators\Date('date_started', t('Invalid date'), $this->dateParser->getParserFormats()), new Validators\Numeric('time_spent', t('This value must be numeric')), diff --git a/app/Validator/UserValidator.php b/app/Validator/UserValidator.php index 041390a3..d7c5a94d 100644 --- a/app/Validator/UserValidator.php +++ b/app/Validator/UserValidator.php @@ -24,7 +24,7 @@ class UserValidator extends BaseValidator { return array( new Validators\MaxLength('role', t('The maximum length is %d characters', 25), 25), - new Validators\MaxLength('username', t('The maximum length is %d characters', 50), 50), + new Validators\MaxLength('username', t('The maximum length is %d characters', 255), 255), new Validators\Unique('username', t('This username is already taken'), $this->db->getConnection(), UserModel::TABLE, 'id'), new Validators\Email('email', t('Email address invalid')), new Validators\Integer('is_ldap_user', t('This value must be an integer')), diff --git a/tests/units/Validator/CustomFilterValidatorTest.php b/tests/units/Validator/CustomFilterValidatorTest.php index 4e107f7f..b3c402c9 100644 --- a/tests/units/Validator/CustomFilterValidatorTest.php +++ b/tests/units/Validator/CustomFilterValidatorTest.php @@ -14,7 +14,7 @@ class CustomFilterValidatorTest extends Base $r = $customFilterValidator->validateCreation(array('filter' => 'test', 'name' => 'test', 'user_id' => 1, 'project_id' => 1, 'is_shared' => 0)); $this->assertTrue($r[0]); - $r = $customFilterValidator->validateCreation(array('filter' => str_repeat('a', 101), 'name' => 'test', 'user_id' => 1, 'project_id' => 1, 'is_shared' => 0)); + $r = $customFilterValidator->validateCreation(array('filter' => str_repeat('a', 65536), 'name' => 'test', 'user_id' => 1, 'project_id' => 1, 'is_shared' => 0)); $this->assertFalse($r[0]); $r = $customFilterValidator->validateCreation(array('name' => 'test', 'user_id' => 1, 'project_id' => 1, 'is_shared' => 0)); @@ -31,7 +31,7 @@ class CustomFilterValidatorTest extends Base $r = $validator->validateModification(array('filter' => 'test', 'name' => 'test', 'user_id' => 1, 'project_id' => 1, 'is_shared' => 0)); $this->assertFalse($r[0]); - $r = $validator->validateModification(array('id' => 1, 'filter' => str_repeat('a', 101), 'name' => 'test', 'user_id' => 1, 'project_id' => 1, 'is_shared' => 0)); + $r = $validator->validateModification(array('id' => 1, 'filter' => str_repeat('a', 65536), 'name' => 'test', 'user_id' => 1, 'project_id' => 1, 'is_shared' => 0)); $this->assertFalse($r[0]); $r = $validator->validateModification(array('id' => 1, 'name' => 'test', 'user_id' => 1, 'project_id' => 1, 'is_shared' => 0)); |