MediaWiki-l February 2006

mediawiki-l@lists.wikimedia.org

159 participants
218 discussions

Re: [Mediawiki-l] Database error
by Vasiliadis, Thomas 17 Feb '06

17 Feb '06

It is possible, that wiki has now right to write it files??? -----Ursprüngliche Nachricht----- Von: mediawiki-l-bounces(a)Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] Im Auftrag von Terry Auspitz Gesendet: Donnerstag, 16. Februar 2006 13:46 An: MediaWiki announcements and site admin list Betreff: [Mediawiki-l] Database error I am getting the following MySQL error when creating a new page on my wiki: A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "SearchMySQL4::update". MySQL returned error "1016: Can't open file: 'wt_searchindex.MYI' (errno: 145) (localhost)". If it helps, the wiki in question is http://wikitography.org. Thanks, ~Terry _______________________________________________ MediaWiki-l mailing list MediaWiki-l(a)Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

2 1

Re: [Mediawiki-l] [mediawiki-l] couldn't connect to database (Paul Sanderson)
by Jasmin Hannemann 17 Feb '06

17 Feb '06

Hi Paul, I had the same problem, when I moved my wiki. In my case, I had installed MySql 4.1. but I read, that there are some problems. I also installed MySql 4.0 and the wiki works fine. Cheers mediawiki-l-request(a)Wikimedia.org wrote: >Send MediaWiki-l mailing list submissions to > mediawiki-l(a)Wikimedia.org > >To subscribe or unsubscribe via the World Wide Web, visit > http://mail.wikipedia.org/mailman/listinfo/mediawiki-l >or, via email, send a message with subject or body 'help' to > mediawiki-l-request(a)Wikimedia.org > >You can reach the person managing the list at > mediawiki-l-owner(a)Wikimedia.org > >When replying, please edit your Subject line so it is more specific >than "Re: Contents of MediaWiki-l digest..." > > >Today's Topics: > > 1. Especial:Newpages doens't follow .htaccess (Mauro do Carmo) > 2. Help with Email (Jacob Llamas) > 3. Help With GMap Extension? (John Concilus) > 4. couldn't connect to database (Paul Sanderson) > 5. Fwd: couldn't connect to database (Paul Sanderson) > 6. Mysql, UTF-8: How is it supposed to work? (Dorthe Luebbert) > 7. Re: Mysql, UTF-8: How is it supposed to work? (Brion Vibber) > 8. Re: Database error (Vasiliadis, Thomas) > > >---------------------------------------------------------------------- > >Message: 1 >Date: Thu, 16 Feb 2006 09:03:31 -0800 >From: "Mauro do Carmo" <mauro(a)carmo.ws> >Subject: [Mediawiki-l] Especial:Newpages doens't follow .htaccess >To: "'MediaWiki announcements and site admin list'" > <mediawiki-l(a)Wikimedia.org> >Message-ID: <20060216170342.CE5981191062(a)mail.wikimedia.org> >Content-Type: text/plain; charset="windows-1250" > >Thanks to ALL of you for your great help, > >I could do nothing without you guys. > >I get another question, though: > >I've noticed that the links on Especial:Allpages, and Especial:Recentchanges >respect the .htaccess rewrite roles so all links of my site look nice. > >However, the links on Especial:Newpages do not follow the .htaccess rewrite. >That is one think important to me since Especial:Newpages is one of the most >important page in my wiki. > >So, if anyone could give me a clue to how to change the links on >Especial:Newpages in order to have them rewrited, I will appreciate. > >Thanks a lot, mauro. > > > > >

1 0

Re: [Mediawiki-l] Database backup, How to
by Vasiliadis, Thomas 17 Feb '06

17 Feb '06

