Last modified: 2013-10-04 14:26:53 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T49191, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 47191 - [Regression] Installer: MySQL Fatal Error "1283: Column 'si_title' cannot be part of FULLTEXT index" for collation set to "binary"
[Regression] Installer: MySQL Fatal Error "1283: Column 'si_title' cannot be ...
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
1.21.x
All All
: Highest blocker (vote)
: 1.22.0 release
Assigned To: Kevin Israel (PleaseStand)
: code-update-regression
: 48608 (view as bug list)
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-04-13 05:58 UTC by Krinkle
Modified: 2013-10-04 14:26 UTC (History)
4 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Krinkle 2013-04-13 05:58:22 UTC
$ php maintenance/install.php --dbname zetawiki --installdbuser root --installdbpass root --pass 1234 MyWiki Root

PHP 5.4.13 is installed.
Warning: Could not find APC, XCache or WinCache.
Object caching is not enabled.
Found GD graphics library built-in.
Image thumbnailing will be enabled if you enable uploads.
Using server name "http://localhost".
Warning: No --scriptpath specified, using default: /wiki.
Using server URL "http://localhost/wiki".
Warning: Your default directory for uploads (/Users/krinkle/Development/mediawiki/core/images/) is not checked for vulnerability
to arbitrary script execution during the CLI install.
Warning: The intl PECL extension is not available to handle Unicode normalization, falling back to slow pure-PHP implementation.
If you run a high-traffic site, you should read a little on Unicode normalization.
The environment has been checked.
You can install MediaWiki.
Setting up database
done
Creating tables
A database query syntax error has occurred.
The last attempted database query was:
"CREATE FULLTEXT INDEX si_title ON `searchindex` (si_title)
"
from within function "DatabaseBase::sourceFile( /Users/krinkle/Development/mediawiki/core/maintenance/tables.sql )".
Database returned error "1283: Column 'si_title' cannot be part of FULLTEXT index (localhost)"
Backtrace:
#0 /Users/krinkle/Development/mediawiki/core/includes/db/Database.php(986): DatabaseBase->reportQueryError('Column 'si_titl...', 1283, 'CREATE FULLTEXT...', 'DatabaseBase::s...', false)
#1 /Users/krinkle/Development/mediawiki/core/includes/db/Database.php(3421): DatabaseBase->query('CREATE FULLTEXT...', 'DatabaseBase::s...')
#2 /Users/krinkle/Development/mediawiki/core/includes/db/Database.php(3334): DatabaseBase->sourceStream(Resource id #90, false, false, 'DatabaseBase::s...', false)
#3 /Users/krinkle/Development/mediawiki/core/includes/installer/DatabaseInstaller.php(185): DatabaseBase->sourceFile('/Users/krinkle/...')
#4 [internal function]: DatabaseInstaller->createTables(Object(MysqlInstaller))
#5 /Users/krinkle/Development/mediawiki/core/includes/installer/Installer.php(1458): call_user_func(Array, Object(MysqlInstaller))
#6 /Users/krinkle/Development/mediawiki/core/includes/installer/CliInstaller.php(126): Installer->performInstallation(Array, Array)
#7 /Users/krinkle/Development/mediawiki/core/maintenance/install.php(119): CliInstaller->execute()
#8 /Users/krinkle/Development/mediawiki/core/maintenance/doMaintenance.php(110): CommandLineInstaller->execute()
#9 /Users/krinkle/Development/mediawiki/core/maintenance/install.php(133): require_once('/Users/krinkle/...')
#10 {main}
Comment 1 Krinkle 2013-04-13 06:00:23 UTC
MySQL version 5.6.10 (latest stable).
Comment 2 Krinkle 2013-04-13 06:09:17 UTC
MySQL database is newly created.

I cannot reproduce the problem with database collation set to binary.

However the default collation for new databases is utf8_general_ci (MySQL 5.6.10).

And when having that as the collation, I can reproduce this fatal error every time.
Comment 3 Krinkle 2013-04-13 06:13:54 UTC
(In reply to comment #2)
> MySQL database is newly created.
> 
> I cannot reproduce the problem with database collation set to binary.
> 
> However the default collation for new databases is utf8_general_ci (MySQL
> 5.6.10).
> 
> And when having that as the collation, I can reproduce this fatal error every
> time.

Sorry, the other way around. On the default collation (utf8_general_ci) is works fine. When installing it on a newly created database with collation set to binary, it fails.

Possibly related issue:
* https://www.mediawiki.org/wiki/Thread:Project:Support_desk/I_just_instill_whole_new_kloxo_on_lindoe_VPS,_Then_I_got_this%EF%BC%9A#Installation_gives_MySQL_ERROR_1283:_Column_.27si_title.27_cannot_be_part_of_FULLTEXT_index_19853
Comment 4 Sam Reed (reedy) 2013-04-13 19:55:23 UTC
Noting that we just comment it out for WMF usage

https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/core.git;a=commitdiff;h=6edbb87aa49f8af763ef217ff4c0882940734594
Comment 5 Kevin Israel (PleaseStand) 2013-05-20 07:37:53 UTC
*** Bug 48608 has been marked as a duplicate of this bug. ***
Comment 6 Andre Klapper 2013-06-20 07:56:15 UTC
hexmode: Do you think you'll have some time to take a look at this problem?
Comment 7 Kevin Israel (PleaseStand) 2013-06-20 09:23:05 UTC
Ied512a75 *might* fix this, though I have not tested or reviewed it, only
tweaked the commit message.
Comment 8 Mark A. Hershberger 2013-06-20 15:19:09 UTC
I will test this fix later today.
Comment 9 Andre Klapper 2013-08-15 15:30:19 UTC
(In reply to comment #8 by Mark A. Hershberger)
> I will test this fix later today.

hexmode: Any news?
Comment 10 Andre Klapper 2013-09-06 13:07:09 UTC
(In reply to comment #8 by Mark A. Hershberger)
> I will test this fix later today.

hexmode: Any news?
Comment 11 Gerrit Notification Bot 2013-09-26 06:06:25 UTC
Change 86075 had a related patch set uploaded by PleaseStand:
Use utf8 charset for searchindex MySQL table

https://gerrit.wikimedia.org/r/86075
Comment 12 Gerrit Notification Bot 2013-09-26 22:47:24 UTC
Change 86075 merged by jenkins-bot:
Use utf8 charset for searchindex MySQL table

https://gerrit.wikimedia.org/r/86075
Comment 13 Kevin Israel (PleaseStand) 2013-10-02 20:50:16 UTC
Should be fixed by 2f02c77b4ef1d6a7d6a8e8862ead5592863d7988. Existing and new databases having a "binary" character set should no longer be a problem.

Do users experience this problem frequently enough to warrant backporting the one-line patch to older versions of MediaWiki?

Also, why was the severity set to "blocker", if this had an easy workaround
(don't do CREATE DATABASE ... CHARACTER SET binary)? Just because a developer
experienced this?
Comment 14 Mark A. Hershberger 2013-10-04 14:26:53 UTC
(In reply to comment #13)
> Also, why was the severity set to "blocker", if this had an easy workaround
> (don't do CREATE DATABASE ... CHARACTER SET binary)? Just because a developer
> experienced this?

If a user came across this, it would block their upgrade/installation.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links