I’m getting this error on the admin webpage while trying to add a new user…
com.sybase.jdbc2.jdbc.SybSQLException: ASA Error -193: Primary key for table ‘servoy_users’ is not unique ASA Error -193: Primary key for table ‘servoy_users’ is not unique
I had this happen when we did our upgrade to Servoy 3.
The primary key in the users table is an auto-increment. Somehow, users have been added to the users table without the sequence for the primary key being updated. So, when you add a new user, the newly assigned ID, is already in use by another user.
You can either manually set the next auto incremented value, or just keep trying to add a user over and over, and eventually the key will increment to the appropriate value.