Last modified: 2007-06-20 18:01:44 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 8716 - binary md5 in Math.php break in postgreSQL
binary md5 in Math.php break in postgreSQL
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.10.x
All All
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
:
: 9546 10321 (view as bug list)
Depends on:
Blocks: postgres
  Show dependency treegraph
 
Reported: 2007-01-20 23:05 UTC by Antoine "hashar" Musso (WMF)
Modified: 2007-06-20 18:01 UTC (History)
2 users (show)

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


Attachments

Description Antoine "hashar" Musso (WMF) 2007-01-20 23:05:59 UTC
Reported by Timonator on irc:

pg_query() [function.pg-query]: Query failed:
ERROR: invalid byte sequence for encoding "UTF8": 0x9a
HINT: This error can also happen if the byte sequence does not
match the encoding expected by the server, which is controlled
by "client_encoding". in ./includes/DatabasePostgres.php on line 389


A database error has occurred Query: SELECT
math_outputhash,math_html_conservativeness,math_html,math_mathml FROM math WHERE
math_inputhash = 'zfsq`X��y���.�V ' LIMIT 1 Function: MathRenderer::_recall
Error: 1 ERROR: invalid byte sequence for encoding "UTF8": 0x9a HINT: This error
can also happen if the byte sequence does not match the encoding expected by the
server, which is controlled by "client_encodin

This is caused by pack() used to store the md5 hash as a binary field
in the database.
Comment 1 Ian Kumlien 2007-02-08 12:26:01 UTC
remove the pack and unpack and it works, why pack at all? A md5 sum should
always work.
to me this looks like a useless operation while it might act as compression.
Comment 2 Cédric 2007-02-08 23:00:04 UTC
else use a bytea data type
Comment 3 Greg Sabino Mullane 2007-03-17 20:01:33 UTC
While I agree the pack and unpack seems a little silly to save a few characters,
I've changed the two database fields to bytea for now: r20542
Comment 4 Rob Church 2007-04-10 10:25:18 UTC
*** Bug 9546 has been marked as a duplicate of this bug. ***
Comment 5 Brion Vibber 2007-06-20 18:01:44 UTC
*** Bug 10321 has been marked as a duplicate of this bug. ***

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


Navigation
Links