My users get these errors when searching my site:
* user warning: Access denied for user 'chrityru'@'localhost' to database 'chrityru' query: CREATE TEMPORARY TABLE temp_search_sids SELECT i.type, i.sid, SUM(i.score * t.count) AS relevance, COUNT(*) AS matches FROM sudoku_search_index i INNER JOIN sudoku_search_total t ON i.word = t.word INNER JOIN sudoku_node n ON n.nid = i.sid INNER JOIN sudoku_users u ON n.uid = u.uid WHERE n.status = 1 AND (i.word = 'download') AND i.type = 'node' GROUP BY i.type, i.sid HAVING COUNT(*) >= 1 in /home/www/chrityru/sudoku/includes/database.mysql.inc on line 120.
* user warning: Table 'chrityru.temp_search_sids' doesn't exist query: SELECT MAX(relevance) FROM temp_search_sids in /home/www/chrityru/sudoku/includes/database.mysql.inc on line 120.
where 'chrityru' is the db name and username.
May I also point out the search doesn't work at all - my site's about sudoku yet searching for 'sudoku' yields no results whatsoever.
Comments
Temporary tables
Give your db user the 'CREATE TEMPORARY TABLES' permission and all should be well.
--
The Manual | Troubleshooting FAQ | Tips for posting | Make Backups! | Consider creating a Test site.
search
Have you run cron yet? Search builds an index when you run the cron.php script at the root directory and uses that to find results.
------------------------------------
Ronan
Founder - NodeSquirrel - https://www.nodesquirrel.com/
Agency Tools Lead - Pantheon - https://www.pantheon.io/