0001827: Inconsistent email adress lengths

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0001827

SiT!

other

public

2013-01-05 12:11

2016-04-01 18:23

Reporter

paulh

Assigned To

paulh

Priority

normal

Severity

minor

Reproducibility

always

Status

resolved

Resolution

fixed

Platform

OS Version

Product Version

Target Version

Fixed in Version

Current GIT

Summary

0001827: Inconsistent email adress lengths

Description

Email address lengths are inconsistent within SiT

Users can have upto 50chars
contacts can have 100
CC field on an incident can be 100 chars in the interface and 255 in the database
all fields on outbound email are 100
emailtemplates are limited to 100 in dbEmailTemplates

Email addresses can be upto 256 characters so I propose we standardise all of these as VARCHAR 255

I've been running into problems in the last few weeks with a couple of customers:

* One whos domain name (bit after @) was 31 chars
* Another one where the customer had alot of staff with long surnames

Tags

No tags attached.

Attached Files

Relationships

Notes
(0005001) paulh (administrator) 2016-04-01 18:23	ecf5ff3

Issue History
Date Modified	Username	Field	Change
2013-01-05 12:11	paulh	New Issue
2013-01-05 12:34	ivan	Status	new => confirmed
2016-04-01 18:23	paulh	Note Added: 0005001
2016-04-01 18:23	paulh	Assigned To	=> paulh
2016-04-01 18:23	paulh	Status	confirmed => resolved
2016-04-01 18:23	paulh	Resolution	open => fixed
2016-04-01 18:23	paulh	Fixed in Version	=> Current GIT