Some hosting providers will not allow temporary tables (e.g. mydomain.com, godaddy.com). The search module will not work without temporary tables. Although there is benefit in dynamic table creation, I think there should be a way to avoid it:
1) Try to create a temporary table in the database. If it fails, create a normal table and use that method.
2) Create normal tables always and avoid temporary tables.

I have seen this issue posted many times in the support forums and the answer doesn't seem to be that there are fixes only that people should switch hosting providers. For me, switching providers is not an option.

Thank you.

Comments

cosmicdreams’s picture

cosmicdreams commented
Project: » Drupal core
Version: » 6.x-dev
Component: accessibility » database system

Very Interesting... Perhaps this is the problem with a site I'm been playing with (hosted by GoDaddy). I think this should be triaged to the current dev base. Feel free to hit me over the head if I'm wrong.
I think it will get more eyeballs if it was there.

chx’s picture

chx commented
Status: Active » Closed (won't fix)

http://drupal.org/node/146466 removes the temp table usage from search and otherwise this is indeed a won't fix, a huge one at that.