Closed (fixed)
Project:
SQL Search (Trip Search)
Version:
4.7.x-1.x-dev
Component:
Miscellaneous
Priority:
Critical
Category:
Support request
Assigned:
Reporter:
Created:
5 Jan 2007 at 18:01 UTC
Updated:
8 Feb 2007 at 17:00 UTC
This should be a piece of cake to those of you veterans, but to someone like me who knows hardly anything about programming, I can only scratch my head.
In the installation instructions text file that comes with the trip_search module, it says that I have to "Enable MySQL full text indexing, by running the sql in full_text_indices.mysql. This will add special "full text" indices to the node and taxonomy tables."
How do I go about enabling the full_text_indices.mysql file? I really appreciate it if someone could give me more detailed clues.
Thanks in advance.
Comments
Comment #1
joel_guesclin commentedYou need to use a front-end administration tool for MySQL. On most sites that I know, the site hoster offers access to PHPMyAdmin. When in PHPMyAdmin, select the database where you want to create the indexes, then click on the "SQL" tab. Copy/paste the lines in the full_text_indices.mysql file that have the "create index" commands, and press "GO". That should build your indexes ok.
I should really put all this into the installer one day...
Comment #2
elvis2 commentedHi Joel,
Yes, could you please put this in an installer. Anxiously waiting.
Comment #3
mindless commentedI put together a trip_search.install file. I'll commit it when I get CVS access.
Comment #4
mindless commentedtrip_search.install file now added in cvs.
Comment #5
(not verified) commented