diff options
27 files changed, 59 insertions, 39 deletions
diff --git a/.travis.yml b/.travis.yml index ef5162cc..07fb894c 100644 --- a/.travis.yml +++ b/.travis.yml @@ -16,6 +16,7 @@ php: env: - DB=sqlite - DB=postgres + - DB=mysql matrix: fast_finish: true diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php index c5144663..efeefd9c 100644 --- a/app/Schema/Mysql.php +++ b/app/Schema/Mysql.php @@ -22,9 +22,28 @@ You might need to run: REPAIR TABLE table_name; OPTIMIZE TABLE table_name; +The max length for Mysql 5.6 is 191 for varchar unique keys in utf8mb4 + */ function version_130(PDO $pdo) { + $pdo->exec("ALTER TABLE `swimlanes` MODIFY `name` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `users` MODIFY `username` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `groups` MODIFY `name` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `links` MODIFY `label` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `tags` MODIFY `name` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `sessions` MODIFY `id` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `project_role_has_restrictions` MODIFY `rule` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `project_has_roles` MODIFY `role` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `project_has_categories` MODIFY `name` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `invites` MODIFY `email` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `invites` MODIFY `token` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `groups` MODIFY `name` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `columns` MODIFY `title` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `column_has_restrictions` MODIFY `rule` VARCHAR(191) NOT NULL"); + $pdo->exec("ALTER TABLE `comments` MODIFY `reference` VARCHAR(191) DEFAULT ''"); + $pdo->exec("ALTER TABLE `tasks` MODIFY `reference` VARCHAR(191) DEFAULT ''"); + $tables = [ 'action_has_params', 'actions', diff --git a/app/Schema/Sql/mysql.sql b/app/Schema/Sql/mysql.sql index 7f46c872..fba959a9 100644 --- a/app/Schema/Sql/mysql.sql +++ b/app/Schema/Sql/mysql.sql @@ -64,7 +64,7 @@ CREATE TABLE `column_has_restrictions` ( `project_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, `column_id` int(11) NOT NULL, - `rule` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `rule` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`restriction_id`), UNIQUE KEY `role_id` (`role_id`,`column_id`,`rule`), KEY `project_id` (`project_id`), @@ -79,7 +79,7 @@ DROP TABLE IF EXISTS `columns`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `columns` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `position` int(11) NOT NULL, `project_id` int(11) NOT NULL, `task_limit` int(11) DEFAULT '0', @@ -100,7 +100,7 @@ CREATE TABLE `comments` ( `user_id` int(11) DEFAULT '0', `date_creation` bigint(20) DEFAULT NULL, `comment` mediumtext COLLATE utf8mb4_unicode_ci, - `reference` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', + `reference` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '', `date_modification` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `user_id` (`user_id`), @@ -154,7 +154,7 @@ DROP TABLE IF EXISTS `groups`; CREATE TABLE `groups` ( `id` int(11) NOT NULL AUTO_INCREMENT, `external_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '', - `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; @@ -163,9 +163,9 @@ DROP TABLE IF EXISTS `invites`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `invites` ( - `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, - `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`email`,`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; @@ -189,7 +189,7 @@ DROP TABLE IF EXISTS `links`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `links` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `label` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `opposite_id` int(11) DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `label` (`label`) @@ -291,7 +291,7 @@ DROP TABLE IF EXISTS `project_has_categories`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `project_has_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, `description` mediumtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`), @@ -360,7 +360,7 @@ DROP TABLE IF EXISTS `project_has_roles`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `project_has_roles` ( `role_id` int(11) NOT NULL AUTO_INCREMENT, - `role` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `role` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, PRIMARY KEY (`role_id`), UNIQUE KEY `project_id` (`project_id`,`role`), @@ -387,7 +387,7 @@ CREATE TABLE `project_role_has_restrictions` ( `restriction_id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `role_id` int(11) NOT NULL, - `rule` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `rule` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`restriction_id`), UNIQUE KEY `role_id` (`role_id`,`rule`), KEY `project_id` (`project_id`), @@ -447,7 +447,7 @@ DROP TABLE IF EXISTS `sessions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sessions` ( - `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `expire_at` int(11) NOT NULL, `data` longtext COLLATE utf8mb4_unicode_ci, PRIMARY KEY (`id`) @@ -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(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `position` int(11) DEFAULT '1', `is_active` int(11) DEFAULT '1', `project_id` int(11) DEFAULT NULL, @@ -519,7 +519,7 @@ DROP TABLE IF EXISTS `tags`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `tags` ( `id` int(11) NOT NULL AUTO_INCREMENT, - `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `project_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `project_id` (`project_id`,`name`) @@ -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(255) COLLATE utf8mb4_unicode_ci DEFAULT '', + `reference` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT '', `date_started` bigint(20) DEFAULT NULL, `time_spent` float DEFAULT '0', `time_estimated` float DEFAULT '0', @@ -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(255) COLLATE utf8mb4_unicode_ci NOT NULL, + `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL, `password` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_ldap_user` tinyint(1) DEFAULT '0', `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, diff --git a/app/Template/category/edit.php b/app/Template/category/edit.php index 08231606..cd8ee7ba 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="255"', 'tabindex="1"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="191"', '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 2ea88eea..034e948c 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="255"', 'tabindex="1"')) ?> + <?= $this->form->text('title', $values, $errors, array('autofocus', 'required', 'maxlength="191"', '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 2025405f..def0f299 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="255"')) ?> + <?= $this->form->text('title', $values, $errors, array('autofocus', 'required', 'maxlength="191"')) ?> <?= $this->form->label(t('Task limit'), 'task_limit') ?> <?= $this->form->number('task_limit', $values, $errors) ?> diff --git a/app/Template/group_creation/show.php b/app/Template/group_creation/show.php index 0b26105b..7cec0755 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="255"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="191"')) ?> <?= $this->modal->submitButtons() ?> </form> diff --git a/app/Template/group_modification/show.php b/app/Template/group_modification/show.php index c314a412..aa647775 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="255"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="191"')) ?> <?= $this->modal->submitButtons() ?> </form> diff --git a/app/Template/project_tag/create.php b/app/Template/project_tag/create.php index 6765e8fc..d665aa76 100644 --- a/app/Template/project_tag/create.php +++ b/app/Template/project_tag/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="255"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="191"')) ?> <?= $this->modal->submitButtons() ?> </form> diff --git a/app/Template/project_tag/edit.php b/app/Template/project_tag/edit.php index 29290c0c..39b08326 100644 --- a/app/Template/project_tag/edit.php +++ b/app/Template/project_tag/edit.php @@ -5,7 +5,7 @@ <?= $this->form->csrf() ?> <?= $this->form->label(t('Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="255"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="191"')) ?> <?= $this->modal->submitButtons() ?> </form> diff --git a/app/Template/swimlane/create.php b/app/Template/swimlane/create.php index 02825547..b769c6ce 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="255"', 'tabindex="1"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="191"', '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 205dc95d..f15a6dfb 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="255"', 'tabindex="1"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="191"', 'tabindex="1"')) ?> <?= $this->form->label(t('Description'), 'description') ?> <?= $this->form->textEditor('description', $values, $errors, array('tabindex' => 2)) ?> diff --git a/app/Template/tag/create.php b/app/Template/tag/create.php index 752a63e5..c376eb28 100644 --- a/app/Template/tag/create.php +++ b/app/Template/tag/create.php @@ -6,7 +6,7 @@ <?= $this->form->hidden('project_id', $values) ?> <?= $this->form->label(t('Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="255"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="191"')) ?> <?= $this->modal->submitButtons() ?> </form> diff --git a/app/Template/tag/edit.php b/app/Template/tag/edit.php index adef3568..a0e54843 100644 --- a/app/Template/tag/edit.php +++ b/app/Template/tag/edit.php @@ -7,7 +7,7 @@ <?= $this->form->hidden('project_id', $values) ?> <?= $this->form->label(t('Name'), 'name') ?> - <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="255"')) ?> + <?= $this->form->text('name', $values, $errors, array('autofocus', 'required', 'maxlength="191"')) ?> <?= $this->modal->submitButtons() ?> </form> diff --git a/app/Template/user_creation/show.php b/app/Template/user_creation/show.php index 90301dbd..d1bde192 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="255"')) ?> + <?= $this->form->text('username', $values, $errors, array('autofocus', 'required', 'maxlength="191"')) ?> <?= $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 c5c50217..88dee216 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="255"')) ?> + <?= $this->form->text('username', $values, $errors, array('autofocus', 'required', 'maxlength="191"')) ?> <?= $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 2bca6675..a21b9d33 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="255"')) ?> + <?= $this->form->text('username', $values, $errors, array('autofocus', 'required', isset($values['is_ldap_user']) && $values['is_ldap_user'] == 1 && !$this->user->isAdmin() ? 'readonly' : '', 'maxlength="191"')) ?> <?= $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 daa913c0..e50f90ce 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', 255), 255), + new Validators\MaxLength('username', t('The maximum length is %d characters', 191), 191), new Validators\Required('password', t('The password is required')), )); diff --git a/app/Validator/CategoryValidator.php b/app/Validator/CategoryValidator.php index f5c7e0f1..1d14891c 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', 255), 255) + new Validators\MaxLength('name', t('The maximum length is %d characters', 191), 191) ); } } diff --git a/app/Validator/ColumnValidator.php b/app/Validator/ColumnValidator.php index bc6af7dd..59d3ddf6 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', 255), 255), + new Validators\MaxLength('title', t('The maximum length is %d characters', 191), 191), ); } } diff --git a/app/Validator/CommentValidator.php b/app/Validator/CommentValidator.php index c5149bad..2051cbde 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', 255), 255), + new Validators\MaxLength('reference', t('The maximum length is %d characters', 191), 191), new Validators\Required('comment', t('Comment is required')) ); } diff --git a/app/Validator/GroupValidator.php b/app/Validator/GroupValidator.php index 66a20eb9..5b32ed2d 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', 255), 255), + new Validators\MaxLength('name', t('The maximum length is %d characters', 191), 191), 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 3c19affe..fb424e89 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', 255), 255), + new Validators\MaxLength('username', t('The maximum length is %d characters', 191), 191), )); return array( diff --git a/app/Validator/SwimlaneValidator.php b/app/Validator/SwimlaneValidator.php index fb3d5f11..0df433f2 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', 255), 255) + new Validators\MaxLength('name', t('The maximum length is %d characters', 191), 191) ); } } diff --git a/app/Validator/TagValidator.php b/app/Validator/TagValidator.php index 0567cf3e..dddd076d 100644 --- a/app/Validator/TagValidator.php +++ b/app/Validator/TagValidator.php @@ -70,7 +70,7 @@ class TagValidator extends BaseValidator return array( new Validators\Required('project_id', t('Field required')), new Validators\Required('name', t('Field required')), - new Validators\MaxLength('name', t('The maximum length is %d characters', 255), 255), + new Validators\MaxLength('name', t('The maximum length is %d characters', 191), 191), ); } } diff --git a/app/Validator/TaskValidator.php b/app/Validator/TaskValidator.php index 7f905b2d..33d80989 100644 --- a/app/Validator/TaskValidator.php +++ b/app/Validator/TaskValidator.php @@ -41,7 +41,7 @@ class TaskValidator extends BaseValidator 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', 65535), 65535), - new Validators\MaxLength('reference', t('The maximum length is %d characters', 255), 255), + new Validators\MaxLength('reference', t('The maximum length is %d characters', 191), 191), 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 d7c5a94d..a6f1dc7d 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', 255), 255), + new Validators\MaxLength('username', t('The maximum length is %d characters', 191), 191), 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')), |