Query to run

[Jason2]

Hello all,

I have an hack in which you can delete visitor messages in one click. I tried it out, now there is still a notification showing -- "Unread profile visitor messages". Is there a query I can run against the database to remove notifications for all users?

Thanks!

[Wayne Luke]

While this sounds like a bug that the author of your hack should fix, the query is:

update user set vmunreadcount=0;

[Jason2]

Tried that on my dev board, but the notification drop down still shows.

[Jason2]

Hi Wayne,

I've just tried that query, however I get the following:

Table 'dbuser_vbulletin.user' doesn't exist

It quite clearly exists, as I can see it -- and if it didn't exist -- my boards members wouldn't register ect.

Any ideas as to why it's saying that?

Thanks!

[Steve Machol]

You are probably using a table prefix which you need to add in front of 'user'.

[Jason2]

Ooops, my bad! Thanks, Steve -- much appreciated! :)