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
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.
>
>
>
>
>
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
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?
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)
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 +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
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
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
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
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