Salutation doctype issue

#1

After upgrade of v8 to v9 getting this error when trying to open the employee list

image

I have a good list of salutations

image
image421Ɨ566 10.2 KB

DocType Mr Mrs Ms Not Found after accessing to Employee
#2

Did you try ā€œbench migrateā€ ?

#3

Yes, this is on a brand new upgrade. I just tried again and get same error.

#4

@James_Robertson,

On which doctype you were getting the error? The issue seems to be with Property Setter.
Please check the Customize Form and check if salutation field options is Salutation or not.

#5

hi all
Thanks you every for your queries and solutions.

#6

I think that is the problem, this is what the field looks like in customize form

image

The upgrade did not clear the option values from the old select value to work as a link.

I try to change the value to Salutation for the link, but get this error

image

#7

Any other thoughts here? I have confirmed that Salutation is a valid DocType (or at least I think it is), but for some reason I canā€™t update the form to allow me to change the options to the DocType.

#8

Do you have access to the database? If so, try changing it there.

#9

Hi ,

We are experiencing exactly the same issue in an ERPNext cloud account! This needs urgent fixing as the Employee list has been inaccessible for about a week now

Thanks

#10

Can you try cut options from options field after that change type to select and re paste options.

#11

Hi @SOLOSOFT

Thanks for your suggestion but that doesnā€™t work. Any changes to the options results in the same error reported by @James_Robertson above

Kind regards,

#12

Since there is a script preventing the changes on the ā€œCustomize Formā€ doctype, would it not be possible to write a custom script to update what you needed?

Havenā€™t tried it myself. I think conceptually, it should work.

Good Luck.

#13

@James_Robertson We had this issue as well, where Employee doctype had Mr/Mrs etc as options for Salutation field.
We deleted the row from ā€˜tabProperty Setterā€™ table, after that bench update was successful.

P.S. I think upto V7, Salutation was a select field, so if database has old data, this error occurs.

Regards,
Sunny.

#14

@schilgod - Thanks for the tip! I knew the issue would be in the database somewhere, but wasnā€™t sure where to look. I was looking in tabDocType and tabDocField last night.

For those following along, this is what I did to resolve

bench backup
bench mysql
DELETE FROM `tabProperty Setter` WHERE name='Employee-salutation-options';
exit
bench migrate

Now I can get to the employee list and when I look at the customize form area the option is set correctly.

This is a workaround of course and does not solve the underlying issue with bench update where we have a scenario where an existing field is changed from a option field to a link field with a new child doctype. I opened a git for this.

https://github.com/frappe/erpnext/issues/11263

2 Likes
#15

Great :+1:

#16

Emā€¦
Iā€™m on the latest and my Salutation Doctype is not of type ā€˜Linkā€™

Screenshot from 2017-10-24 14-27-34
Screenshot from 2017-10-24 14-27-341147Ɨ557 31.1 KB

#17

For the actual Salutation DocType that is right. Where it is used, such as from the Employee DocType it is supposed to be a link.

#18

Oh ok. Now if only I could find where the change took placeā€¦:thinking: Seems like there should have been a patch to remove the Options but there wasnā€™t/

#19

Yes. That is what I am alluding to in the git issue I opened for this. Maybe add a patch script to look for salutation options in the table like what I nuked to work around the issue. Since they run before the bench migrate at the end, the process work work fine. Just some thoughts.

#20

those were the steps i followed to solve the issueā€¦ thanks to James_Robertson