By charly71 on

I've imported (with Node Import module) more than 1000 nodes in my Drupal site but I've forbidden to switch to "Full HTML" input filter before. Now I would like to update my new nodes to show in body texts tags like span and br.

How can I do this? Should I manually change some DB table field or there is some automatic/tool/module?

Thanks in advance.

⋅ Categories: Drupal 5.x

Comments

tm’s picture

tm commented

http://drupal.org/project/retease - have not tried it myself, yet. i do have a use case, but am waiting for the content managers to finish before trying this.

charly71’s picture

charly71 commented

Can I use SQL? Which table may I update? Which field?

charly71’s picture

charly71 commented

I found the solution by myself.

I've used this query:

UPDATE node_revisions SET format={here your input format ID} WHERE nid IN (SELECT nid FROM {here your table name of content type})
summit’s picture

summit commented

Hi,
After trying this solution I am only half way there.
I need to press submit on every node, before the database changes take effect.
Is this also in your case the situation?
Thanks for posting.
Greetings,
Martijn

gpk’s picture

gpk commented

You also need to clear the {cache_filter} table.

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

ghmercado’s picture

ghmercado commented

had sorta the same issue. needed to change only blog nodes to full html input format. Asked around at drupal-support irc and got this:

update node_revisions left join node on node.nid = node_revisions.nid set node_revisions.format = 2 where node.type = 'blog';

where 2 = input format 'full html'

worked!

brenda003’s picture

brenda003
she/her
commented

Take a look at http://drupal.org/project/formats_updater