Question for a SQL Guru

Hi there,

We seem to have a problem with suddenly visitors messages showing as unread when they are read.

I have copied here a SQL query that someone wrote that we use to clear "moderated" social group messages (because there is a bug)

So I am hoping that maybe someone smart will see this and know what field or table or whatever I would change gmmoderatedcount to so that I can mark all of a user's visitors messages read?

Or ... maybe someone has a better solutions?

Thank you in advance!

Code:

UPDATE user
SET gmmoderatedcount = 0
WHERE userid = X

Thank you

 

I recommend downloading SQLyog, which has a GUI to manage your MySQL databases, tables, etc

Open it up, and go to that table, find that column, what are all of the values, 0?

The values may need to be set to 1 to mark as red, no?