An automated run of parserTests.php showed the following failures:
Running test TODO: Table security: embedded pipes (http://mail.wikipedia.org/pipermail/wikitech-l/2006-April/034637.html)... FAILED!
Running test TODO: Link containing double-single-quotes '' (bug 4598)... FAILED!
Running test TODO: Template with thumb image (with link in description)... FAILED!
Running test Template infinite loop... FAILED!
Running test TODO: message transform: <noinclude> in transcluded template (bug 4926)... FAILED!
Running test TODO: message transform: <onlyinclude> in transcluded template (bug 4926)... FAILED!
Running test BUG 1887, part 2: A <math> with a thumbnail- math enabled... FAILED!
Running test TODO: HTML bullet list, unclosed tags (bug 5497)... FAILED!
Running test TODO: HTML ordered list, unclosed tags (bug 5497)... FAILED!
Running test TODO: HTML nested bullet list, open tags (bug 5497)... FAILED!
Running test TODO: HTML nested ordered list, open tags (bug 5497)... FAILED!
Running test TODO: Parsing optional HTML elements (Bug 6171)... FAILED!
Running test TODO: Inline HTML vs wiki block nesting... FAILED!
Running test TODO: Mixing markup for italics and bold... FAILED!
Running test TODO: 5 quotes, code coverage +1 line... FAILED!
Running test TODO: HTML Hex character encoding.... FAILED!
Running test TODO: dt/dd/dl test... FAILED!
Passed 412 of 429 tests (96.04%) FAILED!
Could be just me, but occasionally today I'm getting totally blank
pages being delivered straight away from en.wikipedia.org. Upon
refresh, I usually get the real page.
It's probably me, but thought I'd check :)
Steve
I'm interested in MediaWiki running with Oracle and after searching
through the archives it appears there was an attempt back around version
1.5 - 1.6 but nothing since then. Is there a plan to support Oracle in
the future or has it be put on the shelf?
The WikiMatrix (http://www.wikimatrix.org/) reports MediaWiki supports
Oracle. I guess that is incorrect at this time?
-Jim
Hi,
I was wondering if there was a reason why the date fields are stored
as char(14), doesn't that make them a string? I want to analyse the
dates things happened - between ranges etc, and could do with changing
them to a double or big int or even a mysql date! Storing them in a
numeric format would also increase performance marginally, as the
field size would become much smaller. Am I missing something important
about MySQL/mediawiki date handling? Will MW break if I change the
underlying format? I have never seen a non numeric string in a
timestamp...
Kind regards,
Alex
Hi,
could you please be so kind to tell me if there is a way to count all articles within a category and all of its subcategories? I.e. something like:
There are X articles in this category and all subcategories.
Many thanks,
Claudi
---------------------------------
Découvrez un nouveau moyen de poser toutes vos questions quelque soit le sujet ! Yahoo! Questions/Réponses pour partager vos connaissances, vos opinions et vos expériences. Cliquez ici.
In my wiki installation, I have edited the sanitizer to allow use of
as much HTML as possible, but there are some tags I cannot add
successfully due to strange characters.
adding '!DOCTYPE' returns <!DOCTYPE as it would do if the tag was
not allowed.
the attribute 'http-equiv' gets removed, presumably because of the dash.
Do these characters need to be escaped or written in a different way?
I've tried various methods without success. Hope you can help.
Regards,
Bob Jones
An automated run of parserTests.php showed the following failures:
Running test TODO: Table security: embedded pipes (http://mail.wikipedia.org/pipermail/wikitech-l/2006-April/034637.html)... FAILED!
Running test TODO: Link containing double-single-quotes '' (bug 4598)... FAILED!
Running test TODO: Template with thumb image (with link in description)... FAILED!
Running test Template infinite loop... FAILED!
Running test TODO: message transform: <noinclude> in transcluded template (bug 4926)... FAILED!
Running test TODO: message transform: <onlyinclude> in transcluded template (bug 4926)... FAILED!
Running test BUG 1887, part 2: A <math> with a thumbnail- math enabled... FAILED!
Running test TODO: HTML bullet list, unclosed tags (bug 5497)... FAILED!
Running test TODO: HTML ordered list, unclosed tags (bug 5497)... FAILED!
Running test TODO: HTML nested bullet list, open tags (bug 5497)... FAILED!
Running test TODO: HTML nested ordered list, open tags (bug 5497)... FAILED!
Running test TODO: Parsing optional HTML elements (Bug 6171)... FAILED!
Running test TODO: Inline HTML vs wiki block nesting... FAILED!
Running test TODO: Mixing markup for italics and bold... FAILED!
Running test TODO: 5 quotes, code coverage +1 line... FAILED!
Running test TODO: HTML Hex character encoding.... FAILED!
Running test TODO: dt/dd/dl test... FAILED!
Passed 412 of 429 tests (96.04%) FAILED!
Timwi wrote
You method would:
> * retrieve all pages from category1
> * retrieve all pages from category2
> * sort the whole list
> * group them (i.e. replace runs with their counts)
> * filter out those where the count is 2
>
> The straightfoward method would be:
>
> select a.page from categorylinks a
> where a.category='category1' AND EXISTS (
> select * from categorylinks b
> where a.page=b.page AND b.category='category2'
> )
>
> This would:
> * retrieve all the pages from category2
> * find all the pages in category1 that are any of those
>
> I don't have MySQL handy, but tested this on MSSQL and the second method
> was way faster. :)
>
> Timwi
>
Hey, cool! I don't have my ego wrapped up in it or anything, so if that's
better, great! I don't know what MySQL's internal processes are, so I can
only speculate as to what the pros and cons are to each method (whether it
actually does two queries, or just one, under what circumstances, etc... I
have no idea).
Thanks for calling it "clever" - honestly, it was the only way I could think
of to do it. I've seen it done (dynamic page lists) with a lot of joins,
but it struck me that all those joins had to incur a lot of overhead. Maybe
I'll write the three different implementations and run them head-to-head in
MySQL. Would be interesting, anyway.
Best Regards,
Aerik
Some of the issues around the structure of categories have been both
contentious and promising for a long time, 2 years or better... (see
http://en.wikipedia.org/wiki/Wikipedia:Category_math_feature, and many links
to category intersections / category math on meta)
I *still* think categories as tags is one of the most promising applications
of a wiki, as opposed to hierarchical categories like dmoz. We currently
seem to be doing some of both (the administrative categories are essentially
tags, while many other categories, ie "Norwegian
composers<http://en.wikipedia.org/wiki/Category:Norwegian_composers>"
which is several levels down from the high level musicians category, etc.)
and that's really pretty cool.
I think we should *embrace* doing both types of categories, because we can
in the wiki structure, it's not an mutually exclusive way of doing things.
We can make everybody (sort of) happy. The hurdle then becomes writing code
efficient enough to sift through all the records to find what you want.
Now, as I mentioned before, I don't' have experience with writing code to
deal with zillions of hits, but I think a simple implementation of "find all
pages belonging to category1 AND category2" is accomplished using a sql like
this pseudocode: "select pages, count(pages) as count where
(category='category1' or category='category2') group by pages having
count='2'"
Again, I'm not efficiency expert, but that puts the heavy lifting on mysql
and is pretty straightforward. I've currently written an implementation
that is a bit more full featured, messy, and inefficient than that.. but I'd
be happy to pitch in to a new one (I'm still on mediawiki 1.4x, sshh!)
Best Regards,
Aerik
An automated run of parserTests.php showed the following failures:
Running test TODO: Table security: embedded pipes (http://mail.wikipedia.org/pipermail/wikitech-l/2006-April/034637.html)... FAILED!
Running test TODO: Link containing double-single-quotes '' (bug 4598)... FAILED!
Running test TODO: Template with thumb image (with link in description)... FAILED!
Running test Template infinite loop... FAILED!
Running test TODO: message transform: <noinclude> in transcluded template (bug 4926)... FAILED!
Running test TODO: message transform: <onlyinclude> in transcluded template (bug 4926)... FAILED!
Running test BUG 1887, part 2: A <math> with a thumbnail- math enabled... FAILED!
Running test TODO: HTML bullet list, unclosed tags (bug 5497)... FAILED!
Running test TODO: HTML ordered list, unclosed tags (bug 5497)... FAILED!
Running test TODO: HTML nested bullet list, open tags (bug 5497)... FAILED!
Running test TODO: HTML nested ordered list, open tags (bug 5497)... FAILED!
Running test TODO: Parsing optional HTML elements (Bug 6171)... FAILED!
Running test TODO: Inline HTML vs wiki block nesting... FAILED!
Running test TODO: Mixing markup for italics and bold... FAILED!
Running test TODO: 5 quotes, code coverage +1 line... FAILED!
Running test TODO: HTML Hex character encoding.... FAILED!
Running test TODO: dt/dd/dl test... FAILED!
Passed 412 of 429 tests (96.04%) FAILED!