Search Box Database Error


I have a problem with the search box, when I try do a search I get the following error…

Database error: Access denied for user ‘mydatabasename’@‘%’ to database ‘mydatabasename’ (1044)

Invalid query: CREATE TEMPORARY TABLE _search (id int NOT NULL, object varchar(30) NOT NULL, sort_field varchar(1) NOT NULL)ENGINE=HEAP;

If I do a search using Advanced search it works fine so not sure what the problem is. Has anybody come across this before and found a solution to this problem?

Thanks in advance.

You need to allow the SQL User access to create temporary tables on the database.

Contact your webhost requesting that this be done.

I have the same error. Is there a reason why a basic search function would need to create temporary tables? I have never encountered this on other web scripts.

What is “other web scripts”?

The error and Jessie's statement are facts.

Temporary tables are used to do intermediate sorting and selection.