Symptoms

Browser returns HTTP 500 error when searching

Impacted versions

Open Bee™ Portal version 6.x.

Causes 

The index tables in the database are corrupted. 

To confirm that this is the issue: 

mysqlcheck  -uroot -p obportal

Tables obp_document_index and/or obp_document_text should be marked as “crashed” 

Resolution

Repair the database: 

mysqlcheck -uroot -p  --auto-repair -A

If the repair fails, connect to mysql: 

mysql -uroot -p obportal

Repair the affected table from the FRM files. 

repair table XXX use_frm

Check that the base is repaired: 

mysqlcheck  -uroot -p obportal