Last modified: 2010-05-15 15:48:30 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 9444 - Enabling math with postgres, leads to error
Enabling math with postgres, leads to error
Product: MediaWiki
Classification: Unclassified
Parser (Other open bugs)
PC Linux
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
: 9445 (view as bug list)
Depends on:
Blocks: postgres
  Show dependency treegraph
Reported: 2007-03-29 08:11 UTC by Papadakos Panagiotis
Modified: 2010-05-15 15:48 UTC (History)
0 users

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

Workaround for bug 9444 that disables caching of tex images to DB (9.00 KB, text/plain)
2007-04-01 05:35 UTC, Jason Potkanski
Diff for Math.php, adds UTF8 encoding (955 bytes, patch)
2007-04-01 06:24 UTC, Jason Potkanski

Description Papadakos Panagiotis 2007-03-29 08:11:13 UTC
A database error has occurred Query: SELECT
math_outputhash,math_html_conservativeness,math_html,math_mathml FROM math WHERE
math_inputhash = '��׾���@˵' LIMIT 1 Function: MathRenderer::_recall Error: 1
ERROR: invalid byte sequence for encoding "UTF8": 0xebc3d7 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".


#0 /var/www/apache2-default/includes/Database.php(665):
DatabasePostgres->reportQueryError('ERROR: invalid...', 1, 'SELECT math_ou...',
'MathRenderer::_...', false)
#1 /var/www/apache2-default/includes/Database.php(1057): Database->query('SELECT
math_ou...', 'MathRenderer::_...')
#2 /var/www/apache2-default/includes/Database.php(1076):
Database->select('math', Array, Array, 'MathRenderer::_...', Array)
#3 /var/www/apache2-default/includes/Math.php(193): Database->selectRow('math',
Array, Array, 'MathRenderer::_...')
#4 /var/www/apache2-default/includes/Math.php(46): MathRenderer->_recall()
#5 /var/www/apache2-default/includes/Math.php(271): MathRenderer->render()
#6 /var/www/apache2-default/includes/Parser.php(589):
#7 /var/www/apache2-default/includes/Parser.php(299): Parser->strip('== Status
==?<b...', Object(StripState))
#8 /var/www/apache2-default/includes/EditPage.php(1452): Parser->parse('==
Status ==?<b...', Object(Title), Object(ParserOptions))
#9 /var/www/apache2-default/includes/EditPage.php(992): EditPage->getPreviewText()
#10 /var/www/apache2-default/includes/EditPage.php(429): EditPage->showEditForm()
#11 /var/www/apache2-default/includes/EditPage.php(267): EditPage->edit()
#12 /var/www/apache2-default/includes/Wiki.php(417): EditPage->submit()
#13 /var/www/apache2-default/includes/Wiki.php(50):
MediaWiki->performAction(Object(OutputPage), Object(Article), Object(Title),
Object(User), Object(WebRequest))
#14 /var/www/apache2-default/index.php(48): MediaWiki->initialize(Object(Title),
Object(OutputPage), Object(User), Object(WebRequest))
#15 {main}
Comment 1 Raimond Spekking 2007-03-29 08:28:13 UTC
*** Bug 9445 has been marked as a duplicate of this bug. ***
Comment 2 Papadakos Panagiotis 2007-03-29 08:51:06 UTC
Sorry for the duplicate.
Comment 3 Jason Potkanski 2007-04-01 05:30:16 UTC
Seeing the same issue at Citizendium. Attaching workaround...It's ugly.
Comment 4 Jason Potkanski 2007-04-01 05:35:34 UTC
Created attachment 3406 [details]
Workaround for bug 9444 that disables caching of tex images to DB

Performance wise, this workaround is ugly. Images will be rendered every time a
user hits the page.
Comment 5 Jason Potkanski 2007-04-01 06:24:18 UTC
Created attachment 3407 [details]
Diff for Math.php, adds UTF8 encoding

This patch works on postgresql, adds utf8_encode to hash database writes. Reads
seem to be unaffected. 

Have not/unable to test code for other database backends.
Comment 6 Papadakos Panagiotis 2007-04-01 10:04:52 UTC
Yep, it works also here!
Comment 7 Rob Church 2007-04-01 16:02:51 UTC
This should be fixed in 1.10.

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