I recently setup a new site for testing at http://dbrs-test.com
Everything has been working fine except when I try to search. I get the following:
* user warning: Access denied for user: 'dbrs-tes_drupal@localhost' to database 'dbrs-tes_drupal' 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 = 'barron') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 in /home/dbrs-tes/public_html/includes/database.mysql.inc on line 172.
* user warning: Table 'dbrs-tes_drupal.temp_search_sids' doesn't exist query: SELECT MAX(relevance) FROM temp_search_sids in /home/dbrs-tes/public_html/includes/database.mysql.inc on line 172.
Any help is greatly appreciated.
Leo
Comments
More debugging issue
If I log into my site's db manager (ipowerweb, phpMyAdmin) using the user and password in settings.php I can create tables without any problems. Also, when I add modules to the site, tables are created without issue. It seems to be only when I am trying to search.
DBR Systems, Inc.
Indutrial Automation Experts