[php-src] Issue #8512: PHP SQLite3 extension does not support FTS5 tables

From: Date: Sat, 07 May 2022 21:17:50 +0000
Subject: [php-src] Issue #8512: PHP SQLite3 extension does not support FTS5 tables
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-241436@lists.php.net to get a copy of this message
Issue: https://github.com/php/php-src/issues/8512 Author: neuron-whisperer ### Description The following code: ```php <?php $db = new SQLite3('foo.sqlite'); $db->prepare('select some_field from some_fts5_table'); ``` Resulted in this output: ``` SQLite3::prepare(): Unable to prepare statement: 1, no such module: fts5 ``` But I expected this output instead: ``` [no error message] ``` My webhost is running PHP 8.1 with the sqlite3 extension. For some reason, this configuration does not support FTS5 tables. Note - SQLite FTS5 is at least eight years old - see [this post from May 2014!](https://charlesleifer.com/blog/using-sqlite-full-text-search-with-python/) ### PHP Version PHP 8.1 ### Operating System Unknown (commercial webhost)

« previous php.bugs (#241436) next »