Page MenuHomePhabricator

DB error on addwiki command: Column 'si_title' cannot be part of FULLTEXT index
Closed, ResolvedPublic

Description

Copying from Aaron's comment here: https://bugzilla.wikimedia.org/31096#c6

"Running that addwiki command I get:
aaron@fenari:~$ mwscript addwiki.php --wiki=aawiki bn wikimedia bdwikimedia
bd.wikimedia.org
Creating database bdwikimedia for bn.wikimedia (বাà¦à¦²à¦¾)
Initialising tables
A database error has occurred. Did you forget to run maintenance/update.php
after upgrading? See:
http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script
Query: CREATE FULLTEXT INDEX si_title ON searchindex (si_title)

Function: DatabaseBase::sourceFile(
/home/wikipedia/common/php-1.18/maintenance/tables.sql )
Error: 1283 Column 'si_title' cannot be part of FULLTEXT index (10.0.6.44)
"


Version: 1.16.x
Severity: normal

Details

Reference
bz31624

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:53 PM
bzimport set Reference to bz31624.
bzimport added a subscriber: Unknown Object (MLST).

We don't use searchindex table at wmf setup.

(In reply to comment #1)

We don't use searchindex table at wmf setup.

Exactly. In 1.18wmf1 we can just comment it out of the tables.sql

Slightly a hack, but it's not a big deal for us