Last modified: 2007-03-21 22:54:47 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 T11363, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 9363 - SQL error on SpecialRecentchangeslinked with PostgreSQL
SQL error on SpecialRecentchangeslinked with PostgreSQL
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
unspecified
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: ---


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

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

The Google Bot caused with 
wiki/index.php?title=Spezial:%C3%84nderungen_an_verlinkten_Seiten&target=Vorgaben_der_Finanzbeh%C3%B6rden&hideminor=0&days=7&limit=50

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_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, 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.


Navigation
Links