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@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/ ]