Hi Swapnil,<div><br></div><div>Not sure I totally understand your situation, and proceed with caution always having a backup of code and database.</div><div><br></div><div>In Drupal 6 the input format was set per node at (table.field): node_revisions.format</div>
<div><br></div><div>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</div><div><br></div><div>In D6, there was an integer associated with each input format (e.g. "3" was "Full Html"). </div>
<div><br></div><div>In D7, it is a string. Full HTML is "full_html". So, via SQL directly on the database you could do something like:</div><div><br></div><blockquote style="margin:0 0 0 40px;border:none;padding:0px">
<div><font face="'courier new', monospace">UPDATE field_data_body SET body_format = 'full_html';</font></div></blockquote><div><br></div><div>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. </div>
<div><br></div><div>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.</div><div><br></div><div>Good luck and report back,</div><div>
<br></div><div>Shai<br><br><div class="gmail_quote">On Wed, Jan 4, 2012 at 3:11 PM, Swapnil Bhartiya <span dir="ltr"><<a href="mailto:swapnil.bhartiya@gmail.com">swapnil.bhartiya@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Hi,<br>
<br>
We upgraded our site from D6 to d7. There is a major problem. The body<br>
of nodes is not visible in full node. What has happened is that 'Text<br>
Format field on each node is deselect and there is a drop down menu to<br>
select from plain or full. We have 1000s of node, we can't do it<br>
manually. Is there any way to force set the Text Format to Full Format?<br>
<br>
Thanks alot.<br>
<span class="HOEnZb"><font color="#888888"><br>
Swapnil<br>
--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br>
</font></span></blockquote></div><br></div>