error code EX167 

had this come up on my site affecting new registrations after some custom work

turns out resetting the  Auto_increment value of members table resolved this

error code didn't show on search here so posting this for reference

Exception 167 is duplicate entry for the primary key.