[Mediawiki-l] Problem with image upload

[Tim Gowen]

Having fixed my database with Platonides' help I have users complaining
that IIS is asking for a password on pages which have images.  I've
added NTFS permissions for the IUSR_machine account to the mediawiki
folder in \inetpub\wwwroot so I'm not really sure why this is happening.

I don't get asked for a password, but then I'm a domain admin.

	Tim

-----Original Message-----
From: Platonides [mailto:Platonides at gmail.com]
Sent: 17 January 2008 20:57
To: mediawiki-l at lists.wikimedia.org
Subject: Re: [Mediawiki-l] Problem with image upload

Tim Gowen wrote:
> I've just installed MediaWiki in Windows 2003 with MySQL 4.1.22, PHP
> 5.2.5 and MediaWiki 1.11.0.
> 
> I have enabled upload of images, but when I select an image for upload

> I get the following internal error:
> 
> A database error has occurred
> Query: SELECT
> img_size,img_width,img_height,img_bits,img_media_type,img_major_mime,i
> mg
> _minor_mime,img_metadata,img_timestamp,img_sha1 FROM `image` WHERE 
> img_name = 'Campaignlogo.jpg' LIMIT 1
> Function: LocalFile::loadFromDB
> Error: 1054 Unknown column 'img_sha1' in 'field list' (localhost)
> 
> Am I using the wrong version of MySQL or PHP?

There's a mismatch between your mediawiki code version and your table
layout.
Try
running maintenance/update.php If that doesn't fix it, manually ALTER
TABLE to add the img_sha1 column. You can find a list of the tables in
maintenance/tables.sql



RAF Museum Photograph Sales are now available online at www.rafmuseumphotos.com 

Confidentiality: This e-mail and its attachments are intended for the above named only and may be confidential. If they have come to you in error you must take no action based on them, nor must you copy or show them to anyone; please reply to this e-mail and highlight the error.

Security Warning: Please note that this e-mail has been created in the knowledge that Internet e-mail is not a 100% secure communications medium. You should remember this lack of security when e-mailing us.

Viruses: Although we have taken steps to ensure that this e-mail and attachments are free from any virus, we advise that in keeping with good computing practice the recipient should take steps to confirm that they are actually virus free.

Consider the environment: Do you need to print this message?