Double results on advanced search (solved)

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

starting last week, we experience double results for each search (advanced search, aka solr)

https://SUITECRM/index.php?action=UnifiedSearch&module=Home&query_string=dobes

the results are doubled for almost all, but not all, beans

any idea on how to debug?

Suitecrm: **Version 7.11.18**
Sugar Version 6.5.25 (Build 344)
on linux, apache
#2

It’s not “solr”, it’s Lucene.

You could try Reindexing, especially if the database is not very big.

1 Like
#3

thanks,
I have the following

Screenshot from 2021-05-19 11-06-52
Screenshot from 2021-05-19 11-06-521384Ă—73 12.9 KB

(solr vs lucene, did not know, thanks)

#4

ok, I try the full reindex cited on your link, thanks!

#5

Solved!

Steps followed (exactly as in https://pgorod.github.io/Reindex-AOD/ ):

  • make a backup
  • SSH login, become root, and move to Suitecrm document_root
  • disable cron: crontab -u apache -e and comment out cron job
  • remove dir:
mv modules/AOD_Index/Index/Index modules/AOD_Index/Index/Index.BACKUP
  • empty tables:
mysql -u root -p
use MYDBNAME;
truncate table aod_index;
truncate table aod_indexevent;
exit
  • re-enable cron: crontab -u apache -e
  • start reindexing (force scheduler)

check the scheduler to know if the re-indexing operation is done.

super thanks to https://community.suitecrm.com/u/pgr

1 Like