Developer forum

Forum » Dynamicweb 10 » Error: New order field already exists

Error: New order field already exists

Joakim
Reply

Hi,

I'm running a project on DW 10.19.11.
I was unable to create the field in the standard UI and recieved error msg "Field with system name already exists". 
I was however able to create the field via firehouse, but now I cannot see the field in the UI, dropping the table is shows the created field however.

Any idea as to why I cannot see the field?

Thanks in advance

dw.png

Replies

 
Morten Snedker Dynamicweb Employee
Morten Snedker
Reply

Hi Joakim,

When you create a new OrderField via UI it also gets its definition as a row in table EcomOrderField. If something goes wrong, and the actual column is not created in the EcomOrders table, there's a mismatch.

So, if you use Firehose to drop the column, make sure the same column is also removed as a row in table EcomOrderField.

You will find a similar concept for

  • EcomOrderlines EcomOrderlineField
  • EcomProducts / EcomProductField

Hope this helps.

BR
Snedker

 

You must be logged in to post in the forum