UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support How do I delete private posts

Hi

As mentioned before I imported UbbClassic 6.7.3 to Threads 7.3.1

I noticed I had about 8000 private topics and there must be
a whole bunch in our members too. So
how can I easily clean up and erase all private topics for all members.
Would like to start all over with the private topics as there are many member not using the site and I like to get the space they take on the database.

Thanks in advance for your secure advice...

You'll need to run a few SQL commands from the control panel:

tested all above commands and got error messages on all.
below was the last, I replaced some of the reply path and table data with xxxxxxxxx

Control panel message
Script: /home/xxxxxx/xxxx/x/x/xxxxxxxx/html/forums/admin/dodbcommand.php
Line#: 101
SQL Error: Table 'xxxxxxxxxxxxx.ubbt_USER_PROFILE' doesn't exist
SQL Error #: 1146
Query: update ubbt_USER_PROFILE set USER_TOTAL_PM ='0'


Any comment on what I did wrong???

I saw this in the CP

Table Prefix:
The prefix was determined during initial installation and may not be changed. ubbt_bbf

does this mean I should change the query to
delete from ubbt_bbf_PRIVATE_MESSAGE_TOPICS
???

No, replace ubbt_ with ubbt_bbf

no need for an additional underscore there.

like this???

delete from ubbt_bbfPRIVATE_MESSAGE_TOPICS

or... can you please type the whole line?

Yep, you got it:

delete from ubbt_bbfPRIVATE_MESSAGE_TOPICS