SQLite Searching is Broken

[elasticdog]

Running rev1293 of Habari and using SQLite v3.5.4, the search functionality is broken. Issuing a search with no searchterm will load a page just fine, but putting anything else in search box will error and give you a blank page in the web browser.

In the admin interface, the error log shows:

theme January 17, 2008 PDO::prepare() [function.PDO-prepare]: SQLSTATE[HY000]: General error: 1 no such function: CONCAT in /srv/www/nginx/elasticdog.com/habari/system/classes/error.php line 80

[ringmaster]

Proper CONCAT syntax in SQLite is different than MySQL. The proper SQL statement would look like this:

$where[] .= "(title LIKE '%' ? '%' OR content LIKE '%' ? '%')";

This needs to be integrated into the sql_t() function in the SQLite DatabaseConnection class.

[ringmaster]

In r1294.