Hi,
first of all, there's some progress in my attempt to extend and rewrite
the documentation for MediaWiki (see
http://meta.wikipedia.org/wiki/Documentation); there were some
discrepancies with Mav which we have worked out, as I hope.
Currently I'm structuring the sections, collecting text and testing some
instructions. Doing this, I ran into some problems.
(1) Importing a database dump - this applies to section
[http://meta.wikipedia.org/wiki/Documentation:Administration#Getting_data:_Importing_a_database_dump].
(1a) This applies toWhen importing the database dumps cur_ and old_ of
the German Wikipedia from 20031125 (bzip2 -dc cur_* | mysql -u wikiadmin
-padminpass wikidb, then calling php4 rebuildlinks.php), there appeared
failures when running rebuildlinks.php. The script outputs something like
Rebuilding link tables (pass 1).
1000 of 72120 articles scanned.
2000 of 72120 articles scanned.
...
46000 of 72120 articles scanned.
47000 of 72120 articles scanned.
and then gives an error message:
"Error in the database. There was an syntax error in the database
query. The last database query was: "INSERT INTO rebuildlinks
(rl_f_id,rl_f_title,rl_to) VALUES " from the fuction "".
MySQL reported error "1064: You have an error in your SQL syntax."
[...]"
(This is roughly translated from German; the original says "Fehler in
der Datenbank [...] Es gab einen Syntaxfehler in der Datenbankabfrage.
Die letzte Datenbankabfrage lautete: "INSERT INTO rebuildlinks
(rl_f_id,rl_f_title,rl_to) VALUES " aus der Funktion "". MySQL meldete
den Fehler: "1064: 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 '' at line 1".")
The md5 checksums of old_ and cur_ matched those given on the website.
What is recommended to deal with an error like this? Wait a few days and
download a newer dump? Should the wikidb be dropped or cleared before
importing another dump?
(1b) When just importing cur_, rebuildlinks.php runs fine, but when
accessing the Main_Page ("Hauptseite"), it says that there are "0
articles", but the wiki pages exist, in this case, several thousend
pages. Is this the wanted behaviour, or is there something else to do
after running rebuildlinks.php? Also, newly created pages are not being
counted.
(3) Rewrite Engine - this applies to section
[http://meta.wikipedia.org/wiki/Documentation:Configuration].
The statement references to an external RewriteMap which I couldn't find:
RewriteMap ampescape int:ampescape
RewriteRule ^/wiki/(.*)$ /wiki.phtml?title=${ampescape:$1} [L]
The ../maintenance directory contains just apache-ampersand.diff. Is the
RewriteMap used by Wikipedia somewhere publicly available?
Thanks & greetings, -asb
first of all, there's some progress in my attempt to extend and rewrite
the documentation for MediaWiki (see
http://meta.wikipedia.org/wiki/Documentation); there were some
discrepancies with Mav which we have worked out, as I hope.
Currently I'm structuring the sections, collecting text and testing some
instructions. Doing this, I ran into some problems.
(1) Importing a database dump - this applies to section
[http://meta.wikipedia.org/wiki/Documentation:Administration#Getting_data:_Importing_a_database_dump].
(1a) This applies toWhen importing the database dumps cur_ and old_ of
the German Wikipedia from 20031125 (bzip2 -dc cur_* | mysql -u wikiadmin
-padminpass wikidb, then calling php4 rebuildlinks.php), there appeared
failures when running rebuildlinks.php. The script outputs something like
Rebuilding link tables (pass 1).
1000 of 72120 articles scanned.
2000 of 72120 articles scanned.
...
46000 of 72120 articles scanned.
47000 of 72120 articles scanned.
and then gives an error message:
"Error in the database. There was an syntax error in the database
query. The last database query was: "INSERT INTO rebuildlinks
(rl_f_id,rl_f_title,rl_to) VALUES " from the fuction "".
MySQL reported error "1064: You have an error in your SQL syntax."
[...]"
(This is roughly translated from German; the original says "Fehler in
der Datenbank [...] Es gab einen Syntaxfehler in der Datenbankabfrage.
Die letzte Datenbankabfrage lautete: "INSERT INTO rebuildlinks
(rl_f_id,rl_f_title,rl_to) VALUES " aus der Funktion "". MySQL meldete
den Fehler: "1064: 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 '' at line 1".")
The md5 checksums of old_ and cur_ matched those given on the website.
What is recommended to deal with an error like this? Wait a few days and
download a newer dump? Should the wikidb be dropped or cleared before
importing another dump?
(1b) When just importing cur_, rebuildlinks.php runs fine, but when
accessing the Main_Page ("Hauptseite"), it says that there are "0
articles", but the wiki pages exist, in this case, several thousend
pages. Is this the wanted behaviour, or is there something else to do
after running rebuildlinks.php? Also, newly created pages are not being
counted.
(3) Rewrite Engine - this applies to section
[http://meta.wikipedia.org/wiki/Documentation:Configuration].
The statement references to an external RewriteMap which I couldn't find:
RewriteMap ampescape int:ampescape
RewriteRule ^/wiki/(.*)$ /wiki.phtml?title=${ampescape:$1} [L]
The ../maintenance directory contains just apache-ampersand.diff. Is the
RewriteMap used by Wikipedia somewhere publicly available?
Thanks & greetings, -asb
