Copied internal user tables over, now primary key constraint failling when adding new user

[jeffrey.boey]

Hi guys, bit of a curious problem.

I've copied the following tables over during a migration, everything worked out, roles where preserved, users could log in etc.

However, when I want to create a new user, I'm getting this error:

After some digging, I realized the ID is not an autoincrement field, although I think it should be

Any idea where is ignition getting the user ID from? Is there some table that I'm missing? or does the AI need to be reset?

Thanks!!

[pturmel]

Look at and update the correct row in the SEQUENCES table. Ignition doesn't use the autoincrement column type, probably because the SQLite docs suggest to not.

[jeffrey.boey]

Thanks! I missed that, didn't know SQLite don't recommend autoincrements, learned something new!