Jump to content

Forums

Copying custom fields on personnel file may lead to loss of data!


J.Drake
 Share

Go to solution Solved by Jon Erickson,

Recommended Posts

We used copy to create a new field but instantly got a MySQL error stating that "Column 'personnel_field_x' already exists". Surprisingly the field was added though, so after seeing that error we deleted the field again and created a field from scratch. However because that copied field had a link to the column in perscom_personnel it deleted the original column. We had to partially restore the table from a backup to get back to where we were.

Perhaps some defensive programming is required on this section, I suspect adding custom application fields is going to cause the same issue.

Link to comment
Share on other sites

 Share

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.