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.