need help ASAP! big problem

[thefreebielife]

http://www.thefreebielife.com/

when my users try to join, they get this message

"Could not insert data because Duplicate entry '127' for key 1"

we're at user 127, he was the last registered

the funny part is that everyone who joins gets the welcome message, but cannot log in

please help, i need this fixed quick

[laserlight]

hmm... what is your relevant database schema?

[thefreebielife]

im pretty new with php but if you mean what happens when they sign up, they get a user id and refer friends under them.

please email me at (e-mail removed by mod), i really need your help

[bradgrafelman]

Laserlight is asking you to show us the structure of your table. If you can't explain it, log in to your SQL server and run a command such as EXPLAIN tableName; and paste the output.

Also, can you show us the query that inserts their new user details into the database?