Page MenuHomePhabricator

Missing transcache table in database
Closed, ResolvedPublic


Author: vlb

I now have two mediawiki installations. The first claimed to install and
cpnfigure properly:

  • Created database mediawikidb
  • Creating tables... using MySQL 3/4 table defs... done.
  • Initializing data...
  • Granting user permissions...
  • Created sysop account WikiSysop. *

    Initialising "MediaWiki" namespace... Clearing message cache...Done.

    Creating LocalSettings.php...

The second ran into an error creating the transcache table (claiming my db user
did not have create access). I finally managed to get everything configured
using the root MySQL user.
But I note that my first installation does not have a transcache table.

-rw-rw---- 1 mysql mysql 8640 Jan 22 22:30 mw_searchindex.frm
-rw-rw---- 1 mysql mysql 8852 Jan 22 22:30 mw_site_stats.frm
-rw-rw---- 1 mysql mysql 8642 Jan 22 22:30 mw_text.frm
-rw-rw---- 1 mysql mysql 0 Jan 22 22:30 mw_trackbacks.MYD
-rw-rw---- 1 mysql mysql 1024 Jan 22 22:30 mw_trackbacks.MYI
-rw-rw---- 1 mysql mysql 8738 Jan 22 22:30 mw_trackbacks.frm
-rw-rw---- 1 mysql mysql 9128 Jan 22 22:30 mw_user.frm
-rw-rw---- 1 mysql mysql 8604 Jan 22 22:30 mw_user_groups.frm

Do I need one?

Version: 1.5.x
Severity: normal
OS: Mac OS X 10.0
Platform: Macintosh



Event Timeline

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

robchur wrote:

Going on an observation made last night while setting up a quick local 1.5.6
install in order to process dumps from another wiki, I believe the transcache
table was added sometime during 1.5 branch. It should be in the release notes. I
doubt it's a fatal problem, but you could run the upgrade script to fill in the

robchur wrote:

Follow-up: I've now added the table definition to the schema to be used so this
won't affect new installs.