Thread

Hello

When I try to add custom fields (of any type) to any of our weblogs, I get the following error:

Error Number: 1054

Unknown column 'field_settings' in 'field list'

INSERT INTO `exp_channel_fields` (`site_id`, `group_id`, `field_name`, `field_label`, `field_instructions`, `field_type`, `field_list_items`, `field_pre_populate`, `field_pre_channel_id`, `field_pre_field_id`, `field_related_id`, `field_related_orderby`, `field_related_sort`, `field_related_max`, `field_ta_rows`, `field_maxl`, `field_required`, `field_text_direction`, `field_search`, `field_is_hidden`, `field_fmt`, `field_show_fmt`, `field_order`, `field_content_type`, `field_settings`) VALUES ('1', '6', 'testfilefield', 'Test File Field', 'Testing', 'file', '', 0, 0, 0, '0', 0, 0, 0, '6', '128', 'n', 'ltr', 'n', 'n', 'xhtml', 'n', '10', 'any', 'YTo2OntzOjE4OiJmaWVsZF9zaG93X3NtaWxleXMiO3M6MToibiI7czoxOToiZmllbGRfc2hvd19nbG9zc2FyeSI7czoxOiJuIjtzOjIxOiJmaWVsZF9zaG93X3NwZWxsY2hlY2siO3M6MToibiI7czoyNjoiZmllbGRfc2hvd19mb3JtYXR0aW5nX2J0bnMiO3M6MToibiI7czoyNDoiZmllbGRfc2hvd19maWxlX3NlbGVjdG9yIjtzOjE6Im4iO3M6MjA6ImZpZWxkX3Nob3dfd3JpdGVtb2RlIjtzOjE6Im4iO30=')

Filename: controllers/cp/admin_content.php

Line Number: 4403

We are running v2.1.3 Build: 20110411 but we still had this issue prior to the version we are on now.

I should also note only 3 custom field types appear in the dropdown menu when trying to create a new field. These are File, Text Input and Textarea. There’s no sign of Checkboxes, Radio buttons, etc etc.

We also tried redeveloping the site from scratch but when importing content from the database we got the same error.

Any help would be greatly appreciated.

Uncommon Knowledge.

Hi Uncommon Knowledge. ,

Do you have any custom add-ons installed?
What were you running prior to your upgrade to EE2.1.3?

Can you head to EE’s SQL Manager and then open up the Database Query Form

Add the following and take a screenshot of the result and attach it to a reply here please

DESCRIBE exp_channel_fields

Hi John

I can’t say for sure which version we were running before but it was one of the public betas / first releases for EE2 back in 2010(?).

I have 2 custom extensions installed called ‘Edit This’ and ‘Fetch Current URI’

The ‘only 3 field types can be chosen’ in the custom field list can be ignored. I simply haven’t installed the other custom fieldtypes yet.

Lastly, I ran the query you asked for and here is the screenshot: http://i.imgur.com/dxJrV.png

Thanks for your response!

Edit: After updating an entry I am now getting this error and the site won’t load (but I can still get into the CP). Does this have anything to do with the above or is it a separate issue:

Error Number: 1054

Unknown column 'field_settings' in 'field list'

SELECT `field_id`, `field_type`, `field_name`, `site_id`, `field_settings` FROM (`exp_channel_fields`)

Filename: libraries/api/Api_channel_fields.php

Line Number: 134

Uncommon Knowledge,

Can I get you to disable your extensions temporarily. Follow the guide I linked to and see if that makes a difference