Last modified: 2013-05-24 11:47:10 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 38925 - Creating new accounts causes uninformative "dberrortext" error on PostgreSQL 9.1
Creating new accounts causes uninformative "dberrortext" error on PostgreSQL 9.1
Status: NEW
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
All All
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
: testme
Depends on:
Blocks: postgres
  Show dependency treegraph
Reported: 2012-08-01 17:00 UTC by Chris
Modified: 2013-05-24 11:47 UTC (History)
6 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description Chris 2012-08-01 17:00:21 UTC
When creating new users through Special:CreateAccount on a MediaWiki install using a PostgreSQL database, account creation is interrupted with an uninformative "dberrortext" error message.  The account does appear to be created, but the password emailed to the user does not work, and the user must complete the password-reset process in order to log in.

(This also happens on 1.19.1.)
Comment 1 Karun 2012-09-07 12:25:33 UTC
Can you provide a copy of the error message?
Comment 2 Aude 2012-09-15 08:46:55 UTC
With PostgreSQL 9.1 and MediaWiki trunk (commit 26ef5558850fe4a93316b4a38a3bee32b58b22d1), I don't see this issue.  I can create accounts, get the confirmation email, etc.

Which version of PostgreSQL are you using?
Comment 3 Andre Klapper 2012-12-19 15:30:56 UTC
Chris: Can you please answer the questions in comment 1 and comment 2?
Comment 4 Chris 2012-12-21 17:12:14 UTC
Sorry for the delay in responding.

I have deployed from a Git clone using the 1.19.1 tag.  I am using PostgreSQL 9.1 from Debian backports.

The error results in the page header reading "<databaseerror>" and the body reading "<dberrortext>".  Many strings appear malformed and doubly-escaped.  See this screenshot:
Comment 5 Andre Klapper 2012-12-21 17:16:39 UTC
Any extensions installed (see Special:Version)?
All the raw markup like &gt; also confuses me.
Comment 6 Chris 2012-12-21 17:20:11 UTC
CheckUser 2.3 and ParserFunctions 1.4.1.  Also running on PHP 5.3.3, if that is of any help.
Comment 7 Oren Held 2013-05-23 14:46:31 UTC
Couldn't reproduce this on latest mediawiki snapshot (612353287f1bf898e8234bf6395bde9eb201ef06), Postgres 9.1, PHP 5.4.15, Debian unstable.

Note You need to log in before you can comment on or make changes to this bug.