Topic on Project:Support desk

Wiki Search broken after upgrade to 1.35

9
Summary by MarkAHershberger

Upgraded MySQL 5.0 to 8.0.11 and it looks good now.

Rajeshekv (talkcontribs)

Can someone help me with the below error, it seems the search is broken after the upgrade.


[b2da0aa0b75271aba78dbd75] /index.php?search=jboss&title=Special%3ASearch&go=Go Wikimedia\Rdbms\DBQueryError from line 1699 of C:\wiki\websites\mediawiki\includes\libs\rdbms\database\Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'NATURAL LANGUAGE MODE) DESC LIMIT 21' at line 1 (127.0.0.1)

Function: SearchMySQL::searchInternal

Query: SELECT page_id,page_namespace,page_title FROM `erp_page`,`erp_searchindex` WHERE (page_id=si_page) AND ( MATCH(si_title) AGAINST('+jboss ' IN BOOLEAN MODE) ) AND page_namespace = 0 ORDER BY MATCH(si_title) AGAINST('+jboss ' IN NATURAL LANGUAGE MODE) DESC LIMIT 21

Backtrace:

#0 C:\wiki\websites\mediawiki\includes\libs\rdbms\database\Database.php(1683): Wikimedia\Rdbms\Database->getQueryException()

#1 C:\wiki\websites\mediawiki\includes\libs\rdbms\database\Database.php(1658): Wikimedia\Rdbms\Database->getQueryExceptionAndLog()

#2 C:\wiki\websites\mediawiki\includes\libs\rdbms\database\Database.php(1227): Wikimedia\Rdbms\Database->reportQueryError()

#3 C:\wiki\websites\mediawiki\includes\libs\rdbms\database\Database.php(1907): Wikimedia\Rdbms\Database->query()

#4 C:\wiki\websites\mediawiki\includes\libs\rdbms\database\DBConnRef.php(68): Wikimedia\Rdbms\Database->select()

#5 C:\wiki\websites\mediawiki\includes\libs\rdbms\database\DBConnRef.php(313): Wikimedia\Rdbms\DBConnRef->__call()

#6 C:\wiki\websites\mediawiki\includes\search\SearchMySQL.php(193): Wikimedia\Rdbms\DBConnRef->select()

#7 C:\wiki\websites\mediawiki\includes\search\SearchMySQL.php(179): SearchMySQL->searchInternal()

#8 C:\wiki\websites\mediawiki\includes\search\SearchDatabase.php(74): SearchMySQL->doSearchTitleInDB()

#9 C:\wiki\websites\mediawiki\includes\search\SearchEngine.php(156): SearchDatabase->doSearchTitle()

#10 C:\wiki\websites\mediawiki\includes\search\SearchEngine.php(187): SearchEngine->{closure}()

#11 C:\wiki\websites\mediawiki\includes\search\SearchEngine.php(157): SearchEngine->maybePaginate()

#12 C:\wiki\websites\mediawiki\includes\specials\SpecialSearch.php(387): SearchEngine->searchTitle()

#13 C:\wiki\websites\mediawiki\includes\specials\SpecialSearch.php(179): SpecialSearch->showResults()

#14 C:\wiki\websites\mediawiki\includes\specialpage\SpecialPage.php(600): SpecialSearch->execute()

#15 C:\wiki\websites\mediawiki\includes\specialpage\SpecialPageFactory.php(635): SpecialPage->run()

#16 C:\wiki\websites\mediawiki\includes\MediaWiki.php(307): MediaWiki\SpecialPage\SpecialPageFactory->executePath()

#17 C:\wiki\websites\mediawiki\includes\MediaWiki.php(940): MediaWiki->performRequest()

#18 C:\wiki\websites\mediawiki\includes\MediaWiki.php(543): MediaWiki->main()

#19 C:\wiki\websites\mediawiki\index.php(53): MediaWiki->run()

#20 C:\wiki\websites\mediawiki\index.php(46): wfIndexMain()

#21 {main}

Rajeshekv (talkcontribs)

If I search for existing pages, it just pulling up results just just fine, but If i search with some key words in those pages, it giving the above error. Can someone please help with this.

MarkAHershberger (talkcontribs)
Rajeshekv (talkcontribs)

This is what it's

MySQL 5.0.24a

showing in Version page in Wiki but i have upgraded the schema via webupdater (through mw-config page)

MarkAHershberger (talkcontribs)
Rajeshekv (talkcontribs)

I can upgrade it, Can i install version 5.5.8 and import the data as i already upgraded the schema via web updater?

Or is there anything else i need to do ?

MarkAHershberger (talkcontribs)

If you can install it in place, it should be able to use your old db without any problem. Of course, most of my experience is on UNIX, so YMMV.

MarkAHershberger (talkcontribs)

oh, and be sure you have a backup first, of course.

Rajeshekv (talkcontribs)

Thanks for the info, i have upgraded to 8.0.11 and it looks good now.

MySQL 8.0.11