Last modified: 2010-05-15 15:38:26 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 T6735, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 4735 - Missing transcache table in database
Missing transcache table in database
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
Macintosh Mac OS X 10.0
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2006-01-23 08:12 UTC by Vicki Brown
Modified: 2010-05-15 15:38 UTC (History)
0 users

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


Description Vicki Brown 2006-01-23 08:12:17 UTC
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?
Comment 1 Rob Church 2006-01-23 16:00:41 UTC
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
Comment 2 Rob Church 2006-02-22 23:04:54 UTC
Follow-up: I've now added the table definition to the schema to be used so this
won't affect new installs.

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