Thanks to all, I took the batch file solution and it works well. TV -----Ursprüngliche Nachricht----- Von: mediawiki-l-bounces(a)Wikimedia.org [mailto:mediawiki-l-bounces@Wikimedia.org] Im Auftrag von Andrew Mole Gesendet: Mittwoch, 25. Januar 2006 14:47 An: mediawiki-l(a)wikimedia.org Betreff: Re: [Mediawiki-l] Database backup, How to Have you tried using the free "MySQL Administrator" for Windows? http://dev.mysql.com/downloads/administrator/ I can't remember the details, but I think it actually sets up scheduled tasks with Windows "Task Scheduler". I suggest you check it out. Andrew From: Rob Church <robchur(a)gmail.com> Subject: Re: [Mediawiki-l] Database backup, How to To: MediaWiki announcements and site admin list <mediawiki-l(a)wikimedia.org> Message-ID: <e92136380601250404kd520dcap(a)mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Microsoft Windows doesn't have cron jobs in the same fashion; about the closest thing built into it is Task Scheduler, which is somewhat unreliable, but could work. The original question was how to back up the database? One option could be to write a small batch script to perform the mySQL command-line client line needed to do the export, then create a scheduled task to run this every so often. > > -----Ursprüngliche Nachricht----- > > Von: mediawiki-l-bounces(a)Wikimedia.org > > [mailto: mediawiki-l-bounces(a)Wikimedia.org]Im Auftrag von Vasiliadis, > > Thomas > > Gesendet: Donnerstag, 19. Januar 2006 10:00 > > An: MediaWiki announcements and site admin list > > Betreff: [Mediawiki-l] Database backup, How to > > > > > > Hi there, > > > > I have succesfully installed a Wiki with MySQL 5.0.15-nt and now I have > > to manage the Backups. > > But how to do it? > > I found a Directory named mysql\data\wikidb with some MYI MYD and FRM > > files. Is it this, what I have to Backup? > > Is there any methode of do it automatical? > > I have installed it via xampp > > > > Thanks > > > > TV

1 0

couldn't connect to database
by Paul Sanderson 17 Feb '06

17 Feb '06

I ahve searched through the archives and have not managed to find a solution to this yet. I am just in the process of moving my wiki to a new server. Everything ran fine on the old box but when I install on the new one I get the following. MediaWiki 1.5.6 installation Please include all of the lines below when reporting installation problems. Checking environment... PHP 5.0.2: ok PHP server API is cgi-fcgi; using ugly URLs (index.php?title=Page_Title) Have XML / Latin1-UTF-8 conversion support. PHP is configured with no memory_limit. Have zlib support; enabling output compression. Neither Turck MMCache nor eAccelerator are installed, can't use object caching functions GNU diff3 not found. Couldn't find GD library or ImageMagick; image thumbnailing disabled. Installation directory: D:\home\Default\xxxxxxxxxxx.com\htdocs\wiki Script URI path: /wiki Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider changing it manually. PHP is linked with old MySQL client libraries. If you are using a MySQL 4.1 server and have problems connecting to the database, see http://dev.mysql.com/doc/mysql/en/old-client.html for help. Connecting to sf on localhost as root...failed with error 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client. Something's not quite right yet; make sure everything below is filled out correctly. and then further down Database config MySQL server Couldn't connect to database I have seen a post that suggets upgrading PHP so I tried 5.1.2 but this broke so many other things that I don't think it is worth it. I have also seen various posts reagrding authentication and I have done the set password thing in MySQL - this didn't help either. Anyone have any ideas how I can take this forward?

1 1

Help With GMap Extension?
by John Concilus 17 Feb '06

17 Feb '06

Hello, I am fairly new to Mediawiki , and subscribe to several of the lists. I am hesitant to post to the list, as I feel like a nitwit! I've tried to search for answers elsewhere. The recent post about the Wikipubs project really struck a chord with our curriculum team, and I've been struggling trying build the same sort of functionality he used for pubs into our Mediawiki (1.52) installation. James did a great job with that project. We are a school district on the Bering Sea coast of Alaska, and all of our communities are Yup'ik, Siberian Yup'ik or Inupiaq Eskimo. No roads connect the villages, and traditional hunting and gathering activities are the mainstay of the local "economy" ;-) Our school district is converting our entire curriculum to Mediawiki format, and everyone is jazzed about the potential for wiki use in collaborative resource development, and instructional use by teachers using "place-based" education for writing. The Problem I have followed the instructions on the meta "mafs" page about the Google Map Extension...as far as I can tell...at: http://meta.wikimedia.org/wiki/User:Mafs/GoogleMapExtension - Got a key from Google - Modified LocalSettings.php with the key like this: $IP = "/home/wikibss/public_html"; ini_set( "include_path", ".:$IP:$IP/includes:$IP/languages" ); require_once( "includes/DefaultSettings.php" ); require_once('extensions/gmap.php'); $wgGmapKey = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"; $wgGmapSource = "http://maps.google.com/maps?file=api&v=1&key="; - Created the "gmap.php" file and put in "extensions" - Created the "gmap.js" file and put in "skins/commons" - Modified "MonoBook.php" to add the "function execute()" call - Created a cache directory Got this error: Fatal error: Call to undefined function: curl_init() in /home/wikibss/public_html/extensions/gmap.php on line 291 - Recompiled Apache with curl module (duh!) - I'm trying to test it with the sample script from the meta.wikipedia page, but each sample comes up with the same problem....a blank page. My Question: When I go to that page now I don't get any error, and I see the status bar indicating it is contacting Google Maps....but the page appears blank. What could cause this? I don't know how to trouble shoot this. Our Wiki: http://wiki.bssd.org/ Error Page: http://wiki.bssd.org/index.php/Trail_Markers If my question is naive, I apologize to the regulars for their tolerance, and thank you all in advance for your help. Regards, JTC...in the Bering Sea -- "No matter where you go, there you are." Buckaroo Banzai & Confucius Digital Contacts: http://www.bssd.org jconcilus(a)bssd.org Skype VOIP: Johncn2 John Concilus, Coordinator of Educational Technology Bering Strait School District 225 Polar Bear Avenue Unalakleet, AK 99684 907-624-4237 (Office) 907-624-3283 (Fax)

