Wanted to fix the site search today and found the problem was database permissions. To fix I just granted the necessary permissions. Of course, I could only do that because I have access to the root MySQL account. Other Drupal sites on shared web hosting accounts might have to come up with other solutions. I’ve listed a few of these below.