Last modified: 2005-11-23 20:17:38 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 4059 - Recentchangeslinked fails with 'show minor edits'
Recentchangeslinked fails with 'show minor edits'
Product: MediaWiki
Classification: Unclassified
Special pages (Other open bugs)
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2005-11-23 20:07 UTC by Brion Vibber
Modified: 2005-11-23 20:17 UTC (History)
0 users

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


Description Brion Vibber 2005-11-23 20:07:30 UTC
Seems new in head branch, 1.5 looks ok. Seems to be missing the minor edit field 
from the rc join...

A database query syntax error has occurred. This may indicate a bug in the 
software. The last attempted database query was:

SELECT /* wfSpecialRecentchangeslinked */ rc_cur_id page_id, rc_namespace 
page_namespace, rc_title page_title, rc_user rev_user, rc_comment rev_comment, 
rc_user_text rev_user_text, rc_this_oldid, rc_timestamp rev_timestamp, rc_minor 
rev_minor_edit, rc_new page_is_new FROM `pagelinks`, `recentchanges` WHERE 
rc_timestamp > '20051116200532' AND rev_minor_edit=0 AND 
pl_namespace=rc_namespace AND pl_title=rc_title AND pl_from=7253 GROUP BY 
rev_user,rev_comment,rev_user_text,rev_timestamp,rev_minor_edit, page_is_new 
ORDER BY rev_timestamp DESC LIMIT 50

from within function "wfSpecialRecentchangeslinked". MySQL returned error "1054: 
Unknown column 'rev_minor_edit' in 'where clause' (localhost)".
Comment 1 Brion Vibber 2005-11-23 20:17:38 UTC
Can't use the aliased column name in a where clause; changed it to use the name 
in the rc table and it works now.

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