Jump to content

Ошибка при регистрации и ручной активации пользователя (после переноса)

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

Featured Replies

Posted
comment_72802

Всем добрый день.

 

После переноса форума на другой сервер появилась ошибка:

 

Когда пользователь завершает регистрацию и нажимает подтвердить, то выскакивает следующее:

An error occured with the SQL server:
mySQL query error: SELECT * FROM cache_store WHERE cs_key IN ( 'emoticons' )

This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above.

Когда я активирую пользователя в ручную, то аналогичная проблема.

 

Писал администраторам хостинга, всё что они могли сделали, но ошибка не решена.

 

В phpMyadmin, с cache_store а именно с cs_key делал:

Проверить таблицу
Анализ таблицы
Восстановить таблицу 

 

Оптимизировать таблицу
 
Нечего не помогло.
  • Цитата
    • Author
    comment_72811

    Вот кусочек файла в самом низу было,

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


    Date: Tue, 21 Oct 2014 09:00:24 +0000
    Error: 2006 - MySQL server has gone away
    IP Address: 37.214.141.68 - /index.php?s=3f0efbaf52a6a6c511acd9a55fb0d4da&app=forums&module=ajax§ion=topics&do=reply&t=158&f=8&pid=813
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT * FROM cache_store WHERE cs_key IN ( 'notifications' )
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | admin_panel_mora/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3346 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/classes/member/notifications.php | [ips_CacheRegistry].getCache | 506 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/classes/member/notifications.php | [notifications].getDefaultNotificationConfig | 594 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/classes/member/notifications.php | [notifications].getMemberNotificationConfig | 652 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/forums/sources/classes/post/classPost.php | [notifications].sendNotification | 2986 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/forums/sources/classes/post/classPost.php | [classPost].sendOutQuoteNotifications | 1253 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/forums/modules_public/ajax/topics.php | [classPost].addReply | 607 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/forums/modules_public/ajax/topics.php | [public_forums_ajax_topics]._reply | 76 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/base/ipsController.php | [public_forums_ajax_topics].doExecute | 421 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/base/ipsController.php | [ipsAjaxCommand].execute | 120 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Tue, 21 Oct 2014 10:35:25 +0000
    Error: 2006 - MySQL server has gone away
    IP Address: 46.191.85.163 - /index.php?app=core&module=global§ion=lostpass
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT * FROM cache_store WHERE cs_key IN ( 'emoticons' )
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | admin_panel_mora/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3346 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/classes/bbcode/core.php | [ips_CacheRegistry].getCache | 334 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/handlers/han_parse_bbcode.php | [class_bbcode_core].__construct | 192 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/handlers/han_parse_bbcode.php | [parseBbcode]._loadClasses | 167 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/base/core.php | [parseBbcode].__construct | 4490 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/handlers/han_email.php | [iPSText].getTextClass | 961 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/handlers/han_email.php | [hanEmail].cleanMessage | 735 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/core/modules_public/global/lostpass.php | [hanEmail].buildPlainTextContent | 377 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/core/modules_public/global/lostpass.php | [public_core_global_lostpass].lostPasswordEnd | 54 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/base/ipsController.php | [public_core_global_lostpass].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Tue, 21 Oct 2014 10:43:04 +0000
    Error: 2006 - MySQL server has gone away
    IP Address: 46.191.85.163 - /index.php?app=core&module=usercp&tab=core&area=email
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: INSERT INTO mail_error_logs (`mlog_date`,`mlog_to`,`mlog_from`,`mlog_subject`,`mlog_content`,`mlog_msg`,`mlog_code`,`mlog_smtp_msg`) VALUES(1413888184,'[email protected]','','Информация о восстановлении пароля с Форум сервера www.wowby.ru','Здравствуйте, skripa1!nnВы получили это письмо от https://www.wowby.ru/index.php, потому что запросили изменение E-mail.nn------------------','Could not open a socket to the SMTP server (110:Время ожидания соединения истекло)','','')
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | admin_panel_mora/sources/handlers/han_email.php | [db_main_mysql].insert | 1102 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/handlers/han_email.php | [hanEmail].fatalError | 232 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/core/extensions/usercpForms.php | [hanEmail].sendMail | 3277 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/core/extensions/usercpForms.php | [usercpForms_core].saveFormEmailPassword | 2072 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/core/modules_public/usercp/manualResolver.php| [usercpForms_core].saveForm | 236 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/base/ipsController.php | [public_core_usercp_manualResolver].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Tue, 21 Oct 2014 10:47:57 +0000
    Error: 2006 - MySQL server has gone away
    IP Address: 46.191.85.163 - /index.php?app=core&module=usercp&tab=core&area=email
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: INSERT INTO mail_error_logs (`mlog_date`,`mlog_to`,`mlog_from`,`mlog_subject`,`mlog_content`,`mlog_msg`,`mlog_code`,`mlog_smtp_msg`) VALUES(1413888477,'[email protected]','','Информация о восстановлении пароля с Форум сервера www.wowby.ru','Здравствуйте, skripa1!nnВы получили это письмо от https://www.wowby.ru/index.php, потому что запросили изменение E-mail.nn------------------','Could not open a socket to the SMTP server (110:Время ожидания соединения истекло)','','')
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | admin_panel_mora/sources/handlers/han_email.php | [db_main_mysql].insert | 1102 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/handlers/han_email.php | [hanEmail].fatalError | 232 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/core/extensions/usercpForms.php | [hanEmail].sendMail | 3277 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/core/extensions/usercpForms.php | [usercpForms_core].saveFormEmailPassword | 2072 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/core/modules_public/usercp/manualResolver.php| [usercpForms_core].saveForm | 236 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/base/ipsController.php | [public_core_usercp_manualResolver].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Tue, 21 Oct 2014 12:31:43 +0000
    Error: 2006 - MySQL server has gone away
    IP Address: 178.124.207.85 - /admin_panel_mora/index.php?adsess=07e2b9689123b873f9bf76e46c691971&app=members&module=ajax§ion=members&secure_key=93ede137c11dc4b6e7e706122f657355&do=do_validating&type=approve&mid_836=1
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT * FROM cache_store WHERE cs_key IN ( 'emoticons' )
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | admin_panel_mora/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3346 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/classes/text/parser/bbcode.php | [ips_CacheRegistry].getCache | 343 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/classes/text/parser.php | [class_text_parser_bbcode].__construct | 164 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/handlers/han_email.php | [classes_text_parser].display | 791 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/handlers/han_email.php | [hanEmail].convertTextEmailToHtmlEmail | 561 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/members/sources/adminManage.php | [hanEmail].buildMessage | 718 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/members/modules_admin/ajax/members.php | [adminMemberManagement].approveMembers | 405 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/members/modules_admin/ajax/members.php | [admin_members_ajax_members]._manageValidating | 52 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/base/ipsController.php | [admin_members_ajax_members].doExecute | 421 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/base/ipsController.php | [ipsAjaxCommand].execute | 120 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    Date: Tue, 21 Oct 2014 12:41:28 +0000
    Error: 2006 - MySQL server has gone away
    IP Address: 178.124.207.85 - /index.php?app=core&module=global§ion=register
    ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    mySQL query error: SELECT * FROM cache_store WHERE cs_key IN ( 'emoticons' )
    .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
    | File | Function | Line No. |
    |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
    | admin_panel_mora/sources/base/ipsRegistry.php | [ips_CacheRegistry]._loadCaches | 3346 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/classes/bbcode/core.php | [ips_CacheRegistry].getCache | 334 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/handlers/han_parse_bbcode.php | [class_bbcode_core].__construct | 192 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/handlers/han_parse_bbcode.php | [parseBbcode]._loadClasses | 167 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/base/core.php | [parseBbcode].__construct | 4490 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/handlers/han_email.php | [iPSText].getTextClass | 961 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/handlers/han_email.php | [hanEmail].cleanMessage | 735 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/core/modules_public/global/register.php | [hanEmail].buildPlainTextContent | 2027 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/applications/core/modules_public/global/register.php | [public_core_global_register].registerProcessForm | 65 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
    | admin_panel_mora/sources/base/ipsController.php | [public_core_global_register].doExecute | 306 |
    '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

  • Цитата

    • 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.