Author: mikeymizrahi
Description:
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)".
Version: 1.8.x
Severity: critical
OS: Windows XP
Platform: PC
dto wrote:
Please try to provide as many details as possible -- what page you were trying
to access, if there were any errors during install, etc.
juhapekka.piiroinen wrote:
I had this same bug. The mediawiki corrupted the database completely! I had to
repair database.
All frm files of the mediawiki were corrupted.
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;
avaD wrote:
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?
robchur wrote:
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.
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.