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
It looks like your MySQL
It looks like your MySQL user may not have the CREATE TEMPORARY TABLES privilege.
I can not do that!
Exists other way to solve that problem?
update
I use the solution in http://drupal.org/node/49644#comment-111742
tvm