HI,

I'm receiving the following errors when I try to perform a content search:

‚Access denied for user 'w****' to database 'wa5303_db1' query: CREATE TEMPORARY TABLE temp_search_sids SELECT i.type, i.sid, SUM(i.score * t.count) AS relevance, COUNT(*) AS matches FROM search_index i INNER JOIN search_total t ON i.word = t.word INNER JOIN node n ON n.nid = i.sid INNER JOIN users u ON n.uid = u.uid WHERE n.status = 1 AND (i.word = 'abend') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1‘ in ‚/****/australien-community/includes/database.mysql.inc‘ in Zeile 120.

AND

Table 'wa5303_db1.temp_search_sids' doesn't exist query: SELECT MAX(relevance) FROM temp_search_sids‘ in ‚/home/****/includes/database.mysql.inc‘ in Zeile 120.

Does anyone know what I need to do to get rid of this error so I'm able to use the search function?

THX!

kai

Comments

gonzocoder’s picture

It looks like your MySQL user may not have the CREATE TEMPORARY TABLES privilege.

guidocecilio’s picture

Exists other way to solve that problem?

update
I use the solution in http://drupal.org/node/49644#comment-111742

tvm