BradTBP

+Clients
  • Content count

    27
  • Joined

  • Last visited


About BradTBP

  • Rank
    core_member_rank_44

Recent Profile Visitors


1,142 profile views

BradTBP's Activity

  1. BradTBP added a post in a topic: All deleted posts to one "deleted posts board"   

    I think I have seen that before, but cannot locate the how to.

    Can I create a board that is hidden for all deleted posts to be moved to?

    Thanks,


  2. 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.
  3. 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?
  4. BradTBP added a post in a topic: How to add Advert banners on the right hand side bar   

    Yes, how do I go about adding custom code to run an additional ad in the sidebar?
  5. BradTBP added a post in a topic: Banner referrals and tracking   

    After posting this, I have found that I can manually review each new member in the ACP to see if they were received.

    If there is an easier way, i.e. a referral report or email when a referral is completed, it would be preferred. Thanks,
  6. BradTBP added a post in a topic: Banner referrals and tracking   

    I have read through this board and some google searches to see if anyone has figured out how to track results to determine if anyone followed a referral banner link back to original site and if they signed up for a membership or not. Has anyone figured out a constructive way to use the ability to create member specific referral banners?

    Thank you.
  7. BradTBP added a post in a topic: (e32) Custom Sidebar Blocks   

    What is the proper way to update to newest version?
  8. BradTBP added a post in a topic: Error: "This webpage has a redirect loop"   

    When trying to read a blog entry I've written, I am getting this error in both Chrome and IE:


    This webpage has a redirect loop The webpage at http://thebullspen.com/index.php/blog/4/entry-8-welcome/ has resulted in too many redirects. Clearing your cookies for this site or allowing third-party cookies may fix the problem. If not, it is possibly a server configuration issue and not a problem with your computer. Here are some suggestions: Reload this webpage later. Learn more about this problem.

    I have tried clearing cache, still persists.

    I did not have this issue prior to the last security update, could that be connected?

    Any help is appreciated.

  9. BradTBP added a post in a topic: google adsense code in IP.Mobile   

    Thanks, are you using the same code for mobile as you use for your full site? The mobile code I get from Google for mobile sites is much different.
  10. BradTBP added a post in a topic: google adsense code in IP.Mobile   

    Same here, any help on this? A large percentage of users are on mobile.

    Thanks,
  11. BradTBP added a post in a topic: How do I add an ebay javascript link in the body of a message   

    That surprises me that to add ads to a content page, for example, I am very limited..it must be html or no go.

    Thanks for your answer.
  12. BradTBP added a post in a topic: How do I add an ebay javascript link in the body of a message   

    Having HTML on isn't enough. how do I use code in the "script" tags?

    <script>document.write('<a target="_blank" href="http://rover.ebay.com/rover.....</noscript>

    Thanks,
  13. BradTBP added a post in a topic: Google Analytics Code   

    I entered the code in the

    System Settings > System > Search Engine Optimization

    area of the ACP...is there something else I must do? Thanks
  14. BradTBP added a post in a topic: Google Analytics Code   

    I put my Google Analytics code in my board and it is not registering anything. It was working fine on my old board before conversion...any ideas what to look at to fix? I 'm on 3.3.4


    Thanks,

    Brad

About Me

Status Feed