Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Batch enable comments for all articles
I’m sure there should be sql query that will do this :)
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
Re: Batch enable comments for all articles
- Select all comments in Content>Articles, “With selected: Change comments”
- Or with an SQL query:
update textpattern set Annotate=1;Offline
Re: Batch enable comments for all articles
Changing by list is not convinient because there are a looot of articles :)
sql query is the best solution
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
Re: Batch enable comments for all articles
Is it possible to change sql-query so, that it will affect only articles from section “article”?
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline
Re: Batch enable comments for all articles
At the bottom of the list of articles in TXP, there’s a multi-edit option. Doesn’t that allow enabling comments for all selected articles visible on the page? If the number of pages is limited, that’s not too much work.
Offline
Re: Batch enable comments for all articles
If there are hundreds of articles, listing them is not very convinient.
I tried this sql-query: update textpattern set Annotate=1 where Section='article';
It seems to be worked :)
Providing help in hacking ATM! Come to courses and don’t forget to bring us notebook and hammer! What for notebook? What a kind of hacker you are without notebok?
Offline