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)?
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256
On 9/13/2010 5:53 PM, Tomasz Chmielewski wrote:
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'\'.
enable standard_conforming_strings
mediawiki-l@lists.wikimedia.org