Edit Body field content gone

By AndrzejG on 14 Jun 2012 at 19:08 UTC

I know I am not first with this issue, however, nobody earlier got support in this issue, AFAIK.

I have Drupal 7.14 site with all contributed modules actual.

The content of the field Body are empty in edit form, despite they are visible when nodes are displayed. This is for basic pages and all custom content types, for nodes created until May 30th. Newer nodes are OK.

The date may be important as recently I updated some contributed modules.

Comments

=-=

VM commented 14 June 2012 at 19:16

The date may be important as recently I updated some contributed modules.

which modules?

I too have this exact issue.

bshaf commented 14 June 2012 at 22:37

I too have this exact issue. D7.14 just upgraded from 6.26. Body field shows on page but is empty on edit.

Same problem. Custom content

thajaphio commented 20 June 2012 at 22:22

Same problem.

Custom content type with images (unlimited, with title enabled) & body field.
When i create a new node the edit body field shows up fine.
When editing the node the body field is gone.

When viewing the node body text shows.

Installed modules:

ctools
pathauto
token
views

=-=

VM commented 20 June 2012 at 22:41

check the manage display tab, are you sure the field is set properly?

Yep,

thajaphio commented 21 June 2012 at 14:28

manage display is fine. And field i showing up fine when viewing the node.
It is when editing the node that the body field is gone (the form element is missing).

It only happens when editing nodes, not when creating new ones.

I havent had that much time to look into it yet, but i will try using devel to see if it's only visual.

solved

thajaphio commented 27 June 2012 at 13:15

It was one of my own javascripts that messed it up. Everything works fine now.

Second input

AndrzejG commented 22 June 2012 at 19:10

I checked that after pasting content into this empty field for the second time and save, it doesn't disappear.
So, the first "save" seems not to work properly.

Multilingual?

AndrzejG commented 27 June 2012 at 12:43

I have fresh installation, entirely the same except without these huge complex infrastructures for Multilingual options. It is working OK, without error under discussion.

Same problem

dshields commented 24 July 2012 at 18:33

I'm experiencing the very same issue.

The content is there, but when i go to /edit or click on the edit tab, there is no content in the body field (this only happens for nodes created before a certain date)

Has anyone found a solution for this yet?

Same problem again

Garmisch commented 22 August 2012 at 13:27

I am having the same problem as described above in a drupal 7.15 installation. Some of the content types I can edit and in some others nothing shows up. I am not using Organic Groups (seems to cause in some cases this problem).
I've tried to uninstall Content Access without any success.

Someone has a bright idea where to look for?

CKEditor was broken in my site

Patricia_W commented 15 December 2012 at 19:53

This happened recently, I have a multi-site configuration and several of my sites broke at the same time. I could not edit a page because the body field was blank. (Actually the text appeared briefly in the body field and then the field disappeared although the area it had occupied was still there.)

Eventually I decided to see whether CKEditor was responsible. I tried to disable and then re-enable it ... that did nothing. Eventually, I uninstalled it completely and reinstalled (configured again too.) Now, everything is back to normal. No idea why this would have affected this other than I had recently installed the newest version of the CKEditor module ( 7.11). (I also have the CKEditor code in the Libraries folder so this may have been involved.)

Patricia W

Same problem, Drupal 7.17

xeniak commented 21 December 2012 at 23:25

For me it's nodes imported with Feeds that have this problem. Also, if I type anything in the seemingly blank body edit field and save, what I enter overrides the existing body text.

EDIT:
In my case, it turned out that one of my custom modules was causing the body field to be imported with language 'und'. Once I changed it to 'en', the body text re-appeared in the edit form.

SQL Query

teslina commented 28 June 2013 at 12:36

I've had also the same problem with nodes imported by Feeds. Here's a quick sql query you can run in order to fix this problem. Simply change 'en' / 'de' to the language codes you are using on your site:

For english nodes:

