Announcement

Collapse
No announcement yet.

Database Error When Searching

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

  • Database Error When Searching

    Code:
    Database error in vBulletin 3.8.7:
    
    Invalid SQL:
    
                            SELECT
                            thread.threadid
                            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        : http://www..com/forums/search.php?do=process
    Referrer      : http://www..com/forums/search.php
    IP Address    : 189.172.160.28
    Username      : 
    Classname     : vB_Database
    MySQL Version : 5.5.32-cll
    Help?

  • #2
    Under vBulletin Options -> Search, what is the search type set to? Set it to Database Search please.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #3
      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.

      Comment


      • #4
        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.
        Translations provided by Google.

        Wayne Luke
        The Rabid Badger - a vBulletin Cloud demonstration site.
        vBulletin 5 API - Full / Mobile
        Vote for your favorite feature requests and the bugs you want to see fixed.

        Comment

        widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
        Working...
        X