Search error

[skb]

Everytime the top level Search box is used, it generates the following error

Access denied for user 'xxxxxx'@'localhost' to database 'zzzzzzz01'
File: /home/diabesv6/public_html/Sources/Search.php
Line: 1248

The code around line 1248 is

Code Select Expand

$createTemporary = $smcFunc['db_search_query']('create_tmp_log_search_topics', '
CREATE TEMPORARY TABLE {db_prefix}tmp_log_search_topics (
id_topic int NOT NULL default {string:string_zero},
PRIMARY KEY (id_topic)
) ENGINE=MEMORY',
array(
'string_zero' => '0',
)
) !== false;


Error is generated for all users, including Admin. Any ideas what is causing this ?

[Arantor]

Your database user doesn't have permission to make temporary tables. Ask your host to change this.

[skb]

Thanks Arantor.

I did contact my hosting service, though the solution was available in the cPanel itself. marking this solved.