Page MenuHomePhabricator

fail to create "searchindex" with mysql and db collation = "binary"
Closed, ResolvedPublic

Description

Author: oss

Description:
(...)
Database wiki exists
Creating tables... FAILED
Query "CREATE FULLTEXT INDEX si_title ON searchindex (si_title) " failed with error code "Column 'si_title' cannot be part of FULLTEXT index (localhost)".


Version: 1.22.0
Severity: major

Details

Reference
bz23694

Event Timeline

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

oss wrote:

After reload the installation page, it will continue because 'searchindex' already exist, but the mainpage, default user and l10n-cache may not be created properly.

Hmm, looks like we just need to set some collation for it explicitly, to prevent server defaults from interferring. latin1_swedish_ci?

cbm.wikipedia wrote:

The beta installer for 1.18 has hit this bug again; I see it when trying to install with r80627

cbm.wikipedia wrote:

I'm not sure how to interpret comment 2. Can varbinary columns have a collation at all? Changing severity to major, since this stops the installer even if 'utf8' is selected earlier.

this appears to be fixed for 1.17. Removing blocker there.

It's not present in REL1_17, but it is in trunk.

r80547 is to blame.

(In reply to comment #3)

The beta installer for 1.18 has hit this bug again; I see it when trying to
install with r80627

Are you still hitting this with head (r81026)? I'm pretty sure this is resolved.

This has just happened to me on git master. I changed database collation to utf8_general_ci, dropped all tables, refreshed the installer and it worked.

Hi has this been fixed.

Don't know, see previous comments. :)
Did you test it? If so, which were your exact testing steps and your results?

Not sure I am asking has this been fixed because it works for me but steps are

  1. Go to mw-configure/ using Mediawiki 1.26
  1. Then follow the instructions clicking next and fling out the data.
  1. Then when you get to the upgrade screen click next

Then look at the upgrade log for searchindex it should run say what the error is described above just that it was successful

Then look at the upgrade log for searchindex it should run say what the error is described above just that it was successful

Impossible to understand that sentence. Please read https://en.wikipedia.org/wiki/Punctuation before adding further comments. Thanks.

Ok Sorry.

  1. Setup mediawiki on a website or on localhost.
  1. Then once all the files are installed go to mw-config on the wiki for example if your on localhost it would be localhost/mw-config/
  1. Then when I setup choose the language you want. Click next then follow the steps on the screen until you reach the upgrade screen.
  1. click next on setup screen. And it should not an error if the sql failed.
Krinkle subscribed.

This is an old fague issue from 2010, which indeed appears to not be a problem anymore.