Jump to content


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


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


  • 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.