[SAC] Re: [OSGeo] #133: MySQL error when trying to update wiki.osgeo.org, or upload files

#133: MySQL error when trying to update wiki.osgeo.org, or upload files
--------------------------+-------------------------------------------------
  Reporter: dmorissette | Owner: sac@lists.osgeo.org
      Type: task | Status: new
  Priority: critical | Component: SAC
Resolution: | Keywords:
--------------------------+-------------------------------------------------
Changes (by dpatton):

  * priority: normal => critical
  * summary: MySQL error when trying to update wiki.osgeo.org => MySQL
              error when trying to update wiki.osgeo.org, or
              upload files

Comment:

This problem needs to be fixed ASAP:

1)
Some of the wiki pages are critical infrastructure for the FOSS4G2007
conference.

In particular, the Information for Instructors wiki page:
http://wiki.osgeo.org/index.php/FOSS4G2007_Information_for_Instructors

The problem with this error is that we have told all the Instructors that
they must edit that wiki page, and having them encounter an error when
doing so reflects poorly on OSgeo and FOSS4G2007.

2)
It appears that the error is either preventing file uploads, or masking
relevant error messages relating to failed file uploads.

I'm trying to upload PDF floor plans for the FOSS4G2007 conference centre,
and encountering an error:

- after ignoring the bogus message "It is recommended that images not
exceed 153600 bytes in size, this file is 387555 bytes"(my upload is a PDF
file, not an image)

- I used the "Ignore warning and save file anyway." Save File button

- I get the same error as above:

MySQL returned error "1016: Can't open file: 'osgeo_searchindex.MYI'
(errno: 145) (localhost)".

- My PDF is not uploaded(it is not in the Upload log)

--
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/133#comment:5&gt;
OSGeo <http://www.osgeo.org/&gt;
OSGeo committee and general foundation issue tracker.