Changes
Jump to navigation
Jump to search
← Older edit
User:Hef/rt search
(view source)
Revision as of 04:39, 27 August 2014
52 bytes removed
,
04:39, 27 August 2014
→More output
Line 6:
Line 6:
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/rt";
+
) ENGINE=SPHINX CONNECTION="sphinx://
127.0.0.1
:9312/rt"
CHARACTER SET utf8
;
</pre>
</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 26:
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 31:
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 73:
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 menu
Personal tools
English
Log in
Request account
Namespaces
User page
Discussion
Variants
Views
Read
View source
View history
More
Search
Navigation
Main page
Recent changes
Random page
Help about MediaWiki
Tools
User contributions
Logs
View user groups
Special pages
Printable version