Last modified: 2011-04-04 21:32:40 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 T10984, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 8984 - Database Error with Special:Recentchangeslinked
Database Error with Special:Recentchangeslinked
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.9.x
Other other
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2007-02-14 14:20 UTC by Andreas Walter
Modified: 2011-04-04 21:32 UTC (History)
0 users

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


Attachments

Description Andreas Walter 2007-02-14 14:20:42 UTC
System: AIX 5.3, Technical Level 5
DB: Postgesql 8.1.5
Webserver: Apache 2.2.3 with PHP 5.1.6
Mediawiki: Version 1.9.2, German language

The wiki uses German Language as Default. The actual used link is:
Spezial:%C3%84nderungen_an_verlinkten_Seiten/Hauptseite


For better understanding I set the language of the user English
with the same result.

Interner Fehler (Engl.: internal error)

A database error has occurred Query: SELECT /* wfSpecialRecentchangeslinked */
rc_id, rc_cur_id, rc_namespace, rc_title, rc_user, rc_comment, rc_user_text,
rc_this_oldid, rc_last_oldid, rc_timestamp, rc_minor, rc_bot, rc_new,
rc_patrolled, rc_type, rc_old_len, rc_new_len ,wl_user FROM pagelinks,
recentchanges LEFT OUTER JOIN watchlist ON wl_user=2 AND wl_title=rc_title AND
wl_namespace=rc_namespace WHERE rc_timestamp > '2007-02-07 14:03:00 GMT' AND
pl_namespace=rc_namespace AND pl_title=rc_title AND pl_from=2055 GROUP BY
rc_cur_id,rc_namespace,rc_title,
rc_user,rc_comment,rc_user_text,rc_timestamp,rc_minor, rc_new, rc_id,
rc_this_oldid, rc_last_oldid, rc_bot, rc_patrolled, rc_type ,wl_user ORDER BY
rc_timestamp DESC LIMIT 50 Function: wfSpecialRecentchangeslinked Error: 1
ERROR: column "recentchanges.rc_old_len" must appear in the GROUP BY clause or
be used in an aggregate function

Backtrace:

#0 /data/httpd/ux48prmue76/mediawiki-leitstand/includes/Database.php(665):
DatabasePostgres->reportQueryError('ERROR: column ...', 1, 'SELECT /* wfSpe...',
'wfSpecialRecent...', false)
#1
/data/httpd/ux48prmue76/mediawiki-leitstand/includes/SpecialRecentchangeslinked.php(142):
Database->query('SELECT /* wfSpe...', 'wfSpecialRecent...')
#2 /data/httpd/ux48prmue76/mediawiki-leitstand/includes/SpecialPage.php(625):
wfSpecialRecentchangeslinked('Aktuelle_Ereign...', Object(UnlistedSpecialPage))
#3 /data/httpd/ux48prmue76/mediawiki-leitstand/includes/SpecialPage.php(431):
SpecialPage->execute('Aktuelle_Ereign...')
#4 /data/httpd/ux48prmue76/mediawiki-leitstand/includes/Wiki.php(182):
SpecialPage::executePath(Object(Title))
#5 /data/httpd/ux48prmue76/mediawiki-leitstand/includes/Wiki.php(47):
MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage),
Object(WebRequest))
#6 /data/httpd/ux48prmue76/mediawiki-leitstand/index.php(48):
MediaWiki->initialize(Object(Title), Object(OutputPage), Object(User),
Object(WebRequest))
#7 {main}
Comment 1 Antoine "hashar" Musso (WMF) 2007-02-17 13:14:24 UTC
rc_old_len should be added in the GROUP BY condition.

Looks like it got fixed in r19177. You can apply the patch
to your local file. I added a comment in trunk as r19977.

The fix is back ported in 1.9 branch with r19978, should be
in 1.9.3.

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


Navigation
Links