Page MenuHomePhabricator

MediaWiki 1.16.0 fails to operate beyond installation on PostgreSQL 8.3.11
Closed, DeclinedPublic

Description

Author: francisclyne

Description:
I have Windows Vista, PHP 5.3.3, Apache 2.2 and PostgreSQL 8.3.11. Whenever I attempt to install MediaWiki 1.16.0 with this software, I get the "Installation Successful!" message, and move LocalSettings.php to the main directory as instructed. But after following the link to the wiki, I get the following messages:

MyWiki error

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_preview_html','s:338:"''''''Sorry! We could not process your edit due to a loss of session data.''''''

''''Because {{SITENAME}} has raw HTML enabled, the preview is hidden as a precaution against JavaScript attacks.''''

''''''If this is a legitimate edit attempt, please try again.''''''
If it still does not work, try [[Special:UserLogout|logging out]] and logging back in.";'),('en','messages:token_suffix_mismatch','s:259:"''''''Your edit has been rejected because your client mangled the punctuation characters in the edit token.''''''
The edit has been rejected to prevent corruption of the page text.
This sometimes happens when you are using a buggy web-based anonymous proxy service.";'),('en','messages:editing','s:10:"Editing $1";'),('en','messages:editingsection','s:20:"Editing $1 (section)";'),('en','messages:editingcomment','s:24:"Editing $1 (new section)";'),('en','messages:editconflict','s:17:"Edit conflict: $1";'),('en','messages:explainconflict','s:323:"Someone else has changed this page since you started editing it.
The upper text area contains the page text as it currently exists.
Your changes are shown in the lower text area.
You will have to merge your changes into the existing text.
''''''Only'''''' the text in the upper text area will be saved when you press "Save page".";'),('en','messages:yourtext','s:9:"Your text";'),('en','messages:storedversion','s:15:"Stored revision";'),('en','messages:nonunicodebrowser','s:184:"''''''Warning: Your browser is not unicode compliant.''''''
A workaround is in place to allow you to safely edit pages: non-ASCII characters will appear in the edit box as hexadecimal codes.";'),('en','messages:editingold','s:135:"''''''Warning: You are editing an out-of-date revision of this page.''''''
If you save it, any changes made since this revision will be lost.";'),('en','messages:yourdiff','s:11:"Differences";'),('en','messages:copyrightwarning','s:406:"Please note that all contributions to {{SITENAME}} are considered to be released under the $2 (see $1 for details).
If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.<br />
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource.
''''''Do not submit copyrighted work without permission!''''''";'),('en','messages:copyrightwarning2','s:394:"Please note that all contributions to {{SITENAME}} may be edited, altered, or removed by other contributors.
If you do not want your writing to be edited mercilessly, then do not submit it here.<br />
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see $1 for details).
''''''Do not submit copyrighted work without permission!''''''";'),('en','messages:editpage-tos-summary','s:1:"-";'),('en','messages:longpagewarning','s:182:"''''''Warning:'''''' This page is $1 kilobytes long;
some browsers may have problems editing pages approaching or longer than 32kb.
Please consider breaking the page into smaller sections.";'),('en','messages:longpageerror','s:132:"''''''Error: The text you have submitted is $1 kilobytes long, which is longer than the maximum of $2 kilobytes.''''''
It cannot be saved.";'),('en','messages:readonlywarning','s:253:"''''''Warning: The database has been locked for maintenance, so you will not be able to save your edits right now.''''''
You may wish to cut-n-paste the text into a text file and save it for later.

The administrator who locked it offered this explanation: $1";'),('en','messages:protectedpagewarning','s:156:"''''''Warning: This page has been locked so that only users with administrator privileges can edit it.''''''
The latest log entry is provided below for reference:";'),('en','messages:semiprotectedpagewarning','s:134:"''''''Note:'''''' This page has been locked so that only registered users can edit it.
The latest log entry is provided below for reference:";'),('en','messages:cascadeprotectedwarning','s:186:"''''''Warning:'''''' This page has been locked so that only users with administrator privileges can edit it, because it is included in the following cascade-protected {{PLURAL:$1|page|pages}}:";'),('en','messages:titleprotectedwarning','s:171:"''''''Warning: This page has been locked so that [[Special:ListGroupRights|specific rights]] are needed to create it.''''''
The latest log entry is provided below for reference:";'),('en','messages:templatesused','s:51:"{{PLURAL:$1|Template|Templates}} used on this page:";'),('en','messages:templatesusedpreview','s:54:"{{PLURAL:$1|Template|Templates}} used in this preview:";'),('en','messages:templatesusedsection','s:54:"{{PLURAL:$1|Template|Templates}} used in this section:";'),('en','messages:template-protected','s:11:"(protected)";'),('en','messages:template-semiprotected','s:16:"(semi-protected)";'),('en','messages:hiddencategories','s:78:"This page is a member of {{PLURAL:$1|1 hidden category|$1 hidden categories}}:";'),('en','messages:edittools','s:61:"<!-- Text here will be shown below edit and upload forms. -->";'),('en','messages:nocreatetitle','s:21:"Page creation limited";'),('en','messages:nocreatetext','s:157:"{{SITENAME}} has restricted the ability to create new pages.
You can go back and edit an existing page, or [[Special:UserLogin|log in or create an account]].";'),('en','messages:nocreate-loggedin','s:47:"You do not have permission to create new pages.";'),('en','messages:sectioneditnotsupported-title','s:29:"Section editing not supported";'),('en','messages:sectioneditnotsupported-text','s:46:"Section editing is not supported in this page.";'),('en','messages:permissionserrors','s:18:"Permissions errors";'),('en','messages:permissionserrorstext','s:86:"You do not have permission to do that, for the following {{PLURAL:$1|reason|reasons}}:";'),('en','messages:permissionserrorstext-withaction','s:81:"You do not have permission to $2, for the following {{PLURAL:$1|reason|reasons}}:";'),('en','messages:recreate-moveddeleted-warn','s:222:"''''''Warning: You are recreating a page that was previously deleted.''''''

