Last modified: 2007-03-21 22:54:47 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 9363 - SQL error on SpecialRecentchangeslinked with PostgreSQL
SQL error on SpecialRecentchangeslinked with PostgreSQL
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
PC Linux
: Normal minor (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
Blocks: postgres
  Show dependency treegraph
Reported: 2007-03-21 22:33 UTC by Mathias Behrle
Modified: 2007-03-21 22:54 UTC (History)
0 users

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

Patch for SpecialRecentchangeslinked.php (642 bytes, patch)
2007-03-21 22:35 UTC, Mathias Behrle

Description Mathias Behrle 2007-03-21 22:33:10 UTC
Working on rev 20562:

The Google Bot caused with 

the following error in my logs:
mediawiki_fl ERROR:  column "rc_deleted" does not exist

I don't know, when columns

  rc_deleted         INTEGER      NOT NULL  DEFAULT 0,                         
  rc_logid           INTEGER      NOT NULL  DEFAULT 0,                         
  rc_log_type        TEXT,                                                     
  rc_log_action      TEXT,                                                     
  rc_params          TEXT 

were added to table recentchanges (there is no patch in archives), but after
adding them the following error appeared:

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, rc_deleted FROM pagelinks,
recentchanges WHERE rc_timestamp > '2007-03-14 22:13:04 GMT' AND
pl_namespace=rc_namespace AND pl_title=rc_title AND pl_from=44 GROUP BY
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, rc_old_len,
rc_new_len ORDER BY rc_timestamp DESC LIMIT 50 Function:
wfSpecialRecentchangeslinked Error: 1 ERROR: column "recentchanges.rc_deleted"
must appear in the GROUP BY clause or be used in an aggregate function

The attached patch adresses this problem.
Comment 1 Mathias Behrle 2007-03-21 22:35:29 UTC
Created attachment 3375 [details]
Patch for SpecialRecentchangeslinked.php
Comment 2 Greg Sabino Mullane 2007-03-21 22:54:47 UTC
Fixed in r20604, thanks for the report and patch!

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