Last modified: 2010-05-15 15:48:30 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T11444, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 9444 - Enabling math with postgres, leads to error
Enabling math with postgres, leads to error
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Parser (Other open bugs)
1.9.x
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: ---


Attachments
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
Details
Diff for Math.php, adds UTF8 encoding (955 bytes, patch)
2007-04-01 06:24 UTC, Jason Potkanski
Details

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".

Backtrace:

#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):
MathRenderer::renderMath('a^2')
#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.


Navigation
Links