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@gmail.com]
Sent: 17 January 2008 20:57
To: mediawiki-l(a)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?