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

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
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