All questions and answers delete

Question

Please help i have a clone of my QA.

now i will delete all Questions and answers ?

Comments

You made a clone of q2a, I suppose you copied the files and the database and now you want to remove all the questions and answers from the copy you made?

---

yes i need a clean q2a script no answers and Questions ^^

---

Why did you copy it? Are you trying to save some data? In general, copying a database is not good practice. Even if you are trying to save something, there are better ways to do it.

Answer 1

DELETE * FROM qa_posts

You could run that SQL query eg in phpmyadmin, replace "qa" with whatever your table prefix is. (Make sure you delete from the right table!) Then you can run all the scripts in Admin>Stats to clear up everything.

 

Also just to ask, what exactly are you "cloning"? I mean, you can just set up a new Q2A from scratch and copy your themes/plugins over. What else do you need to copy?

Comments

phpmyadmin "Cleare" qa_posts .. not working
#1451 - Cannot delete or update a parent row: a foreign key constraint fails (`fragen_fragen`.`qa_posts`, CONSTRAINT `qa_posts_ibfk_2` FOREIGN KEY (`parentid`) REFERENCES `qa_posts` (`postid`))

---

and delete :
#1217 - Cannot delete or update a parent row: a foreign key constraint fails

---

You should be able to disable foreign key checks temporarily. I don't know the exact code for that, sorry.

---

hmmm and now ?

Answer 2

 

Solution:

SET FOREIGN_KEY_CHECKS=0;

TRUNCATE qa_posts

 

Comments

This does not work. Any other suggestions.