One of my wiki is growing an growing, now the DB is approx. 600 MB
(unexperienced users dont often use the preview ;)).
The sysops in the wiki have deleted several articles in the wiki, but of cause,
they are still physical available in the DB (and restore-able for sysops).
How to remove the "deleted revisions" permanently from the DB?
maintenance/DeleteOldRevisions.php doesnt seem to be what I'm looking for; this
removes the version-historie from all pages.
maintenance/DeleteOrphanRevisions.php doesnt seem to do anything - "0 found".
I hope anyone has a tipp,
I'm trying to get rid of the old revisions in my wiki (1.82).
Using "php deleteOldRevisions.php" I get the reply:
Searching for active revisions...done.
Searching for inactive revisions...done.
0 old revisions found.
But for sure, I do have (too many) old revisions in the wiki.
So, where is the problem?
Thanks in advance, zaydo
in spanish the term "discussion" is translated "discusión" (with
Now how to set up a custom namespace called "ES_Discusión" in an
international (utf-8) wiki? If following the description from
Help:Custom namespaces (from meta) and coding it as html "ó" it
is displayed as is - and if coding it in iso-8859, it is displayed with
the small black questionmark rhomb - which is normal behavior in utf-8.
The meta instruction says "Do not save LocalSettings.php as Unicode,
because PHP cannot handle it" - so is there any possibility to get
(for php reasons we still use mediawiki 1.6.8 /php 4.3.3)
When I'm try to upload a png, the debug file has the following:
Unstubbing $wgContLang on call of $wgContLang->checkTitleEncoding from WebRequest::getGPCVal
Language::loadLocalisation(): got localisation for es from source
Language::loadLocalisation(): got localisation for en from source
Unstubbing $wgUser on call of $wgUser->isAllowed from Title::userCanRead
Cache miss for user 2
Unstubbing $wgLoadBalancer on call of $wgLoadBalancer->getConnection from wfGetDB
Logged in from session
Unstubbing $wgMessageCache on call of $wgMessageCache->getTransform from wfMsgGetKey
Unstubbing $wgLang on call of $wgLang->getCode from MessageCache::get
MessageCache::load(): got from global cache
Unstubbing $wgParser on call of $wgParser->firstCallInit from MessageCache::transform
UploadForm: watchthis is: ''
WebRequest::getFileName() 'LogoCamaleon.png' normalized to 'LogoCamaleon.png'
Block::load: '188.8.131.52', '2', 1
User::getBlockedStatus: No block.
MacBinary: 0000: 89 50 4e 47 0d 0a 1a 0a 00 00 00 0d 49 48 44 52 .PNG........IHDR
MacBinary: 0010: 00 00 00 b9 00 00 00 8b 08 02 00 00 01 c5 7a 9f ..............z.
MacBinary: 0020: 3b 00 00 00 04 67 41 4d 41 00 00 b1 8f 0b fc 61 ;....gAMA......a
MacBinary: 0030: 05 00 00 00 06 62 4b 47 44 00 ff 00 ff 00 ff a0 .....bKGD.......
MacBinary: 0040: bd a7 93 00 00 00 09 70 48 59 73 00 00 0b 13 00 .......pHYs.....
MacBinary: 0050: 00 0b 13 01 00 9a 9c 18 00 00 00 07 74 49 4d 45 ............tIME
MacBinary: 0060: 07 d6 05 09 15 20 13 b6 8c 91 8f 00 00 20 00 49 ..... ....... .I
MacBinary: 0070: 44 41 54 78 da 24 d8 c9 af a6 d9 61 98 f7 33 9f DATx.$.....a..3.
MacBinary::loadHeader: header bytes 0 and 74 not null
MimeMagic::MimeMagic: loading mime types from includes/mime.types
MimeMagic::MimeMagic: loading mime info from includes/mime.info
DjVuImage::getInfo: not a DjVu file
MimeMagic::detectMimeType: magic mime type of /tmp/phpSAl8QB: text/plain
MimeMagic::guessMimeType: final mime type of /tmp/phpSAl8QB: text/plain
SpecialUpload::verifyExtension: mime type text/plain mismatches file extension png, rejecting file
OutputPage::sendCacheControl: private caching; **
Then, the upload page reply is an error...
I think that all files are detected like text/plain ...(I can see the
same with ppt's).
My solution was set $wgMimeDetectorCommand="file -bi" and
$wgVerifyMimeType = false in LocalSettings....
But now, all office files (.xls,.ppt etc.) are detected as
application/msword and not as application/vnd.powerpoint (o excel...)....
This work OK, but the content of the image table can be wrong.
Can be the wrong data in image table a great problem in the future?
(today doesn't seems to be a problem...)
PS: Excuse my english again !!!!!
Thanks to everyone who's been helping.
As I get closer to my goal, I have some more complex questions
regarding templates, protected pages, transclusions, pre-loading, etc.
It would be really useful to have a "test wiki" I could point people
to to show them what I've done so far, and why it doesn't work.
Ideally, this would be one where any registered user could
protect/unprotect pages (of course, giving any user the power to
protect/unprotect pages makes protection meaningless, but this would
be more to experiment with protected pages, not actually protect
Is there such a "test wiki" out there?
I realize I could create test pages and even templates on ANY wiki
(even mediawiki.org or wikipedia.org), but it would be wrong to
We're just a Bunch Of Regular Guys, a collective group that's trying
to understand and assimilate technology. We feel that resistance to
new ideas and technology is unwise and ultimately futile.
Can someone please remind me how/where to check which version of Mediawiki
Getting ready to upgrade to a newer version....
Newsroom Systems Specialist
The Orange County Register/Freedom Orange County Information
625 N. Grand Ave., Santa Ana, CA 92701