login field length
I am not sure where to post this - so i'm posting it here in case it can actually be fixed promptly.
I was flabbergasted to realize today that the login field in X-Cart is limited to 32 characters. This is devastating. Many stores (in fact much of the internet) promotes the use of email addresses as logins.
The Intershop store that I am currently converting to X-Cart has 500 account logins longer than 32 characters.
The length of this field is way below current internet standards and with current database technology, makes no sense. There is no conceivable reason why this field shouldn't be much longer.
In my case, i am left with two really painful alternatives:
1. alter 8 tables in my xcart-pro database. this would virtually guarantee problems with every product update ever applied to this store in the future
2. alter the login code so it ignores login characters longer than 32 and allows login (with the logins truncated in the db). The downside here is that every subsequent customer interaction will show the truncated username (which would be very confusing to legacy customers).
__________________
4.0.18 Pro, unix
|