Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
7 registered (smallufo, SteveS, sampsonzurich, Bjab, FordDoctor, Stan, Pilgrim), 27 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/17/12
Posts: 3
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#217046 - 09/16/08 08:23 AM How do I delete private posts
Morgan Offline
member
Registered: 06/13/06
Posts: 131
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... wink
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#217076 - 09/17/08 11:58 AM Re: How do I delete private posts [Re: Morgan]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
You'll need to run a few SQL commands from the control panel:

Sql Query:
delete from ubbt_PRIVATE_MESSAGE_TOPICS


Sql Query:
delete from ubbt_PRIVATE_MESSAGE_POSTS


Sql Query:
delete from ubbt_PRIVATE_MESSAGE_USERS


Sql Query:
update ubbt_USER_PROFILE
set USER_TOTAL_PM ='0'
Top
#217378 - 09/27/08 06:18 AM Re: How do I delete private posts [Re: Rick]
Morgan Offline
member
Registered: 06/13/06
Posts: 131

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???
Top
#217386 - 09/27/08 08:09 AM Re: How do I delete private posts [Re: Morgan]
Morgan Offline
member
Registered: 06/13/06
Posts: 131
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
???



Edited by Morgan (09/27/08 08:09 AM)
Top
#217387 - 09/27/08 09:36 AM Re: How do I delete private posts [Re: Morgan]
Yarp™ Offline
Registered: 08/30/06
Posts: 1513
Loc: Breda, NL
No, replace ubbt_ with ubbt_bbf

no need for an additional underscore there.
_________________________
Top
#217388 - 09/27/08 09:41 AM Re: How do I delete private posts [Re: Yarp™]
Morgan Offline
member
Registered: 06/13/06
Posts: 131
like this???

delete from ubbt_bbfPRIVATE_MESSAGE_TOPICS

or... can you please type the whole line?
Top
#217400 - 09/27/08 08:13 PM Re: How do I delete private posts [Re: Morgan]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Yep, you got it:

delete from ubbt_bbfPRIVATE_MESSAGE_TOPICS
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Due Date Calculator-Calculate When Your Baby is Due
by StewartMyduedate
12:54 AM
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image