1 0

Help with Email
by Jacob Llamas 17 Feb '06

17 Feb '06

Hello, I'm running media wiki 1.5.5 on a RedHat Enterprise AS 4 box. I can not seem to get email working... from the command line I can use "mail -s "test" jllamas(a)ipac.caltech.edu" to send my self a message... But within the wiki no email is sent (notifications, password rest, etc). Here is my LocalSettings file... [root@pelican ISGWIKI]# cat LocalSettings.php <?php # This file was automatically generated by the MediaWiki installer. # If you make manual changes, please keep track in case you need to # recreate them later. $IP = "/var/www/ISGWIKI"; ini_set( "include_path", ".:$IP:$IP/includes:$IP/languages" ); require_once( "includes/DefaultSettings.php" ); # If PHP's memory limit is very low, some operations may fail. ini_set( 'memory_limit', '20M' ); if ( $wgCommandLineMode ) { if ( isset( $_SERVER ) && array_key_exists( 'REQUEST_METHOD', $_SERVER ) ) { die( "This script must be run from the command line\n" ); } } elseif ( empty( $wgNoOutputBuffer ) ) { ## Compress output if the browser supports it if( !ini_get( 'zlib.output_compression' ) ) @ob_start( 'ob_gzhandler' ); } $wgSitename = "ISGwiki"; $wgLocaltimezone="PST8PDT"; $wgLocalTZoffset = date("Z") / 3600; $wgGroupPermissions['*' ]['createaccount'] = false; $wgGroupPermissions['*' ]['read'] = true; $wgGroupPermissions['*' ]['edit'] = false; $wgScriptPath = ""; $wgScript = "$wgScriptPath/index.php"; $wgRedirectScript = "$wgScriptPath/redirect.php"; ## If using PHP as a CGI module, use the ugly URLs $wgArticlePath = "$wgScript/$1"; # $wgArticlePath = "$wgScript?title=$1"; $wgStylePath = "$wgScriptPath/skins"; $wgStyleDirectory = "$IP/skins"; $wgLogo = "$wgScriptPath/images/isg-button.png"; $wgUploadPath = "$wgScriptPath/images"; $wgUploadDirectory = "$IP/images"; $wgEnableEmail = true; $wgEnableUserEmail = true; $wgEmergencyContact = "www(a)ipac.caltech.edu"; $wgPasswordSender = "www(a)ipac.caltech.edu"; ## For a detailed description of the following switches see ## http://meta.wikimedia.org/Enotif and http://meta.wikimedia.org/Eauthent ## There are many more options for fine tuning available see ## /includes/DefaultSettings.php ## UPO means: this is also a user preference option $wgEnotifUserTalk = true; # UPO $wgEnotifWatchlist = true; # UPO $wgEmailAuthentication = true; $wgDBserver = "localhost"; $wgDBname = "XXXXXXXX"; $wgDBuser = "XXXXXXXX"; $wgDBpassword = "XXXXXXXX"; $wgDBprefix = "ISGWIKI"; # If you're on MySQL 3.x, this next line must be FALSE: $wgDBmysql4 = true; # Experimental charset support for MySQL 4.1/5.0. $wgDBmysql5 = false; ## Shared memory settings $wgMainCacheType = CACHE_NONE; $wgMemCachedServers = array(); ## To enable image uploads, make sure the 'images' directory ## is writable, then uncomment this: $wgEnableUploads = true; $wgUseImageResize = true; $wgUseImageMagick = true; $wgImageMagickConvertCommand = "/usr/bin/convert"; ## If you want to use image uploads under safe mode, ## create the directories images/archive, images/thumb and ## images/temp, and make them all writable. Then uncomment ## this, if it's not already uncommented: # $wgHashedUploadDirectory = false; ## If you have the appropriate support software installed ## you can enable inline LaTeX equations: # $wgUseTeX = true; $wgMathPath = "{$wgUploadPath}/math"; $wgMathDirectory = "{$wgUploadDirectory}/math"; $wgTmpDirectory = "{$wgUploadDirectory}/tmp"; $wgLocalInterwiki = $wgSitename; $wgLanguageCode = "en"; $wgProxyKey = "9ee8f21a31eae079993ee2e0d6ebba787188c35d4e0f35176dfd50db1fb92788"; ## Default skin: you can change the default skin. Use the internal symbolic ## names, ie 'standard', 'nostalgia', 'cologneblue', 'monobook': # $wgDefaultSkin = 'monobook'; ## For attaching licensing metadata to pages, and displaying an ## appropriate copyright notice / icon. GNU Free Documentation ## License and Creative Commons licenses are supported so far. # $wgEnableCreativeCommonsRdf = true; $wgRightsPage = ""; # Set to the title of a wiki page that describes your license/copyright $wgRightsUrl = ""; $wgRightsText = ""; $wgRightsIcon = ""; # $wgRightsCode = ""; # Not yet used $wgDiff3 = "/usr/bin/diff3"; ?> Thanks in advance Jake -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ + + . _ .-. Jacob Llamas + + 3\ ({)_ . ( \ IPAC/Caltech/ISG + + + . \=)`\-| * ) \ _.Office 626-395-3115 + + . /_`' / |\ .-' ` + +. CD'/`-'|_| ) / . Much learning does not + + . * // ( / . teach understanding. + + . CD' `-' - Heraclitus + +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

1 0

Especial:Newpages doens't follow .htaccess
by Mauro do Carmo 16 Feb '06

16 Feb '06

Thanks to ALL of you for your great help, I could do nothing without you guys. I get another question, though: I've noticed that the links on Especial:Allpages, and Especial:Recentchanges respect the .htaccess rewrite roles so all links of my site look nice. However, the links on Especial:Newpages do not follow the .htaccess rewrite. That is one think important to me since Especial:Newpages is one of the most important page in my wiki. So, if anyone could give me a clue to how to change the links on Especial:Newpages in order to have them rewrited, I will appreciate. Thanks a lot, mauro. -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.9/261 - Release Date: 2/15/2006

1 0

Editing special pages / Upload additional file types
by zach bass 16 Feb '06

16 Feb '06

Hi, I'm somewhat of a n00b to MediaWiki administration and have a couple questions. Apologies if these have been answered before, but I checked the list archives and web and haven't been able to find clear answers. 1. Is it possible to edit special pages? It looks like the text for special pages is stored in the database and is non-editable binary data, and that these database fields are populated from the file ./languages/Language.php, but changing the text in this file has no effect--is this data just imported to the database when the Wiki is first set up? Is there any way to pull in new changes from this file? 2. Is it possible to allow uploads of all file types (versus only images, audio, or video)? I'd like to permit users to upload PDFs, .xls, .doc, etc so they can store templates, documentation, etc. 3. Is there a way to add your own special pages that contain PHP code? I'd like to embed a PHP tool into a new Wiki page (this page doesn't have to be editable by users). I'm pretty sure this is possible, but not sure what's the best/recommended way. Thanks! -zach

3 4

Error in numRows() trying to rollback
by Al Degutis 16 Feb '06

16 Feb '06

I was alerted to spam entries by someone that tried to remove them but couldn't. When I try to rollback or save a new copy of the page I get the following error: Error in numRows(): 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 Backtrace: * GlobalFunctions.php line 451 calls wfbacktrace() * Database.php line 554 calls wfdebugdiebacktrace() * Wikification.php line 136 calls databasemysql::numrows() * - line - calls wikification_save() * Hooks.php line 109 calls call_user_func_array() * EditPage.php line 470 calls wfrunhooks() * EditPage.php line 178 calls editpage::editform() * EditPage.php line 285 calls editpage::edit() * index.php line 219 calls editpage::submit() Any suggestions? Thanks Al Degutis

1 0

Database error
by Terry Auspitz 16 Feb '06

16 Feb '06

I am getting the following MySQL error when creating a new page on my wiki: A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: (SQL query hidden) from within function "SearchMySQL4::update". MySQL returned error "1016: Can't open file: 'wt_searchindex.MYI' (errno: 145) (localhost)". If it helps, the wiki in question is http://wikitography.org. Thanks, ~Terry

1 0

← Newer
1
...
7
8
9
10
11
12
13
...
22
Older →

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

MediaWiki-l February 2006