Mysql Help

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
ek5932
Forum Commoner
Posts: 25
Joined: Mon Jun 28, 2004 5:55 pm

Mysql Help

Post 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.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

looks like the name is being clipped before insertion..
ek5932
Forum Commoner
Posts: 25
Joined: Mon Jun 28, 2004 5:55 pm

Post by ek5932 »

nope, its the same in everything including phpmyadmin
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

post your table structure (in a [syntax=php]block please)[/syntax]
Post Reply