Find non textiled articles

colak · Yesterday 15:41:50

Over 20 years ago, when I started using txp textile was slightly rough around the edges and it did not work as expected. This meant that sometimes I would post articles with “leave text untouched” or “convert to line breaks.”

20 years & 1,984 posts later, and all is working as it was designed for. I took advantage of the Easter holidays and did some updates to our site but I cannot think of a build in way to check all articles that do not go through the textile parser. Is there a way?

jakob · Yesterday 16:18:10

I don’t know of a built-in way, but you can check in the database by looking at the textpattern table and sorting via the textile_body (if necessary, the textile_excerpt) column. The values are:

0 = leave text untouched
1 = textile
2 = convert line breaks

Maybe that would help if you just want to identify them.

colak · Yesterday 16:51:57

jakob wrote #339583:

I don’t know of a built-in way, but you can check in the database by looking at the textpattern table and sorting via the textile_body (if necessary, the textile_excerpt) column. The values are:

0 = leave text untouched
1 = textile
2 = convert line breaks

Maybe that would help if you just want to identify them.

Yep, It’s the way Im doing it now. Checking everything through phpMyAdmin. It feels that it will take forerver. Is there a MySQL way that I can use in Database Manager to ask it to return just the ids of articles that have the value 2 in the textile_body?

Bloke · Yesterday 17:01:03

SELECT ID FROM textpattern WHERE textile_body = 2

That should do the trick.

colak · Today 01:55:59

Bloke wrote #339585:

SELECT ID FROM textpattern WHERE textile_body = 2

That should do the trick.

That’s exactly what I was looking for. Thanks so much Stef.

Textpattern CMS

Textpattern CMS support forum

#1 Yesterday 15:41:50