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

XF 1.3 Missing/skipping some alerts

Discussion in 'Troubleshooting and Problems' started by D.O.A., Sep 6, 2014.

  1. D.O.A.

    D.O.A. Well-Known Member

    Hi, we have a problem now and then with likes failing to be alerted in the navigation drop-down or recent likes page, we have post ratings installed and a pretty busy forum but I never see any errors in admin or the logs. Any ideas where to begin looking for the causes?

    Capture2.JPG Capture.JPG

    Example; above images only two of the three likes appeared as notifications. Not sure if it's mysql performance related? although we do get the odd long query from post ratings add-on and social groups, but the like above was not posted in groups.

    Code:
    # User@Host: user[xxx] @ localhost []
    # Query_time: 6.647592  Lock_time: 0.000061 Rows_sent: 4  Rows_examined: 28301
    SET timestamp=1409967911;
    SELECT post.*
                    ,
                        bb_code_parse_cache.parse_tree AS message_parsed, bb_code_parse_cache.cache_version AS message_cache_version,
                        user.*, IF(user.username IS NULL, post.username, user.username) AS username,
                        user_profile.*,
                        signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
                        liked_content.like_date,
                        social_forum.logo_date,
                        social_forum.logo_width,
                        social_forum.logo_height,
                        social_forum.logo_crop_x,
                        social_forum.logo_crop_y,
                        social_forum.title AS social_forum_title,
                        social_forum_combination.cache_value AS secondary_social_forums
                        ,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (20,1,2)) as positive_rating_count
                   
                        ,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (15,16,17,18,19,23,22,14,3)) as negative_rating_count
                    ,
                pr2.rating,
                    pr.*, post.post_id
                FROM xf_post AS post
               
                        LEFT JOIN xf_bb_code_parse_cache AS bb_code_parse_cache ON
                            (bb_code_parse_cache.content_type = 'post' AND bb_code_parse_cache.content_id = post.post_id)
                        LEFT JOIN xf_user AS user ON
                            (user.user_id = post.user_id)
                        LEFT JOIN xf_user_profile AS user_profile ON
                            (user_profile.user_id = post.user_id)
                        LEFT JOIN xf_bb_code_parse_cache AS signature_parse_cache ON
                            (signature_parse_cache.content_type = 'signature' AND signature_parse_cache.content_id = post.user_id)
                        LEFT JOIN xf_liked_content AS liked_content
                            ON (liked_content.content_type = 'post'
                                AND liked_content.content_id = post.post_id
                                AND liked_content.like_user_id = 57274)
                        LEFT JOIN xf_social_forum AS social_forum ON
                            (social_forum.social_forum_id = user_profile.primary_social_forum_id)
                        LEFT JOIN xf_social_forum_combination AS social_forum_combination ON
                            (social_forum_combination.social_forum_combination_id = user_profile.social_forum_combination_id)
                LEFT JOIN dark_postrating pr2 ON (post.post_id = pr2.post_id and pr2.user_id = 57274)
        LEFT JOIN (
            select
                pivot_pr.post_id
        , sum(case when pivot_pr.rating = 15 then 1 else 0 end) dark_postrating_15_count
        , sum(case when pivot_pr.rating = 16 then 1 else 0 end) dark_postrating_16_count
        , sum(case when pivot_pr.rating = 17 then 1 else 0 end) dark_postrating_17_count
        , sum(case when pivot_pr.rating = 18 then 1 else 0 end) dark_postrating_18_count
        , sum(case when pivot_pr.rating = 19 then 1 else 0 end) dark_postrating_19_count
        , sum(case when pivot_pr.rating = 20 then 1 else 0 end) dark_postrating_20_count
        , sum(case when pivot_pr.rating = 23 then 1 else 0 end) dark_postrating_23_count
        , sum(case when pivot_pr.rating = 22 then 1 else 0 end) dark_postrating_22_count
        , sum(case when pivot_pr.rating = 1 then 1 else 0 end) dark_postrating_1_count
        , sum(case when pivot_pr.rating = 14 then 1 else 0 end) dark_postrating_14_count
        , sum(case when pivot_pr.rating = 2 then 1 else 0 end) dark_postrating_2_count
        , sum(case when pivot_pr.rating = 3 then 1 else 0 end) dark_postrating_3_count
       
                       
            from dark_postrating pivot_pr
            use index (`post_id_rating`)
            left join xf_post pivot_post on (pivot_pr.post_id = pivot_post.post_id)
            where pivot_post.thread_id = 4
            group by pivot_pr.post_id
        ) pr on (pr.post_id = post.post_id)
    
       
                WHERE post.thread_id = '4'
                     AND (post.position >= 12430 AND post.position < 12440)
                    AND (post.message_state IN ('visible') OR (post.message_state = 'moderated' AND post.user_id = 57274))
                ORDER BY post.position ASC, post.post_date ASC;
    /usr/libexec/mysqld, Version: 5.5.39-log (MySQL Community Server (GPL) by Remi). started with:
    Tcp port: 0  Unix socket: /var/lib/mysql/mysql.sock
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    Could you list all your add ons? I know of one that may cause this.
     
  3. D.O.A.

    D.O.A. Well-Known Member

    sure, we have
    1. ******* - User Profile Cover 1.2.5
    2. Carlton GG pest 2.0 Carlton
    3. Conversation Search by Waindigo 1.0.4
    4. Digital Point Better Analytics 1.0.4
    5. Widget Framework 2.5.0d
    6. BD Medal
    7. BD tag me
    8. Digital Point Spy 1.3.0
    9. Moderator Essentials 1.1.7
    10. Member map
    11. Multiple Account Detection 1.0.1
    12. Nodes As Tabs 1.2.1
    13. Poke by Waindigo 1.0.0
    14. Post Ratings 1.6.6
    15. Profile View Count 1.3
    16. s9e Media Pack 201403220
    17. Sitemap for XenForo 1.5.2
    18. Social Groups by Waindigo 1.1.3b
    19. Status Permissions by Waindigo 1.0.0
    20. TAC FoolBotHoneyPot - Stop spam bots registering 2.4.05
    21. Thumbnails by Waindigo 2.0.2
    22. User Criteria by Waindigo 1.0.6
    23. Who Replied 1.2.0
    24. XenForo Enhanced Search 1.1.1
    25. XenZine Articles 1.2.06
    26. [3.studIo] Custom Markup For Users 1.0.1
    27. [MWS] Daily Statistics 1.2.4a
    28. [RT] User Rank Ribbons (15, w/TMS) 2.3
    29. [Tinhte] Attach Image Optimization 2.2.11
    30. [xFS] User Smilies 1.0 BETA 1
    31. [YOU] hack 1.1.1
    32. Tapatalk 2.0.3 (DISABLED)
     
  4. Chris D

    Chris D XenForo Developer Staff Member

    The one I thought it might be isn't there.

    However it would be interesting to disable all of those add ons apart from Post Ratings to see if the problem persists.
     
  5. D.O.A.

    D.O.A. Well-Known Member

    I've had add-ons installed in the past since removed. anything in particular you were going to mention? I know tapatalk earlier versions screwed with alerts, we had missing text in most of them.
     
  6. Chris D

    Chris D XenForo Developer Staff Member

    If they are removed they shouldn't be able to do anything. So if anything it's likely to be something currently enabled.
     
  7. D.O.A.

    D.O.A. Well-Known Member

    We have stuff like deferJS, tapatalk,notable members tab improvements installed, but disabled, so I assume they have no effect... I'll give disabling everything except post ratings a shot and get our members feedback also if they notice new likes they were never notified of.
     
  8. D.O.A.

    D.O.A. Well-Known Member

Share This Page