Unable to load requested field type file: ft.ftype_id_2.php

Edit Subject

Hi,

Go into your database and take a look at your exp_channel_fields table. Any fields that have a field_type of "ftype_id_X" need to be converted to EE2 counterparts.

Let me know what the original Field Type's were set to, and I can help you with the conversion.

Hi Brandon,

Thanks for getting back with me on this. Here is the list of fields in the exp_channel_fields

field_name field_type
summary textarea
body textarea
extended textarea
proc_photo text
proc_summary text
proclamation textarea
big_photo text
mission_statement textarea
leader_photo text
history textarea
sub_head textarea
caption text
state_text textarea
state_video textarea
state_photo text
state_proclamation text
organization text
location_time textarea
event_description textarea
tools textarea
age_limit text
news_url text
additional_info textarea
flyer text
link-1 text
link-2 text
event_photo text
contact_person text
contact_email text
intro-text textarea

None of these appear to be field_type_id. Please let me know if you need any other information. And thank you again for your prompt feedback.

Forrest

Hmm, that’s odd. Does the error give you a filename and line number where it’s occurring?

No it does not. I have tried to track it down and there is nothing I can see that relates to it. You can take a look here: http://dayofservice.org/

P.S. As a result of this error - four websites are down and have been down since yesterday morning. I would really appreciate your help in a timely resolution. Thanks.

Hi Brandon, one other note. I don't always get notified when a response is posted to these cases. Fortunately I came back and checked to see if you had responded again. Not sure why the notifications don't come through.

Hi Brandon,

Good news. I went into the database and did a search for ftype and found one row that had a reference to ftype_id_2. I removed the row and the site is working correctly.

Please close this case. Thanks.

Sweet! Do you remember which table & column you found it in?

Okay, so I'm having a similar problem. But I'm not sure that I want to just delete all the rows that have this syntax going on.

I have several rows with ftype_id_1 and ftype_id_2.

Oh and I found them in the exp_channel_fields, in the field_type column (not field_type_id).

No, you definitely don't want to delete them. You just want to update their field_type column to the name of the fieldtype you want to set them to.

Right. So the question is, what is the mapping of fieldtype's to ftype_id_1 and ftype_id_2...

Those are references to the fieldtype_id column in exp_ff_fieldtypes. So check that table.

So I did some comparison with the field types on my old site, and it appears that 'ftype_id_1' should be 'file' and 'ftype_id_2' should be matrix.

Now I don't think this makes the fields functionally equivalent, but at least it stops the loading errors.

If it was an nGen File field, you should take a look at this thread: http://expressionengine.com/forums/vi...