FS#74962 - [mediawiki] math extension doesn't work with postgresql

Attached to Project: Community Packages
Opened by Guoyi (malacology) - Sunday, 05 June 2022, 00:36 GMT
Last edited by Sergej Pupykin (sergej) - Sunday, 03 July 2022, 15:04 GMT
Task Type Bug Report
Category Packages
Status Closed
Assigned To Sergej Pupykin (sergej)
Architecture x86_64
Severity Medium
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

If I just put <math>a^2</math> to preview the article
it will report

<code>
MediaWiki internal error.

Original exception: [54fce9c14a967de8b118c17e] /index.php?title=%E9%A6%96%E9%A1%B5&action=submit Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 42: ERROR: relation "mathoid" does not exist
LINE 1: ...sh,math_mathml,math_tex,math_svg,math_input FROM "mathoid" ...
^

Function: MediaWiki\Extension\Math\MathRenderer::readFromDatabase
Query: SELECT math_inputhash,math_mathml,math_tex,math_svg,math_input FROM "mathoid" WHERE math_inputhash = '\xebc3d7bedc1f11e08895c3124001cbb5' LIMIT 1

Backtrace:
from /usr/share/webapps/mediawiki/includes/libs/rdbms/database/Database.php(1606)
#0 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/Database.php(1590): Wikimedia\Rdbms\Database->getQueryException()
#1 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/Database.php(1564): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#2 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/Database.php(1173): Wikimedia\Rdbms\Database->reportQueryError()
#3 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/Database.php(1810): Wikimedia\Rdbms\Database->query()
#4 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/Database.php(1911): Wikimedia\Rdbms\Database->select()
#5 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/DBConnRef.php(69): Wikimedia\Rdbms\Database->selectRow()
#6 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/DBConnRef.php(337): Wikimedia\Rdbms\DBConnRef->__call()
#7 /usr/share/webapps/mediawiki/extensions/Math/src/MathRenderer.php(256): Wikimedia\Rdbms\DBConnRef->selectRow()
#8 /usr/share/webapps/mediawiki/extensions/Math/src/MathRenderer.php(611): MediaWiki\Extension\Math\MathRenderer->readFromDatabase()
#9 /usr/share/webapps/mediawiki/extensions/Math/src/HookHandlers/ParserHooksHandler.php(113): MediaWiki\Extension\Math\MathRenderer->checkTeX()
#10 /usr/share/webapps/mediawiki/extensions/Math/src/HookHandlers/ParserHooksHandler.php(159): MediaWiki\Extension\Math\HookHandlers\ParserHooksHandler->mathPostTagHook()
#11 /usr/share/webapps/mediawiki/includes/HookContainer/HookContainer.php(160): MediaWiki\Extension\Math\HookHandlers\ParserHooksHandler->onParserAfterTidy()
#12 /usr/share/webapps/mediawiki/includes/HookContainer/HookRunner.php(2828): MediaWiki\HookContainer\HookContainer->run()
#13 /usr/share/webapps/mediawiki/includes/parser/Parser.php(1721): MediaWiki\HookContainer\HookRunner->onParserAfterTidy()
#14 /usr/share/webapps/mediawiki/includes/parser/Parser.php(700): Parser->internalParseHalfParsed()
#15 /usr/share/webapps/mediawiki/includes/content/WikitextContentHandler.php(294): Parser->parse()
#16 /usr/share/webapps/mediawiki/includes/content/ContentHandler.php(1705): WikitextContentHandler->fillParserOutput()
#17 /usr/share/webapps/mediawiki/includes/content/Renderer/ContentRenderer.php(47): ContentHandler->getParserOutput()
#18 /usr/share/webapps/mediawiki/includes/EditPage.php(4254): MediaWiki\Content\Renderer\ContentRenderer->getParserOutput()
#19 /usr/share/webapps/mediawiki/includes/EditPage.php(4157): EditPage->doPreviewParse()
#20 /usr/share/webapps/mediawiki/includes/EditPage.php(2926): EditPage->getPreviewText()
#21 /usr/share/webapps/mediawiki/includes/EditPage.php(728): EditPage->showEditForm()
#22 /usr/share/webapps/mediawiki/includes/actions/EditAction.php(71): EditPage->edit()
#23 /usr/share/webapps/mediawiki/includes/actions/SubmitAction.php(38): EditAction->show()
#24 /usr/share/webapps/mediawiki/includes/MediaWiki.php(544): SubmitAction->show()
#25 /usr/share/webapps/mediawiki/includes/MediaWiki.php(321): MediaWiki->performAction()
#26 /usr/share/webapps/mediawiki/includes/MediaWiki.php(910): MediaWiki->performRequest()
#27 /usr/share/webapps/mediawiki/includes/MediaWiki.php(564): MediaWiki->main()
#28 /usr/share/webapps/mediawiki/index.php(53): MediaWiki->run()
#29 /usr/share/webapps/mediawiki/index.php(46): wfIndexMain()
#30 {main}

Exception caught inside exception handler: [54fce9c14a967de8b118c17e] /index.php?title=%E9%A6%96%E9%A1%B5&action=submit Wikimedia\Rdbms\DBQueryError: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading or after adding a new extension?

Please see https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:Upgrading and https://www.mediawiki.org/wiki/Special:MyLanguage/Manual:How_to_debug for more information.

Error 42: ERROR: relation "mathoid" does not exist
LINE 1: ...sh,math_mathml,math_tex,math_svg,math_input FROM "mathoid" ...
^

