I have recently started working on Magento. I had to fix search issue wherein the products were not displayed on the frontend for some values of attribute "brand" even if the products exist for that brand in the database.
So i did Re indexing and cleared the cache, but these steps broke up my full search. i.e. full search functionality stopped working and also listing of products by categories. I did re indexing and cache clear again but it could not fix the issue.
I was able to fix the listing by categories issue when i found out that "catalog_product_index_price" was empty after re indexing. I repopulated the table with my backup data. But I'm still not able to fix the search.Can anyone tell me how i can fix this. What database tables are related to search?? and where the query is generated??