Advanced search in "message text only" crashes with SQL error when using Mysql fulltext search index

Get help with installation and running phpBB 3.1.x here. Please do not post bug reports, feature requests, or extension related questions here.
Scam Warning
Forum rules
READ: Board-Wide Rules and Regulations

NOTE: phpBB 3.1.x is at its End of Life stage and support will NOT be provided after July 1st, 2018.
Registered User
Posts: 172
Joined: Sun Jan 06, 2008 10:51 am

Advanced search in "message text only" crashes with SQL error when using Mysql fulltext search index

Post by BioLogIn »

Support Request Template
What version of phpBB are you using? phpBB 3.1.10
What is your board's URL?
Who do you host your board with? linode
How did you install your board? I used the download package from
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What version of phpBB3 did you update from? phpBB 3.1.9
What extensions do you have installed? viewtopic.php?p=14633611#p14633611
What styles do you currently have installed? prosilver
What language(s) is your board currently using? Ru, EN
Which database type/version are you using? MySQL 5
What is your level of experience? Comfortable with PHP and phpBB
What username can be used to view this issue? test
What password can be used to view this issue? testphpbb
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Migrated tables to InnoDB and switched to mysql fulltext search index.
Please describe your problem. Any advanced search with a setting "Search within: Message text only" results in SQL general error:

Code: Select all

    SQL ERROR [ mysqli ]

    Can't find FULLTEXT index matching the column list [1191]


    SELECT SQL_CALC_FOUND_ROWS p.post_id FROM phpbb_posts p WHERE MATCH (p.post_text) AGAINST ('+video ' IN BOOLEAN MODE) AND (p.post_visibility = 1 OR p.forum_id IN (1, 2, [long list of all forum IDs], 144)) ORDER BY p.post_time DESC LIMIT 250


    FILE: (not given by php)
    LINE: (not given by php)
    CALL: msg_handler()

    FILE: [ROOT]/phpbb/db/driver/driver.php
    LINE: 855
    CALL: trigger_error()

    FILE: [ROOT]/phpbb/db/driver/mysqli.php
    LINE: 193
    CALL: phpbb\db\driver\driver->sql_error()

    FILE: [ROOT]/phpbb/db/driver/mysql_base.php
    LINE: 45
    CALL: phpbb\db\driver\mysqli->sql_query()

    FILE: [ROOT]/phpbb/db/driver/driver.php
    LINE: 261
    CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

    FILE: [ROOT]/phpbb/db/driver/factory.php
    LINE: 321
    CALL: phpbb\db\driver\driver->sql_query_limit()

    FILE: [ROOT]/phpbb/search/fulltext_mysql.php
    LINE: 573
    CALL: phpbb\db\driver\factory->sql_query_limit()

    FILE: [ROOT]/search.php
    LINE: 590
    CALL: phpbb\search\fulltext_mysql->keyword_search()
    [size=60]Generated by SRT Generator[/size]

Return to “[3.1.x] Support Forum”