hell friends i am using mysql fulltext search in Boolean mode for my mobile selling site, user can register their mobile for sell and there is search bar like google where we can search that mobile and get user's advertise.
地狱的朋友我在布尔模式下使用mysql全文搜索为我的移动销售网站,用户可以注册他们的手机进行销售,并有谷歌搜索栏,我们可以搜索该手机,并获得用户的广告。
problem is when user register their mobile at then some time full text can search that mobile from database and sometimes it cant, i tried by "repair table items;" then once it worked but again same problem"
问题是当用户注册他们的手机然后有时全文可以从数据库中搜索该手机有时它不能,我试过“修复表项目”;然后一旦它工作但又一次同样的问题“
eg i have listed samsung galaxy" then it cant search that mobile from db, then i tried by just "galaxy" keyword and i got it from database again i registerd samsung ace and search that mobile from search bar then it is retrived from db....some times it is searching items sometimes not .any solution plz??thanx in advance
例如,我已经列出了三星galaxy“然后它无法从数据库中搜索移动设备,然后我尝试通过”galaxy“关键字再次从数据库获取它我注册了samsung ace并从搜索栏中搜索该移动设备然后从数据库中重新启动。 ...有时它搜索项目有时不会。任何解决方案plz ?? thanx提前
i tried to off ft_stopword_word and ft_min_length but it did not worked.
我试图关闭ft_stopword_word和ft_min_length,但它没有奏效。
1 个解决方案
#1
0
thank you all for your help, i got solution, there was problem at server side, i was using openshift server for hosting, when i change ft_min_word_len file then in again next restart it will default changes value to 4.. i reported bug and got this reply
谢谢大家的帮助,我得到解决方案,服务器端出现问题,我使用openshift服务器进行托管,当我更改ft_min_word_len文件然后再次重新启动它将默认将值更改为4 ..我报告了bug并得到了这个回复
the "devenv" is a lightly built testing environment, a daily version.
also we have other testing environment like INT and STG, i guess you may test
on them even on PR environment.
INT -> is built from devenv;
STG -> is built from INT;
generally, the INT version is older than devenv, and the STG version is older than INT so if you test on INT and STG, we need to ensure the fixed is merged into them. as i know, the devenv may be merged to PR environment till January 2014.
一般来说,INT版本比devenv旧,STG版本比INT早,所以如果你测试INT和STG,我们需要确保将它们合并到它们中。据我所知,devenv可能会合并到公关环境,直到2014年1月。
if possible,you can have a try on devenv.
如果可能的话,你可以试试devenv。
#1
0
thank you all for your help, i got solution, there was problem at server side, i was using openshift server for hosting, when i change ft_min_word_len file then in again next restart it will default changes value to 4.. i reported bug and got this reply
谢谢大家的帮助,我得到解决方案,服务器端出现问题,我使用openshift服务器进行托管,当我更改ft_min_word_len文件然后再次重新启动它将默认将值更改为4 ..我报告了bug并得到了这个回复
the "devenv" is a lightly built testing environment, a daily version.
also we have other testing environment like INT and STG, i guess you may test
on them even on PR environment.
INT -> is built from devenv;
STG -> is built from INT;
generally, the INT version is older than devenv, and the STG version is older than INT so if you test on INT and STG, we need to ensure the fixed is merged into them. as i know, the devenv may be merged to PR environment till January 2014.
一般来说,INT版本比devenv旧,STG版本比INT早,所以如果你测试INT和STG,我们需要确保将它们合并到它们中。据我所知,devenv可能会合并到公关环境,直到2014年1月。
if possible,you can have a try on devenv.
如果可能的话,你可以试试devenv。