[support] Text Format Missing After Site Upgrade Content Invisible

[Shai Gluskin]

Hi Swapnil,

Not sure I totally understand your situation, and proceed with caution
always having a backup of code and database.

In Drupal 6 the input format was set per node  at (table.field):
node_revisions.format

In Drupal 7, the input format is set per field. The format for the body
field is at (table.field) field_data_body.body_format

In D6, there was an integer associated with each input format (e.g. "3" was
"Full Html").

In D7, it is a string. Full HTML is "full_html". So, via SQL directly on
the database you could do something like:

UPDATE field_data_body SET body_format = 'full_html';


This is totally untested. This would change every instance of a body field
on the whole site. To limit the changes to specific nodes you would add a
"WHERE" clause at the end. Also remember that full_html has security
implications if users have editing privileges.

Also note that I'm not sure what the cause of your problem is and it's
always better to go to a fix when you understand the cause.

Good luck and report back,

Shai

On Wed, Jan 4, 2012 at 3:11 PM, Swapnil Bhartiya <swapnil.bhartiya at gmail.com
> wrote:

> Hi,
>
> We upgraded our site from D6 to d7. There is a major problem. The body
> of nodes is not visible in full node. What has happened is that 'Text
> Format field on each node is deselect and there is a drop down menu to
> select from plain or full. We have 1000s of node, we can't do it
> manually. Is there any way to force set the Text Format to Full Format?
>
> Thanks alot.
>
> Swapnil
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20120104/4f1e07a8/attachment-0001.html