+3 votes
in General IT Tips by (56.8k points)
edited by
I am using Question2Answer CMS on my website. New questions can be identified but there is no notification for new comments in the admin area. How can I check the comments posted under any question?

1 Answer

+1 vote
by (349k points)
selected by
 
Best answer

If you can access your database, finding comments is very easy. All the questions, answers, and comments are stored in table 'posts'. The column 'type' has 3 values: C, A, Q, where C is for comments, A is for answers, and Q is for questions. 

Log into your database from the command line or phpMyAdmin and run the following SQL to find all comments:

SELECT * FROM `posts` WHERE type = 'C'


...