Wikitech-l November 2009

wikitech-l@lists.wikimedia.org

64 participants
45 discussions

by 李琴

Hi, I have already got the article data from the wikipedia and I stored it on my computer .Now I want to add the article to the local wiki. I have done a lot of reaserches and I know that there are a lot of things to do. If add a record to the page table ,then the revision,recentchange,text,pagelink table and so on will be changed.So I think maybe there is a easy way to do that . Can you tell me what should I do ? Should I simply use 'insert,update,select...'words? Sincerely looking froward you help, thanks vanessa lee

12 years, 10 months

English Wikipedia bad request error

by Jet Chosawasdi

The English Wikipedia is down. When I try to access Wikipedia, it show a error page which has this message: Bad Request (Invalid Hostname)I can't access Wikipedia because of this error. It should be fixed soon. ~Jet (User:WJetChao)

12 years, 10 months

Size of DB/table of enwiki after import into MySQL

by Ryan Chan

Hello, Anyone has experience in importing enwiki database dump at http://download.wikimedia.org/backup-index.html into a real MySQL server? 1. It seems pages-meta-history has the max. size in term of download, how much storage space does it take when imported into a table? (including index) 2. What are the total storage needed for importing the whole enwiki? 3. Do you experience performance problem when querying the database, seems I think most table if over 10GB size? Any suggestion? I need this imformation as I require to prepare budget plan to buy a proper server for doing the job. Thank you. Ryan

12 years, 10 months

SQL

by 李琴

hi, I want to find something in wikidb. But I don't exectly know how to use the select statement write in WIKI. For ecample . DatabaseBase::select ($ table, $ vars, $ conds = '', $ fname = 'Database::select', $ options = array(), $ join_conds = array() ) How can I use this to rewrite ' select * from recentchangs where rc_id in(selcet max(rc_id) from recentchangs group by rc_title) and rc_title='Wiki' '. Thanks very much! vanessa lee

12 years, 10 months

using higher resolution for math images

by Ralf Schmitt

