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@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
mediawiki-l@lists.wikimedia.org