Database error: Access denied for user ''@'%' to database '' (1044)

Hi all

I have this error with the basic search, really It is very weird because i have not done anything in my code and in my database previous to this error

I mean, one day it was working properly and the next day it was wrong

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

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


File: /var/www/vhost/

Line: 310

Function: db_error

File: /var/www/vhost/

Line: 197

Function: db_query

File: /var/www/vhost/

Line: 26

Function: fn_search

File: /var/www/vhost/

Line: 567

Function: include

File: /var/www/vhost/

Line: 422

Function: fn_run_controller

File: /var/www/vhost/

Line: 28

Function: fn_dispatch[/QUOTE]

Has anyone faced it before?

There is a thread about the same problem but inside this thread there is not a solution

thanks in advanced

did anyone find a fix, i also have the same problem.

Your database user does not have CREATE permission.

I think it is another thing, because when i make a fresh install i get this error not, when i change something disable products and categories and create new one then search i get the same error :frowning:

this was due to Your database user does not have CREATE permission, contact your hosting provider.

Not it is the error, it s a other error. Because now i have tested the “advanced search” and this works. And i think when the error appears because the database user havent enough rights to create temp tables, why the “advanced search” works???