HOw to remove all pm's form database

[hescominsoon]

RHEL is built for stability over a long term not keeping up with the jonses. However their version of php has the important security fixes backported from 5.2. If your managed provider refuses to install...

[hescominsoon]

That's going to cause issues with my server as Centos 5 does not use 5.2x. They back port just about everything though so should be interesting to see if vb4 will run on a Centos 5 server.

[hescominsoon]

i really think you should go dedicated server.

[hescominsoon]

have you put in a support ticket at all? I can't say i've seen that error. I just got done dealing with a nasty pm database bug of my own.....

[hescominsoon]

ok i got the fields cleared out but i have another issue. The notification of new messages and the counters for folder contents have not been reset yet. How do i reset those?...

[hescominsoon]

so go into the table select everything and delete it?...

[hescominsoon]

not sure on that one. The database in question doesn't have the id's and actual pm's matched up anymore. I just need to nuke everything in terms of pm's. Take a look at the links in this thread it'll...

[hescominsoon]

I have hit what is a design issue with vbulletin and i now need some help. I need to know how to completely clear all pm's, their id's and whatnot out of the database. I basically need to empty all...

[hescominsoon]

Don't have any add-ons running. The owner of the site says if it's not officially supported we don't run it(and i concur with him on that). Vbull only has vbull running..that's all.

[hescominsoon]

ok then i have TWO servers misconfigured because the same dump on a different system system does the exact same thing. Don't think it's a server issue. Also it's only vbull that has this problem. My...

[hescominsoon]

Steve can you look at ticket #947672 please?...

[hescominsoon]

http://www.vbulletin.com/forum/showthread.php?t=317226

[hescominsoon]

for future reference i am tlaking int he server optimization forum as well.

[hescominsoon]

i'm trying to get that query to stop hanging the database. If it's too many records then that will clear it out. should i delete the first 10k then as a test?

[hescominsoon]

what would happen if i cleared the pmtext table?