How do you remove Unindexed records

💬 General Discussion
1

In doing some testing I added some leads and did some test converts to accounts, etc., and deleted them all.

I went to …/index.php?module=AOD_Index

and see that I have:

Total records 193
Indexed records 199
Unindexed records -6
Failed records 0
Index file count 15
Last optimised 2014-05-09 18:12:35

Clicking the “Optimise Now” button does nothing. I even manually ran the cron job and stats are the same.

Curious, how do you get rid of them? Maybe by optimizing the database in phpMyAdmin?

Thanks.

2

Would you recommend that I rebuild the index via this post?

http://suitecrm.com/index.php?option=com_kunena&view=topic&catid=10&id=949&Itemid=1136#4094

3

No one answered (true, it is the weekend) so I went ahead and deleted the directory and emptied the two tables and when the cron job ran all was fine.

I did have to logout of SuiteCRM and log back in to get the search to work again. That somewhat surprised me.