Mysql Help
Posted: Thu Aug 04, 2005 5:47 pm
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.
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.