You should consider whether it is appropriate to continue editing this page.
The deletion and move log for this page are provided here for convenience:";'),('en','messages:moveddeleted-notice','s:100:"This page has been deleted.
The deletion and move log for the page are provided below for reference.";'),('en','messages:log-fulllog','s:13:"View full log";'),('en','messages:edit-hook-aborted','s:45:"Edit aborted by hook.
It gave no explanation.";'),('en','messages:edit-gone-missing','s:59:"Could not update the page.
It appears to have been deleted.";'),('en','messages:edit-conflict','s:14:"Edit conflict.";'),('en','messages:edit-no-change','s:62:"Your edit was ignored, because no change was made to the text.";'),('en','messages:edit-already-exists','s:47:"Could not create a new page.
It already exists.";'),('en','messages:addsection-preload','s:0:"";'),('en','messages:addsection-editintro','s:0:"";'),('en','messages:expensive-parserfunction-warning','s:183:"''''''Warning:'''''' This page contains too many expensive parser function calls.

It should have less than $2 {{PLURAL:$2|call|calls}}, there {{PLURAL:$1|is now $1 call|are now $1 calls}}.";'),('en','messages:expensive-parserfunction-category','s:51:"Pages with too many expensive parser function calls";'),('en','messages:post-expand-template-inclusion-warning','s:87:"''''''Warning:'''''' Template include size is too large.
Some templates will not be included.";'),('en','messages:post-expand-template-inclusion-category','s:45:"Pages where template include size is exceeded";'),('en','messages:post-expand-template-argument-warning','s:137:"''''''Warning:'''''' This page contains at least one template argument which has a too large expansion size.
These arguments have been omitted.";'),('en','messages:post-expand-template-argument-category','s:43:"Pages containing omitted template arguments";'),('en','messages:parser-template-loop-warning','s:30:"Template loop detected: [[$1]]";'),('en','messages:parser-template-recursion-depth-warning','s:44:"Template recursion depth limit exceeded ($1)";'),('en','messages:language-converter-depth-warning','s:44:"Language converter depth limit exceeded ($1)";'),('en','messages:undo-success','s:161:"The edit can be undone.
Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.";'),('en','messages:undo-failure','s:67:"The edit could not be undone due to conflicting intermediate edits.";'),('en','messages:undo-norev','s:70:"The edit could not be undone because it does not exist or was deleted.";'),('en','messages:undo-summary','s:75:"Undo revision $1 by [[Special:Contributions/$2|$2]] ([[User talk:$2|talk]])";'),('en','messages:cantcreateaccounttitle','s:21:"Cannot create account";'),('en','messages:cantcreateaccount-text','s:118:"Account creation from this IP address (''''''$1'''''') has been blocked by [[User:$3|$3]].

