|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
When importing your old forum to your test forum you'll notice that some pm's you've deleted in the past have come back, this is because they are linked from the other user involved in the message's inbox. You'll find that a lot of these are the "Welcome to our forums" pm's that many of you have enabled; in larger forums you'll have quite the bombardement... Well, just load up your control panel and run the follwoing SQL Query (Tools -> Database Tools -> SQL Command): DELETE FROM `forums_PRIVATE_MESSAGE_POSTS` WHERE `POST_BODY` LIKE CONVERT( _utf8 'Welcome to our%' USING latin1 );
DELETE FROM `forums_PRIVATE_MESSAGE_TOPICS` WHERE `TOPIC_SUBJECT` LIKE CONVERT( _utf8 'Welcome to our%' USING latin1 ); Now, you'll want to make sure that you replace "welcome to our" with the subject line of your welcome message. There are two queries because of the two sql tables used. Since I have used several similar but not exact lines I am using a wildcard search to nuke old pm's.
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
danke
|
|
|
|
Joined: Jun 2006
Posts: 196
enthusiast
|
enthusiast
Joined: Jun 2006
Posts: 196 |
will probably want to remove from PRIVATE_MESSAGE_USERS as well, since it's 2 rows per pm
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
removing from PRIVATE_MESSAGE_USERS will be a smidge harder, as theres not really anything to search by lol.
|
|
|
|
Joined: Dec 2003
Posts: 1,796
Pooh-Bah
|
Pooh-Bah
Joined: Dec 2003
Posts: 1,796 |
any automagic way of getting rid of the hundreds now in my inbox?
|
|
|
|
Joined: Jun 2006
Posts: 16,299 Likes: 116
|
Joined: Jun 2006
Posts: 16,299 Likes: 116 |
:shrug: dont' feel like doing another importer to see why it woudln't work :x...
|
|
|
Bots
by Outdoorking - 04/13/2024 5:08 PM
|
|
|
|
|
|
2 members (DennyP, 1 invisible),
969
guests, and
171
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|