Last modified: 2005-11-23 20:17:38 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 T6059, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 4059 - Recentchangeslinked fails with 'show minor edits'
Recentchangeslinked fails with 'show minor edits'
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Special pages (Other open bugs)
1.6.x
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
http://fr.wikipedia.org/w/index.php?t...
:
Depends on:
Blocks:
  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: ---


Attachments

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 
page_id,page_namespace,page_title, 
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.


Navigation
Links