Re: Getting error when trying to edit a user account from workbench
We have had problems occasionally with sequences not being set properly after a database is reloaded with content from another database. The sequence for the knta_users table is knta_users_s. Compare its value to the largest value of user_id in the knta_users table.
Did you stop the production instance before dumping the database contents? If not, you could get inconsistent content in tables and sequences.