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

XF 1.1 PC issue after vB4 import...

Discussion in 'Troubleshooting and Problems' started by vVv, Nov 10, 2012.

  1. vVv

    vVv Guest

    not sure what happened with PC's on my site... but they're all showing as single PC's and most as "zero replies"... like..

    hey man
    Replies:
    0
    Participants:
    2

    re: hey man
    Replies:
    0
    Participants:
    2

    re: hey man
    Replies:
    0
    Participants:
    2

    re: hey man
    Replies:
    0
    Participants:
    2

    re: hey man
    Replies:
    0
    Participants:
    2

    and that's not just for my own PC's.. this is for everyone's.. how can I fix this? Once I get this fixed, then I'd like to prune out PCs with actually zero replies...Like running query, for example below here:

    Code:
    DELETE
    FROM xf_conversation_message
    WHERE conversation_id IN (
        SELECT conversation_id
        FROM xf_conversation_master
        WHERE user_id = 1
        AND reply_count = 0
    );
     
    DELETE
    FROM xf_conversation_recipient
    WHERE conversation_id IN (
        SELECT conversation_id
        FROM xf_conversation_master
        WHERE user_id = 1
        AND reply_count = 0
    );
     
    DELETE
    FROM xf_conversation_user
    WHERE conversation_id IN (
        SELECT conversation_id
        FROM xf_conversation_master
        WHERE user_id = 1
        AND reply_count = 0
    );
     
    DELETE
    FROM xf_conversation_master
    WHERE user_id = 1;
    Basically, my PC's for my user ID, with PCs actually containing zero replies.
     
  2. Jake Bunce

    Jake Bunce XenForo Moderator Staff Member

    PMs in vB are not "discussions." Rather they are individual messages. The importer imports them as such. There is no formal relation between PMs in vB to be able to combine them into discussions.
     
    vVv likes this.
  3. vVv

    vVv Guest

    ah right, true...dang it. >_<. too bad there wasn't way to run some queries, that appends/merges in order the convos/messages to starter message from the imported only lol.

    find first message - post1
    merge/append children messages of post1 to post1

    :p i guess.. time to delete specific ones then sigh.
     
  4. Chris D

    Chris D XenForo Developer Staff Member

    Or just leave them?

    Over time your past PMs that are a bit screwy will be pages and pages behind your nice new XenForo conversations.
     
  5. vVv

    vVv Guest

    yeah, well i installed that TLK Read PC resource.. and was kinda deleting some here and there. But, maybe just re-running query again to remove ALL zero replied PCs. Since most are "old" stuff anyway.. and doubtful anyone is really doing anything with them anyway. Or, remove ones from before X time/date.
     

Share This Page