UPDATE  `drupal_field_data_body`
SET `language` = 'en'
WHERE `language` LIKE 'und'
AND `entity_id` IN (SELECT `nid` FROM `drupal_node` WHERE `language` LIKE 'en');

German nodes:

UPDATE  `drupal_field_data_body`
SET `language` = 'de'
WHERE `language` LIKE 'und'
AND `entity_id` IN (SELECT `nid` FROM `drupal_node` WHERE `language` LIKE 'de')

After you've executed the queries, you need to FLUSH the cache - and the body will be displayed again in edit mode.

The same problem may also occur for other fields (images and other custom fields). Those you also need to update manually:

UPDATE  `drupal_field_data_field_blog_image`
SET `language` = 'de'
WHERE `language` LIKE 'und'
AND `entity_id` IN (SELECT `nid` FROM `drupal_node` WHERE `language` LIKE 'de');

UPDATE  `drupal_field_data_field_blog_image`
SET `language` = 'en'
WHERE `language` LIKE 'und'
AND `entity_id` IN (SELECT `nid` FROM `drupal_node` WHERE `language` LIKE 'en');

Thank you

Sakhmed commented 18 January 2015 at 17:33

Thank you! This worked for me!

This also worked for me

Eric At NRD commented 19 January 2016 at 19:45

Thank you @teslina!

If your Drupal installation does not have table prefixes, you will not need the leading "drupal_" in your table names. For example, on the site I ran into this on, the queries looked like:

UPDATE  `field_data_body`
SET `language` = 'en'
WHERE `language` LIKE 'und'
AND `entity_id` IN (SELECT `nid` FROM `node` WHERE `language` LIKE 'en');

Thanks - fixed

web226 commented 7 November 2016 at 21:52

Your solution worked for me. The error occurred after i installed the Automatic Entity Labels module. Thanks!

This work for me too. All

tarasiadis commented 9 February 2019 at 12:34

This work for me too. All content have to set lang.

Same Probelm

Sirisha commented 31 October 2014 at 11:23

Hi,

Content in body field empty when i edit the node, but it is visible when node is displayed. My website is a multi-language site, we are managing 8 languages. We are also using ckeditor and i have done install and reinstall. still no use. when i print the array, it is showing 'und' array for some body fields, for some of them it is showing that particular language array. For example, if it is English, it is showing 'en' array, instead of 'und'. But for any of the page in my website, it is not showing the content when i edit the body. Can someone please help me to sort out this issue asap.

Thanks,

I had the same issue. It

kikecastillo commented 3 December 2015 at 15:42

I had the same issue. It happened exactly during the installation of Answers module and it seems totally related with Wysiwyg module. I solved setting language to 'fr' instead of 'und' for all my field_data_body elements. As I used only French on my site, it was easy but it can be done for other all the existing languages taking them from node table. It is important to do it before there is duplicated languages and after doing it, it is important to clean the Drupal cache.

Good luck!

Body field is/is not translatable setting in field_config table

petednz commented 30 June 2016 at 06:24

Turned out that the issue that caused our Body field both in View and Edit mode to suddently show as blank was language related.

Body field had been set to translatable (before we inherited the site), but there was only 'en' as a language.

We then pulled in a feature that updated the body field (field_config table) so translatable was set to 0

GAH - took ages to figure. There is nowhere in the ui that showed that the field had been set to translatable on the old live site.

Hope it gives someone else some clues

peter davis : fuzion : connect.campaign.communicate : www.fuzion.co.nz

Worked for me

rtackett commented 1 March 2017 at 18:12

The previous sql update statements did not work for me since I had several revisions for each node and the imported nodes had language='und' or 'en'. When I ran the sql statements, I received an integrity constraint error.

Using /u/petednz fix resolved the issue of the body field being blank on edit.

db_update('field_config')
    ->fields(array('translatable' => 0))
    ->condition('field_name', 'body')
    ->condition('translatable', 1)
    ->execute();