Function: MediaWiki\Extension\Math\MathRenderer::readFromDatabase
Query: SELECT math_inputhash,math_mathml,math_tex,math_svg,math_input FROM "mathoid" WHERE math_inputhash = '\xebc3d7bedc1f11e08895c3124001cbb5' LIMIT 1

Backtrace:
from /usr/share/webapps/mediawiki/includes/libs/rdbms/database/Database.php(1606)
#0 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/Database.php(1590): Wikimedia\Rdbms\Database->getQueryException()
#1 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/Database.php(1564): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()
#2 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/Database.php(1173): Wikimedia\Rdbms\Database->reportQueryError()
#3 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/Database.php(1810): Wikimedia\Rdbms\Database->query()
#4 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/Database.php(1911): Wikimedia\Rdbms\Database->select()
#5 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/DBConnRef.php(69): Wikimedia\Rdbms\Database->selectRow()
#6 /usr/share/webapps/mediawiki/includes/libs/rdbms/database/DBConnRef.php(337): Wikimedia\Rdbms\DBConnRef->__call()
#7 /usr/share/webapps/mediawiki/extensions/Math/src/MathRenderer.php(256): Wikimedia\Rdbms\DBConnRef->selectRow()
#8 /usr/share/webapps/mediawiki/extensions/Math/src/MathRenderer.php(611): MediaWiki\Extension\Math\MathRenderer->readFromDatabase()
#9 /usr/share/webapps/mediawiki/extensions/Math/src/HookHandlers/ParserHooksHandler.php(113): MediaWiki\Extension\Math\MathRenderer->checkTeX()
#10 /usr/share/webapps/mediawiki/extensions/Math/src/HookHandlers/ParserHooksHandler.php(159): MediaWiki\Extension\Math\HookHandlers\ParserHooksHandler->mathPostTagHook()
#11 /usr/share/webapps/mediawiki/includes/HookContainer/HookContainer.php(160): MediaWiki\Extension\Math\HookHandlers\ParserHooksHandler->onParserAfterTidy()
#12 /usr/share/webapps/mediawiki/includes/HookContainer/HookRunner.php(2828): MediaWiki\HookContainer\HookContainer->run()
#13 /usr/share/webapps/mediawiki/includes/parser/Parser.php(1721): MediaWiki\HookContainer\HookRunner->onParserAfterTidy()
#14 /usr/share/webapps/mediawiki/includes/parser/Parser.php(700): Parser->internalParseHalfParsed()
#15 /usr/share/webapps/mediawiki/includes/cache/MessageCache.php(1323): Parser->parse()
#16 /usr/share/webapps/mediawiki/includes/language/Message.php(1445): MessageCache->parse()
#17 /usr/share/webapps/mediawiki/includes/language/Message.php(1002): Message->parseText()
#18 /usr/share/webapps/mediawiki/includes/language/Message.php(1060): Message->format()
#19 /usr/share/webapps/mediawiki/includes/skins/Skin.php(750): Message->parse()
#20 /usr/share/webapps/mediawiki/includes/skins/SkinMustache.php(76): Skin->printSource()
#21 /usr/share/webapps/mediawiki/skins/Vector/includes/SkinVector.php(564): SkinMustache->getTemplateData()
#22 /usr/share/webapps/mediawiki/skins/Vector/includes/SkinVector22.php(82): Vector\SkinVector->getTemplateData()
#23 /usr/share/webapps/mediawiki/includes/skins/SkinMustache.php(58): Vector\SkinVector22->getTemplateData()
#24 /usr/share/webapps/mediawiki/skins/Vector/includes/SkinVector.php(455): SkinMustache->generateHTML()
#25 /usr/share/webapps/mediawiki/includes/skins/SkinTemplate.php(150): Vector\SkinVector->generateHTML()
#26 /usr/share/webapps/mediawiki/includes/OutputPage.php(2807): SkinTemplate->outputPage()
#27 /usr/share/webapps/mediawiki/includes/exception/MWExceptionRenderer.php(157): OutputPage->output()
#28 /usr/share/webapps/mediawiki/includes/exception/MWExceptionRenderer.php(76): MWExceptionRenderer::reportHTML()
#29 /usr/share/webapps/mediawiki/includes/exception/MWExceptionHandler.php(107): MWExceptionRenderer::output()
#30 /usr/share/webapps/mediawiki/includes/exception/MWExceptionHandler.php(202): MWExceptionHandler::report()
#31 /usr/share/webapps/mediawiki/includes/MediaWiki.php(583): MWExceptionHandler::handleException()
#32 /usr/share/webapps/mediawiki/index.php(53): MediaWiki->run()
#33 /usr/share/webapps/mediawiki/index.php(46): wfIndexMain()
#34 {main}
</code>

Steps to reproduce:
This task depends upon

Closed by  Sergej Pupykin (sergej)
Sunday, 03 July 2022, 15:04 GMT
Reason for closing:  Fixed
Comment by Sergej Pupykin (sergej) - Sunday, 05 June 2022, 23:25 GMT
Did you run `php7 maintenance/update.php`? I use it with mariadb and still with texvc, but it works for me.
Comment by Guoyi (malacology) - Monday, 06 June 2022, 03:28 GMT
I already run it, but it can't be used. Maybe postgresql related?
Comment by Sergej Pupykin (sergej) - Saturday, 02 July 2022, 14:34 GMT
Is 1.38.2 still affected?
Comment by Guoyi (malacology) - Sunday, 03 July 2022, 14:31 GMT
Now it is fixed

Loading...