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
Comment #1
mcurry commentedreassigning to drupal, as it was assigned to search_keywords, which has nothing to do with search.
Comment #2
jptavan commentedduplicate of http://drupal.org/node/41412 , "Seach requires CREATE TEMPORARY TABLE rights" (Status: by design)