Front End User - add new users throws Duplicate entry '55' for key 1

[DonnaNJ]

I have a few hundred users in my front end user member area.

We are t rying to add a new user and keep getting this error

Duplicate entry '55' for key 1

I looked at the table in phpMyAdmin and found the id numbers in reverse order so the last entry is 40 ... so user id 55 is used (in fact numbers 1 to 335 are used) ... where is is getting this number and why isn't it picking up the last one.

thanks

DonnaNJ

[Jeff]

The numbers usually come from the *_seq table.

[Dr.CSS]

What ver. of cmsms, FEU and any other info that may pertain to this like recent site updates or upgrades, more info more likely someone can duplicate it and give an answer...

[vfreriks]

Not meaning to kick this unnessecarily but I had the same issue a while ago after an extensive import. I changed the _seq number to the next highest available ID in the users table to get this working, like Jeff said.