Page MenuHomeMiraheze

Wikimedia\Rdbms\DBQueryError when searching on 321nailswiki
Closed, ResolvedPublic


[9b6dee53f621cb50a7b7791d] 2024-01-04 04:55:33: 类型“Wikimedia\Rdbms\DBQueryError”的致命异常

It occurred when I tried to search any pages.

Event Timeline

Error 1191: Can't find FULLTEXT index matching the column list
Function: SearchMySQL::searchInternal
Query: SELECT  page_id,page_namespace,page_title  FROM `page`,`searchindex`    WHERE (page_id=si_page) AND ( MATCH(si_title) AGAINST('+.cssu800 ' IN BOOLEAN MODE) ) AND page_namespace IN (0,4)   ORDER BY  MATCH(si_title) AGAINST('+.cssu800 ' IN NATURAL LANGUAGE MODE) DESC  LIMIT 21

After the wiki reset the problem seemed to disappear. Issues may be caused by the import or the extension enabling process?

I'm leaving the task open in case that the problem happens again in the future as there is no progress in the import request. Anyone here?

The problem obviously still exists.

Now it can be sure that this problem will continue to exist if we don't do something to deal with it.

Here is an exception id: [82e71dcda45b656f209922cb]

Maybe we need to run some maintainence scripts to fix that.

? Almost a month passed and it seems that there isn't any progress on this issue. Do we encounter any critical issues on the problem?

Universal_Omega raised the priority of this task from Normal to High.Mar 23 2024, 05:50
Universal_Omega subscribed.

I am very sorry for the lack of response. Someone will get to it soon. I am going to raise this to high priority, even though we don't typically for these type of issues due to how long it's been open for, if no one else gets to this I can within the next couple days.

Reception123 claimed this task.

Fixed by enabling CirrusSearch. I'd also like to apologize for the delay.