Announcement

Collapse
No announcement yet.

Search Index Error

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Frank Hatfull
    replied
    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 '

    Leave a comment:


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

    Leave a comment:


  • Frank Hatfull
    started a topic Search Index Error

    Search Index Error



    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

Related Topics

Collapse

  • Frank Hatfull
    Search Index Error
    by Frank Hatfull
    If I try to do a search on our new v5 forum I get an error:

    An unexpected error was returned: ' Database error in vBulletin 5.0.0: Invalid SQL: CREATE TEMPORARY TABLE IF NOT EXISTS temp_search...
    Tue 28 May '13, 5:00am
Working...
X