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(a)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.