Hello
I read the node 224 to include description in search, i'd like to know how i can modify setup.sql to include the modification in the installation so the search will always be made on name AND description.
I plan on installing the script on several sites and i'd like avoiding to modify the db for every site.
Thanks
Pat
Hi Pat,
To modify setup.php look for the following line (102)
FULLTEXT KEY name_2 (name)...and change this as follows:
FULLTEXT KEY name_2 (name),FULLTEXT KEY ft_namedescription (name,description)
(note how you need to add a comma after the existing line...!)
Don't forget that you will also need the corresponding modifications in search.php to match they query against both name and description - described in this post in the other thread...
http://www.pricetapestry.com/node/224#comment-1304
Hope this helps!
Cheers,
David.