Jump to content

Ошибка sql которая приходит каждый день

Вячеслав Русаков
Вячеслав Русаков
in Техническая поддержка IP.Board

Featured Replies

Posted
comment_93559

у меня каждый день вот такая вот ошибка в панели

'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/search/search.php | [public_core_search_search].searchResults | 173 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_core_search_search].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Thu, 24 Sep 2015 14:34:21 +0000
Error: 2006 - MySQL server has gone away
IP Address: 176.49.191.219 - /index.php?app=core&module=search&do=search&andor_type=&sid=d3f2ac86a63184641ad71777702c28f2&search_app_filters[forums][sortKey]=date&search_tags=�а���лка+вибе�&search_app_filters[forums][sortKey]=date&search_app_filters[forums][searchInKey]=&search_term=&search_app=forums
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT cs_value, cs_updated FROM cache_store WHERE cs_key='mail_processing'
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Thu, 24 Sep 2015 14:34:23 +0000
Error: 2006 - MySQL server has gone away
IP Address: 176.49.191.219 - /index.php?app=core&module=search&do=search&andor_type=&sid=9ccd7807cf8990b574b8256cd50cea72&search_app_filters[forums][sortKey]=date&search_tags=�г�а+�+в�водом+денег&search_app_filters[forums][sortKey]=date&search_app_filters[forums][searchInKey]=&search_term=&search_app=forums&search_app_filters[forums][searchInKey]=&search_app_filters[forums][sortKey]=date&search_app_filters[forums][sortDir]=0
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT cs_value, cs_updated FROM cache_store WHERE cs_key='mail_processing'
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Thu, 24 Sep 2015 14:34:29 +0000
Error: 2006 - MySQL server has gone away
IP Address: 176.49.191.219 - /index.php?app=core&module=search&do=search&andor_type=&sid=8c48972173e57ce60aa0c51fb3d957a3&search_app_filters[forums][sortKey]=date&search_tags=��бай&search_app_filters[forums][sortKey]=date&search_app_filters[forums][searchInKey]=&search_term=&search_app=forums&search_app_filters[forums][searchInKey]=&search_app_filters[forums][sortKey]=date&search_app_filters[forums][sortDir]=1
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT t.tid as id, t.tid as topic_id, t.title, t.posts, t.views, t.last_post, t.topic_firstpost,p.post_date, p.pid FROM topics t LEFT JOIN posts p ON ( p.pid=t.topic_firstpost ) WHERE t.tid IN (43) AND t.forum_id IN (3,4,5,6,12,8,9,10,11,14,15,16,17,18,20,25,21,26,23,27,22,31,29,30,32,80,81,82,85,89,47,35,36,37,39,40,42,43,44,45,46,49,50,51,53,54,55,56,58,59,61,62,63,65,66,67,68,70,78,72,73,74,75,76,77,79,84,87,88,91,92) AND p.queued=0 AND t.approved=1 AND t.topic_archive_status IN (0,3) AND t.state != 'link' ORDER BY t.last_post asc LIMIT 0,201
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/classes/search/controller.php | [search_engine_forums].search | 544 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/search/search.php | [IPSSearch].search | 674 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/core/modules_public/search/search.php | [public_core_search_search].searchResults | 173 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_core_search_search].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Thu, 24 Sep 2015 14:34:29 +0000
Error: 2006 - MySQL server has gone away
IP Address: 176.49.191.219 - /index.php?app=core&module=search&do=search&andor_type=&sid=8c48972173e57ce60aa0c51fb3d957a3&search_app_filters[forums][sortKey]=date&search_tags=��бай&search_app_filters[forums][sortKey]=date&search_app_filters[forums][searchInKey]=&search_term=&search_app=forums&search_app_filters[forums][searchInKey]=&search_app_filters[forums][sortKey]=date&search_app_filters[forums][sortDir]=1
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT cs_value, cs_updated FROM cache_store WHERE cs_key='mail_processing'
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Thu, 24 Sep 2015 14:34:29 +0000
Error: 2006 - MySQL server has gone away
IP Address: 176.49.191.219 - /index.php?app=core&module=search&do=search&andor_type=&sid=ec9acfb5c0324a606e194ed7336b2438&search_app_filters[forums][sortKey]=date&search_tags=пла�ежна�+�и��ема&search_app_filters[forums][sortKey]=date&search_app_filters[forums][searchInKey]=&search_term=&search_app=forums&search_app_filters[forums][searchInKey]=&search_app_filters[forums][sortKey]=views&search_app_filters[forums][sortDir]=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM members m LEFT JOIN pfields_content p ON ( p.member_id=m.member_id ) 
LEFT JOIN profile_portal pp ON ( pp.pp_member_id=m.member_id ) 
LEFT JOIN groups g ON ( g.g_id=m.member_group_id ) 
LEFT JOIN content_cache_sigs ccb ON ( ccb.cache_content_id=m.member_id ) WHERE m.member_id IN (51) 

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/12436-oshibka-sql-kotoraya-prihodit-kazhdyj-den/
    Share on other sites
    comment_93582

    MySQL server has gone away

    либо маленькое значение выставлено у wait_timeout, либо запрос слишком сложный

  • Цитата
    • Author
    comment_93598

    MySQL server has gone away

    либо маленькое значение выставлено у wait_timeout, либо запрос слишком сложный

    А подробнее? просто я в этом особо не разбираюсь 

  • Цитата

    • Join the conversation

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

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

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

    • No registered users viewing this page.