The reason given by $3 is ''''$2''''";'),('en','messages:cantcreateaccount-nonblock-text','s:0:"";'),('en','messages:viewpagelogs','s:23:"View logs for this page";'),('en','messages:nohistory','s:39:"There is no edit history for this page.";'),('en','messages:currentrev','s:15:"Latest revision";'),('en','messages:currentrev-asof','s:24:"Latest revision as of $1";'),('en','messages:revisionasof','s:17:"Revision as of $1";'),('en','messages:revision-info','s:23:"Revision as of $1 by $2";'),('en','messages:revision-info-current','s:1:"-";'),('en','messages:revision-nav','s:65:"($1) $2{{int:pipe-separator}}$3 ($4){{int:pipe-separator}}$5 ($6)";'),('en','messages:previousrevision','s:18:"← Older revision";'),('en','messages:nextrevision','s:18:"Newer revision →";'),('en','messages:currentrevisionlink','s:15:"Latest revision";'),('en','messages:cur','s:3:"cur";'),('en','messages:next','s:4:"next";'),('en','messages:last','s:4:"prev";'),('en','messages:page_first','s:5:"first";'),('en','messages:page_last','s:4:"last";'),('en','messages:histlegend','s:279:"Diff selection: mark the radio boxes of the revisions to compare and hit enter or the button at the bottom.<br />
Legend: ''''''({{int:cur}})'''''' = difference with latest revision, ''''''({{int:last}})'''''' = difference with preceding revision, ''''''{{int:minoreditletter}}'''''' = minor edit.";'),('en','messages:history-fieldset-title','s:14:"Browse history";'),('en','messages:history-show-deleted','s:12:"Deleted only";'),('en','messages:history_copyright','s:1:"-";'),('en','messages:histfirst','s:8:"Earliest";'),('en','messages:histlast','s:6:"Latest";'),('en','messages:historysize','s:31:"({{PLURAL:$1|1 byte|$1 bytes}})";'),('en','messages:historyempty','s:7:"(empty)";'),('en','messages:history-feed-title','s:16:"Revision history";'),('en','messages:history-feed-description','s:42:"Revision history for this page on the wiki";')
Function: LCStore_DB::set
Error: 1 ERROR: character 0xe28692 of encoding "UTF8" has no equivalent in "WIN1252"

Backtrace:

#0 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\db\Database.php(538): DatabasePostgres->reportQueryError('ERROR: charact...', 1, 'INSERT INTO l10...', 'LCStore_DB::set', '')
#1 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\db\DatabasePostgres.php(810): DatabaseBase->query('INSERT INTO l10...', 'LCStore_DB::set', '')
#2 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\LocalisationCache.php(822): DatabasePostgres->insert('l10n_cache', Array, 'LCStore_DB::set')
#3 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\LocalisationCache.php(617): LCStore_DB->set('messages:histor...', 'Revision histor...')
#4 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\LocalisationCache.php(352): LocalisationCache->recache('en')
#5 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\LocalisationCache.php(262): LocalisationCache->initLanguage('en')
#6 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\LocalisationCache.php(205): LocalisationCache->loadItem('en', 'deps')
#7 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\LocalisationCache.php(514): LocalisationCache->getItem('en', 'deps')
#8 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\LocalisationCache.php(352): LocalisationCache->recache('en-gb')
#9 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\LocalisationCache.php(262): LocalisationCache->initLanguage('en-gb')
#10 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\LocalisationCache.php(205): LocalisationCache->loadItem('en-gb', 'fallback')
#11 C:\Users\francis clyne\Desktop\apache\htdocs\mw\languages\Language.php(2503): LocalisationCache->getItem('en-gb', 'fallback')
#12 C:\Users\francis clyne\Desktop\apache\htdocs\mw\languages\Language.php(165): Language::getFallbackFor('en-gb')
#13 C:\Users\francis clyne\Desktop\apache\htdocs\mw\languages\Language.php(136): Language::newFromCode('en-gb')
#14 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\StubObject.php(126): Language::factory('en-gb')
#15 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\StubObject.php(103): StubContLang->_newObject()
#16 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\StubObject.php(57): StubObject->_unstub('getCode', 5)
#17 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\StubObject.php(121): StubObject->_call('getCode', Array)
#18 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\GlobalFunctions.php(576): StubContLang->call('getCode', Array)
#19 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\GlobalFunctions.php(576): StubContLang->getCode()
#20 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\MessageCache.php(506): wfGetLangObj(true)
#21 [internal function]: MessageCache->get('mainpage', true, true)
#22 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\StubObject.php(58): call_user_func_array(Array, Array)
#23 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\StubObject.php(76): StubObject->_call('get', Array)
#24 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\GlobalFunctions.php(742): StubObject->
call('get', Array)
#25 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\GlobalFunctions.php(742): StubObject->get('mainpage', true, true)
#26 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\GlobalFunctions.php(707): wfMsgGetKey('mainpage', true, true, true)
#27 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\GlobalFunctions.php(655): wfMsgReal('mainpage', Array, true, true)
#28 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\Title.php(284): wfMsgForContent('mainpage')
#29 C:\Users\francis clyne\Desktop\apache\htdocs\mw\includes\Wiki.php(117): Title::newMainPage()
#30 C:\Users\francis clyne\desktop\apache\htdocs\mw\index.php(61): MediaWiki->checkInitialQueries(NULL, 'view')
#31 {main}

This also happens if I upgrade 1.15 to 1.16. I have no idea what might be causing the error, since I know very little about working with SQL code.

This problem does not seem to occur with the 1.15 series, I have 1.15.4 and 1.15.5 running with absolutely no issues.


Version: 1.16.x
Severity: major
OS: Windows Vista
Platform: PC

Details

Reference
bz24986

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:09 PM
bzimport set Reference to bz24986.
bzimport added a subscriber: Unknown Object (MLST).

The actual query error (tl;dr):

Error: 1 ERROR: character 0xe28692 of encoding "UTF8" has no equivalent in "WIN1252"

Happening during initial l10n cache population.

francisclyne wrote:

Fixed it myself: arrows in previous and next page links aren't recognised by Windows, apparently. I edited each one out of /languages/messages/MessagesEn.php manually.

Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.