> From: Victor Pendleton [mailto:[EMAIL PROTECTED] > This error should be logged. Do you have a file called <hostname>.err in your directory?
Yes I have a file called <hostname>.err and that error is not in it. > From: Paul DuBois [mailto:[EMAIL PROTECTED] > The error log is for messages pertaining to problems with the operational > state of the server. Normally there's not much in it at all. > The error you show above is a problem with a query sent by a client. > That type of error message is sent to the client, not logged. the query (see below) seems to be okay. the problem doesn't seem to be with the query, but with the table. UPDATE referenceEntries SET heading = 'Delete', body = '', keywords = '' , dateVerified = NULL WHERE entryID = 168 the error (see below) seems to be the first indication of a corrupt table. So wouldn't that be a server issue and be appropriate to log into the mysql error log? Incorrect key file for table: 'referenceEntries'. Try to repair it The manual makes a reference to this error in Section 14.1.3.1 Corrupted MyISAM Tables... Typical symptoms for a corrupt table is: You get the error Incorrect key file for table: '...'. Try to repair it while selecting data from the table. Thanks, Daniel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]