Advanced Search broken

💬 General Discussion
1

Problem started on 7.10.9

When I enter a search parameter in the search field on the top right of the screen I get a blank screen with the option “Use Basic Search”. I looks liek the advanced search option is broken because I can access Basic Search and on top of the search page is the option “Use Advanced Search” but when I choose Advanced it brings me back to the blank screen with the “Use Basic Search” option.

It was working fine yesterday. Last night I backed up the database and created a tar.ga manual backup of my SuiteCRM instance using the terminal. I made no changes to the SuteCRM settings.

I have since tried a “Quick Repair and Rebuild” without luck. I also cloned my server and updated to 7.10.10 but the problem persists.

Any ideas on how to recover Advanced Search capabilities would be hugely appreciated…

2

Look in both your logs, you should find a FATAL error when the screen blanks out. That error might contain important clues.

suitecrm.log
php_errors.log

Then you might have a corrupted AOD Index, and you can rebuild it. But I wouldn’t think about this until I checked the logs, there’s no point in guessing when there might be specific information error waiting for you.

3

Here is the output from suitecrm.log (I’ve cut the directory structure out of the log).

Fri Nov 2 12:57:57 2018 [1125][1][FATAL] Exception handling in …/include/MVC/Controller/SugarController.php:400
Fri Nov 2 12:57:57 2018 [1125][1][FATAL] Exception in Controller: Unsupported segments file format
Fri Nov 2 12:57:57 2018 [1125][1][FATAL] backtrace:
#0 …/modules/AOD_Index/Lib/Zend/Search/Lucene.php(572): Zend_Search_Lucene->_readSegmentsFile()
#1 …/modules/AOD_Index/AOD_Index.php(360): Zend_Search_Lucene->__construct(‘modules/AOD_Ind…’)
#2 …/modules/AOD_Index/AOD_Index.php(81): AOD_Index->getLuceneIndex()
#3 …/modules/Home/UnifiedSearch.php(234): AOD_Index->find(‘test’)
#4 …/modules/Home/UnifiedSearch.php(84): doSearch(Object(AOD_Index), ‘test’, 0, 20)
#5 …/include/MVC/View/SugarView.php(818): include_once(’/var/www/html/M…’)
#6 …/include/MVC/View/views/view.classic.php(72): SugarView->includeClassicFile(‘modules/Home/Un…’)
#7 …/include/MVC/View/SugarView.php(211): ViewClassic->display()
#8 …/include/MVC/Controller/SugarController.php(435): SugarView->process()
#9 …/include/MVC/Controller/SugarController.php(375): SugarController->processView()
#10 …/include/MVC/SugarApplication.php(113): SugarController->execute()
#11 …/index.php(52): SugarApplication->execute()

SuiteCRM is running on Apache.

I turned on php_errors.log and replicated the error but nothing showed up in php_errors.log.

Any clues?

4

That sounds to me like a corrupted AOD Index, it happens sometimes.

I recommend a full Rebuild, check this post

https://pgorod.github.io/Reindex-AOD/

1 Like
5

Huge help!

After following your suggestion and instructions the Advanced Search feature re-appeared. The re-indexing will take a while to complete because our database is huge but it sees to be working.

Thanks!