Is there a quick way to turn all comments into answers?

Question

There is a plugin for it but it does it individually.

Answer 1

The distinction between comment and answer is merely the value of the field type in the database table qa_posts. To convert all comments to answers do this:

UPDATE qa_posts SET type='A' WHERE type='C';

To convert just the comments for a particular question do this (replace 42 with the actual post ID of the question at hand):

UPDATE qa_posts SET type='A' WHERE parentid=42 AND type='C';

---

Edit: For converting comments on answers you can use a slightly modified version of the query for converting comments on questions that I posted in the comments. Change the post type from "Q" to "A" and also change the parent ID of the comment to the parent ID of the answer (i.e. the ID of its grandparent, which is the question).

UPDATE qa_posts c INNER JOIN qa_posts p ON c.parentid = p.postid SET c.type = 'A', c.parentid = p.parentid WHERE c.type = 'C' AND p.type = 'A';

If you want to convert comments for a particular post add a clause for the parent post ID:

... AND p.type = 'A' AND p.postid = 42;

Comments

Modifying the database directly might bring some issues. For example: wrong points for users, wrong cache information or answers will appear and plugins will not be notified about that (might be relevant or not).

The first 2 issues can be dodged by recalculating points and recounting posts. The last one would require a completely different and longer approach

---

I think there will also some issues by querying the first SQL command.In fact, it coverts all comments to answers (even comments of answers too). So you have to convert just those comments what are belonged to a question (A post with type=Q).
So actually, it will not work as wished..

---

It might cause issues, yes. But since we don't know more about the OPs situation and requirements this is all I can suggest.

---

@fazleysabbir O ye of little faith ... UPDATE qa_posts c INNER JOIN qa_posts q ON c.parentid = q.postid SET c.type = 'A' WHERE c.type = 'C' AND q.type = 'Q';

---

Oh..That's great!You killed it with only SQL.I thought we have to use php..

---

Thank you for the answers.

---

But the comments below the answers are a bigger problem for me

---

You can take care of those with a minor change to the query from my previous comment. See updated answer.

---

UPDATE qa_posts c INNER JOIN qa_posts p ON c.parentid = p.postid SET c.type = 'A' WHERE c.type = 'C' AND p.type = 'A';

must be -- p.type = 'Q';

---

@sonsuz That would convert the comments on *questions* to answers. You said you needed to convert the comments on *answers* to answers.

---

I said is not same

@fazleysabbir O ye of little faith ... UPDATE qa_posts c INNER JOIN qa_posts q ON c.parentid = q.postid SET c.type = 'A' WHERE c.type = 'C' AND q.type = 'Q';

UPDATE qa_posts c INNER JOIN qa_posts p ON c.parentid = p.postid SET c.type = 'A' WHERE c.type = 'C' AND p.type = 'A';

---

do they both work?

---

Of course they're not the same. Did you not read what I wrote in my answer? type='Q' is for CONVERTING COMMENTS ON QUESTIONS. type='A' is for CONVERTING COMMENTS ON ANSWERS.

If you want to convert comments on answers rather than questions YOU MUST USE THE LATTER INSTEAD OF THE FORMER.

---

should that be?

UPDATE qa_posts c INNER JOIN qa_posts p ON c.parentid = p.postid SET c.type = 'A', c.parentid=p.parentid WHERE c.type = 'C' AND p.type = 'A';

---

Ah, now I understand the problem. Yes, you're right, you need to update the parent ID of the comment to the parent ID of the answer (i.e. the question ID). Updated my answer.

---

Yes, did work.. 20.000 comment is now answer, just add
AND length(c.content)>100

Answer 2

https://github.com/q2apro/q2apro-comment-to-answer/blob/master/q2apro-comment-to-answer-page.php

It's okay to do it one by one. Is it possible to do all of them?

Comments

maybe it can be done again for all comments in this plugin