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

Store Builder Questions
1

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;



Backtrace:

File: /var/www/vhost/tendabit.es/home/html/core/fn.database.php

Line: 310

Function: db_error

File: /var/www/vhost/tendabit.es/home/html/core/fn.search.php

Line: 197

Function: db_query

File: /var/www/vhost/tendabit.es/home/html/controllers/customer/search.php

Line: 26

Function: fn_search

File: /var/www/vhost/tendabit.es/home/html/core/fn.control.php

Line: 567

Function: include

File: /var/www/vhost/tendabit.es/home/html/core/fn.control.php

Line: 422

Function: fn_run_controller

File: /var/www/vhost/tendabit.es/home/html/index.php

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

2

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

3

Your database user does not have CREATE permission.

4

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:

5

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

6

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???