Posted on: 07/24/08 08:48pm
By: Anonymous (Austin)
I have a lot of stories posted in plaintext mode but include html formatting. I ran a query to change their format in html in the tables...but the html tags still aren't being parsed correctly. When I go to edit a story, it shows that html is the format...and, if I then click "save," it posts it correctly...but I'm looking for a solution that can auto-correct all of the stories. Is there a way to do this?
Thanks!
Re: Rehashing Stories
Posted on: 07/24/08 09:28pm
By: Anonymous (Austin)
In case anyone is interested, I found a solution to this. On insert/update, the story is formatted for html or plaintext...so, to convert between the two using SQL, you have to run a search and replace. An example query:
UPDATE gl_stories SET introtext = replace(introtext,"<br>","<br>"
where sid > '20080719161001241'
Re: Rehashing Stories
Posted on: 07/25/08 02:20pm
By: Dirk
HTML mode is actually escaping a few more things, but I guess it would work for most simple stories.
How did you manage to post a lot of stories in the wrong mode?
bye, Dirk