Перейти к содержанию

BigP

Пользователи
  • Постов

    10
  • Зарегистрирован

  • Посещение

Сообщения, опубликованные BigP

  1. Снова здравствуйте, в общем скачал я шаблон поставил все вроде нормально но при нажатие на чей-то профиль вылезает ошибка: 

    Цитата

    Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/sampcrea/domains/samp-create.ru/public_html/cache/skin_cache/cacheid_5/skin_profile.php on line 1013

    Строка на которую ругается:

    Цитата

    <span class='ipsType_smaller desc lighter blend_links'><a href='" . $this->registry->getClass('output')->formatUrl( $this->registry->getClass('output')->buildUrl( "app=members&amp;module=profile&amp;section=status&amp;type=single&amp;status_id={$status['status_id']}", "public",'' ), "array($status['member_id'], $status['members_seo_name'])", "members_status_single" ) . "'>{$this->lang->words['ps_updated']} " . $this->registry->getClass('class_localization')->getDate($status['status_date'],"manual{%d %b}", 0) . " &middot; " . intval($status['status_replies']) . " {$this->lang->words['ps_comments']}</a></span>

    При смене на стандартный шаблон все впорядке. Прошу помочь с этой проблемой

  2. 13 минут назад, Silence сказал:

    Illegal mix of collations .... 

    Нужно менять кодировку в бд

    Обычно в phpmyadmin.
    Везде где не utf8 переведите на utf8_general_ci.

    Sql запросы.
    Для базы данных:

    
    ALTER DATABASE `название_бд` CHARACTER SET utf8 COLLATE utf8_general_ci

    Для таблиц:

    
    ALTER TABLE `название_таблицы` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci   

     

    Я тебя обожаю ;D Все получилось, спасибо за помощь ! Желаю блага тебе, если что обращайся помогу чем смогу

  3. Лог ошибок

     

    Цитата


     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 17:36:14 +0000
     Error: 2006 - MySQL server has gone away
     IP Address: 46.16.116.20 - /index.php?
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT * FROM downloads_temp_records WHERE record_type='files' AND record_post_key='cbf1b432974bcff813a229fb5af92d6d'
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/applications_addon/ips/downloads/modules_public/post/submit.php      | [localStorageEngine].store                                                    | 1033              |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     | admin/applications_addon/ips/downloads/modules_public/post/submit.php      | [public_downloads_post_submit]._mainSave                                      | 138               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     | admin/sources/base/ipsController.php                                       | [public_downloads_post_submit].doExecute                                      | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 17:38:21 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 17:38:32 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 17:38:37 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/2-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=2 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 17:40:56 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/2-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=2 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 17:41:02 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 17:42:46 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 17:47:24 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 17:47:32 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/2-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=2 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 17:49:16 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/2-%d0%b2%d1%84%d1%8b%d0%b2%d1%84%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=2
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 17:57:58 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:00:56 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:01:10 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:01:13 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/2-%d0%b2%d1%84%d1%8b%d0%b2%d1%84%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=2
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:01:16 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:03:35 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE ( f.file_open=1 ) AND f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:06:11 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/2-%d0%b2%d1%84%d1%8b%d0%b2%d1%84%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=2
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:06:12 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/2-%d0%b2%d1%84%d1%8b%d0%b2%d1%84%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=2
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:06:13 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/2-%d0%b2%d1%84%d1%8b%d0%b2%d1%84%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=2
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:06:15 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/2-%d0%b2%d1%84%d1%8b%d0%b2%d1%84%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=2
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:06:31 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:06:54 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:13:11 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:18:15 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:18:33 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE ( f.file_open=1 ) AND f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:19:03 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:24:51 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:27:37 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:28:16 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/1-fdfsd/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:28:51 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:28:53 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:28:53 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:28:54 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:28:55 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:28:55 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:28:58 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/2-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=2 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:29:00 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/2-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=2 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:29:00 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/2-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=2 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:29:01 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/2-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=2 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:29:19 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/forum/2-forum/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=2 AND t.pinned IN (0,1) AND  t.approved IN (1,0,-1)  ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 451               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:29:24 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/topic/1-ura-zarabotalo/unread/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.tid=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsRegistry.php                                         | [app_class_forums].__construct                                                | 1346              |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:30:16 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:30:17 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:30:18 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:30:19 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:30:31 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/2-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=2 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:31:16 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/topic/1-ura-zarabotalo/unread/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.tid=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsRegistry.php                                         | [app_class_forums].__construct                                                | 1346              |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:31:21 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/topic/1-ura-zarabotalo/unread/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.tid=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsRegistry.php                                         | [app_class_forums].__construct                                                | 1346              |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:32:35 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/topic/1-ura-zarabotalo/unread/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.tid=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsRegistry.php                                         | [app_class_forums].__construct                                                | 1346              |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:33:57 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/1-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=1 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:35:22 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/forum/2-forum/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=2 AND t.pinned IN (0,1) AND  t.approved IN (1,0,-1)  ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 451               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:35:25 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/file/2-%d0%b2%d1%84%d1%8b%d0%b2%d1%84%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=2 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=2
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:36:44 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/3-%d1%8b%d1%8b%d1%8b%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=3
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:38:39 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/4-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=4 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:38:45 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/category/4-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=4 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:38:48 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/files/file/3-%d1%8b%d1%8b%d1%8b%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=1 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=3
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:38:52 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/forum/2-forum/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=2 AND t.pinned IN (0,1) AND  t.approved IN (1,0,-1)  ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 451               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:39:40 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/4-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=4 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:39:42 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/4-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=4 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:39:42 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/topic/1-ura-zarabotalo/unread/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.tid=1
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsRegistry.php                                         | [app_class_forums].__construct                                                | 1346              |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:40:22 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/file/4-%d1%82%d0%b5%d1%81%d1%82/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=2 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=4
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:41:59 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/3-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=3 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:43:12 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/4-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=4 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:43:17 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/4-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=4 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:43:18 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/4-%d0%ba%d0%bb%d0%b8%d0%b5%d0%bd%d1%82%d1%8b/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=4 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:46:54 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/file/5-%d1%82%d0%b5%d1%81%d1%82/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*, f.file_id as real_file_id,mem.*,pp.*,mim.members_display_name as approver_name, mim.members_seo_name as file_approver_seoname, mim.member_group_id as file_approver_group,cc.*,xxx.*,itemmarking.* FROM downloads_files f  LEFT JOIN members mem ON ( mem.member_id=f.file_submitter ) 
     LEFT JOIN profile_portal pp ON ( pp.pp_member_id=mem.member_id ) 
     LEFT JOIN members mim ON ( mim.member_id=f.file_approver ) 
     LEFT JOIN downloads_ccontent cc ON ( cc.file_id=f.file_id ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) ) 
     LEFT JOIN core_item_markers itemmarking ON ( itemmarking.item_member_id=2 AND itemmarking.item_app='downloads' AND itemmarking.item_app_key_1=f.file_cat )   WHERE f.file_id=5
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_file].doExecute                                     | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:47:04 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/3-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=3 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:47:33 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/3-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=3 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:48:22 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 79.124.12.25 - /index.php?/files/category/3-gamemodes/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT f.*,m.member_id, m.members_display_name, m.members_seo_name, m.member_group_id,xxx.* FROM downloads_files f  LEFT JOIN members m ON ( m.member_id=f.file_submitter ) 
     LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('downloads',';','files',';',f.file_id)) )   WHERE f.file_cat=3 ORDER BY f.file_pinned DESC, f.file_open ASC, f.file_submitted DESC LIMIT 0,10
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/sources/base/ipsController.php                                       | [public_downloads_display_category].doExecute                                 | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     Date: Sat, 29 Apr 2017 18:48:43 +0000
     Error: 1267 - Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
     IP Address: 46.16.116.20 - /index.php?/forum/2-forum/
     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     mySQL query error: SELECT t.*,xxx.* FROM topics t  LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid)) )   WHERE t.forum_id=2 AND t.pinned IN (0,1) AND  t.approved IN (1,0,-1)  ORDER BY t.pinned DESC,  t.last_post DESC LIMIT 0,30
     .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
     | File                                                                       | Function                                                                      | Line No.          |
     |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
     | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].renderForum                                     | 451               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     | admin/applications/forums/modules_public/forums/forums.php                 | [public_forums_forums_forums].showForum                                       | 147               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
     | admin/sources/base/ipsController.php                                       | [public_forums_forums_forums].doExecute                                       | 306               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

     

  4. В общем, когда добавляешь файл выдает вот это, а так же после обновления страницы при нажатие на этот файл вылезает тоже самое.

    http://i.imgur.com/YhjcHtO.png

     

    Немогу понять в чем проблема с этой базой. Буду очень благодарен за помощь.

×
×
  • Создать...