[Mediawiki-l] can't use MediaWiki 1.16.0 with PostgreSQL 8.4.4?

[Tomasz Chmielewski]

I'm trying to use MediaWiki with PostgreSQL 8.4.4 - however, it fails miserably.

It installs fine:

PHP 5.3.2-1ubuntu4.2 installed
Found database drivers for: PostgreSQL
PHP server API is cgi-fcgi; using ugly URLs (index.php?title=Page_Title)
Have XML / Latin1-UTF-8 conversion support.
Session save path (/var/lib/php5) appears to be valid.
PHP's memory_limit is 128M bytes.
Couldn't find eAccelerator, APC or XCache; cannot use these for object caching.
Found GNU diff3: /usr/bin/diff3.
Couldn't find GD library or ImageMagick; image thumbnailing disabled.
Installation directory: /shared/sites/intra.dooster.net/wiki
Script URI path: /wiki
Installing MediaWiki with php file extensions
Environment checked. You can install MediaWiki.

Generating configuration file...
Database type: PostgreSQL
Loading class: DatabasePostgres
Attempting to connect to database "intrawikidb" as "intrawikiuser"...
Checking the version of Postgres...version 8.4.4 is OK.
Checking for Pl/Pgsql ...not installed. Attempting to install Pl/Pgsql ...OK
Creating schema mediawiki ...OK
Setting the timezone to GMT for user "intrawikiuser" ...OK
Setting the datestyle to ISO, YMD for user "intrawikiuser" ...OK
Setting the search path for user "intrawikiuser" ...OK
Connected to postgres 8.4.4
Creating tables... done.
Populating interwiki table... successfully populated.
Initializing statistics...
Created sysop account WikiSysop.

Creating LocalSettings.php...
-----------------------------------------------




However as I try to use the wiki, all I see is:

A database error has occurred
Query: INSERT INTO l10n_cache (lc_lang,lc_key,lc_value) VALUES ('en','messages:clearyourcache','s:438:"''''''Note: After saving, you may have to bypass your browser''s cache to see the changes.''''''
''''''Mozilla / Firefox / Safari:'''''' hold ''''Shift'''' while clicking ''''Reload'''', or press either ''''Ctrl-F5'''' or ''''Ctrl-R'''' (''''Command-R'''' on a Macintosh);
''''''Konqueror: ''''''click ''''Reload'''' or press ''''F5'''';
''''''Opera:'''''' clear the cache in ''''Tools → Preferences'''';
''''''Internet Explorer:'''''' hold ''''Ctrl'''' while clicking ''''Refresh,'''' or press ''''Ctrl-F5''''.";'),('en','messages:usercssyoucanpreview','s:83:"''''''Tip:'''''' Use the "{{int:showpreview}}" button to test your new CSS before saving.";'),('en','messages:userjsyoucanpreview','s:90:"''''''Tip:'''''' Use the "{{int:showpreview}}" button to test your new JavaScript before saving.";'),('en','messages:usercsspreview','s:91:"''''''Remember that you are only previewing your user CSS.''''''
''''''It has not yet been saved!''''''";'),('en','messages:userjspreview','s:106:"''''''Remember that you are only testing/previewing your user JavaScript.''''''
''''''It has not yet been saved!''''''";'),('en','messages:userinvalidcssjstitle','s:178:"''''''Warning:'''''' There is no skin "$1".
Remember that custom .css and .js pages use a lowercase title, e.g. {{ns:user}}:Foo/monobook.css as opposed to {{ns:user}}:Foo/Monobook.css.";'),('en','messages:updated','s:9:"(Updated)";'),('en','messages:note','s:11:"''''''Note:''''''";'),('en','messages:previewnote','s:81:"''''''Remember that this is only a preview.''''''
Your changes have not yet been saved!";'),('en','messages:previewconflict','s:102:"This preview reflects the text in the upper text editing area as it will appear if you choose to save.";'),('en','messages:session_fail_preview','s:179:"''''''Sorry! We could not process your edit due to a loss of session data.''''''
Please try again.
If it still does not work, try [[Special:UserLogout|logging out]] and logging back in.";'),('en','messages:session_fail_previe



PostgreSQL reports this in the log:

2010-09-14 00:23:47 CEST WARNING:  nonstandard use of \\ in a string literal at character 113
2010-09-14 00:23:47 CEST HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
2010-09-14 00:23:47 CEST WARNING:  nonstandard use of \\ in a string literal at character 115
2010-09-14 00:23:47 CEST HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
2010-09-14 00:23:47 CEST WARNING:  nonstandard use of \\ in a string literal at character 108
2010-09-14 00:23:47 CEST HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
2010-09-14 00:23:47 CEST WARNING:  nonstandard use of \\ in a string literal at character 2307
2010-09-14 00:23:47 CEST HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
2010-09-14 00:23:47 CEST ERROR:  character 0xe28692 of encoding "UTF8" has no equivalent in "LATIN1"
2010-09-14 00:24:02 CEST LOG:  could not receive data from client: Connection reset by peer
2010-09-14 00:24:02 CEST LOG:  unexpected EOF within message length word
2010-09-14 00:24:05 CEST WARNING:  nonstandard use of \\ in a string literal at character 2307
2010-09-14 00:24:05 CEST HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.
2010-09-14 00:24:05 CEST ERROR:  character 0xe28692 of encoding "UTF8" has no equivalent in "LATIN1"


Is the newest MediaWiki usable with PostgreSQL, or is it something wrong with my setup (I tried MediaWiki 1.15.5, but it didn't even install, as it detected PostgreSQL 8.4.4 as 7.x)?


-- 
Tomasz Chmielewski
http://wpkg.org