[Mediawiki-l] Problem after database upgrade

[Michael Doyle]

I was running MediaWiki 1.15.4 on a private FreeBSD server (6.4  
stable), PostgreSQL 8.3, PHP 5.2, Apache 2.2
This was part of the intranet for our company.

However, since that operating system is no-longer supported, I  
upgraded the OS to FreeBSD 8.2
As part of that upgrade, I updated PHP and PostgreSQL to the latest  
versions
(PHP 5.3.6, PostgreSQL 9.0)

My wiki now gives the following error message when I attempt to view it:

Warning: pg_query(): Query failed: ERROR: relation "objectcache" does  
not exist LINE 1: ...diaWikiBagOStuff::_doquery */ value,exptime FROM  
objectcach... ^ in /usr/local/www/apache22/data/wiki/includes/db/ 
DatabasePostgres.php on line 580 Warning: pg_query(): Query failed:  
ERROR: relation "objectcache" does not exist LINE 1: ...uff::_doquery  
89.124.236.45 */ value,exptime FROM objectcach... ^ in /usr/local/www/ 
apache22/data/wiki/includes/db/DatabasePostgres.php on line 580  
Warning: pg_query(): Query failed: ERROR: relation "objectcache" does  
not exist LINE 1: ...uff::_doquery 89.124.236.45 */ value,exptime FROM  
objectcach... ^ in /usr/local/www/apache22/data/wiki/includes/db/ 
DatabasePostgres.php on line 580 Warning: pg_query(): Query failed:  
ERROR: relation "objectcache" does not exist LINE  
1: ...ediaWikiBagOStuff::_doquery 89.124.236.45 */ FROM objectcach...  
^ in /usr/local/www/apache22/data/wiki/includes/db/ 
DatabasePostgres.php on line 580 Warning: pg_query(): Query failed:  
ERROR: relation "objectcache" does not exist LINE 1: ...uff::_doquery  
89.124.236.45 */ value,exptime FROM objectcach... ^ in /usr/local/www/ 
apache22/data/wiki/includes/db/DatabasePostgres.php on line 580  
Warning: pg_query(): Query failed: ERROR: relation "objectcache" does  
not exist LINE 1: ...ediaWikiBagOStuff::_doquery 89.124.236.45 */ FROM  
objectcach... ^ in /usr/local/www/apache22/data/wiki/includes/db/ 
DatabasePostgres.php on line 580 Warning: pg_query(): Query failed:  
ERROR: relation "page" does not exist LINE 1: ...he::loadFromDB  
89.124.236.45 */ page_title FROM page WHER... ^ in /usr/local/www/ 
apache22/data/wiki/includes/db/DatabasePostgres.php on line 580  
MediaWiki internal error.



Exception caught inside exception handler


NOW, the table DOES exist.

Here is some output from the PSQL command line tool:
$ psql wiki2
psql (9.0.4)
Type "help" for help.

wiki2=# SET search_path = mediawiki, pg_catalog, public;
SET
wiki2=# \dt
                List of relations
   Schema   |       Name        | Type  | Owner
-----------+-------------------+-------+--------
  mediawiki | archive           | table | relyod
  mediawiki | category          | table | relyod
  mediawiki | categorylinks     | table | relyod
  mediawiki | change_tag        | table | relyod
  mediawiki | externallinks     | table | relyod
  mediawiki | filearchive       | table | relyod
  mediawiki | hitcounter        | table | relyod
  mediawiki | image             | table | relyod
  mediawiki | imagelinks        | table | relyod
  mediawiki | interwiki         | table | relyod
  mediawiki | ipblocks          | table | relyod
  mediawiki | job               | table | relyod
  mediawiki | langlinks         | table | relyod
  mediawiki | logging           | table | relyod
  mediawiki | math              | table | relyod
  mediawiki | mediawiki_version | table | relyod
  mediawiki | mwuser            | table | relyod
  mediawiki | objectcache       | table | relyod
  mediawiki | oldimage          | table | relyod
  mediawiki | page              | table | relyod
  mediawiki | page_props        | table | relyod
  mediawiki | page_restrictions | table | relyod
  mediawiki | pagecontent       | table | relyod
  mediawiki | pagelinks         | table | relyod
  mediawiki | profiling         | table | relyod
  mediawiki | protected_titles  | table | relyod
  mediawiki | querycache        | table | relyod
  mediawiki | querycache_info   | table | relyod
  mediawiki | querycachetwo     | table | relyod
  mediawiki | recentchanges     | table | relyod
  mediawiki | redirect          | table | relyod
  mediawiki | revision          | table | relyod
  mediawiki | site_stats        | table | relyod
  mediawiki | tag_summary       | table | relyod
  mediawiki | templatelinks     | table | relyod
  mediawiki | trackbacks        | table | relyod
  mediawiki | transcache        | table | relyod
  mediawiki | updatelog         | table | relyod
  mediawiki | user_groups       | table | relyod
  mediawiki | user_newtalk      | table | relyod
  mediawiki | valid_tag         | table | relyod
  mediawiki | watchlist         | table | relyod
(42 rows)




Michael Doyle
Network Administrator, Co-operation Ireland
mdoyle at cooperationireland.org
http://www.cooperationireland.org/

Co-operation Ireland Events: http://www.cooperationireland.org/supportus/overview

Phone: +353-1-6610588
Fax: +353-1-6618456
Mobile: 00353-87-2357853







-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.