Topic on User talk:Animaratio/Flow

Hola @Ciencia Al Poder

sabes que tengo este error en el motor de búsqueda, tiens idea o sugerencia?:

[XqH1dzyeqUhrhv2xHnsQuQAAAAQ] /index.php?title=Especial%3ABuscar&search=trombo&go=Ir Wikimedia\Rdbms\DBQueryError from line 1603 of /home/datra/public_html/musiki/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?

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

Function: SearchMySQL::searchInternal

Error: 1191 Can't find FULLTEXT index matching the column list (127.0.0.1:3306)

Backtrace:

#0 /home/datra/public_html/musiki/includes/libs/rdbms/database/Database.php(1574): Wikimedia\Rdbms\Database->getQueryExceptionAndLog(string, integer, string, string)

#1 /home/datra/public_html/musiki/includes/libs/rdbms/database/Database.php(1152): Wikimedia\Rdbms\Database->reportQueryError(string, integer, string, string, boolean)

#2 /home/datra/public_html/musiki/includes/libs/rdbms/database/Database.php(1807): Wikimedia\Rdbms\Database->query(string, string)

#3 /home/datra/public_html/musiki/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->select(array, array, array, string, array, array)

#4 /home/datra/public_html/musiki/includes/libs/rdbms/database/DBConnRef.php(315): Wikimedia\Rdbms\DBConnRef->__call(string, array)

#5 /home/datra/public_html/musiki/includes/search/SearchMySQL.php(193): Wikimedia\Rdbms\DBConnRef->select(array, array, array, string, array, array)

#6 /home/datra/public_html/musiki/includes/search/SearchMySQL.php(179): SearchMySQL->searchInternal(string, boolean)

#7 /home/datra/public_html/musiki/includes/search/SearchDatabase.php(73): SearchMySQL->doSearchTitleInDB(string)

#8 /home/datra/public_html/musiki/includes/search/SearchEngine.php(143): SearchDatabase->doSearchTitle(string)

#9 /home/datra/public_html/musiki/includes/search/SearchEngine.php(172): SearchEngine->{closure}()

#10 /home/datra/public_html/musiki/includes/search/SearchEngine.php(144): SearchEngine->maybePaginate(Closure)

#11 /home/datra/public_html/musiki/includes/specials/SpecialSearch.php(355): SearchEngine->searchTitle(string)

#12 /home/datra/public_html/musiki/includes/specials/SpecialSearch.php(179): SpecialSearch->showResults(string)

#13 /home/datra/public_html/musiki/includes/specialpage/SpecialPage.php(575): SpecialSearch->execute(NULL)

#14 /home/datra/public_html/musiki/includes/specialpage/SpecialPageFactory.php(611): SpecialPage->run(NULL)

#15 /home/datra/public_html/musiki/includes/MediaWiki.php(296): MediaWiki\Special\SpecialPageFactory->executePath(Title, RequestContext)

#16 /home/datra/public_html/musiki/includes/MediaWiki.php(900): MediaWiki->performRequest()

#17 /home/datra/public_html/musiki/includes/MediaWiki.php(527): MediaWiki->main()

#18 /home/datra/public_html/musiki/index.php(44): MediaWiki->run()

#19 {main}

Según esto https://stackoverflow.com/questions/9680472/cant-find-fulltext-index-matching-the-column-list-indexes-is-set

Tienes que ejecutar en la base de datos:

ALTER TABLE mwpx_searchindex ADD FULLTEXT(si_title);

lo había intentado si, pero sigue dando el mismo error:

[XqNUNgE4KMwOSgAQneWr0AAAAAI] /index.php?title=Especial%3ABuscar&search=trombo&go=Ir Wikimedia\Rdbms\DBQueryError from line 1603 of /home/datra/public_html/musiki/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?

Query: SELECT page_id,page_namespace,page_title FROM `mwpx_page`,`mwpx_searchindex` WHERE (page_id=si_page) AND ( MATCH(si_text) AGAINST('+trombo ' IN BOOLEAN MODE) ) AND page_namespace = '0' ORDER BY MATCH(si_text) AGAINST('+trombo ' IN NATURAL LANGUAGE MODE) DESC LIMIT 21

Function: SearchMySQL::searchInternal

Error: 1191 Can't find FULLTEXT index matching the column list (127.0.0.1:3306)

por otro lado esta página de Cargo también da error, fue todo luego del update a 1.34 desde 1.33,

tal vez esten relacionados?. mil gracias por tu ayuda.

http://musiki.org.ar/Especial:Buscar_datos

[XqNSQMRhv507vxg7G8GcUAAAAAE] /Especial:Buscar_datos Wikimedia\Rdbms\DBReadOnlyRoleError from line 1195 of /home/datra/public_html/musiki/includes/libs/rdbms/database/Database.php: Cannot write; target role is DB_REPLICA

Backtrace:

#0 /home/datra/public_html/musiki/includes/libs/rdbms/database/Database.php(1148): Wikimedia\Rdbms\Database->executeQuery(string, string, integer)

#1 /home/datra/public_html/musiki/includes/libs/rdbms/database/DBConnRef.php(68): Wikimedia\Rdbms\Database->query(string, string, integer)

#2 /home/datra/public_html/musiki/includes/libs/rdbms/database/DBConnRef.php(292): Wikimedia\Rdbms\DBConnRef->__call(string, array)

#3 /home/datra/public_html/musiki/extensions/SemanticDrilldown/includes/TemporaryTableManager.php(34): Wikimedia\Rdbms\DBConnRef->query(string, string)

#4 /home/datra/public_html/musiki/extensions/SemanticDrilldown/specials/SD_BrowseData.php(237): TemporaryTableManager->queryWithAutoCommit(string, string)

#5 /home/datra/public_html/musiki/extensions/SemanticDrilldown/specials/SD_BrowseData.php(1146): SDBrowseDataPage->createTempTable(string, string, array, array)

#6 /home/datra/public_html/musiki/includes/specialpage/QueryPage.php(687): SDBrowseDataPage->getPageHeader()

#7 /home/datra/public_html/musiki/extensions/SemanticDrilldown/specials/SD_BrowseData.php(133): QueryPage->execute(NULL)

#8 /home/datra/public_html/musiki/includes/specialpage/SpecialPage.php(575): SDBrowseData->execute(NULL)

#9 /home/datra/public_html/musiki/includes/specialpage/SpecialPageFactory.php(611): SpecialPage->run(NULL)

#10 /home/datra/public_html/musiki/includes/MediaWiki.php(296): MediaWiki\Special\SpecialPageFactory->executePath(Title, RequestContext)

#11 /home/datra/public_html/musiki/includes/MediaWiki.php(900): MediaWiki->performRequest()

#12 /home/datra/public_html/musiki/includes/MediaWiki.php(527): MediaWiki->main()

#13 /home/datra/public_html/musiki/index.php(44): MediaWiki->run()

#14 {main}

Pues creo que estás aplicando la actualización sobre una base de datos, y MediaWiki está apuntando a una base de datos totalmente diferente.