Но осталось 3 таблицы битые: При ручном или автоматическом запросе ошибка БД.
Самая интерестная таблица. Она восстанавливается и минуту, снова битая.
ibf_rc_classes
com_id Отсутствует индекс: onoff Нажмите здесь для исправления индексов этой таблицы или вы можете выполнить следующие запросы вручную. ALTER TABLE ibf_rc_classes DROP INDEX onoff, ADD INDEX onoff (onoff,mod_group_perm(255))
ibf_topics
tid topic_firstpost last_post forum_id starter_id last_post_sorting start_date Отсутствует индекс: last_x_topics Нажмите здесь для исправления индексов этой таблицы или вы можете выполнить следующие запросы вручную. ALTER TABLE ibf_topics DROP INDEX last_x_topics, ADD INDEX last_x_topics (forum_id,approved,start_date)
ibf_tags_index
id app Отсутствует индекс: tag_grab Нажмите здесь для исправления индексов этой таблицы или вы можете выполнить следующие запросы вручную. ALTER TABLE ibf_tags_index DROP INDEX tag_grab, ADD INDEX tag_grab (app,type,type_id,type_2,type_id_2,tag_hidden)
Ошибка бд
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 24 Oct 2014 05:54:43 +0000 Error: 1091 - Can't DROP 'last_x_topics'; check that column/key exists IP Address: - /forum/s_admin_s/index.php?adsess=124415c68ecb6c83b7c1ee6eeb870b4b&app=core&module=diagnostics§ion=diagnostics§ion=diagnostics&do=dbindex&fix=ibf_topics ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: ALTER TABLE ibf_topics DROP INDEX last_x_topics, ADD INDEX last_x_topics (forum_id,approved,start_date) .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |-----------------------------------------------------------------------------+------------------------------------------------------------------------------+-------------------| | s_admin_s/applications/core/modules_admin/diagnostics/diagnostics.php | [db_tools].dbIndexDiag | 795 | '-----------------------------------------------------------------------------+------------------------------------------------------------------------------+-------------------' | s_admin_s/applications/core/modules_admin/diagnostics/diagnostics.php | [admin_core_diagnostics_diagnostics]._indexCheck | 110 | '-----------------------------------------------------------------------------+------------------------------------------------------------------------------+-------------------' | s_admin_s/sources/base/ipsController.php | [admin_core_diagnostics_diagnostics].doExecute | 285 | '-----------------------------------------------------------------------------+------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 24 Oct 2014 06:00:55 +0000 Error: 1091 - Can't DROP 'last_x_topics'; check that column/key exists IP Address: - /forum/s_admin_s/index.php?adsess=124415c68ecb6c83b7c1ee6eeb870b4b&app=core&module=diagnostics§ion=diagnostics§ion=diagnostics&do=dbindex&fix=ibf_topics ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: ALTER TABLE ibf_topics DROP INDEX last_x_topics, ADD INDEX last_x_topics (forum_id,approved,start_date) .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | s_admin_s/applications/core/modules_admin/diagnostics/diagnostics.php | [db_tools].dbIndexDiag | 795 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | s_admin_s/applications/core/modules_admin/diagnostics/diagnostics.php | [admin_core_diagnostics_diagnostics]._indexCheck | 110 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | s_admin_s/sources/base/ipsController.php | [admin_core_diagnostics_diagnostics].doExecute | 285 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Fri, 24 Oct 2014 06:06:09 +0000 Error: 1091 - Can't DROP 'tag_grab'; check that column/key exists IP Address: - /forum/s_admin_s/index.php?adsess=124415c68ecb6c83b7c1ee6eeb870b4b&app=core&module=diagnostics§ion=diagnostics§ion=diagnostics&do=dbindex&fix=ibf_tags_index ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: ALTER TABLE ibf_tags_index DROP INDEX tag_grab, ADD INDEX tag_grab (app,type,type_id,type_2,type_id_2,tag_hidden) .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | s_admin_s/applications/core/modules_admin/diagnostics/diagnostics.php | [db_tools].dbIndexDiag | 795 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | s_admin_s/applications/core/modules_admin/diagnostics/diagnostics.php | [admin_core_diagnostics_diagnostics]._indexCheck | 110 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | s_admin_s/sources/base/ipsController.php | [admin_core_diagnostics_diagnostics].doExecute | 285 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'