Jump to content

Ошибка с SQL.

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

Featured Replies

Posted
comment_20745

Здравствуйте. 

 

У меня достаточно часто вылазеет ошибка о том, что что-то не так с SQL. Тоже происходит и при регистрации новых пользователей. Ошибка вылазеет при регистрации вылазеет, а пользователь её видет, но при этом, каким-то чудным образом, он регистрируется на сайте. Сама эта ошибка вроде как не опасна, т.к. сайт не падал после её показа, а при обновлении страницы все было нормально.

 

Кидаю вам лог, но там было 4 файла.

 

 

sql_error_log_02_07_13

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Date: Thu, 07 Feb 2013 17:45:35 +0000
Error: 2006 - MySQL server has gone away
IP Address: 85.26.234.53 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT * FROM cache_store WHERE cs_key IN ( 'tutorials_cats' )
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3199 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/tutorials/sources/categories.php | [ips_CacheRegistry].getCache | 36 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/tutorials/app_class_tutorials.php | [categories].__construct | 18 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/tutorialsRecentlyAdded_65400762b895a9cfc1409dd9855d2a6a.php | [app_class_tutorials].__construct | 30 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php | [tutorialsRecentlyAdded].getOutput | 3472 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php | [output].templateHooks | 2734 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php | [output].sendOutput | 124 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_forums_forums_boards].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

 

sql_error_log_01_19_13


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sat, 19 Jan 2013 10:53:47 +0000
Error: 2006 - MySQL server has gone away
IP Address: 85.26.235.112 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT * FROM cache_store WHERE cs_key IN ( 'tutorials_cats' )
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3199 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/tutorials/sources/categories.php | [ips_CacheRegistry].getCache | 36 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/tutorials/app_class_tutorials.php | [categories].__construct | 18 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/tutorialsRecentlyAdded_65400762b895a9cfc1409dd9855d2a6a.php | [app_class_tutorials].__construct | 30 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php | [tutorialsRecentlyAdded].getOutput | 3472 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php | [output].templateHooks | 2734 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php | [output].sendOutput | 124 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_forums_forums_boards].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

 

 

sql_error_log_01_12_13


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sat, 12 Jan 2013 14:55:33 +0000
Error: 2006 - MySQL server has gone away
IP Address: 78.106.124.155 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT * FROM cache_store WHERE cs_key IN ( 'tutorials_cats' )
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3199 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/tutorials/sources/categories.php | [ips_CacheRegistry].getCache | 36 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/tutorials/app_class_tutorials.php | [categories].__construct | 18 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/tutorialsRecentlyAdded_65400762b895a9cfc1409dd9855d2a6a.php | [app_class_tutorials].__construct | 30 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php | [tutorialsRecentlyAdded].getOutput | 3472 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php | [output].templateHooks | 2734 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php | [output].sendOutput | 124 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_forums_forums_boards].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Date: Sat, 12 Jan 2013 14:55:33 +0000
Error: 2006 - MySQL server has gone away
IP Address: 78.106.124.155 - /index.php?
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT * FROM cache_store WHERE cs_key IN ( 'tutorials_cats' )
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3199 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/tutorials/sources/categories.php | [ips_CacheRegistry].getCache | 36 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/tutorials/app_class_tutorials.php | [categories].__construct | 18 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/tutorialsRecentlyAdded_65400762b895a9cfc1409dd9855d2a6a.php | [app_class_tutorials].__construct | 30 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php | [tutorialsRecentlyAdded].getOutput | 3472 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php | [output].templateHooks | 2734 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php | [output].sendOutput | 124 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_forums_forums_boards].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

 

 

sql_error_latest

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


Date: Thu, 07 Feb 2013 17:45:35 +0000
Error: 2006 - MySQL server has gone away
IP Address: 85.26.234.53 - /
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
mySQL query error: SELECT * FROM cache_store WHERE cs_key IN ( 'tutorials_cats' )
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File | Function | Line No. |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| admin/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3199 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/tutorials/sources/categories.php | [ips_CacheRegistry].getCache | 36 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications_addon/other/tutorials/app_class_tutorials.php | [categories].__construct | 18 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| hooks/tutorialsRecentlyAdded_65400762b895a9cfc1409dd9855d2a6a.php | [app_class_tutorials].__construct | 30 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php | [tutorialsRecentlyAdded].getOutput | 3472 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/classes/output/publicOutput.php | [output].templateHooks | 2734 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/applications/forums/modules_public/forums/boards.php | [output].sendOutput | 124 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| admin/sources/base/ipsController.php | [public_forums_forums_boards].doExecute | 306 |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

 

Вот, все логи.

Теперь могу скинуть вам картинку ошибки.

post-1060-0-63211000-1360268356_thumb.jp

 

вот такие вот дела. Помогите пожалуйста.

 

 

Зы... - седня еле на форум ваш попал, администрация мой ник исправила. Спасибо и за это. =)

Edited by Metrotram

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3024-oshibka-s-sql/
    Share on other sites
    comment_20762

    Сбрось глобальный кеш. 

     

    Проверь приложение tutorials (выключи его и попробуй проделать все те же действия где возникали ошибки) 

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3024-oshibka-s-sql/?&do=findComment&comment=20762
    Share on other sites
    • Author
    comment_20764
    Сбрось глобальный кеш. 

     

    Проверь приложение tutorials (выключи его и попробуй проделать все те же действия где возникали ошибки) 

    Не найду глобальный кеш, ткни пожайлуста. А приложения отключил.

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3024-oshibka-s-sql/?&do=findComment&comment=20764
    Share on other sites
    comment_20774

    У вас сервер MySQL падает, к хостеру обращайтесь.

  • Цитата
    • Link to comment
    https://ipbmafia.ru/topic/3024-oshibka-s-sql/?&do=findComment&comment=20774
    Share on other sites

    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.