Forum management
- Threads started by me
- Threads I participate in

Developer forum

Autogeneration of ID on EcomProductField

Chris Søgaard

Posted on 22/03/2021 13:46:11

How is autogeneration of IDs on tables (e.g. EcomProductField) controlled, when creating the field in backend?

We have some cases after export/import of test/prod databases where these generations are out of sync causing a duplicate error when trying to create a new item in the backend. I cannot see that it is handled by SQL.

And are there anyway to actively reset/assign the next number that will be chosen when creating these items in backend?

Replies

Chris Søgaard

Posted on 22/03/2021 13:54:15

Found the answer myself by digging ínto it.

It seems to be controlled by EcomNumbers table, but we get this error anyway after importing the entire database from one environment to another, meaning that the numbers table should have been imported as well. Unless there's another logic behind this, it seems our issues are caused somewhere in the development instead.

You must be logged in to post in the forum