https://bugzilla.wikimedia.org/show_bug.cgi?id=24986

           Summary: MediaWiki 1.16.0 fails to operate beyond installation
                    on PostgreSQL 8.3.11
           Product: MediaWiki
           Version: 1.16.0
          Platform: PC
        OS/Version: Windows Vista
            Status: NEW
          Keywords: postgresql
          Severity: major
          Priority: Normal
         Component: Database
        AssignedTo: wikibugs-l@lists.wikimedia.org
        ReportedBy: franciscl...@gmail.com


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.

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to