Module: Non-Temporary Search This module plugs into the search-functionality bypassing the core search implementation to search without the use of temporary tables (in mysql, won't work with any other layer probably). Its only purpose is to provide some search functionality for the users which can't get their ISP/host to fix the permissions for allowing temporary tables. Beware, it might get really slow! Better get your host to fix your mysql-permissions! For installing and using this module just drop the attached .php file into the mods folder (directly, not into another directory) and enable it through the admin at the modules page. https://www.phorum.org/support/read.php?62,126861,126861#msg-126861 Sun, 13 Sep 2026 14:07:01 -0500 Phorum 6.0.4 https://www.phorum.org/support/read.php?62,126861,155474#msg-155474 Re: Non-Temporary Search hack to fix PHRASE search https://www.phorum.org/support/read.php?62,126861,155474#msg-155474
I found a bug in the addon where the query built looked like this:

SELECT message FROM table WHERE search_text LIKE ('%term1%' OR '%term2%' OR '%term3%')

but MySQL doesn't like that. Fixed to look like this

SELECT message FROM table WHERE search_text LIKE '%term1%' OR search_text LIKE '%term2%' OR search_text LIKE '%term3%'

and that seems to work! My latest change is prefixed with comment "Bill 101914"

Bill]]> BillS v5/v6 Modules/Add-Ons Mon, 20 Oct 2014 13:45:32 -0500 https://www.phorum.org/support/read.php?62,126861,150578#msg-150578 Non-Temporary Search hack to fix PHRASE search https://www.phorum.org/support/read.php?62,126861,150578#msg-150578
A big thanks to the original author!

Bill]]> BillS v5/v6 Modules/Add-Ons Sun, 11 Dec 2011 19:19:48 -0600 https://www.phorum.org/support/read.php?62,126861,126861#msg-126861 Module: Non-Temporary Search https://www.phorum.org/support/read.php?62,126861,126861#msg-126861 to search without the use of temporary tables (in mysql, won't work with any other layer probably).
Its only purpose is to provide some search functionality for the users which can't get their ISP/host to fix the permissions for allowing temporary tables.
Beware, it might get really slow! Better get your host to fix your mysql-permissions!

For installing and using this module just drop the attached .php file into the mods folder (directly, not into another directory) and enable it through the admin at the modules page.]]> Thomas Seifert v5/v6 Modules/Add-Ons Tue, 08 Jan 2008 15:59:14 -0600