[Pkg-mediawiki-devel] Bug#656163: mediawiki: Edit and Recent Changes broken after lenny->squeeze upgrade with PostgreSQL backend

[Dave Page]

Package: mediawiki
Version: 1:1.15.5-2squeeze2
Severity: important


After a lenny to squeeze dist-upgrade, my mediawiki installation is fine
for read access, but attempts to edit pages or view recent changes fail.
I infer that there has been some schema change between mediawiki 1.12.0
(lenny) and 1.15.5 (squeeze) which was not enacted by the package
upgrade.

I've tried looking on the BTS, searching on Google and asking on #debian
to find a solution to this problem, but the search results are cluttered
with similar error messages in different contexts.

I enabled $wgShowExceptionDetails = true; in LocalSettings.php to
produce the following stack traces.

Page edit:
==========

A database error has occurred
Query: SELECT cl_to FROM categorylinks,page_props,page WHERE cl_from = '116' AND (pp_page=page_id) AND pp_propname = 'hiddencat' AND page_namespace = '14' AND (page_title=cl_to)
Function: Article::getHiddenCategories
Error: 1 ERROR: relation "page_props" does not exist

Backtrace:

#0 /usr/share/mediawiki/includes/db/Database.php(616): DatabasePostgres->reportQueryError('ERROR: relatio...', 1, 'SELECT cl_to ...', 'Article::getHid...', false)
#1 /usr/share/mediawiki/includes/db/Database.php(1026): Database->query('SELECT cl_to ...', 'Article::getHid...')
#2 /usr/share/mediawiki/includes/Article.php(3488): Database->select(Array, Array, Array, 'Article::getHid...')
#3 /usr/share/mediawiki/includes/EditPage.php(1432): Article->getHiddenCategories()
#4 /usr/share/mediawiki/includes/EditPage.php(469): EditPage->showEditForm()
#5 /usr/share/mediawiki/includes/EditPage.php(340): EditPage->edit()
#6 /usr/share/mediawiki/includes/Wiki.php(520): EditPage->submit()
#7 /usr/share/mediawiki/includes/Wiki.php(63): MediaWiki->performAction(Object(OutputPage), Object(Article), Object(Title), Object(User), Object(WebRequest))
#8 /usr/share/mediawiki/index.php(116): MediaWiki->initialize(Object(Title), Object(Article), Object(OutputPage), Object(User), Object(WebRequest))
#9 {main}

Recent Changes:
===============

A database error has occurred
Query: SELECT * FROM recentchanges LEFT JOIN watchlist ON ((wl_user=2 AND wl_title=rc_title AND wl_namespace=rc_namespace)) LEFT JOIN tag_summary ON ((ts_rc_id=rc_id)) WHERE (rc_timestamp >= '2012-01-10 00:00:00 GMT') AND rc_bot = '0' ORDER BY rc_timestamp DESC LIMIT 50
Function: SpecialRecentChanges::doMainQuery
Error: 1 ERROR: relation "tag_summary" does not exist

Backtrace:

#0 /usr/share/mediawiki/includes/db/Database.php(616): DatabasePostgres->reportQueryError('ERROR: relatio...', 1, 'SELECT * FROM...', 'SpecialRecentCh...', false)
#1 /usr/share/mediawiki/includes/db/Database.php(1026): Database->query('SELECT * FROM...', 'SpecialRecentCh...')
#2 /usr/share/mediawiki/includes/specials/SpecialRecentchanges.php(313): Database->select(Array, '*', Array, 'SpecialRecentCh...', Array, Array)
#3 /usr/share/mediawiki/includes/specials/SpecialRecentchanges.php(100): SpecialRecentChanges->doMainQuery(Array, Object(FormOptions))
#4 /usr/share/mediawiki/includes/SpecialPage.php(559): SpecialRecentChanges->execute(NULL)
#5 /usr/share/mediawiki/includes/Wiki.php(239): SpecialPage::executePath(Object(Title))
#6 /usr/share/mediawiki/includes/Wiki.php(59): MediaWiki->initializeSpecialCases(Object(Title), Object(OutputPage), Object(WebRequest))
#7 /usr/share/mediawiki/index.php(116): MediaWiki->initialize(Object(Title), NULL, Object(OutputPage), Object(User), Object(WebRequest))
#8 {main}

-- System Information:
Debian Release: 6.0.3
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: i386 (i686)

Kernel: Linux 2.6.38.4-kvm-hosting.org-i386-20110428
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages mediawiki depends on:
ii  apache2                2.2.16-6+squeeze4 Apache HTTP Server metapackage
ii  apache2-mpm-prefork [h 2.2.16-6+squeeze4 Apache HTTP Server - traditional n
ii  debconf [debconf-2.0]  1.5.36.1          Debian configuration management sy
ii  mime-support           3.48-1            MIME files 'mime.types' & 'mailcap
ii  php5                   5.3.3-7+squeeze3  server-side, HTML-embedded scripti
ii  php5-mysql             5.3.3-7+squeeze3  MySQL module for php5
ii  php5-pgsql             5.3.3-7+squeeze3  PostgreSQL module for php5

Versions of packages mediawiki recommends:
ii  mysql-server-5.1 [mysql 5.1.49-3         MySQL database server binaries and
ii  php5-cli                5.3.3-7+squeeze3 command-line interpreter for the p

Versions of packages mediawiki suggests:
ii  clamav              0.97.3+dfsg-1~lenny1 anti-virus utility for Unix - comm
ii  imagemagick         8:6.6.0.4-3          image manipulation programs
pn  mediawiki-math      <none>               (no description available)
ii  memcached           1.4.5-1              A high-performance memory object c
ii  php5-gd             5.3.3-7+squeeze3     GD module for php5

-- debconf information:
* mediawiki/webserver: apache2