Search Index Error

[Frank Hatfull]

If I try to run a "search" I always get the error:



An unexpected error was returned: ' Database error in vBulletin 5.0.0: Invalid SQL: CREATE TEMPORARY TABLE IF NOT EXISTS temp_search ( nodeid INT(11) NOT NULL DEFAULT 0



This is on a new installation of vB 5.

Many thanks Frank

[Trevor Hannant]

What's the next line of the error - it should start "MySQL Error:"

[Frank Hatfull]

Hi Trevor
The whole message is:

An unexpected error was returned: ' Database error in vBulletin 5.0.0: Invalid SQL: CREATE TEMPORARY TABLE IF NOT EXISTS temp_search ( nodeid INT(11) NOT NULL DEFAULT 0, score INT(11) NOT NULL DEFAULT 0, prev_position INT(11) NOT NULL DEFAULT 0, words_nr TINYINT(2) NOT NULL DEFAULT 1, distance DECIMAL(6,4) NOT NULL DEFAULT 1, is_title TINYINT(1) NOT NULL DEFAULT 0, PRIMARY KEY USING HASH (nodeid) ) ENGINE = MEMORY; MySQL Error : Access denied for user 'web52-najad1'@'%' to database 'web52-najad1' Error Number : 1044 Request Date : Tuesday, May 14th 2013 @ 09:12:34 AM Error Date : Tuesday, May 14th 2013 @ 09:12:34 AM Script : http:///forums/search?q=najad&searchJSON={"keywords":"najad"} Referrer : http://www.najadowners.com/forums/ IP Address : 86.159.188.213 Username : Frank Hatfull Classname : vB_Database_MySQLi MySQL Version : 5.5.30-log '