0008017: Increase the size of the username field

(0014736)
vboctor (administrator)
2007-06-09 13:09

The size of the field in the database also needs to be changed. If we are going to increase the field size, then we should increase it to the maximum size of an email address as per RFC or the maximum size allowed for a db varchar field. So, I would suggest 250.

(0014826)
libregeek (reporter)
2007-06-27 08:04

RFC 2821 (http://tools.ietf.org/html/rfc2821 [^]) specifies that the local part of the email address can ne upto 64 characters and the domain part upto 255 characters. Combining these two will make up 319characters which may not be necessary in the near future.
So I would also suggest to use the maximum allowed size of a database VARCHAR field. I think that the maximum allowed sixe(in MySQL) is 255, am I right?

(0020586)
libregeek (reporter)
2009-01-12 04:51

I have created a patch for increasing the size of username field in mantis-1.1.6. Please verify and commit if it makes sense. This patch will increase the size of the username field to 255 characters.

(0020594)
siebrand (developer)
2009-01-12 18:06

Please update patch to be based on trunk.

(0020598)
libregeek (reporter)
2009-01-13 01:34

I'm confused on how to get the source code from the git repository. It seems the documentation in http://www.mantisbt.org/development.php [^] doesn't have enough information about git. Please help.

(0020599)
siebrand (developer)
2009-01-13 01:53

Yeah, I was a bit confused, too. Still learning GIT and I have access to the master repo, so didn't know about the public repo. See http://www.mantisforge.org/development [^] for details.

(0020600)
libregeek (reporter)
2009-01-13 02:31

Here is a quick patch from trunk. I'm a beginner in GIT, please guide me if something have gone wrong.

(0030152)
ubuone (reporter)
2011-11-03 05:59

Hi, to increase the username max size on an existing installation of mantis, you just have to increase the username database field to 255 (for example) and to create a custom_constants_inc.php file with :
<?php define( 'DB_FIELD_SIZE_USERNAME', 255);
The rest is cosmetic (html input size).
Am I right ?

(0031037)
anabuki (reporter)
2012-01-25 17:44

I am running Mantis version 1.2.8, and, as far as I have been able to perceive, the changes on the files described here are not required anymore. The files have already been updated to use a constant.

To change the size of the login field, you just need to edit the column "username" in the table "bugtracker.mantis_user_table" to the required size and then, change the constant "DB_FIELD_SIZE_USERNAME" in the file "core/constant_inc.php".

In my case, I changed the column to varchar(64) and changed the constant size to 64. And now I can create longer usernames. =)

Ps.: Just adding this comment, so that people may know how to change the username size in the new versions of Mantis.

(0031060)
vboctor (administrator)
2012-01-27 12:39

The change to the schema file is incorrect. What you should do is add a step to the end of the schema that change the size of the username field. This way, the upgrade path works as well, and not just the new installs. In other words, the schema file should create the username with the old size, then make it larger at the end.

I would also suggest that you try using github.com to fork the code, apply your change, and then submit a pull request. This will make the process as efficient as possible.

(0031126)
grangeway (developer)
2012-02-05 07:31

fixed in next branch

(0031165)
libregeek (reporter)
2012-02-06 00:02

@grangeway
Could you please post the changeset id?

(0031467)
atrol (developer)
2012-03-14 18:26

Reopened, there is no "Fixed in Version" and we will have no "Roadmap" and
"Changelog". There is no patch / changeset attached which will confuse any user
who has a look at this issue.

(0031685)
ubuone (reporter)
2012-04-18 10:46

In mantisbt 1.2.9 the size of the column "username" is 255.
But the max length of the field in the html form is limited to 32 char.
This lentgh can be modified with the constant "DB_FIELD_SIZE_USERNAME" in the file "core/constant_inc.php".
Is it possible to define this size in a user file like custom_constants_inc.php ?

(0031686)
atrol (developer)
2012-04-18 10:57

ubuone wrote
> In mantisbt 1.2.9 the size of the column "username" is 255.

This is not true, it's still 32.

(0031699)
ubuone (reporter)
2012-04-20 16:38

Sorry, my mistake !

Notes
(0014736) vboctor (administrator) 2007-06-09 13:09	The size of the field in the database also needs to be changed. If we are going to increase the field size, then we should increase it to the maximum size of an email address as per RFC or the maximum size allowed for a db varchar field. So, I would suggest 250.

