By drgonzo121 on

hello,

We want to be able to use the full editor (only twenty people who add content). We do not need filters. But we have imported a lot of faulty html code from the old site and that now needs to be cleaned inside the database...

Any suggestions?

a lot of thanks and a happy new year!

Comments

drgonzo121’s picture

drgonzo121 commented

So i mean, remove it from the database itself...

thanks.

drgonzo121’s picture

drgonzo121 commented

Hello,

Why is nobody answering please?

:-)

vm’s picture

vm commented

Without writing a mysql query (if that is even possible for every tag in use) or doing it by hand there is no way to handle this issue as far as I can see.

drgonzo121’s picture

drgonzo121 commented

Thanks, so i should use the filters instead?

vm’s picture

vm commented

filters won't remove the data (HTML tags you don't want) from the database. filters are used to choose what to display and what not to display based on whatever the filter does and it's settings.

may want to look at http://drupal.org/project/scanner

drgonzo121’s picture

drgonzo121 commented

thanks, am working on it right now

WorldFallz’s picture

WorldFallz commented

Another option might be to save all the nodes at least once with http://drupal.org/project/safehtml enabled-- it's the only filter I know of that actually modifies what gets stored in the db. It's geared more toward safety, but also addresses validity.