MediaWiki-l October 2009

mediawiki-l@lists.wikimedia.org

73 participants
75 discussions

Re: [Mediawiki-l] Importing an Excel Spread sheet
by Jan Steinman 22 Oct '09

22 Oct '09

> From: "DaveM" <davem(a)triumphtalk.com> > > Is there anyway to import a spreadsheet into my Wiki. I have quite a > bit of > information I need to place in my WiKi and it is on an excel > spreadsheet. > Now to have to make up tables for all this will take me forever so > is there > an easer way of getting this into my WikI beside just adding the > spread > sheet as a download You could place the extension (.XLS) into the array of file types that are allowed to be uploaded, and then simply upload the files. They will be fairly useless to others until they download them and bring them into Excel. Another way that's more interactive is to export them as CSV files, import them into their own tables in MySQL, then use the sql2wiki extension to display them. This is much more versatile, but can only be done on a trusted site, as you generally don't want just anyone sending arbitrary SQL to your database. You can also update and change the tables at will, and have the changes instantly show up on the wiki. Here's some examples of live data display: http://www.EcoReality.org/wiki/2009_harvest http://www.EcoReality.org/wiki/User:Jan_Steinman/Vehicle_log :::: Quite clearly, our task is predominantly metaphysical, for it is how to get all of humanity to educate itself swiftly enough to generate spontaneous behaviors that will avoid extinction. -- R. Buckminster Fuller, _Synergetics_ :::: :::: Jan Steinman, EcoReality http://www.EcoReality.org ::::

1 0

Welcome to mediawiki-l (weekly posting)
by river＠nightshade.toolserver.org 22 Oct '09

22 Oct '09

Welcome to mediawiki-l. This mailing list exists for discussion and questions about the MediaWiki software[0]. Important MediaWiki-related announcements (such as new versions) are also posted to this list. Other resources. If you only wish to receive announcements, you should subscribe to mediawiki-announce[1] instead. MediaWiki development discussion, and all Wikimedia technical questions, should be directed to the wikitech-l[2] mailing list. Several other MediaWiki-related lists exist: - mediawiki-api[5] for API discussions, - mediawiki-enterprise[6] for discussion of MediaWiki in the enterprise, - mediawiki-cvs[7] for notification of commits to the Subversion repository, - mediawiki-i18n[8] for discussion of MediaWiki internationalisation support, - wikibugs-l[9] for notification of changes to the bug tracker. List administrivia (unsubscribing, list archives). To unsubscribe from this mailing list, visit [12]. Archives of previous postings can be found at [3]. This list is also gatewayed to the Gmane NNTP server[4], which you can use to read and post to the list. Posting to the list. Before posting to this list, please read the MediaWiki FAQ[10]. Many common questions are answered here. You may also search the list archives to see if your question has been asked before. Please try to ask your question in a way that enables people to answer you. Provide all relevant details, explain your problem clearly, etc. You may wish to read [13], which explains how to ask questions well. To post to the list, send mail to <mediawiki-l(a)lists.wikimedia.org>. This is a public list, so you should not include confidential information in mails you send. When replying to an existing thread, use the "Reply" or "Followup" feature of your mail client, so that clients that understand threading can sort your message properly. When quoting other messages, please use the "inline" quoting style[11], for clarity. When creating a new thread, do not reply to an existing message and change the subject. This will confuse peoples' mail readers, and will result in fewer people reading your mail. Instead, compose a new message for your post. Messages posted to the list have the "Reply-To" header set to the mailing list, which means that by default, replies will go to the entire list. If you are posting a reply which is only interesting to the original poster, and not the list in general, you should change the reply to only go to that person. This avoids cluttering the list with irrelevant traffic. About this message. This message is posted to the list once per week by <river(a)wikimedia.org>. Please contact me if you have any questions or concerns about this mailing. References. [0] http://www.mediawiki.org/ [1] http://lists.wikimedia.org/mailman/listinfo/mediawiki-announce [2] http://lists.wikimedia.org/mailman/listinfo/wikitech-l [3] http://lists.wikimedia.org/pipermail/mediawiki-l/ [4] http://dir.gmane.org/gmane.org.wikimedia.mediawiki [5] http://lists.wikimedia.org/mailman/listinfo/mediawiki-api [6] http://lists.wikimedia.org/mailman/listinfo/mediawiki-enterprise [7] http://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs [8] http://lists.wikimedia.org/mailman/listinfo/mediawiki-i18n [9] http://lists.wikimedia.org/mailman/listinfo/wikibugs-l [10] http://www.mediawiki.org/wiki/FAQ [11] http://en.wikipedia.org/wiki/Posting_style#Inline_replying [12] http://lists.wikimedia.org/mailman/listinfo/mediawiki-l [13] http://www.catb.org/~esr/faqs/smart-questions.html

