When I upgraded Dongyiyong 2006 to SW6.8 today, I found that the front-end member center prompted an error Provider (0x80020005) type mismatch when publishing an article. I looked at the line of the error code prompted. The code was about custom fields. I found that the code did not The problem indicates that it is a database problem, because the database was not directly upgraded. I only compared a few tables and did not pay attention to the others.
After careful inspection, I feel that PE_Field and PE_Article are suspicious. Only these two tables contain custom fields. Searching online, this error is because the inserted data type matches the data table field type, so it has nothing to do with PE_Field, because PE_Field only defines the relevant parameters of the custom field and does not involve the custom fields of the article. That must be a problem with PE_Article. Because the custom field I added is of date type. The ones in PE_Article are also of date type, so why don’t they match?
So I re-added a date-type custom field, and then went to the data table to see what type it was. I found that the newly added field was actually a text type. No wonder! Change the original two to text type and successfully solve it! A small problem troubled me for 4 hours... The foundation is very important~