[Sorry if this is posted twice, I tried to post via gmane but the message didn't show up after 16 hours] Hi all, texvc currently generates math images with a density of 120 dpi. This value is hard coded. I'm attaching a patch which allows one to change that value by passing an additional density argument on the command line. This patch is already being used on wikipedia when one uses the collection extension to generate a pdf. Is it ok to apply this patch to current svn trunk? My coworker has commit rights, but it's not clear to us who is responsible for texvc and if it would be ok to apply it. Regards, - Ralf diff --git a/Makefile b/Makefile index 47c40f9..361a665 100644 --- a/Makefile +++ b/Makefile @@ -9,6 +9,7 @@ render.o render.cmi render.cmo render.cmx texvc_tex.cmx \ texvc_tex.o texvc_tex.cmi texvc_tex html.cmi html.cmo html.cmx \ html.o mathml.cmi mathml.cmo mathml.cmx mathml.o CGIPATH=-I /usr/lib/ocaml/cgi -I /usr/lib/ocaml/netstring -I /usr/lib/ocaml/pcre +PREFIX=/usr/local all: texvc texvc_test texvc_tex texvc.bc: util.cmo parser.cmo html.cmo mathml.cmo texutil.cmo render.cmo lexer.cmo texvc.cmo @@ -37,6 +38,9 @@ texvc_cgi: util.cmo parser.cmo texutil.cmo render.cmo lexer.cmo texvc_cgi.cmo clean: rm -f $(OBJ) +install:: all + install -m 755 -p -s texvc texvc_test texvc_tex $(PREFIX)/bin + html.cmo: render_info.cmi tex.cmi util.cmo html.cmi html.cmx: render_info.cmi tex.cmi util.cmx html.cmi html.cmi: tex.cmi diff --git a/render.ml b/render.ml index 67ecab8..945c2b0 100644 --- a/render.ml +++ b/render.ml @@ -1,15 +1,15 @@ let cmd_dvips tmpprefix = "dvips -q -R -E " ^ tmpprefix ^ ".dvi -f >" ^ tmpprefix ^ ".ps" let cmd_latex tmpprefix = "latex " ^ tmpprefix ^ ".tex >/dev/null" (* Putting -transparent white in converts arguments will sort-of give you transperancy *) -let cmd_convert tmpprefix finalpath = "convert -quality 100 -density 120 " ^ tmpprefix ^ ".ps " ^ finalpath ^ " >/dev/null 2>/dev/null" +let cmd_convert tmpprefix finalpath resolution_in_dpi = "convert -quality 100 -density " ^ (string_of_int resolution_in_dpi) ^ " " ^ tmpprefix ^ ".ps " ^ finalpath ^ " >/dev/null 2>/dev/null" (* Putting -bg Transparent in dvipng's arguments will give full-alpha transparency *) (* Note that IE have problems with such PNGs and need an additional javascript snippet *) (* Putting -bg transparent in dvipng's arguments will give binary transparency *) -let cmd_dvipng tmpprefix finalpath = "dvipng -gamma 1.5 -D 120 -T tight --strict " ^ tmpprefix ^ ".dvi -o " ^ finalpath ^ " >/dev/null 2>/dev/null" +let cmd_dvipng tmpprefix finalpath resolution_in_dpi = "dvipng -gamma 1.5 -D " ^ (string_of_int resolution_in_dpi) ^ " -T tight --strict " ^ tmpprefix ^ ".dvi -o " ^ finalpath ^ " >/dev/null 2>/dev/null" exception ExternalCommandFailure of string -let render tmppath finalpath outtex md5 = +let render tmppath finalpath outtex md5 resolution_in_dpi = let tmpprefix0 = (string_of_int (Unix.getpid ()))^"_"^md5 in let tmpprefix = (tmppath^"/"^tmpprefix0) in let unlink_all () = @@ -30,10 +30,10 @@ let render tmppath finalpath outtex md5 = close_out f; if Util.run_in_other_directory tmppath (cmd_latex tmpprefix0) != 0 then (unlink_all (); raise (ExternalCommandFailure "latex")) - else if (Sys.command (cmd_dvipng tmpprefix (finalpath^"/"^md5^".png")) != 0) + else if (Sys.command (cmd_dvipng tmpprefix (finalpath^"/"^md5^".png") resolution_in_dpi) != 0) then (if (Sys.command (cmd_dvips tmpprefix) != 0) then (unlink_all (); raise (ExternalCommandFailure "dvips")) - else if (Sys.command (cmd_convert tmpprefix (finalpath^"/"^md5^".png")) != 0) + else if (Sys.command (cmd_convert tmpprefix (finalpath^"/"^md5^".png") resolution_in_dpi) != 0) then (unlink_all (); raise (ExternalCommandFailure "convert")) else unlink_all ()) else unlink_all () diff --git a/texvc.ml b/texvc.ml index abddd3d..7fae97c 100644 --- a/texvc.ml +++ b/texvc.ml @@ -3,7 +3,7 @@ let lexer_token_safe lexbuf = try Lexer.token lexbuf with Failure s -> raise (LexerException s) -let render tmppath finalpath tree = +let render tmppath finalpath tree resolution_in_dpi = let outtex = Util.mapjoin Texutil.render_tex tree in let md5 = Digest.to_hex (Digest.string outtex) in begin @@ -19,11 +19,12 @@ let render tmppath finalpath tree = | Some h,Html.LIBERAL,Some m -> "L" ^ md5 ^ h ^ "\000" ^ m | None,_,Some m -> "X" ^ md5 ^ m ); - Render.render tmppath finalpath outtex md5 + Render.render tmppath finalpath outtex md5 resolution_in_dpi end let _ = - Texutil.set_encoding (try Sys.argv.(4) with _ -> "UTF-8"); - try render Sys.argv.(1) Sys.argv.(2) (Parser.tex_expr lexer_token_safe (Lexing.from_string Sys.argv.(3))) + Texutil.set_encoding (try Sys.argv.(4) with _ -> "UTF-8"); + let resolution_in_dpi = (try int_of_string Sys.argv.(5) with _ -> 120) in + try render Sys.argv.(1) Sys.argv.(2) (Parser.tex_expr lexer_token_safe (Lexing.from_string Sys.argv.(3))) resolution_in_dpi with Parsing.Parse_error -> print_string "S" | LexerException _ -> print_string "E" | Texutil.Illegal_tex_function s -> print_string ("F" ^ s) @@ -32,3 +33,4 @@ let _ = | Failure _ -> print_string "-" | Render.ExternalCommandFailure s -> () | _ -> print_string "-" +

12 years, 10 months

Re: [Wikitech-l] Handling of system messages got strange

by Uwe Baumbach

Liangent (liangent(a)gmail.com) wrote Sun Nov 22 16:32:33 UTC 2009: > I found nothing special on http://wiki-de.genealogy.net/ , and I have > seen such behavior on Wikipedia for few times -- maybe it's just a > temporary software error? This is because I healed obvios places. At least one example remains: http://wiki-en.genealogy.net/Special:BookSources Is it possible that during update language files got corrupted? Uwe (Baumbach) U.Baumbach(a)web.de ______________________________________________________ GRATIS für alle WEB.DE-Nutzer: Die maxdome Movie-FLAT! Jetzt freischalten unter http://movieflat.web.de

12 years, 10 months

235 Auto unit conversion

by Sylvain Leroux

Hi, There is an issue concerning unit conversions in wikitext: https://bugzilla.wikimedia.org/show_bug.cgi?id=235 This one doesn't deserved any attention since a long time. The original proposition was about converting units "on the fly" regarding user preferences. I don't know if it is feasible and/or desirable. I propose to work on something less ambitious: adding a parser function to provide conversion - maybe in ParserFunction. The idea would be something like: {{#unit: 1000 ft|m}} => <span title="304m (1000ft)">304m</span> If I start working on this, will anyone accept to review the code? Thanks in advance, Sylvain. -- sylvain(a)chicoree.fr http://www.chicoree.fr

12 years, 10 months

by Bilal Abdul Kader

Greetings, This template is not being parsed on my french local wiki. Any hints on that. I did several search on google but I could not find the problem. bilal -- Verily, with hardship comes ease.

12 years, 10 months

skins

by 李琴

Hi I add a page to the wiki which I write by myself . And I want to use the wiki's skins .What can I do to resolve this problm. Use getSkin() ? Or something others? Thanks very much. vanessa lee

12 years, 10 months

Bugzilla Weekly Report

by reporter＠isidore.wikimedia.org

MediaWiki Bugzilla Report for November 16, 2009 - November 23, 2009 Status changes this week Bugs NEW : 94 Bugs ASSIGNED : 2 Bugs REOPENED : 14 Bugs RESOLVED : 60 Total bugs still open: 4127 Resolutions for the week: Bugs marked FIXED : 40 Bugs marked REMIND : 0 Bugs marked INVALID : 5 Bugs marked DUPLICATE : 7 Bugs marked WONTFIX : 3 Bugs marked WORKSFORME : 5 Bugs marked LATER : 0 Bugs marked MOVED : 0 Specific Product/Component Resolutions & User Metrics New Bugs Per Component Site requests 7 UsabilityInitiative 4 Special pages 4 General/Unknown 3 OTRS 2 New Bugs Per Product MediaWiki 13 Wikimedia 17 MediaWiki extensions 17 Wiktionary tools 1 Top 5 Bug Resolvers roan.kattouw [AT] gmail.com 17 agarrett [AT] wikimedia.org 7 JSchulz_4587 [AT] msn.com 5 sam [AT] reedyboy.net 3 thomasV1 [AT] gmx.de 3

12 years, 10 months

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

Wikitech-l November 2009