(Not a duplicate of the 'prefix' temp_search_sids issue, to my understanding, as I'm not using prefixes anyway.)

Table 'cv_drupal.temp_search_sids' doesn't exist query: SELECT MAX(relevance) FROM temp_search_sids in /includes/database.mysql.inc on line 124.

If there are no results returned from search_index during the CREATE TEMP TABLE query, a watchdog SQL error is logged because the temp table doesn't exist.

Type php
Date Sunday, 12 February, 2006 - 19:01
User Guest
Location /search/node/adult
Referrer /search/node/xxx
Message Table 'cv_drupal.temp_search_sids' doesn't exist query: SELECT MAX(relevance) FROM temp_search_sids in includes/database.mysql.inc on line 124.
Severity error
Hostname [removed]

The code, at line 843 of search.module ($Id: search.module,v 1.159 2006/01/22 07:43:19 dries Exp $) needs to check to see if the table exists before executing the query on line 846. (Or at least use an @ to suppress the error)

Comments

Signe’s picture

Signe commented

I'm a dumbass. It is the permissions failure for CREATE TEMP TABLE, however the issue still stands. If the table creation fails the code doesn't check for that failure and just blindly continues.

RaRi’s picture

RaRi commented

mmh .. guess I need to wait for an update ..

ckclarke’s picture

ckclarke commented

I'm getting this error as well on RC1; I notice also that the site indexing is not working, even if I manually ask it to reindex the site. It's still reporting 22 items not indexed.

killes@www.drop.org’s picture

killes@www.drop.org commented
Status: Active » Closed (won't fix)

You need "CREATE TABLE" permission for your mysql user.

Lappie’s picture

Lappie commented

Actually, you'll need 'CREATE TEMPORARY TABLE' permissions. See this reply by Killes elsewhere.