Jump to content

Настройки: IP.Download ругается на базу

BigP
BigP
in Техническая поддержка IP.Board

Featured Replies

Posted
comment_127790

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

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

 

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

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/17259-nastrojki-ipdownload-rugaetsya-na-bazu/
    Share on other sites
    comment_127791

    отключаем хуки и проверяем 

  • Цитата
    • Author
    comment_127792

    Все ровно, вот гляньте. http://samp-create.ru/index.php?/files/ не реклама. При нажатие на файл появляется эта ошибка.

  • Цитата
    comment_127793
    1 минуту назад, BigP сказал:

    Все ровно, вот гляньте. http://samp-create.ru/index.php?/files/ не реклама. При нажатие на файл появляется эта ошибка.

    кеш чистили .... ?

    если нет проблема дайте мне админ права в личку

  • Цитата
    • Author
    comment_127794
    7 минут назад, Silence сказал:

    кеш чистили .... ?

    Чистил, только поставил движок

  • Цитата
    comment_127795
    8 минут назад, BigP сказал:

    Чистил, только поставил движок

     

    15 минут назад, Silence сказал:

    если нет проблема дайте мне админ права в личку

     

  • Цитата
    • Author
    comment_127797
    Цитата

    Вы можете отправить только 0 сообщений в день. Пожалуйста, повторите попытку позже.

    Зарегестрируйтесь выдам права.

  • Цитата
    • Author
    comment_127799
    Цитата

    Вы можете отправить только 0 сообщений в день. Пожалуйста, повторите попытку позже.

    Оказывается если тыкнуть на созданую тему, тоже самое выскакивает...

  • Цитата
    comment_127800
    15 минут назад, BigP сказал:

    Зарегестрируйтесь выдам права.

    Попробуйте сейчас

  • Цитата
    • Author
    comment_127801
    2 минуты назад, Silence сказал:

    Попробуйте сейчас

    Все так-же :c

  • Цитата
    • Author
    comment_127802

    Лог ошибок

     

    Цитата


     ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
     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               |
     '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

     

  • Цитата
    comment_127803

    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

     

  • Цитата
    • Author
    comment_127804
    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 Все получилось, спасибо за помощь ! Желаю блага тебе, если что обращайся помогу чем смогу

  • Цитата

    • Join the conversation

    You can post now and register later. If you have an account, sign in now to post with your account.
    Note: Your post will require moderator approval before it will be visible.

    Guest
    Ответить в этой теме...
    Go to topic listing

    Последние посетители 0

    • No registered users viewing this page.