Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-16423

Add Aria Engine to list of Fulltext Supported

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Minor Minor
    • 3.2.10-RC1, 3.3.1-RC1
    • None
    • Search
    • PHP 7.4, MariaDB 10.4, phpBB 3.3

      MySQL Fulltext index creation is currently only available for MyISAM and Innodb engines.

      The Aria engine from MariaDB is a replacement for MyISAM and allows Fulltext indexes. Please modify fulltext_mysql.php to check for and allow the Aria engine.

       

      $fulltext_supported =
       
       $engine === 'Aria' ||
       
       $engine === 'MyISAM' ||
       // FULLTEXT is supported on InnoDB since MySQL 5.6.4 according to
       // http://dev.mysql.com/doc/refman/5.6/en/innodb-storage-engine.html
       // We also require https://bugs.mysql.com/bug.php?id=67004 to be
       // fixed for proper overall operation. Hence we require 5.6.8.
       $engine === 'InnoDB' &&
       phpbb_version_compare($this->db->sql_server_info(true), '5.6.8', '>=');

       

       

       

            Marc Marc
            Frank Rizzo Frank Rizzo
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: