Module: Non-Temporary Search

All files from this thread

File Name	File Size		Posted by	Date
non_temp_search.php	9.1 KB	open | download	Thomas Seifert	04/01/2008	Read message
non_temp_search.php	9.3 KB	open | download	BillS	12/11/2011	Read message
non_temp_search.php	9.5 KB	open | download	BillS	10/20/2014	Read message

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.

---

Thomas Seifert

The Non-Temporary Search's PHRASE search did not work for me. I managed to get it to work. My two changes are prefixed with the comment "Bill 121111". See attached.

A big thanks to the original author!

Bill

The Any Words and All Words searches did not work for me.

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