Hi , I am working on my own wiki site. I installed it using MS SQL Server as DB.
The only problem is it failed to do content full-text searching, no matter what key words I typed in (I am pretty sure some pages contains the key words), it just gave 'There were no results matching the query.' No searching results shown.
What's wrong with it? Could somebody help me?
Best Regards,
Richard
Plus, I use
Nginx 1.10.2 + Microsoft Sql Server 10.50.2550.0 + PHP 7.0.15-nts-Win32-VC14-x86 + MediaWiki 1.27.1
The only extra modification I made is I cut the oi_name,oi_archive_name length from 255 to 225 because of the problem
Error: 1945 [SQLSTATE 01000][Error Code 1945][Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Warning! The maximum key length is 900 bytes. The index 'oi_name_archive_name' has maximum length of 1020 bytes.
I am not sure if this is the cause for that.
Thanks in advance.
Best Regards
Richard
Hi guys,
When I check the table 'searchindex' , I found all content is messy code.
Is it the problem of failing to make full text searching? How may I fix it?
SQL Server has poor support in MediaWiki, that's probably a bug. Try to bugreport it
@Ciencia Al Poder Thanks very much. Have posted one.
@MarkAHershberger Yes, https://phabricator.wikimedia.org/T158530 :-)
Sounds more like a configuration issue with charset or collation to me (see more info in the bug report)
