Search Box Database Error

Store Builder Questions
1

Hi



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.

2

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



Contact your webhost requesting that this be done.

3

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.

4

What is “other web scripts”?

The error and Jessie's statement are facts.



Temporary tables are used to do intermediate sorting and selection.