Log in

View Full Version : query to run to clear everybodys message tracking folder?


Gutspiller
02-02-2002, 05:53 PM
I turned off message tracking for my users, but I guess a few had some in there and it just keeps them there and they have no way of cleaning it out.

If somebody could give me the query to run that would ONLY clean everybodys message tracking out, that would be great.

Thanks. :up:

Gutspiller
02-04-2002, 05:52 PM
BUMP!

Admin
02-05-2002, 07:02 AM
lol nice timing (exactly 2 days). :)

I don't think that the tracking folder is an actual folder... I have very little idea about how it works but try running this query:
UPDATE privatemessage SET receipt=0;
backup that table before doing this.

Gutspiller
02-05-2002, 03:06 PM
hey, I didn't even do that on purpose. OK, um.... new question. How do I backup that table? Come BOOOOY you gots to help da noob out. :D

I turned the tracking off, so they can't even get into it anymore, but some peeps still have 2 out of 50 messages in their private messaging and yet they cleared out all their PMs, so it has to be the left over message trackings. :confused:

SloppyGoat
04-11-2003, 06:26 AM
Bump! I just disabled this too. I should probably clear these. I'm kinda skeered to run that query, unless I know how to back it up and restore it.

SloppyGoat
04-15-2003, 03:07 PM
If anyone knows this one, I'd sure appreciate it, as I'm sure a few others would.