I'm experiencing an interesting problem with SharePoint 2010 Foundation Search and was hoping someone already faced the same issue.
Here is some technical background. I have a site with about 20 custom lists. Most of them have tens to hundreds records, one has 2,000+ records and the biggest one is 12,000+ records (resource limits have been adjusted). The search is using two dedicated accounts (for the search service and crawling access). Content database is referencing the one and only search server. The web application has a local default address (http://portal) and an Internet address (https://portal..com).
I created and re-created the search service application a few times. It starts normally (creating a new search database) and then crawls without any problem (no errors in the Event Log and in the search database log tables). However, if I try searching ANY of the lists, it will only search in the Title column, although I created a few indices on most lists and expect more results. Even ID columns are not being indexed for some reason.
Did anyone have the same problem? I would appreciate any ideas - what else I have to check/fix in order to make it work. This is not the first SPF project I did. No fancy configurations, just normal deployment with quite a bit of custom code.
Many thanks. Alex