$wgDBtransactions gets set to true if using InnoDB tables. Is there
an advantage to using InnoDB tables?
The disadvantage is that with MySQL there is a file, ibdata1, that
seems to grow endlessly if InnoDB tables are used. See
We're wondering if we should just convert everything to MyISAM. Any
Dept. of Biochemistry and Biophysics
Texas A&M Univ.
College Station, TX 77843-2128
I want to moving all pages in a certain namespace (about 60 pages) into
the the "main" namespace. I couldn't find how to do this, so I tried
exporting the pages and importing them and I ran into all sorts of
problems. Is there a way to do what I want without using the import and
export features (and without having to move each of them manually)?
After the upgrade I get this error
A database query syntax error has occurred. This may indicate a bug in
the software. The last attempted database query was:
(SQL query hidden)
from within function "MessageCache::loadFromDB". MySQL returned error
"1146: Table 'wikidb.text' doesn't exist (localhost)".
Here is the output from the update.php script
# php maintenance/update.php
MediaWiki 1.10.4 Updater
Going to run database updates for wikidb
Depending on the size of your database this may take a while!
Abort with control-c in the next five seconds...0
...hitcounter table already exists.
...querycache table already exists.
...objectcache table already exists.
...categorylinks table already exists.
...logging table already exists.
...user_newtalk table already exists.
...transcache table already exists.
...trackbacks table already exists.
...externallinks table already exists.
...job table already exists.
...langlinks table already exists.
...querycache_info table already exists.
...filearchive table already exists.
...querycachetwo table already exists.
...have ipb_id field in ipblocks table.
...have ipb_expiry field in ipblocks table.
...have rc_type field in recentchanges table.
...have rc_ip field in recentchanges table.
...have rc_id field in recentchanges table.
...have rc_patrolled field in recentchanges table.
...have rc_old_len field in recentchanges table.
...have user_real_name field in user table.
...have user_token field in user table.
...have user_email_token field in user table.
...have user_registration field in user table.
...have log_params field in logging table.
...have ar_rev_id field in archive table.
...have ar_text_id field in archive table.
...have page_len field in page table.
...have rev_deleted field in revision table.
...have img_width field in image table.
...have img_metadata field in image table.
...have img_media_type field in image table.
...have ss_total_pages field in site_stats table.
...have iw_trans field in interwiki table.
...have ipb_range_start field in ipblocks table.
...have ss_images field in site_stats table.
...have ipb_anon_only field in ipblocks table.
...have ipb_enable_autoblock field in ipblocks table.
...have user_newpass_time field in user table.
...have user_editcount field in user table.
...have rc_deleted field in recentchanges table.
...have log_id field in logging table.
...have log_deleted field in logging table.
...have ar_deleted field in archive table.
...have ipb_deleted field in ipblocks table.
...have fa_deleted field in filearchive table.
...have rev_len field in revision table.
...have ar_len field in archive table.
...have rev_parent_id field in revision table.
...have pr_id field in page_restrictions table.
...already have interwiki table
...indexes seem up to 20031107 standards
Already have pagelinks; skipping old links table updates.
...image primary key already set.
The watchlist table is already set up for email notification.
...watchlist talk page rows already present
...user table does not contain old email authentication field.
Logging table has correct title encoding.
...page table already exists.
revision timestamp indexes already up to 2005-03-13
...rev_text_id already in place.
...page_namespace is already a full int (int(11)).
...ar_namespace is already a full int (int(11)).
...rc_namespace is already a full int (int(11)).
...wl_namespace is already a full int (int(11)).
...qc_namespace is already a full int (int(11)).
...log_namespace is already a full int (int(11)).
...already have pagelinks table.
...templatelinks table already exists
No img_type field in image table; Good.
Already have unique user_name index.
...user_groups table already exists.
...user_groups is in current format.
...wl_notificationtimestamp is already nullable.
...timestamp key on logging already exists.
Setting page_random to a random value on rows where it equals
0...changed 0 rows
Checking for additional recent changes indices...
...index on ( rc_namespace, rc_user_text ) seems to be ok
...index on ( rc_user_text, rc_timestamp ) seems to be ok
...redirect table already exists.
Checking for backlinking indices...
Checking if pagelinks index pl_namespace includes field pl_from...
...index pl_namespace on table pagelinks seems to be ok
Checking if templatelinks index tl_namespace includes field tl_from...
...index tl_namespace on table templatelinks seems to be ok
Checking if imagelinks index il_to includes field il_from...
...index il_to on table imagelinks seems to be ok
...page_restrictions table already exists.
Deleting old default messages (this may take a long time!)...Done
Checking site_stats row...ok.
Here is my wikidb:
| Tables_in_wikidb |
| archive |
| blobs |
| brokenlinks |
| categorylinks |
| cur |
| externallinks |
| filearchive |
| hitcounter |
| image |
| imagelinks |
| interwiki |
| ipblocks |
| ipblocks_old |
| job |
| langlinks |
| links |
| linkscc |
| logging |
| math |
| objectcache |
| old |
| oldimage |
| page |
| page_restrictions |
| pagelinks |
| querycache |
| querycache_info |
| querycachetwo |
| recentchanges |
| redirect |
| revision |
| searchindex |
| site_stats |
| templatelinks |
| trackbacks |
| transcache |
| user |
| user_groups |
| user_newtalk |
| user_rights |
| validate |
| watchlist |
Web Services Systems Engineer
* MediaWiki <http://www.mediawiki.org/> : 1.10.0
* PHP <http://www.php.net/> : 5.2.0-8+etch11 (apache2handler)
* MySQL <http://www.mysql.com/> : 5.0.32-Debian_7etch6-log
In the last week we have somehow lost the ability to 'edit' a new page.
You can go to a page and edit the whole page or a section of the page.
But If you enter "FOOBAR PAGE" in the search then click on edit new page
you will get a blank page with no header/footer .. nothing (guess that
is what 'blank' means)
Has anyone seen this before? Ideas on what could change in a system
(outside of mediawiki) to do this?
David Tod Sigafoos | SANMAR Corporation
some spammers made my "text" table explode, its size is now 170 MB,
many rows with 2 MB. I've already deleted the spam revisions in the
wiki with deleting the page and restoring only spam-free revisions (as
described on http://www.mediawiki.org/wiki/Manual:Administrators#Deletion).
But the spam rows are still in the "text" table. Is it safe to delete
I'm using Mediawiki 1.12.0.
Georg | http://serchilo.net - command the web
I'm trying to modify my extension to account for the autoAuthenticate
-> UserLoadFromSession change (moving SpecialUserlogin.php out of the
include path was also a surprise).
The problem is user info in the upper right nav, for the front page
only, does not update when I create a LoginForm and do initUser in the
What do I have to do to tell the front page that the user's identity
Has anything else has changed WRT non-username/password authentication?
Michael B Allen
PHP Active Directory SPNEGO SSO
I would like linked many words about my wiki to wikipedia pages. Now, I use
but I would like use
is it possible?
can you help me about it?
Alessandra Bilardi, Ph. D.
CRIBI, University of Padova, Italy
La semplicità è la più alta forma di perfezione (Leonardo Da Vinci)
Keep simple, stupid (KISS, IT)
I have one or more spambots that keep coming back on a specific page, you
can see it in action here:
(this is a test set up - the site is not ready for visitors yet)
Tried to install SpamBlacklist. Used the simple setup suggested for
localsettings.php (without including array). Did not get it to work.
Also tried to protect the page with no result.
The SpamBlacklist extension's talk page has old discussions about it not
working, no apparent solution at hand.