XF 2.2 Error code when trying to delete a post

[tommydamic68]

Hello,
hopefully someone can help. A member was posting and she did a duplicate post on accident. When I try to deleted either post I am getting this error. Not sure if its coincidence but my site is running really slow suddenly.

XF\Db\Exception: MySQL statement prepare error [144]: Table './admin_dbxcom/xf_search_index' is marked as crashed and last (automatic?) repair failed in src/XF/Db/AbstractStatement.php at line 228
XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 289
XF\Db\AbstractAdapter->delete() in src/XF/Search/Source/MySqlFt.php at line 126
XF\Search\Source\MySqlFt->delete() in src/XF/Search/Search.php at line 122
XF\Search\Search->delete() in src/XF/Behavior/Indexable.php at line 81
XF\Behavior\Indexable->XF\Behavior\{closure}() in src/XF.php at line 341
XF::triggerRunOnce() in src/XF/Mvc/Dispatcher.php at line 156
XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
XF\App->run() in src/XF.php at line 488
XF::runApp() in index.php at line 20

Just checked my control panel, I have about 7000+ ages of this error as well.

 

[Paul B]

Repair or truncate the xf_search_index table using phpMyAdmin.

Then rebuild the search index in the ACP.

 

[tommydamic68]

Repair or truncate the xf_search_index table using phpMyAdmin.

Then rebuild the search index in the ACP.

I get this error after performing this process. thought?

 

[tommydamic68]

Also I've tried doing this from SSH and it says command not found.

[root@cloud ~]# TRUNCATE TABLE xf_search_index;


-bash: TRUNCATE: command not found

 

[djbaxter]

From phpMyAdmin, use this SQL query:

TRUNCATE TABLE 'xf_search_index';

The error above indicates you left out the word TABLE.

 

[tommydamic68]

From phpMyAdmin, use this SQL query:

TRUNCATE TABLE 'xf_search_index';

The error above indicates you left out the word TABLE.

I've tried both, same exact error.

 

[Kirby]

The error above indicates you left out the word TABLE.

The second error indicates that he tried to run TRUNCATE directly on the prompt instead within mysql.

Despite that, TABLE is optional so it should work with or without that keyword - but definitly not with quotes around the table name (backticks can be used)

 

[tommydamic68]

The second error indicates that he tried to run TRUNCATE directly on the prompt instead within mysql

not sure if this is what your referencing, I'm running it here.

 

[Kirby]

I was refering to https://xenforo.com/community/threads/error-code-when-trying-to-delete-a-post.194984/post-1520089 - this error mesaage clearly shows that you tried a TRUNCATE as a shell comnand; this won't work.

 

[tommydamic68]

I was refering to https://xenforo.com/community/threads/error-code-when-trying-to-delete-a-post.194984/post-1520089 - this error mesaage clearly shows that you tried a TRUNCATE as a shell comnand; this won't work.

I"m only going by this post I found.

 

[Kirby]

Well ... that post is incorrect

TRUNCATE xf_seach_index in phpMyAdmin should work.

In SSH you can try mysql -e 'TRUNCATE xf_search_index' but that does require the mysql command line client to be installed and configured properly.

 

[tommydamic68]

Well ... that post is incorrect

TRUNCATE xf_seach_index in phpMyAdmin should work.

In SSH you can try mysql -e 'TRUNCATE xf_search_index' but that does require the mysql command line client to be installed and configured properly.

When I run what you hav there I get this error.

 

[MisakiTaro]

As It said, you must select your database first.

For example I'm using silicone_xf database. You should click it, after that run from there.

 

[tommydamic68]

When I run what you hav there I get this error.

View attachment 252623

Tried SSH as well and get this.

 

[djbaxter]

As It said, you must select your database first.

For example I'm using silicone_xf database. You should click it, after that run from there.

^^^ this

Your TRUNCATE query is failing because you haven't selected a database to which it should be applied.

 

[tommydamic68]

^^^ this

Your TRUNCATE query is failing because you haven't selected a database to which it should be applied.

Ok, I think I figured it out, emptied from here see the image below. Rebuilding the search index now to see if this fixes the issue.

 

[tommydamic68]

Site seems to be working correctly again, thanks all for the help.

 

[Mike]

For future reference, the option to delete the search index before rebuilding should run the truncate command internally (for the default search at least), so it'd effectively do this for you.

(On a side note, if you're running into this in any frequency, it may indicate either a server issue or a server config issue -- or MySQL being shutdown ungracefully. It probably requires server investigation.)

 

[tommydamic68]

For future reference, the option to delete the search index before rebuilding should run the truncate command internally (for the default search at least), so it'd effectively do this for you.

(On a side note, if you're running into this in any frequency, it may indicate either a server issue or a server config issue -- or MySQL being shutdown ungracefully. It probably requires server investigation.)

Thanks Mike, this is the first time this has happened on on site.