+3 votes
in General IT Tips by (17.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

0 votes
by (48.7k points)

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'