BradTBP

+Clients
  • members_posts

    27
  • Joined

  • Last visited


About BradTBP

  • Rank
    IPB Newbie

Recent Profile Visitors


1,211 profile views

BradTBP's Activity

  1. BradTBP added a post in a topic: PM Viewer   



    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 03:33:19 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=7a94d406719d94e633912080a4c48f39&app=pmviewer&module=main&section=overview&messageinabottleacp=Settings+updated&messagepersistent=0
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND t.mt_is_system = 0
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND t.mt_is_system = 0
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 03:33:37 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=7a94d406719d94e633912080a4c48f39&app=pmviewer&module=main&section=overview&messageinabottleacp=Settings+updated&messagepersistent=0
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND t.mt_is_system = 0
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND t.mt_is_system = 0
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 03:34:02 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=cdd123820629eba3b7051dd94703f7d3&app=pmviewer&module=main&section=overview&
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND t.mt_is_system = 0
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND t.mt_is_system = 0
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 03:34:23 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=cdd123820629eba3b7051dd94703f7d3&app=pmviewer&module=main&section=overview&messageinabottleacp=Settings+updated&messagepersistent=0
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (m.member_group_id IN (3) OR f.member_group_id IN (3) OR m.member_group_id IS NULL OR f.member_group_id IS NULL) AND t.mt_is_system = 0
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (m.member_group_id IN (3) OR f.member_group_id IN (3) OR m.member_group_id IS NULL OR f.member_group_id IS NULL) AND t.mt_is_system = 0
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 03:38:03 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=cdd123820629eba3b7051dd94703f7d3&app=pmviewer&module=main&section=overview&messageinabottleacp=Settings+updated&messagepersistent=0
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (m.member_group_id IN (3) OR m.member_group_id IS NULL) AND f.member_group_id IS NOT NULL
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (m.member_group_id IN (3) OR m.member_group_id IS NULL) AND f.member_group_id IS NOT NULL
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 03:38:14 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=cdd123820629eba3b7051dd94703f7d3&app=pmviewer&module=main&section=overview&messageinabottleacp=Settings+updated&messagepersistent=0
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (m.member_group_id IN (3) OR m.member_group_id IS NULL) AND f.member_group_id IS NOT NULL
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (m.member_group_id IN (3) OR m.member_group_id IS NULL) AND f.member_group_id IS NOT NULL
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 03:38:17 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=cdd123820629eba3b7051dd94703f7d3&app=pmviewer&module=main&section=overview&messageinabottleacp=Settings+updated&messagepersistent=0
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (m.member_group_id IN (3) OR m.member_group_id IS NULL) AND f.member_group_id IS NOT NULL
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (m.member_group_id IN (3) OR m.member_group_id IS NULL) AND f.member_group_id IS NOT NULL
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 03:39:04 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=cdd123820629eba3b7051dd94703f7d3&app=pmviewer&module=main&section=overview&messageinabottleacp=Settings+updated&messagepersistent=0
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (m.member_group_id IN (3) OR m.member_group_id IS NULL) AND f.member_group_id IS NOT NULL
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (m.member_group_id IN (3) OR m.member_group_id IS NULL) AND f.member_group_id IS NOT NULL
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 03:39:07 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=cdd123820629eba3b7051dd94703f7d3&app=pmviewer&module=main&section=overview&messageinabottleacp=Settings+updated&messagepersistent=0
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (m.member_group_id IN (3) OR m.member_group_id IS NULL) AND f.member_group_id IS NOT NULL
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (m.member_group_id IN (3) OR m.member_group_id IS NULL) AND f.member_group_id IS NOT NULL
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'


    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 03:42:39 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=cdd123820629eba3b7051dd94703f7d3&app=pmviewer&module=main&section=overview&messageinabottleacp=Settings+updated&messagepersistent=0
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (f.member_group_id IN (3) OR f.member_group_id IS NULL) AND m.member_group_id IS NOT NULL
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (f.member_group_id IN (3) OR f.member_group_id IS NULL) AND m.member_group_id IS NOT NULL
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 03:42:43 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=cdd123820629eba3b7051dd94703f7d3&app=pmviewer&module=main&section=overview&messageinabottleacp=Settings+updated&messagepersistent=0
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (f.member_group_id IN (3) OR f.member_group_id IS NULL) AND m.member_group_id IS NOT NULL
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (f.member_group_id IN (3) OR f.member_group_id IS NULL) AND m.member_group_id IS NOT NULL
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 03:42:49 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=cdd123820629eba3b7051dd94703f7d3&app=pmviewer&module=main&section=overview
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (f.member_group_id IN (3) OR f.member_group_id IS NULL) AND m.member_group_id IS NOT NULL
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (f.member_group_id IN (3) OR f.member_group_id IS NULL) AND m.member_group_id IS NOT NULL
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 05:05:46 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=a796569d589c6ea97f796b98e148f859&app=pmviewer&module=main&section=overview&messageinabottleacp=Settings+updated&messagepersistent=0
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (f.member_group_id IN (3) OR f.member_group_id IS NULL) AND m.member_group_id IS NOT NULL AND f.member_group_id NOT IN (4)
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (f.member_group_id IN (3) OR f.member_group_id IS NULL) AND m.member_group_id IS NOT NULL AND f.member_group_id NOT IN (4)
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 05:17:14 +0000
    Error: 2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    IP Address: 157.55.34.99 - /index.php?topic=73258.0;all
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 05:17:24 +0000
    Error: 2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    IP Address: 66.249.75.120 - /topic/17955-is-tonight-the-night/
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 05:17:27 +0000
    Error: 2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    IP Address: 157.55.34.99 - /index.php/topic/44044-new-years-resolution-go-bulls/
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 05:17:28 +0000
    Error: 2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    IP Address: 157.55.34.99 - /index.php/topic/93968-this-new-joey-knight-guy/page-3
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 05:17:29 +0000
    Error: 2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    IP Address: 70.162.242.227 - /
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 05:17:29 +0000
    Error: 2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    IP Address: 180.76.5.19 - /topic/94964-graduation-rates-reaches-an-all-time-record/page-1
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 05:17:29 +0000
    Error: 2002 - Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    IP Address: 157.55.34.99 - /index.php/calendar/event/558-south-florida-football-vs-ucf-800-pm-est/
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 05:20:31 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=8f118a2babf001d399bce4fa6998fc8f&app=pmviewer&module=main&section=overview&
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (f.member_group_id IN (3) OR f.member_group_id IS NULL) AND m.member_group_id IS NOT NULL AND f.member_group_id NOT IN (4)
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (f.member_group_id IN (3) OR f.member_group_id IS NULL) AND m.member_group_id IS NOT NULL AND f.member_group_id NOT IN (4)
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Fri, 18 Apr 2014 05:20:43 +0000
    Error: 1271 - Illegal mix of collations for operation 'UNION'
    IP Address: 70.162.242.227 - /tbpcont/index.php?adsess=8f118a2babf001d399bce4fa6998fc8f&app=pmviewer&module=main&section=overview&messageinabottleacp=Settings+updated&messagepersistent=0
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'current' as source
    FROM message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (f.member_group_id IN (3) OR f.member_group_id IS NULL) AND m.member_group_id IS NOT NULL AND f.member_group_id NOT IN (4)
    UNION
    SELECT t.mt_id,t.mt_is_draft,m.members_display_name AS author,t.mt_title,m.member_group_id AS a_group,f.member_group_id AS r_group,f.members_display_name AS recipient,t.mt_to_member_id,t.mt_replies,t.mt_last_post_time,t.mt_starter_id,t.mt_to_count,t.mt_last_msg_id,'deleted' as source
    FROM pmviewer_message_topics t
    LEFT JOIN members m ON (m.member_id=t.mt_starter_id )
    LEFT JOIN members f ON ( f.member_id=t.mt_to_member_id )
    WHERE t.pmviewer_hide = 0 AND (f.member_group_id IN (3) OR f.member_group_id IS NULL) AND m.member_group_id IS NOT NULL AND f.member_group_id NOT IN (4)
    ORDER BY mt_last_post_time DESC
    LIMIT 0,20
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | tbpcont/applications_addon/other/pmviewer/modules_admin/main/overview.php | [admin_pmviewer_main_overview].overview | 154 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | tbpcont/sources/base/ipsController.php | [admin_pmviewer_main_overview].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

    Thanks....please let me know if anything else is needed. I appreciate it.
  2. BradTBP added a post in a topic: PM Viewer   

    Hi I completed the install and after selecting PM Viewer settings, I received the attached error:


    Can you tell me what has gone wrong?
  3. BradTBP added a post in a topic: (e32) Custom Sidebar Blocks   

    What is the proper way to update to newest version?

About Me

Status Feed