Why doesn't Special:Search ever find anything on my test wiki that is on a computer powered up only a few hours every few days? Must be some mysterious cron function. OK, this looks like it will manually refresh things: $ php rebuildtextindex.php Dropping index... A database query syntax error has occurred. The last attempted database query was: "ALTER TABLE `searchindex` DROP INDEX si_title, DROP INDEX si_text" from within function "dropTextIndex". MySQL returned error "1142: ALTER command denied to user 'wikiuser'@'localhost' for table 'searchindex' (localhost)"
OK, but why wasn't that detected/fixed by the upgrader script when I upgraded to 1.9.0? Now what? Manually change some/what mysql things? I don't want to put my fingers in there.
Dan Jacobson schrieb:
"ALTER TABLE `searchindex` DROP INDEX si_title, DROP INDEX si_text"
from within function "dropTextIndex".
MySQL returned error "1142: ALTER command denied to user 'wikiuser'@'localhost' for table 'searchindex' (localhost)"
You do not have the right MySQL permissions. Add to your wikiuser account the ALTER TABLE privilege and your problems should be fixed.
Regards, Marco
On 28/01/07, Dan Jacobson jidanni@jidanni.org wrote:
Why doesn't Special:Search ever find anything on my test wiki that is on a computer powered up only a few hours every few days?
What are the search terms? What content language?
Must be some mysterious cron function. OK, this looks like it will
No, no cron job needed by default, unless $wgMiserMode is turned off, and possibly other live update options.
OK, but why wasn't that detected/fixed by the upgrader script when I upgraded to 1.9.0? Now what? Manually change some/what mysql things? I don't want to put my fingers in there.
The search index rebuild script drops and re-creates the full text index on the search engine, when using the default MyISAM search. Your database user will obviously need to be able to do this.
Rob Church
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Dan Jacobson wrote:
Why doesn't Special:Search ever find anything on my test wiki that is on a computer powered up only a few hours every few days?
Likely possibilities:
* you're searching for short words or words on MySQL's internal stoplist; see the FAQ and the MySQL documentation for how to change those options
* the searchindex table is not populated because you created your wiki's content through some sort of import system instead of through the wiki; in that case you might want to run rebuildtextindex
If running that script, you of course need appropriate permission for the database user used for scripts (fill out AdminSettings.php).
- -- brion vibber (brion @ pobox.com)
wikitech-l@lists.wikimedia.org