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

Posted 29 апреля, 20177 yr

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

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

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

Цитата

29 апреля, 20177 yr

comment_127791

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

Цитата

29 апреля, 20177 yr

Author

comment_127792

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

Цитата

29 апреля, 20177 yr

comment_127793

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

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

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

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

Цитата

29 апреля, 20177 yr

Author

comment_127794

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

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

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

Цитата

29 апреля, 20177 yr

comment_127795

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

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

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

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

Цитата

BigP
1

29 апреля, 20177 yr

Author

comment_127797

Цитата

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

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

Цитата

Silence
1

29 апреля, 20177 yr

Author

comment_127799

Цитата

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

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

Цитата

29 апреля, 20177 yr

comment_127800

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

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

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

Цитата

29 апреля, 20177 yr

Author

comment_127801

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

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

Все так-же :c

Цитата

29 апреля, 20177 yr

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

Цитата

29 апреля, 20177 yr

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

Цитата

29 апреля, 20177 yr

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

Цитата

Silence
1

Sign In

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

Featured Replies

Join the conversation

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

Account

Navigation

Messages

Уведомления

Search