By Wolfflow on

Search access denied after using advanced search with a standard Drupal 5 Beta 1
installation at http://www.adaccs.at/test/ : user : Drupal5 psw: thebest

here mysql log message:


user warning: Access denied for user: 'xxxxxxx@%.%' to database 'xxxxxxx_test' 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 (n.type = 'forum') AND (i.word = 'lock') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 in /home/xxxxxxx/www/home/test/includes/database.mysql.inc on line 167.
user warning: Table 'xxxxxxx_test.temp_search_sids' doesn't exist query: SELECT MAX(relevance) FROM temp_search_sids in /home/xxxxxxx/www/home/test/includes/database.mysql.inc on line 167.

⋅ Categories: Drupal 5.x

Comments

lamb0176 at umn dot edu’s picture

lamb0176 at umn dot edu commented

My guess is your hosting service, like mine, doesn't allow you to create temporary tables. I hope Drupal decides to move away from using temporary tables; even though I can see the benefit, it prevents some people from using Drupal.