After running mwdumper to strip out the NS_MEDIAWIKI namespace entries
from the 20070206 SQL dumps, the output filtered
XML file created by mwdumper after stripping out the name space has sql
syntax errors in the output:
1. The output files cannot be used by mwimport because the text labels
for XML types, etc, are modified by mwdumper to the extent the program
can no longer read the dump.
2. If you take the XML file output by mwdumper and attempt to reimport
it into an empty database with mwdumper, it produces corrupted SQL
statements
and fails. It will process about 720,000 articles however, before
failing. Output from mysql error log provided.
ERROR 1062 (23000) at line 15327: Duplicate entry '70473566' for key 1
ERROR 1064 (42000) at line 15328: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near ''== Greatest Common Factor / Least Common
Multiple Problem ==\n\nI recently went' at line 1
Jeff
An automated run of parserTests.php showed the following failures:
This is MediaWiki version 1.10alpha (r20691).
Reading tests from "maintenance/parserTests.txt"...
Reading tests from "extensions/Cite/citeParserTests.txt"...
Reading tests from "extensions/Poem/poemParserTests.txt"...
17 still FAILING test(s) :(
* URL-encoding in URL functions (single parameter) [Has never passed]
* URL-encoding in URL functions (multiple parameters) [Has never passed]
* Table security: embedded pipes (http://mail.wikipedia.org/pipermail/wikitech-l/2006-April/034637.html) [Has never passed]
* Link containing double-single-quotes '' (bug 4598) [Has never passed]
* message transform: <noinclude> in transcluded template (bug 4926) [Has never passed]
* message transform: <onlyinclude> in transcluded template (bug 4926) [Has never passed]
* BUG 1887, part 2: A <math> with a thumbnail- math enabled [Has never passed]
* HTML bullet list, unclosed tags (bug 5497) [Has never passed]
* HTML ordered list, unclosed tags (bug 5497) [Has never passed]
* HTML nested bullet list, open tags (bug 5497) [Has never passed]
* HTML nested ordered list, open tags (bug 5497) [Has never passed]
* Inline HTML vs wiki block nesting [Has never passed]
* Mixing markup for italics and bold [Has never passed]
* dt/dd/dl test [Has never passed]
* Images with the "|" character in the comment [Has never passed]
* Parents of subpages, two levels up, without trailing slash or name. [Has never passed]
* Parents of subpages, two levels up, with lots of extra trailing slashes. [Has never passed]
Passed 494 of 511 tests (96.67%)... 17 tests failed!
Dear list,
maybe a stupid question, but...
our wiki lost almost all entries from Recent changes. Mysql logs said
DELETE FROM `recentchanges` WHERE rc_timestamp < '20070317115213';
I looked into apache logs, but could not find any http request around
the time when this DELETE query was issued.
Any possible (automated?) script which deletes recent changes table?
Which one? (And why?)
The only information I came across was
http://meta.wikimedia.org/wiki/Help:Rebuildall.php
which states that 1.5rc4 might empty recentchanges table.
However we use 1.5.6.
Any possibility to rebuild recent changes table from page history data?
Thanks for your patience.
Regards, Nino
WikiSym 2007 paper submission deadline is upon us in 6 weeks!
Please consider submitting a paper, panel, workshop, etc.
Dirk
---
WikiSym 2007
CALL FOR PAPERS
2007 International Symposium on Wikis (WikiSym 2007)
Wikis at Work in the World:
Open, Organic, Participatory Media for the 21st Century
October 21-23, 2007, Montreal, Canada
Co-located with ACM OOPSLA 2007
In cooperation with ACM SIGWEB
See http://www.wikisym.org/
Archived * Peer Reviewed * ACM Sponsored
OVERVIEW
The 2007 International Symposium on Wikis brings together wiki
researchers, practitioners, and users. The goal of the symposium is to
explore and extend our growing community. The symposium has a
rigorously reviewed research paper track as well as plenty of space
for practitioner reports, demonstrations, and discussions. Anyone who
is involved in using, researching, or developing wikis is invited to
WikiSym 2007!
We recognize the online world is always evolving, and we also welcome
contributions which are about other online media consistent with the
wiki philosophy of being open, organic and participatory.
We are seeking submissions for
* research papers (long and short): due 7 May 2007
* workshops: due 7 May 2007
* panels: due 7 May 2007
* posters: due 9 July 2007
* demonstrations: due 9 July 2007
Given the interdisciplinary nature of wikis, we invite contributions
from researchers and practitioners in a wide range of fields
including:
* business, marketing, law
* communications and media studies
* computer science, human-computer interaction
* history, political science, geography
* information and library science
* linguistics, discourse analysis, language studies
* natural sciences, medicine
Topics of interest to the symposium include, but are not limited to:
* wiki technologies and implementations
* wiki in the workplace; for business use
* wiki as social software for collaboration and work group processes
* wiki user experiences, usability, discourse analysis
* wiki for non-text media (images, video, audio) and spatial systems
* wiki content dynamics and evolution, wiki metrics
* wiki journalism; wiki archiving
* wiki reputation systems, quality assurance processes
* wiki administration, processes, dealing with abuse
* wiki scalability, social and technical
* wiki and the semantic web, knowledge management, tacit-knowledge
* wikis for specific domains (education, genomics, politics, etc.)
* wikis written by and for small audiences (ex: family wikis)
* wiki legal issues (copyright, licensing)
* wiki translation and multilingual wiki content
SUBMISSION DETAILS
Research papers will be reviewed by the Program Committee to meet
rigorous academic standards of publication. Research papers are
expected to advance the state of the art by describing substantiated
new research or novel technical results or by reporting on significant
experience (including case studies) or experimentation. They will be
reviewed both with respect to conceptual quality and clarity of
presentation. Note that authors of accepted papers are expected to attend
the conference and present the paper, otherwise publication will be
canceled.
Accepted research papers will be provided as part of the conference
proceedings. They will be put into the ACM Digital Library and can be
referenced as papers that appeared in the "Proceedings of the 2007
International Symposium on Wikis (WikiSym 2007)". We invite full papers
(recommended length of 10 to 15 pages with maximum of 20 pages, and a 30
minute
presentation time) and short papers (maximum 6 pages, with a 15 minute
presentation time). Papers should use the ACM SIG Proceedings Format,
see: http://www.acm.org/sigs/pubs/proceed/template.html
Workshop and Panels submissions will be reviewed and selected for
their interest to the community. A submission should consist of two
pages describing what you intend to do and how you meet this
criterion. It should include a 100-word abstract and one-paragraph
bios of all people relevant to the submission. Workshops will be
allocated a half-day or a full-day and a room of their own (depending
on your request). Panels will be given a 90 minutes time slot and a
room of their own.
Poster submissions will be reviewed on their merits and may describe
research projects or experience reports. A submission should consist
of two page extended abstract outlining the content of the
poster. Successful applicants will be invited to bring a poster for
display at the symposium. Posters must be flat and within 1mx2m in
size.
Demos will be reviewed based on their relevance to the community. A
submission should be one page in length, with a title, a short
description of the demo, as well as a description of any special
technical needs you may have (ex: wireless connectivity).
Please submit your papers or proposals in PDF format by the respective
deadline through our submission system, which will be available
through the WikiSym website. Questions should be directed respectively
at papers(a)wikisym.org (research papers and practitioner reports),
workshopsandpanels(a)wikisym.org (workshops and panels), or
demosandposters(a)wikisym.org (posters and demos).
SYMPOSIUM LOGISTICS
The 2007 International Symposium on Wikis will be held at the Palais
des Congrs in Montreal, Canada, October 21-23, 2007. A special hotel
rate has been negotiated at the Hyatt Regency Montreal. WikiSym 2007
will be co-located with the ACM OOPSLA 2007 conference, and
participants may register for the symposium alone, or may jointly
register for WikiSym and OOPSLA 2007. Registration is handled through
the ACM OOPSLA website: http://oopsla.org/
If you have any questions, please contact Alain Desilets through
chair(a)wikisym.org.
SYMPOSIUM COMMITTEE
Alain Dsilet, NRC-CNRC, Canada (Symposium Chair)
Robert Biddle, Carleton University, Canada (Program Chair)
Phoebe Ayers, U. of California Davis, USA (Wikimedia Liaison and
Publicity)
Angela Beesley, Wikia / Wikimedia, USA (Posters and Demos Chair)
Mark Bernstein, Eastgate Systems, USA (Panels and Workshops Chair)
Ward Cunningham, Eclipse Foundation, USA (Honorary Chair)
Ted Ernst, Open Space World (Open Space Chair)
Andrea Forte, Georgia Institute of Technology, USA (Publicity Chair)
Dirk Riehle, SAP, USA (Treasurer and Corporate Sponsorships)
Peter Thoeny, TWiki.org and StructuredWikis LLC, USA (Web Master)
PROGRAM COMMITTEE
Ademar Aguiar, Universidade do Porto, Portugal
Phoebe Ayers, University of California Davis, United States
Angela Beesley, Wikimedia / Wikia, United Kingdom
Amy Bruckman, Georgia Institute of Technology, United States
Mark Bernstein, Eastgate Systems, United States
Robert Biddle, Carleton University, Canada
Sally Jo Cunningham, University of Waikato, New Zealand
Alain Dsilets, National Research Council, Canada
Mark Gaved, The Open University, United Kingdom
Brian Greenspan, Carleton University, Canada
Beat Doebeli Honegger, UAS Northwestern, Switzerland
Matthias Jugel, Fraunhofer FIRST, Germany
Elizabeth Da Lio, Marche Polytechnic University, Italy
Ann Majchrzak, University of Southern California, United States
Sky Marsen, Victoria University of Wellington, New Zealand
James Noble, Victoria University of Wellington, New Zealand
Michele Notari, University of Applied Sciences Berne, Switzerland
Alejandro Ramirez, Carleton University, Canada
Dirk Riehle, SAP Research, United States
Hugh Robinson, The Open University, United Kingdom
Cristoff Sauer, Hochschule Heilbronn, Germany
Till Schuemmer, FernUniversitaet in Hagen, Germany
Sunir Shah, BibWiki.com, Canada
Robert Tolksdorf, Freie Universitaet Berlin, Germany
Brion Vibber, Wikimedia Foundation, United States
Max Vlkel, FZI Forschungszentrum Informatik Karlsruhe, Germany
Jacob Voss, Wikimedia Deutschland, Germany
Christian Wagner, City University of Hong Kong, China
An automated run of parserTests.php showed the following failures:
This is MediaWiki version 1.10alpha (r20670).
Reading tests from "maintenance/parserTests.txt"...
Reading tests from "extensions/Cite/citeParserTests.txt"...
Reading tests from "extensions/Poem/poemParserTests.txt"...
17 still FAILING test(s) :(
* URL-encoding in URL functions (single parameter) [Has never passed]
* URL-encoding in URL functions (multiple parameters) [Has never passed]
* Table security: embedded pipes (http://mail.wikipedia.org/pipermail/wikitech-l/2006-April/034637.html) [Has never passed]
* Link containing double-single-quotes '' (bug 4598) [Has never passed]
* message transform: <noinclude> in transcluded template (bug 4926) [Has never passed]
* message transform: <onlyinclude> in transcluded template (bug 4926) [Has never passed]
* BUG 1887, part 2: A <math> with a thumbnail- math enabled [Has never passed]
* HTML bullet list, unclosed tags (bug 5497) [Has never passed]
* HTML ordered list, unclosed tags (bug 5497) [Has never passed]
* HTML nested bullet list, open tags (bug 5497) [Has never passed]
* HTML nested ordered list, open tags (bug 5497) [Has never passed]
* Inline HTML vs wiki block nesting [Has never passed]
* Mixing markup for italics and bold [Has never passed]
* dt/dd/dl test [Has never passed]
* Images with the "|" character in the comment [Has never passed]
* Parents of subpages, two levels up, without trailing slash or name. [Has never passed]
* Parents of subpages, two levels up, with lots of extra trailing slashes. [Has never passed]
Passed 494 of 511 tests (96.67%)... 17 tests failed!
An automated run of parserTests.php showed the following failures:
This is MediaWiki version 1.10alpha (r20658).
Reading tests from "maintenance/parserTests.txt"...
Reading tests from "extensions/Cite/citeParserTests.txt"...
Reading tests from "extensions/Poem/poemParserTests.txt"...
17 still FAILING test(s) :(
* URL-encoding in URL functions (single parameter) [Has never passed]
* URL-encoding in URL functions (multiple parameters) [Has never passed]
* Table security: embedded pipes (http://mail.wikipedia.org/pipermail/wikitech-l/2006-April/034637.html) [Has never passed]
* Link containing double-single-quotes '' (bug 4598) [Has never passed]
* message transform: <noinclude> in transcluded template (bug 4926) [Has never passed]
* message transform: <onlyinclude> in transcluded template (bug 4926) [Has never passed]
* BUG 1887, part 2: A <math> with a thumbnail- math enabled [Has never passed]
* HTML bullet list, unclosed tags (bug 5497) [Has never passed]
* HTML ordered list, unclosed tags (bug 5497) [Has never passed]
* HTML nested bullet list, open tags (bug 5497) [Has never passed]
* HTML nested ordered list, open tags (bug 5497) [Has never passed]
* Inline HTML vs wiki block nesting [Has never passed]
* Mixing markup for italics and bold [Has never passed]
* dt/dd/dl test [Has never passed]
* Images with the "|" character in the comment [Has never passed]
* Parents of subpages, two levels up, without trailing slash or name. [Has never passed]
* Parents of subpages, two levels up, with lots of extra trailing slashes. [Has never passed]
Passed 494 of 511 tests (96.67%)... 17 tests failed!
Wikigadugi.org has been under a massive Bot-Net generated denial of
service attack since late yesterday. The IP addresses are from China,
Korea, Turkey, and Russia. Blocking at the firewall or proxy just
results in more spawned attacks from hundreds of new and unrelated IP
addresses. I found one solution which was limit the number of
connections httpd allows concurrently and this seems to allow legitimate
users to access the system though the attacks persist. The attack
pattern seems very specific to MediaWiki behavior. It attempts to
load an article then aborts the HTTP request while MediaWiki is churning
through the database, then immediately issues another request for
another article. It in essense shotguns through the entire name space
of articles rapidly. It has trouble taking MediaWiki to its knees but
had no trouble taking squid down to a crawl on the proxies and choking
the network with garbage.
What do you guys do to deal with these zombie bot-net attacks on this scale?
Jeff