Not able to search text containing period
yngvewb - July 9, 2009 - 22:20
| Project: | Search and Replace |
| Version: | 5.x-1.1 |
| Component: | Code |
| Category: | bug report |
| Priority: | minor |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
I have titles with a lot of periods i.e. "ALEXANDER, John. Cisco CallManager fundamentals. 2a."
Search failed every time I tried to search with a text string containing a period.
To fix i added this line
$query_params[6] = str_replace ('.', '. ', $query_params[6]);just before this (line 756 in scanner.module)
$result = db_query("
SELECT t.%s as content, t.nid, n.title
FROM {%s} t
INNER JOIN {node} n ON t.%s = n.%s
$join
WHERE n.type = '%s' AND $where
", $query_params);
#1
This should have been posted in the Search and Replace scanner module issue queue. Sorry about that! Just delete this post please.