I am getting these errors when I try to search for content
and don't know where to start to fix this issue

* user warning: Access denied for user: 'uzbekmusic@%' to database 'uzbekmusic' 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 = 'yulduz') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 in /home/content/a/z/i/azizjon/html/includes/database.mysql.inc on line 120.
* user warning: Table 'uzbekmusic.temp_search_sids' doesn't exist query: SELECT MAX(relevance) FROM temp_search_sids in /home/content/a/z/i/azizjon/html/includes/database.mysql.inc on line 120.

Comments

mcurry’s picture

Project: Search Keywords » Drupal core
Version: 4.7.x-1.x-dev » 4.7.x-dev
Component: User interface » search.module

reassigning to drupal, as it was assigned to search_keywords, which has nothing to do with search.

jptavan’s picture

Status: Active » Closed (duplicate)

duplicate of http://drupal.org/node/41412 , "Seach requires CREATE TEMPORARY TABLE rights" (Status: by design)