SQLSTATE[HY000]: General error: 144 Table './wcf/wbb1_post_search_index' is marked as crashed and last (automatic?) repair failed

greatestmj · Sep 7th 2016

Hi there,

Just this morning out of nowhere something crashed on my database.

SQLSTATE[HY000]: General error: 144 Table './wcf/wbb1_post_search_index' is marked as crashed and last (automatic?) repair failed

Code

Time
Sep 7th 2016, 7:38am
File (Line)
/teenhut.net/public/wcf/lib/system/database/Database.class.php (231)
Requested URL
/index.php?ajax-proxy/&
Referrer
http://www.teenhut.net/thread-add/63/
User Agent
Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0.2743.116 Safari/537.36
Stacktrace
#0 
/teenhut.net/public/lib/data/thread/Thread.class.php(390): wcf\system\database\Database->prepareStatement('SELECT\t\tpost.th...', 5)
#1 /teenhut.net/public/lib/data/thread/ThreadAction.class.php(1748): wbb\data\thread\Thread::getSimilarThreads('fdgdfgd', Array, 5, 63, 0, NULL)
#2 [internal function]: wbb\data\thread\ThreadAction->getSimilarThreads()
#3 /teenhut.net/public/wcf/lib/data/AbstractDatabaseObjectAction.class.php(196): call_user_func(Array)
#4 /teenhut.net/public/wcf/lib/action/AJAXProxyAction.class.php(77): wcf\data\AbstractDatabaseObjectAction->executeAction()
#5 /teenhut.net/public/wcf/lib/action/AJAXInvokeAction.class.php(96): wcf\action\AJAXProxyAction->invoke()
#6 /teenhut.net/public/wcf/lib/action/AbstractAction.class.php(49): wcf\action\AJAXInvokeAction->execute()
#7 /teenhut.net/public/wcf/lib/action/AJAXInvokeAction.class.php(63): wcf\action\AbstractAction->__run()
#8 /teenhut.net/public/wcf/lib/system/request/Request.class.php(58): wcf\action\AJAXInvokeAction->__run()
#9 /teenhut.net/public/wcf/lib/system/request/RequestHandler.class.php(139): wcf\system\request\Request->execute()
#10 /teenhut.net/public/index.php(10): wcf\system\request\RequestHandler->handle('wbb')
#11 {main}

Display More

There is EXCEPTION ERROR everytime I

Make a new thread
Make a new post
Delete a post or a thread

There is no problem in adding visitor message or chatting in shoutbox etc.

So it seems problem is specific to posts and probably related to search index.

**Andrea Berg** · Sep 7th 2016

According to the error message, the table is broken in the database and could not be repaired automatically. Execute the following SQL query in phpMyAdmin to re-create the table. Thereafter, the search index needs to be rebuilt in the ACP.

SQL

DROP TABLE IF EXISTS `wbb1_post_search_index`;
CREATE TABLE `wbb1_post_search_index` (
  `objectID` int(10) NOT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `message` mediumtext COLLATE utf8_unicode_ci,
  `metaData` mediumtext COLLATE utf8_unicode_ci,
  `time` int(10) NOT NULL DEFAULT '0',
  `userID` int(10) DEFAULT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `languageID` int(10) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Search index for com.woltlab.wbb.post';




ALTER TABLE `wbb1_post_search_index`
  ADD UNIQUE KEY `objectAndLanguage` (`objectID`,`languageID`),
  ADD KEY `language` (`languageID`),
  ADD KEY `user` (`userID`,`time`);
ALTER TABLE `wbb1_post_search_index` ADD FULLTEXT KEY `fulltextIndex` (`subject`,`message`,`metaData`);
ALTER TABLE `wbb1_post_search_index` ADD FULLTEXT KEY `fulltextIndexSubjectOnly` (`subject`);

Display More

greatestmj · Sep 7th 2016

Strange. Before I was going to run the query I just decided to check if the problem is still there and now posts are going normally. Posts are deleting also without an issue. New threads also no issue.

very strange.

**Andrea Berg** · Sep 7th 2016

Probably your web host was just faster than you and the automatic repair has now worked.

SQLSTATE[HY000]: General error: 144 Table './wcf/wbb1_post_search_index' is marked as crashed and last (automatic?) repair failed

Participate now!

Share