Page 1 of 1

Mysql Help

Posted: Thu Aug 04, 2005 5:47 pm
by ek5932
Hi, i currently have a problem with my mysql DB. in my username field it is using some sort of unqie block to stop duplicate entries. It's not total duplicate entries its any entries which contain the same first 3 letters. Some one used the name redshowspf and i can't enter another entry begining with "red". A user tried to signup using the name Redger and the entry would not work. I displayed the mysql error which is:

Duplicate entry 'red' for key 2

I am using MySQL 4.0.24

the properties for the username field are:

username varchar(50) not null

any clue to what my problem is? P.s. i cant change the value in phpmyadmin either.

Posted: Thu Aug 04, 2005 6:02 pm
by feyd
looks like the name is being clipped before insertion..

Posted: Thu Aug 04, 2005 6:26 pm
by ek5932
nope, its the same in everything including phpmyadmin

Posted: Thu Aug 04, 2005 7:28 pm
by feyd
post your table structure (in a [syntax=php]block please)[/syntax]