Search returns no results (ver 5.1x)
drupal-king - September 23, 2009 - 14:45
| Project: | Search Keywords |
| Version: | 5.x-1.0 |
| Component: | Code |
| Category: | support request |
| Priority: | critical |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
I am on 5.19 and the search does not work. I have tried everything but can't seem to get it to work.
- i have enabled search
- provided permissions
- 100% indexed the site
- checked the search_index table - i have 10000+ rows of content
- checked the other two search tables - and they too have records
- run cron manually and it completes successfully each time
not sure what else to do - i saw someone mentioned a patch but I can't find it anywhere -
can anyone help with this - please

#1
i just noticed that in the handbook it states:
"A technical note: To use the search module the database user needs the create temporary table permission. If you seem not to have it, ask your systems administrator to make sure it's granted to you"
I inquired of my hosting company and they said no they will not grant it...
I assume this is the issue - is there a way to get round this? or use a different search module?