1 0

Last login time
by Francois Piette 22 Oct '09

22 Oct '09

Hello, I would like to query the wiki database to get a list of users with their last login time. The user table doesn't have a field for last login. Maybe the information is somewhere in the logging table ? Any help appreciated. -- francois.piette(a)overbyte.be The author of the freeware multi-tier middleware MidWare The author of the freeware Internet Component Suite (ICS) http://www.overbyte.be -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.

5 5

Upload files not working since upgrade
by David Price 21 Oct '09

21 Oct '09

Dear All, Since upgrading MediaWiki from 1.12 to 1.15 I have lost the ability to upload files, I get the below internal error. Could not rename file "C:\PHP\uploadtemp\php140.tmp" to "public/8/8b/Tn_IMG_6423ASL_CARDIFF.jpg". Can anyone suggest anything to rectify this? David ________________________________________________________________________ This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ________________________________________________________________________

1 0

Installing CodeReview
by Mike.lifeguard 20 Oct '09

20 Oct '09

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I have tried to get the CodeReview extension, and I've run into two problems. For the code_authors table in codereview.sql, I had to reduce both varchar(255) to varchar(160) because I was getting "#1071 - Specified key was too long; max key length is 1000 bytes" -- why would that need to be shorter? (and by so much!) But - reduce the size and it works. For svnImport.php, the script claims to be working (though with errors) but no revisions are actually imported: root@binnie:/var/www/w/extensions/CodeReview# php svnImport.php mikelifeguard Syncing repo mikelifeguard from r1 to HEAD... svn: invalid option: --trust-server-cert Type 'svn help' for usage. svn: invalid option: --trust-server-cert Type 'svn help' for usage. svn: invalid option: --trust-server-cert Type 'svn help' for usage. svn: invalid option: --trust-server-cert Type 'svn help' for usage. svn: invalid option: --trust-server-cert Type 'svn help' for usage. Pre-caching the latest 50 diffs... Done! The repository uses svn:// and not apache (the --trust-server-cert sounds like to me like it might be expecting https:// and it might have to trust the cert - but I use svnserve not apache for now at least). What can I do to have this work? Thanks for your help, - -Mike -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkrb6HAACgkQst0AR/DaKHssSACeLk/6M87kxrkAYn7erkp0leHa aIYAoKmQWaFwqlFiHmEMT0GJmFeX8YfD =oB1U -----END PGP SIGNATURE-----

2 2

Help with help pages
by Laura O'Grady 19 Oct '09

19 Oct '09

Hi all, I followed the instructions at http://www.mediawiki.org/wiki/Help:Copying to install the public domain help pages at my wiki. I'm not sure what happened but I think the export process has somehow been tampered with. Please see the results here: http://lauraogrady.ca/ckbwiki/index.php/Help:Contents If you scroll through this page you will see that is repeats the same content (Template then Usage). Has anyone recently installed the help files? If so, did you get it to work? Also I followed the instructions at http://www.mediawiki.org/wiki/Special:ListFiles to grab all the images associate with the help pages. There are literally hundreds of them and it took a considerable amount of time to grab them one file at a time. I haven't uploaded them yet due to the problem with the help pages. My question is could they not be provided in a zip/compressed format for download? Thanks. Laura

3 5

List all the pages with no image
by Wikimini 17 Oct '09

17 Oct '09

Hello! I need a way to find all the pages on my wiki that do not have any illustrations yet. I was wondering if there was a tool to do that. Sorry for my poor english and thank you a lot for your help! Laurent

3 3

Problem restoring MW 1.15.1 DB from PostgreSQL 8.3 to PostgreSQL 8.4
by Madison Kelly 17 Oct '09

17 Oct '09

