You need to repair ow_base_search_entity table

Hi Ross,

My host have checked the case and executed the following command:

Code:

mysql> check table ow_base_search_entity;
+---------------------------------------+-------+----------+----------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------------+-------+----------+----------------------------------------------------------+
| myvirgo3_oxwall.ow_base_search_entity | check | warning | Table is marked as crashed and last repair failed |
| myvirgo3_oxwall.ow_base_search_entity | check | warning | Size of indexfile is: 298145792 Should be: 26186752 |
| myvirgo3_oxwall.ow_base_search_entity | check | error | Record-count is not ok; is 1443861 Should be: 109886 |
| myvirgo3_oxwall.ow_base_search_entity | check | warning | Found 1443861 key parts. Should be: 109886 |
| myvirgo3_oxwall.ow_base_search_entity | check | error | Corrupt |
+---------------------------------------+-------+----------+----------------------------------------------------------+

After that they repaired the table via SSH:

Code:

mysql> repair table ow_base_search_entity;
+---------------------------------------+--------+----------+------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------------+--------+----------+------------------------------------------+
| myvirgo3_oxwall.ow_base_search_entity | repair | error | myisam_sort_buffer_size is too small |
| myvirgo3_oxwall.ow_base_search_entity | repair | warning | Number of rows changed from 0 to 1443861 |
| myvirgo3_oxwall.ow_base_search_entity | repair | status | OK |
+---------------------------------------+--------+----------+------------------------------------------+

Now the table is returning OK status:

Code:

mysql> check table ow_base_search_entity;
+---------------------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+---------------------------------------+-------+----------+----------+
| myvirgo3_oxwall.ow_base_search_entity | check | status | OK |
+---------------------------------------+-------+----------+----------+

Is the issue resolved after repairing?

Hi Ross,

Still i get :

Error details: Type: Exception Message: SQLSTATE[HY000]: General error: 144 Table './myvirgo3_oxwall/ow_base_search_entity' is marked as crashed and last (automatic?) repair failed File: /home/myvirgo3/public_html/ow_core/database.php Line: 707 Trace: #0 /home/myvirgo3/public_html/ow_core/database.php(707): PDOStatement->execute() #1 /home/myvirgo3/public_html/ow_core/database.php(435): OW_Database->execute('?? U...', Array) #2 /home/myvirgo3/public_html/ow_system_plugins/base/bol/search_entity_dao.php(684): OW_Database->query('?? U...', Array) #3 /home/myvirgo3/public_html/ow_system_plugins/base/classes/mysql_search_storage.php(162): BOL_SearchEntityDao->setEntitiesStatusByTags(Array, 'deleted') #4 /home/myvirgo3/public_html/ow_core/text_search_manager.php(199): BASE_CLASS_MysqlSearchStorage->deleteAllEntitiesByTags(Array) #5 /home/myvirgo3/public_html/ow_plugins/forum/bol/text_search_service.php(95): OW_TextSearchManager->deleteAllEntitiesByTags(Array) #6 /home/myvirgo3/public_html/ow_plugins/forum/bol/text_search_service.php(145): FORUM_BOL_TextSearchService->deletePost('14') #7 /home/myvirgo3/public_html/ow_plugins/forum/bol/forum_service.php(1399): FORUM_BOL_TextSearchService->saveOrUpdatePost(Object(FORUM_BOL_Post)) #8 /home/myvirgo3/public_html/ow_plugins/forum/bol/forum_service.php(1173): FORUM_BOL_ForumService->saveOrUpdatePost(Object(FORUM_BOL_Post)) #9 /home/myvirgo3/public_html/ow_plugins/forum/controllers/add_topic.php(188): FORUM_BOL_ForumService->addTopic(Object(FORUM_BOL_Group), '0', 1, Array, Object(FORUM_BOL_Section)) #10 [internal function]: FORUM_CTRL_AddTopic->index(Array) #11 /home/myvirgo3/public_html/ow_core/request_handler.php(266): call_user_func_array(Array, Array) #12 /home/myvirgo3/public_html/ow_core/application.php(329): OW_RequestHandler->dispatch() #13 /home/myvirgo3/public_html/index.php(73): OW_Application->handleRequest() #14 {main}

Clear the browser cache, enable dev mode and refresh the website couple of times if the issue persists, then you need to repair the database again. 

Okay will do that...!!!