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@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?
Which version of IIS are you using? Have you checked the permissions specifically on the images folder?
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Tim Gowen Sent: Friday, January 18, 2008 6:01 AM To: mediawiki-l@lists.wikimedia.org Subject: Re: [Mediawiki-l] Problem with image upload
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@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?
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
It's IIS 6, and I've sort of got around the problem by making Internet Explorer detect the wiki server as the local intranet. But this doesn't fix the problem for Firefox.
The images folder has IUSR_SERVER set to full control.
-----Original Message----- From: Christensen, Courtney [mailto:ChristensenC@BATTELLE.ORG] Sent: 18 January 2008 14:51 To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Problem with image upload
Which version of IIS are you using? Have you checked the permissions specifically on the images folder?
-----Original Message----- From: mediawiki-l-bounces@lists.wikimedia.org [mailto:mediawiki-l-bounces@lists.wikimedia.org] On Behalf Of Tim Gowen Sent: Friday, January 18, 2008 6:01 AM To: mediawiki-l@lists.wikimedia.org Subject: Re: [Mediawiki-l] Problem with image upload
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@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?
_______________________________________________ MediaWiki-l mailing list MediaWiki-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
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?
Tim Gowen wrote:
It's IIS 6, and I've sort of got around the problem by making Internet Explorer detect the wiki server as the local intranet. But this doesn't fix the problem for Firefox.
The images folder has IUSR_SERVER set to full control.
Maybe the images subfolders doesn't?
mediawiki-l@lists.wikimedia.org