Anonymous
Not logged in
Log in
Request account
Search
Changes
From Pumping Station One
Namespaces
User page
Discussion
More
More
Languages
Page actions
Read
View source
History
User contributions
← Older edit
User:Hef/rt search
(view source)
Revision as of 04:39, 27 August 2014
40 bytes removed
,
04:39, 27 August 2014
→More output
Line 2:
Line 2:
== Create Table ==
== Create Table ==
+
+
<pre>
CREATE TABLE AttachmentsIndex
CREATE TABLE AttachmentsIndex
(
(
−
id
INTEGER UNSIGNED
NOT NULL,
+
id
BIGINT
NOT NULL,
weight INTEGER NOT NULL,
weight INTEGER NOT NULL,
query VARCHAR(3072) NOT NULL,
query VARCHAR(3072) NOT NULL,
group_id INTEGER,
group_id INTEGER,
INDEX(query)
INDEX(query)
−
) ENGINE=SPHINX CONNECTION="sphinx://
localhost
:9312/
test
";
+
) ENGINE=SPHINX CONNECTION="sphinx://
127.0.0.1
:9312/
rt
"
CHARACTER SET utf8
;
+
</pre>
== More output ==
== More output ==
−
<pre>
−
You can now configure RT to use the newly-created full-text index by
+
I added The
following to RT_SiteConfig.pm
−
adding the
following to
your
RT_SiteConfig.pm
:
+
<pre>
Set( %FullTextSearch,
Set( %FullTextSearch,
Enable => 1,
Enable => 1,
Line 23:
Line 25:
Table => 'AttachmentsIndex',
Table => 'AttachmentsIndex',
);
);
+
</pre>
Below is a simple Sphinx configuration which can be used to index all
Below is a simple Sphinx configuration which can be used to index all
Line 28:
Line 31:
ideal; you should read the Sphinx documentation to understand how to
ideal; you should read the Sphinx documentation to understand how to
configure it to better suit your needs.
configure it to better suit your needs.
+
<pre>
source rt {
source rt {
Line 70:
Line 74:
unlink_old = 1
unlink_old = 1
}
}
+
</pre>
</pre>
−
== Prime things ==
== Prime things ==
Hef
Bureaucrats
,
Administrators
3,430
edits
Cookies help us deliver our services. By using our services, you agree to our use of cookies.
More information
OK
Navigation
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
Wiki tools
Wiki tools
Special pages
Page tools
Page tools
Userpage tools
Logs
View user groups
More
Printable version