Hi all, I understand that PostgreSQL isn't as well supported by mediawiki as MySQL is, but it's what I am familiar with, so I use it. :) Specifically, I already use it on my server (Debian Lenny), and I want to install it on my laptop for devel and testing (Ubuntu 9.10), so I actually really need to stick with PostgreSQL at this point. Which brings me to my problem; I tried just copying my MW install and database to the laptop, but I get a bunch of PgSQL errors: ------------------------------------- Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "objectcache" does not exist LINE 1: ...diaWikiBagOStuff::_doquery */ value,exptime FROM objectcach... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580 Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "objectcache" does not exist LINE 1: ...gOStuff::_doquery 127.0.0.1 */ value,exptime FROM objectcach... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580 Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "objectcache" does not exist LINE 1: ...gOStuff::_doquery 127.0.0.1 */ value,exptime FROM objectcach... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580 Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "objectcache" does not exist LINE 1: .../* MediaWikiBagOStuff::_doquery 127.0.0.1 */ FROM objectcach... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580 Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "objectcache" does not exist LINE 1: ...gOStuff::_doquery 127.0.0.1 */ value,exptime FROM objectcach... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580 Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "objectcache" does not exist LINE 1: .../* MediaWikiBagOStuff::_doquery 127.0.0.1 */ FROM objectcach... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580 Warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "page" does not exist LINE 1: ...eCache::loadFromDB 127.0.0.1 */ page_title FROM page WHER... ^ in /var/www/wiki.alteeve.com/html/includes/db/DatabasePostgres.php on line 580 MediaWiki internal error. Exception caught inside exception handler ------------------------------------- How do I know if I am doing something wrong WRT restoring from backup versus a MW + PgSQL 8.4 bug? I simply do 'pg_dump an_wiki -U digimer > an_wiki.out' and use the resulting file to load back the DB: 'psql an_wiki -U digimer -f an_wiki.out'; Nothing special. Thanks! Madi

1 0

JS2 and jquery
by Gregor Hagedorn 17 Oct '09

17 Oct '09

We need some help with the new JS2 method. Th documentation is understandably a bit patchy (http://www.mediawiki.org/wiki/Talk:JS2_Overview - anything better or more?). Scenario: we use jquery for javascript that resides in the mediawiki namespace and is called through mediawiki:common.js In the last months, the usability initiative has provided the necessary jquery core library. With the update to the current mediawiki revision (as used by wikipedia) this no longer works. I understand that JS2 provides a superior mechanism. And I understand that ulitmately, putting language strings into php might be beneficial. For the moment, however: Is there a simple cooking recipe to simply make use of JS2 for having jquery loaded? We could write an extension, to hardcode that, but we would like to move forward and start using JS2. thanks in advance! Gregor -- --------------------------------- Dr. Gregor Hagedorn Heinrich-Seidel-Str. 2 12167 Berlin skype: g.hagedorn This message is sent on a personal basis and does not constitute an activity of the German Federal Government or its research institutions. Together with any attachments, this message is intended only for the person to whom it is addressed and may not be redistributed or published without permission.

1 1

Re: [Mediawiki-l] How do you allow zip files uploads
by Jan Luca 16 Oct '09

16 Oct '09

Hello, .zip files are locked in $wgMimeTypeBlacklist because .zip can be a security hole. If you really want to enable the upload, add this to LocalSettings.php: $wgMimeTypeBlacklist= array( # HTML may contain cookie-stealing JavaScript and web bugs 'text/html', 'text/javascript', 'text/x-javascript', 'application/x-shellscript', # PHP scripts may execute arbitrary code on the server 'application/x-php', 'text/x-php', # Other types that may be interpreted by some servers 'text/x-python', 'text/x-perl', 'text/x-bash', 'text/x-sh', 'text/x-csh', # Windows metafile, client-side vulnerability on some systems 'application/x-msmetafile', ); $wgFileExtensions[] = 'zip'; Viele Grüße Jan -----Ursprüngliche Nachricht----- Von: mediawiki-l-bounces(a)lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] Im Auftrag von DaveM Gesendet: Freitag, 16. Oktober 2009 13:55 An: mediawiki-l(a)lists.wikimedia.org Betreff: [Mediawiki-l] How do you allow zip files uploads I need to configure my wiki to allow uploading of zip files. Now I have added it to my LocalSettings.php file. However I see that it is still blacklisted and I need to change this setting in another file. I have done quite a bit of reading up on this but I am still in the dark as to what file I need to edit and what I need to edit into it? _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/mediawiki-l

2 1

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

MediaWiki-l October 2009