summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFrédéric Guillot <fred@kanboard.net>2018-04-11 12:03:38 -0700
committerFrédéric Guillot <fred@kanboard.net>2018-04-11 13:48:13 -0700
commitdd92564d221f35fc4fc7bb449c6d24cc4743247b (patch)
treefb1e46d904f0fbf1f33f1449ca24354003f5e809
parent8c5b9925c49bc1a989cdc5e146ce79543fdf7f0a (diff)
Increase text fields length in several tables
-rw-r--r--app/Helper/SubtaskHelper.php2
-rw-r--r--app/Helper/TaskHelper.php1
-rw-r--r--app/Import/TaskImport.php4
-rw-r--r--app/Import/UserImport.php2
-rw-r--r--app/Schema/Mysql.php30
-rw-r--r--app/Schema/Postgres.php30
-rw-r--r--app/Schema/Sql/mysql.sql52
-rw-r--r--app/Schema/Sql/postgres.sql66
-rw-r--r--app/Schema/Sqlite.php2
-rw-r--r--app/Template/category/create.php2
-rw-r--r--app/Template/category/edit.php2
-rw-r--r--app/Template/column/create.php2
-rw-r--r--app/Template/column/edit.php2
-rw-r--r--app/Template/custom_filter/create.php4
-rw-r--r--app/Template/custom_filter/edit.php4
-rw-r--r--app/Template/group_creation/show.php2
-rw-r--r--app/Template/group_modification/show.php2
-rw-r--r--app/Template/project_creation/create.php2
-rw-r--r--app/Template/project_edit/show.php4
-rw-r--r--app/Template/swimlane/create.php2
-rw-r--r--app/Template/swimlane/edit.php2
-rw-r--r--app/Template/user_creation/show.php2
-rw-r--r--app/Template/user_invite/signup.php2
-rw-r--r--app/Template/user_modification/show.php2
-rw-r--r--app/Validator/AuthValidator.php2
-rw-r--r--app/Validator/CategoryValidator.php2
-rw-r--r--app/Validator/ColumnValidator.php2
-rw-r--r--app/Validator/CommentValidator.php2
-rw-r--r--app/Validator/CustomFilterValidator.php4
-rw-r--r--app/Validator/ExternalLinkValidator.php4
-rw-r--r--app/Validator/GroupValidator.php2
-rw-r--r--app/Validator/PasswordResetValidator.php2
-rw-r--r--app/Validator/ProjectValidator.php2
-rw-r--r--app/Validator/SubtaskValidator.php2
-rw-r--r--app/Validator/SwimlaneValidator.php2
-rw-r--r--app/Validator/TaskValidator.php4
-rw-r--r--app/Validator/UserValidator.php2
-rw-r--r--tests/units/Validator/CustomFilterValidatorTest.php4
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));