(0014826) libregeek (reporter) 2007-06-27 08:04	RFC 2821 (http://tools.ietf.org/html/rfc2821 [^]) specifies that the local part of the email address can ne upto 64 characters and the domain part upto 255 characters. Combining these two will make up 319characters which may not be necessary in the near future. So I would also suggest to use the maximum allowed size of a database VARCHAR field. I think that the maximum allowed sixe(in MySQL) is 255, am I right?

(0020586) libregeek (reporter) 2009-01-12 04:51	I have created a patch for increasing the size of username field in mantis-1.1.6. Please verify and commit if it makes sense. This patch will increase the size of the username field to 255 characters.

(0020594) siebrand (developer) 2009-01-12 18:06	Please update patch to be based on trunk.

(0020598) libregeek (reporter) 2009-01-13 01:34	I'm confused on how to get the source code from the git repository. It seems the documentation in http://www.mantisbt.org/development.php [^] doesn't have enough information about git. Please help.

(0020599) siebrand (developer) 2009-01-13 01:53	Yeah, I was a bit confused, too. Still learning GIT and I have access to the master repo, so didn't know about the public repo. See http://www.mantisforge.org/development [^] for details.

(0020600) libregeek (reporter) 2009-01-13 02:31	Here is a quick patch from trunk. I'm a beginner in GIT, please guide me if something have gone wrong.

(0030152) ubuone (reporter) 2011-11-03 05:59	Hi, to increase the username max size on an existing installation of mantis, you just have to increase the username database field to 255 (for example) and to create a custom_constants_inc.php file with : <?php define( 'DB_FIELD_SIZE_USERNAME', 255); The rest is cosmetic (html input size). Am I right ?

(0031037) anabuki (reporter) 2012-01-25 17:44	I am running Mantis version 1.2.8, and, as far as I have been able to perceive, the changes on the files described here are not required anymore. The files have already been updated to use a constant. To change the size of the login field, you just need to edit the column "username" in the table "bugtracker.mantis_user_table" to the required size and then, change the constant "DB_FIELD_SIZE_USERNAME" in the file "core/constant_inc.php". In my case, I changed the column to varchar(64) and changed the constant size to 64. And now I can create longer usernames. =) Ps.: Just adding this comment, so that people may know how to change the username size in the new versions of Mantis.

(0031060) vboctor (administrator) 2012-01-27 12:39	The change to the schema file is incorrect. What you should do is add a step to the end of the schema that change the size of the username field. This way, the upgrade path works as well, and not just the new installs. In other words, the schema file should create the username with the old size, then make it larger at the end. I would also suggest that you try using github.com to fork the code, apply your change, and then submit a pull request. This will make the process as efficient as possible.

(0031126) grangeway (developer) 2012-02-05 07:31	fixed in next branch

(0031165) libregeek (reporter) 2012-02-06 00:02	@grangeway Could you please post the changeset id?

(0031467) atrol (developer) 2012-03-14 18:26	Reopened, there is no "Fixed in Version" and we will have no "Roadmap" and "Changelog". There is no patch / changeset attached which will confuse any user who has a look at this issue.

(0031685) ubuone (reporter) 2012-04-18 10:46	In mantisbt 1.2.9 the size of the column "username" is 255. But the max length of the field in the html form is limited to 32 char. This lentgh can be modified with the constant "DB_FIELD_SIZE_USERNAME" in the file "core/constant_inc.php". Is it possible to define this size in a user file like custom_constants_inc.php ?

(0031686) atrol (developer) 2012-04-18 10:57	ubuone wrote > In mantisbt 1.2.9 the size of the column "username" is 255. This is not true, it's still 32.

(0031699) ubuone (reporter) 2012-04-20 16:38	Sorry, my mistake !

Issue History
Date Modified	Username	Field	Change
2007-05-25 03:55	libregeek	New Issue
2007-06-09 13:09	vboctor	Note Added: 0014736
2007-06-09 13:09	vboctor	Status	new => confirmed
2007-06-27 08:04	libregeek	Note Added: 0014826
2009-01-12 04:51	libregeek	Note Added: 0020586
2009-01-12 04:52	libregeek	File Added: username_field-1.1.6.patch
2009-01-12 18:06	siebrand	Note Added: 0020594
2009-01-12 18:06	siebrand	Status	confirmed => feedback
2009-01-12 18:39	siebrand	Tag Attached: patch
2009-01-13 01:34	libregeek	Note Added: 0020598
2009-01-13 01:53	siebrand	Note Added: 0020599
2009-01-13 02:31	libregeek	Note Added: 0020600
2009-01-13 02:32	libregeek	File Added: username-trunk.patch
2011-11-02 14:01	atrol	Relationship added	has duplicate 0013478
2011-11-03 05:59	ubuone	Note Added: 0030152
2012-01-25 17:44	anabuki	Note Added: 0031037
2012-01-27 12:39	vboctor	Note Added: 0031060
2012-02-05 07:31	grangeway	Note Added: 0031126
2012-02-05 07:31	grangeway	Status	feedback => resolved
2012-02-05 07:31	grangeway	Resolution	open => fixed
2012-02-05 07:31	grangeway	Assigned To	=> grangeway
2012-02-06 00:02	libregeek	Note Added: 0031165
2012-02-20 07:18	atrol	Status	resolved => closed
2012-03-14 18:26	atrol	Note Added: 0031467
2012-03-14 18:26	atrol	Status	closed => feedback
2012-03-14 18:26	atrol	Resolution	fixed => reopened
2012-04-18 10:46	ubuone	Note Added: 0031685
2012-04-18 10:57	atrol	Note Added: 0031686
2012-04-20 16:38	ubuone	Note Added: 0031699
2012-10-12 18:40	atrol	Relationship added	has duplicate 0008596