I had that problem today. It was the way I start mysql.

If I type: service mysql start The db starts but mediawiki still gave that error.

If I type: /usr/local/mysql/bin/safe_mysqld Bingo. It works.

Why? Who knows. I don't have time to research further.

-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Philip Beach III Sent: Wednesday, February 07, 2007 8:39 AM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] problem with mediawiki

wiki software wrote:

hi, I had installed Mediawiki 1.7.1 and 1.9.1 locally on the system

using IIS

5, PHP5.1.6, and MYSQL server 5.0.24.

It was woking fine for almost week after installaton, but suddenly i

get

this particular error message when i try to access the wiki site on my system.

Wiki has a problem

*Sorry! This site is experiencing technical difficulties.*

Try waiting a few minutes and reloading.

(Can't contact the database server: Access denied for user 'wikiuser'@'localhost' (using password: YES) (localhost))

I have no clue why this is happening though, can someone kindly help

me.

Thanks. _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Something is up with your database/satabase user. Do you have phpMyAdmin?

I would try logging in there and make sure none of your database settings changed... or since your running it locally you could just create a new database user and change the logon info in LocalSettings.php.

_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

This is probably a stupid question, but does the 'mx_redirect' table exist in the 'wiki_wiki' database?

On 2/7/07, Metaspheres metaspheres@yahoo.com wrote:

Hi,

I posted this once before here, but thought I'd try one more time to see if anyone had any ideas. I've also posted on a number of forums, but no one seems to have come across this. I have my wiki backed up, but ideally I'd like to continue being able to upgrade as I've always done.

After having a tech guy at my hosting provider run the update.php and refreshLinks.php scripts I ran into this error when trying to make an edit:

---

Database error

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 "Article::updateRedirectOn". MySQL returned error "1146: Table 'wiki_wiki.mx_redirect' doesn't exist (localhost)".

---

Everything else looks okay (Special:Version works fine), but I can't edit the wiki because of the above error. AdminSettings.php was in the root directory and I did everything as I've done before, but this is the first time I'm getting this problem.

Is it a software issue, corrupt database, ...? Possibly the tech guy said he ran the scripts when he really didn't or something?

Any help would be appreciated.

Thanks,

Sven

---

Never Miss an Email Stay connected with Yahoo! Mail on your mobile. Get started! _______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Hi Brion,

I did everything according to the upgrade instructions as per usual since the 1.6 branch: do backups, unpack the new files over the old ones, make sure AdminSettings is setup properly, and run update.php. I've also run refreshLinks.php since 1.6 for good measure. This is the first time I'm receiving this error, so this is pretty strange. I'm upgrading from 1.8.2 to 1.9.2.

I tried a clean install of 1.9.2 and it went along perfectly with no problems.

Should I revert back to 1.8.2, then upgrade to 1.8.3 and then try 1.9.2? Or should I try the web installer this time around (skipping update.php) and just run refreshLinks? Special:Version reports that the server is running PHP: 5.0.5 (cgi) and MySQL: 4.1.21-standard-log, if that helps.

Thanks,

Sven

--------------------------------- Be a PS3 game guru. Get your game face on with the latest PS3 news and previews at Yahoo! Games.

Hi,

I restored the database and did a clean install of 1.8.2, make sure it worked, then unpacked 1.9.2 and had the support guy run update.php (I have no command-line access, so unfortunately I have to rely on them) and he didn't report any problems. Mind you I have no idea if they are doing something wrong or not, as for some reason they never bother to give me the output even when I request it. I am assuming they are running the script properly since it isn't exactly rocket science. Its one of those support ticket based systems, which makes communication with them difficult.

Anyway, same exact problem as before. So then I delete everything and restore the database as before, do a fresh install of 1.8.2., works fine, then unpack 1.9.2 and I go with the web installer this time around. Worked smoothly and updated the tables perfectly, not even a need for refreshLinks. Which is strange because when I upgraded from 1.6.8 to 1.7.1 and ran the web installer, I had to run refreshLinks.

So anyway, everything works fine now. Either the support guy at my provider was doing something wrong with update.php or the script has some issue with the server. Its also possible I suppose that he wasn't running it at all and just saying he did, but that would be completely bizarre behavior. But one never knows with these characters.

Thanks,

Sven

Brion Vibber brion@pobox.com wrote: -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Metaspheres wrote:

Hi Brion,

I did everything according to the upgrade instructions as per usual since the 1.6 branch: do backups, unpack the new files over the old ones, make sure AdminSettings is setup properly, and run update.php. I've also run refreshLinks.php since 1.6 for good measure. This is the first time I'm receiving this error, so this is pretty strange. I'm upgrading from 1.8.2 to 1.9.2.

Run update.php on 1.9.2 and save the output. Confirm that it's creating the table.

- -- brion vibber (brion @ pobox.com / brion @ wikimedia.org)

_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

--------------------------------- Get your own web address. Have a HUGE year through Yahoo! Small Business.

We use this extension :

http://assela.pathirana.net/File_Link_Extension

Seems to work ok... you need to change some security settings in Firefox to get it to open the document properly though.

thanks Andrew

Anthony Smith wrote:

Let's say I have a Novell Server, and I really want to link to a document or something from Novel or say any file on a windows computer. How would I do that?

For Example: I:\My Documents\Myfile.txt

---

MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

One more thing - if this is Lotus Notes then there is also a special extension *you may find useful:*

http://www.mediawiki.org/wiki/Extension:LotusNotesLink

Notes Version 6 or above required.

Regards, Aretai

On 2/21/07, aretai aretai aretaiuc@gmail.com wrote:

You may also want to try my extension: http://www.mediawiki.org/wiki/Extension:Link

Regards, Aretai

On 2/20/07, Andrew andrew.naismith@adelaide.edu.au wrote:

...

We use this extension :

http://assela.pathirana.net/File_Link_Extension

Seems to work ok... you need to change some security settings in Firefox to get it to open the document properly though.

thanks Andrew

Anthony Smith wrote:

...

Let's say I have a Novell Server, and I really want to link to a document or something from Novel or say any file on a windows

computer.

...

How would I do that?

For Example: I:\My Documents\Myfile.txt

---

MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

---

MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

Hi Anthony,

My wiki is currently using it and I've just tested it with Wiki On a Stick - http://meta.wikimedia.org/wiki/Wiki_on_a_stick

And everything is working. I've followed the guidelines on: http://www.mediawiki.org/wiki/Extension:Link

What version of MW (PHP, etc) you use. Is your PHP environment configured properly?

Regards, Aretai

On 2/21/07, Anthony Smith anthony.smith@fedex.com wrote:

I actually meant when I tried this extension I get the following:

http://www.mediawiki.org/wiki/Extension:Link

I added the extension and then added the entry in the LocalSettings.php Now I get this:

information - headers already sent by (output started at /usr/local/apache2-prod/htdocs/wiki/extensions/Link.php:2) in /usr/local/apache2-prod/htdocs/wiki/includes/WebResponse.php on line 9

-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of aretai aretai Sent: Wednesday, February 21, 2007 3:49 AM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Link to a Novell doc?

You may also want to try my extension: http://www.mediawiki.org/wiki/Extension:Link

Regards, Aretai

On 2/20/07, Andrew andrew.naismith@adelaide.edu.au wrote:

...

We use this extension :

http://assela.pathirana.net/File_Link_Extension

Seems to work ok... you need to change some security settings in

Firefox

...

to get it to open the document properly though.

thanks Andrew

Anthony Smith wrote:

...

Let's say I have a Novell Server, and I really want to link to a document or something from Novel or say any file on a windows

computer.

...

...

How would I do that?

For Example: I:\My Documents\Myfile.txt

---

MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

---

MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

---

MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

---

MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

What do I need to change in Firefox?

-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Andrew Sent: Tuesday, February 20, 2007 5:37 PM To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Link to a Novell doc?

We use this extension :

http://assela.pathirana.net/File_Link_Extension

Seems to work ok... you need to change some security settings in Firefox

to get it to open the document properly though.

thanks Andrew

Anthony Smith wrote:

Let's say I have a Novell Server, and I really want to link to a document or something from Novel or say any file on a windows

computer.

How would I do that?

For Example: I:\My Documents\Myfile.txt

---

MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l

_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l