Last modified: 2010-05-15 15:42:50 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T9659, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 7659 - Database Error
Database Error
Status: RESOLVED WORKSFORME
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.8.x
PC Windows XP
: Normal critical (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-10-21 22:40 UTC by Michael Mizrahi
Modified: 2010-05-15 15:42 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Michael Mizrahi 2006-10-21 22:40:34 UTC
A database query syntax error has occurred. This may indicate a bug in the
software. The last attempted database query was:

    (SQL query hidden)

from within function "". MySQL returned error "1054: Unknown column
'c1.cl_timestamp' in 'field list' (localhost)".
Comment 1 Dan Li 2006-10-21 23:43:46 UTC
Please try to provide as many details as possible -- what page you were trying
to access, if there were any errors during install, etc.
Comment 2 Juhapekka Piiroinen 2006-10-31 05:43:11 UTC
I had this same bug. The mediawiki corrupted the database completely! I had to
repair database.

All frm files of the mediawiki were corrupted.
Comment 3 Antoine "hashar" Musso (WMF) 2007-01-07 18:58:26 UTC
Make sure the column exist in your database.

When reproducing the issue you also want to enable SQL
messages. In your LocalSettings.php add:

$wgShowSQLErrors = true;
Comment 4 avaD 2007-02-28 06:15:11 UTC
I've been having the same problem (2days now) when trying to edit/save any of my pages. The 
exact message I'm receiving is this:

Database error
From CloudPad
A database query syntax error has occurred. This may indicate a bug in the software. The last 
attempted database query was: 
(SQL query hidden)
from within function "SearchUpdate::doUpdate". MySQL returned error "1016: Can't open 
file: 'wiki_searchindex.MYI' (errno: 145) (localhost)".

please advise?
Comment 5 Rob Church 2007-02-28 15:14:34 UTC
http://www.google.co.uk/search?q=mysql+error+145

Often due to a crashed table. Try issuing the statement "REPAIR TABLE
searchindex;" in a MySQL client or similar.
Comment 6 Brion Vibber 2007-03-06 14:44:24 UTC
Resolving WORKSFORME; never got further information out of the original poster,
and this bug seems to attract unrelated "table marked crashed when MySQL crashed
and/or the machine was shut down ungracefully" comments.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links