To delete pm's (like all those welcome pm's that re-appear after upgrading), try these commands:
Code
DELETE FROM `ubbt_PRIVATE_MESSAGE_TOPICS` WHERE `TOPIC_SUBJECT` = 'Welcome'
DELETE FROM `ubbt_PRIVATE_MESSAGE_POSTS` WHERE `POST_BODY` LIKE '%Welcome to our forums%'
Change the topic subject wording to whatever you send to new registered members.
There's still the ubbt_PRIVATE_MESSAGE_USERS table - I imagine a script would need to be written to match the pm with the topic id being deleted above and clean that out too.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.