A

How I Purged old Conversations in database

  • Thread starter Thread starter ActorMike
  • Start date Start date

Visitor Greeting

Welcome to NullWarehouse.com... We are currently seeking Mod's and Contributors. If you wish to apply for a Mod position then please click on Members dropdown arrow, then click on Staff App and fill it out completely and submit it. If you want to be a Contributor then start contributing and we will have our eye on you and take notice, something great could come of it.

  • We have redone the forum. If you notice any issues or errors please open a Support Ticket under the Members dropdown and let us know.
A

ActorMike

Guest

I simply picked a conversation ID that was in the timeframe I wanted and executed this query. In this case the id was 17783.

DELETE FROM databasename.xf_conversation_message WHERE (conversation_id <= '17783');
DELETE FROM databasename.xf_conversation_master WHERE (conversation_id <= '17783');
DELETE FROM databasename.xf_conversation_recipient WHERE (conversation_id <= '17783');
DELETE FROM...

Read more

Continue reading...
 
Similar content Most view View more
Back
Top Bottom