By jorditr on

Hi you all.

I've uploaded a complete 4.7 site after three months of developement and editing on a local machine. Surprisingly the search engine drops the "Your search yielded no results" message despite being fully indexed with about 8000+ records on the search tables.

I've double checked everything: reloading the search tables, rebuilding the search indexes, deleting the cache, turning off and on the search module, with no results. The online site is an exact copy of the localhost site which works smoothly on every other aspect. Even writting the search url yields no results. The hosting machine has almost identical MySQL and PHP versions (slightly superior), the only difference is that the localhost Apache is 1.3.something and the hosting Apache is 2.0.something.

Has anyone faced something similar? A whole project release is stopped just by this detail coming from a core module. Thanks!

⋅ Categories: Drupal 4.7.x

Comments

mohamedn’s picture

mohamedn commented

Try running http://www.yoursite.com/cron.php if you haven't already. That may be causing it...

-
Qatar - A Community Site

jorditr’s picture

jorditr commented

As I mentioned on "rebuilding indexes". This is my fifth (medium-to-big) Drupal site. I can't understant at all what is happening. Any other technical insight?

jorditr’s picture

jorditr commented

I've decided to close that thread with the solution I've found on that case. I had no privileges on my sql database user for creating temporary tables. The search module uses temporary tables to store the result of some queries to query inside it. I've just had to ask the provider to habilitate such permission to the database user drupal was using to access the search data.

I had never found that issue and since on online sites I drive the error messages to the log and not to the screen I hadn't realize it. The devel module has been a big help, so thanks to its developers.