1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Mark all private messages as "read" after migration

Discussion in 'XenForo Questions and Support' started by vkams, Oct 20, 2011.

  1. vkams

    vkams Active Member

    My users have hundreds of private messages after migrating from phpBB2. I'd like to remove their "unread" status and so exclude from notification. What should I do?
  2. Brogan

    Brogan XenForo Moderator Staff Member

  3. vkams

    vkams Active Member

    Thank you again, Brogan!
    I have mixed feeling. It is awkward to find out that a question was already asked half a year back. On the other hand, it doesn't please that for half a year this simple option hasn't been included in the distribution kit. It also forces to worry, as it is necessary to wait half a year or even more further? I have found out that another simple possibilities are not included for a long time too :(. Why??
  4. Brogan

    Brogan XenForo Moderator Staff Member

    You state that you imported from phpBB2, presumably that was via vB using ImPex?

    The problems occur when using a 3rd party importer/software as part of the import.

    There isn't an official phpBB2 importer.
  5. vkams

    vkams Active Member

    phpBB2.23 - ( Impex 1.9.6) - vB 3.8.4 - XenForo 1.04
    In vB I've updated all counters.
  6. vkams

    vkams Active Member

    I've applied SQL Query from post You referenced with success. But it is obvious that the problem will arise again and again with other migrations, so it should be resolved by developers.

    One more question: how to leave many conversations not one by one? I have hundreds of converted private messages and I'd like to remove lots of them.

    By the way, how can I purge database from removed conversations and posts?
  7. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    This is an ImpEx problem. I have done many imports to vBulletin which resulted in the same problem of all PMs being unread. XenForo inherits this problem when you import via ImpEx but those queries fix it.

    Here are some queries to prune all PMs:


    To remove individual PMs from your inbox you need to "leave" the conservation. If all participants in a conversation leave then it will be removed from the database.

Share This Page