No announcement yet.

Database Error When Searching

  • Filter
  • Time
  • Show
Clear All
new posts

  • Wayne Luke
    Your tables are most likely INNODB. You cannot use FULL Text searching with INNODB tables. You will need to ask your host to change them post and thread tables to MyISAM.

    Leave a comment:

  • diecastfast
    Under vBulletin Options > Search, I chose the only available option, and now I forget what it was. Now under vBulletin Options > Search all I get is this.
    Your forum is currently using the vBulletin search engine.

    To enable the MySQL Fulltext search, we will issue the following two queries. If for some reason this process is unsuccessful, you will need to perform these queries manually. Please be patient as this can take from 10 seconds to an hour depending on the number of posts on your forum.

    ALTER TABLE db84650_post ADD FULLTEXT INDEX (title,pagetext)
    ALTER TABLE db84650_thread ADD FULLTEXT INDEX (title)

    Your post and thread table will be converted to the MyISAM type in order to support Fulltext searching.
    Empty postindex and word tables?
    When I choose Yes to the only option there, I get a db error.

    Also, now search doesn't return any results.

    Leave a comment:

  • Wayne Luke
    Under vBulletin Options -> Search, what is the search type set to? Set it to Database Search please.

    Leave a comment:

  • diecastfast
    started a topic Database Error When Searching

    Database Error When Searching

    Database error in vBulletin 3.8.7:
    Invalid SQL:
                            FROM db84650_thread AS thread 
                            WHERE MATCH(thread.title) AGAINST ('+term' IN BOOLEAN MODE);
    MySQL Error   : The used table type doesn't support FULLTEXT indexes
    Error Number  : 1214
    Request Date  : Thursday, October 24th 2013 @ 09:57:35 PM
    Error Date    : Thursday, October 24th 2013 @ 09:57:35 PM
    Script        :
    Referrer      :
    IP Address    :
    Username      : 
    Classname     : vB_Database
    MySQL Version : 5.5.32-cll
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.