Imported conversations

[PeterT]

I am in the process of completing the setup of my imported MyBB forum.

I and other users have many many old private conversations, is there a way of deleting these en mass rather then clicking them one at a time and then clicking Leave Conversation.

 

[Paul B]

You can run a query/empty the table to delete them all, if you're comfortable doing so.
I would need to check which tables are involved, as there are several tables related to conversations.

I actually ran the query on my old (phpBB) forum before importing.

 

[PeterT]

You can run a query to delete them all, if you're comfortable doing so.

I actually ran the query on my old (phpBB) forum before importing.

I wish I had

I know how to run a query in phpmyadmin but alas not how to construct it.

 

[Paul B]

I haven't tested this so please take a backup first and test it on your local installation.

There are 4 tables related to conversations so if you empty/truncate those, in theory it should work:

The tables are:
xf_conversation_master
xf_conversation_message
xf_conversation_recipient
xf_conversation_user

My good friend Jake also suggested you may need to run this query:
UPDATE xf_user SET conversations_unread = 0

You might need to run a cron task or update the cache afterwards but I shouldn't think so.

I'll do some testing on my local installation to see what the effect is.

 

[Jake Bunce]

I just did a quick test and these queries work for deleting all personal conversations. You can paste these queries into phpmyadmin:

TRUNCATE TABLE xf_conversation_master;
TRUNCATE TABLE xf_conversation_message;
TRUNCATE TABLE xf_conversation_recipient;
TRUNCATE TABLE xf_conversation_user;
UPDATE xf_user SET conversations_unread = 0;

Backup first just in case. My test was successful but I might have missed something.

 

[PeterT]

will backup and give it a go, thanks.

 

[PeterT]

Wow you guys are good worked a treat, thank you.

 

[PeterT]

5 minutes and I am going online.

A big thanks to Floris at XenFans.com for the import and you guys with the SQL.

 

[Floris]

Hey PeterT, I am glad we were able to help you convert away from mybb to xenforo. Enjoy the new board!

 

[kilcher]

Hopefully you warned people before deleting all of their private messages.

Mind sharing your link so that we can look at your new forum?

 

[PeterT]

here you go http://www.ukdivers.com/community/

No style changes yet.

 

[Bellinis]

I would like to delete a member's conversations older than x days. How can I do that?

 

[Eagle]

I just did a quick test and these queries work for deleting all personal conversations. You can paste these queries into phpmyadmin:

TRUNCATE TABLE xf_conversation_master;
TRUNCATE TABLE xf_conversation_message;
TRUNCATE TABLE xf_conversation_recipient;
TRUNCATE TABLE xf_conversation_user;
UPDATE xf_user SET conversations_unread = 0;

Backup first just in case. My test was successful but I might have missed something.

Thank you Jake.. But we will wait for another "older than X days" SQL Query

 

[motowebmaster]

I just did a quick test and these queries work for deleting all personal conversations. You can paste these queries into phpmyadmin:

TRUNCATE TABLE xf_conversation_master;
TRUNCATE TABLE xf_conversation_message;
TRUNCATE TABLE xf_conversation_recipient;
TRUNCATE TABLE xf_conversation_user;
UPDATE xf_user SET conversations_unread = 0;

Backup first just in case. My test was successful but I might have missed something.

Is this still good for xf 1.5 ?

 

[Jake Bunce]

Is this still good for xf 1.5 ?

Yes.

 

[NURV]

Hi,

How could I delete all conversations with the same title? I sent out a mass message and forgot to check the box for leaving the conversation. Now I have a ton of clutter. How can I just delete these completely?

Thanks!

 

[Amaury]

Just select all the conversations and leave them:

 

[NURV]

Hi @Amaury, I'm aware of that but there are thousands of conversations. It will take me a day to do it that way.