UBB.Developers Forums UBB.threads 6 Bug Reports Username column width inconsistencies

[6.0.1]

The w3t_Posts.B_ParentUser and w3t_PollData.P_IP columns have maximum widths of 20 and 25 characters, respectively. All the other username fields apparently have a maximum width of 30 characters.

Why is this?

I know that the stock input form limits usernames to 16 characters, but I'm importing from UBB.classic, which allows 25-character login names and 35-character public names. I can truncate them if required, but I need to know what the limits are. The more truncation I have to do, the more complicated it will be, since I'll have to contact users individually to let them know their usernames have changed.

Here's a related post concerning this issue.

Edit:

I found some other username columns with widths other than 30:

w3t_Subscribe.S_Username - varchar(60)
w3t_Posts.B_LastEditBy - varchar(64)
w3t_Boards.Bo_Poster - varchar(64)

These will all need to be changed when I do the next release with an altertable. You can change these as you see fit to a consistent size for now by ALTERing the columns.

[6.0.2]

Here's a list of all the columns which may contain usernames, along with their current maximum widths (if I've omitted any, please add them):

30 w3t_AddressBook.Add_Owner
30 w3t_AddressBook.Add_Member
60 w3t_Banned.B_Username
65535 w3t_Boards.Bo_Moderators (comma-separated list of usernames)
64 w3t_Boards.Bo_Poster
250 w3t_Favorites.F_Owner
30 w3t_Last.L_Username
30 w3t_Messages.M_Sender
30 w3t_Messages.M_Username
30 w3t_Moderators.Mod_Username
30 w3t_Online.O_Username
25 w3t_PollData.P_IP (username or IP address)
200 w3t_PollData.P_Name (timestamp concatenated with username)
200 w3t_Polls.P_Name (timestamp concatenated with username)
64 w3t_Posts.B_LastEditBy
20 w3t_Posts.B_ParentUser
30 w3t_Posts.B_Username
100 w3t_Ratings.R_Rater
100 w3t_Ratings.R_What (username or post number)
60 w3t_Subscribe.S_Username
30 w3t_Users.U_Username

After these are made more consistent, what will the minimum column width be for usernames? I.e., what is the maximum safe length for a username that will fit into all the columns?

*bump*

I'd go with 64 on everything just to be safe. This should allow for any modifications in the future if we decide to allow longer usernames than what is currently supported.

Just to make sure I understand, in the next version, the altertable script will set all the above columns to be at least 64 characters wide?

Do you plan on keeping the current limit of 16 characters in adduser.php?

(I'm just trying to decide how much truncation, if any, to do on imported UBB.classic usernames.)

The width will be set to 64 chararacters in the next version for all username fields (except for the ones that are a combination of username/timestamp which will need to be 75).

The 16 character limit on usernames will remain and I'll eventually get this into a config option.

Thanks