【求助】php + sphinx 配置后 无法使用!返回空!sphinx.conf是否配置正确
sphinx 配置
使用sphinx,也不知道安装是否成功。但是结果是PHP程序搜索不到任何内容。1)sphinx安装目录:F:\sphinx\,配置文件:F:\sphinx\sphinx.conf
2)数据库:tbdb.ratedat,sphinx来自 sphinx-for-chinese-2.1.0-dev-r3361-win32.zip
3)Apache/2.4.4 (Win32) PHP/5.4.16,服务器版本: 5.6.12-log - MySQL Community Server (GPL)
F:\sphinx\sphinx.conf 全部内容
source srcDB{ type = mysql sql_host = localhost sql_user = root sql_pass = zbphp.com~$ sql_db = tbdb sql_port = 3306 sql_query_pre = SET NAMES utf8 #sql_query_pre = SET SESSION query_cache_type=OFF #很奇怪,加这一句会报错! sql_query = \ SELECT trade_id,trade_time,goods_title,goods_price,uid_buy,uid_sell \ FROM ratedat sql_attr_bigint = trade_id sql_attr_bigint = uid_buy sql_attr_bigint = uid_sell sql_attr_timestamp = trade_time sql_query_info = SELECT * FROM ratedat WHERE trade_id=$id}index goods_title{ source = srcDB path = F:/sphinx/data/ratedat.goods_title charset_type = utf-8 html_strip = 1}indexer{ mem_limit = 128M}searchd{ listen = 9312 listen = 9306:mysql41 log = F:/sphinx/log/searchd.log query_log = F:/sphinx/log/query.log read_timeout = 5 max_children = 30 pid_file = F:/sphinx/log/searchd.pid max_matches = 1000 seamless_rotate = 1 preopen_indexes = 1 unlink_old = 1 workers = threads # for RT to work binlog_path = F:/sphinx/data}
安装文件 F:/sphinx/Install.bat
net stop SphinxSearchsc delete SphinxSearchdel /s/q %cd%\log\*.*del /s/q %cd%\data\*.*%cd%\bin\searchd --install --config %cd%\sphinx.conf --servicename SphinxSearch%cd%\bin\indexer -c %cd%\sphinx.conf --allnet start SphinxSearchpause
bat脚本安装过程提示:
F:\sphinx>net stop SphinxSearchSphinxSearch 服务正在停止..SphinxSearch 服务已成功停止。F:\sphinx>sc delete SphinxSearch[SC] DeleteService SUCCESSF:\sphinx>del /s/q F:\sphinx\log\*.*删除文件 - F:\sphinx\log\query.log删除文件 - F:\sphinx\log\searchd.logF:\sphinx>del /s/q F:\sphinx\data\*.*删除文件 - F:\sphinx\data\binlog.001删除文件 - F:\sphinx\data\binlog.meta删除文件 - F:\sphinx\data\ratedat.goods_title.spa删除文件 - F:\sphinx\data\ratedat.goods_title.spd删除文件 - F:\sphinx\data\ratedat.goods_title.spe删除文件 - F:\sphinx\data\ratedat.goods_title.sph删除文件 - F:\sphinx\data\ratedat.goods_title.spi删除文件 - F:\sphinx\data\ratedat.goods_title.spk删除文件 - F:\sphinx\data\ratedat.goods_title.spm删除文件 - F:\sphinx\data\ratedat.goods_title.spp删除文件 - F:\sphinx\data\ratedat.goods_title.spsF:\sphinx>F:\sphinx\bin\searchd --install --config F:\sphinx\sphinx.conf --servicename SphinxSearchsphinx-for-chinese 2.1.0-dev (r3361)Copyright (c) 2008-2012, sphinx-search.comInstalling service...Service 'SphinxSearch' installed succesfully.F:\sphinx>F:\sphinx\bin\indexer -c F:\sphinx\sphinx.conf --allsphinx-for-chinese 2.1.0-dev (r3361)Copyright (c) 2008-2012, sphinx-search.comusing config file 'F:\sphinx\sphinx.conf'...indexing index 'goods_title'...WARNING: attribute 'trade_id' not found - IGNORINGWARNING: source srcDB: skipped 10378355 document(s) with DOCID_MAX idscollected 176464 docs, 12.1 MBsorted 0.7 Mhits, 100.0% donetotal 176464 docs, 12144715 bytestotal 37.745 sec, 321754 bytes/sec, 4675.12 docs/sectotal 2 reads, 0.007 sec, 4604.6 kb/call avg, 3.9 msec/call avgtotal 19 writes, 0.360 sec, 950.7 kb/call avg, 18.9 msec/call avgF:\sphinx>net start SphinxSearchSphinxSearch 服务正在启动 .SphinxSearch 服务已经启动成功。F:\sphinx>pause请按任意键继续. . .
PHP文件内容:
<?phprequire ( "sphinxapi.php" );$s = new SphinxClient();$s->SetServer('localhost');$rst = $s->Query('电脑');print_r($s);print_r($rst);/*SphinxClient Object( [_host] => localhost [_port] => 9312 [_offset] => 0 [_limit] => 20 [_mode] => 0 [_weights] => Array ( ) [_sort] => 0 [_sortby] => [_min_id] => 0 [_max_id] => 0 [_filters] => Array ( ) [_groupby] => [_groupfunc] => 0 [_groupsort] => @group desc [_groupdistinct] => [_maxmatches] => 1000 [_cutoff] => 0 [_retrycount] => 0 [_retrydelay] => 0 [_anchor] => Array ( ) [_indexweights] => Array ( ) [_ranker] => 0 [_rankexpr] => [_maxquerytime] => 0 [_fieldweights] => Array ( ) [_overrides] => Array ( ) [_select] => * [_error] => [_warning] => [_connerror] => [_reqs] => Array ( ) [_mbenc] => [_arrayresult] => [_timeout] => 0 [_path] => [_socket] => )Array( [error] => [warning] => [status] => 0 [fields] => Array ( [0] => goods_title [1] => goods_price ) [attrs] => Array ( [trade_time] => 2 [uid_buy] => 6 [uid_sell] => 6 ) [total] => 0 [total_found] => 0 [time] => 0.000)*/
sphinx日志内容:F:\sphinx\log\query.log
[Mon Sep 9 12:40:43.311 2013] 0.035 sec [all/0/rel 0 (0,20)] [*] 电脑[Mon Sep 9 12:40:48.751 2013] 0.000 sec [all/0/rel 0 (0,20)] [*] 电脑
回复讨论(解决方案)
现在,看起来我应该终于安装把sphinx安装成功了。
不过我发现如果我把下面这几个的注释去掉,就没有任何结果。为什么?
有几个疑问,搜索的关键字,到底是针对的那几个字段?
sphinx似乎不能指定某个字段内的搜索? ?如何指定在某几个字段内搜索?
F:\sphinx\sphinx.conf
source srcDB{ type = mysql sql_host = localhost sql_user = root sql_pass = zbphp.com~ sql_db = tbdb sql_port = 3306 sql_query_pre = SET NAMES utf8 sql_query = \ SELECT trade_id,trade_time,goods_title,goods_price,uid_buy,uid_sell,rate_txt \ FROM ratedat #sql_attr_uint = trade_id #sql_attr_timestamp = trade_time #sql_attr_float = goods_price #sql_attr_string = rate_txt sql_attr_uint = uid_buy sql_attr_string = goods_title sql_query_info = SELECT * FROM ratedat WHERE trade_id=$id}
SELECT trade_id,trade_time,goods_title,goods_price,uid_buy,uid_sell,rate_txt \
FROM ratedat
很明显 已经指定字段了啊,他会搜索trade_id,trade_time,goods_title,goods_price,uid_buy,uid_sell,rate_txt
这几个字段
你把哪几个注释掉了?没明白
你把哪几个注释掉了?没明白
#1楼代码中的这几个注释后可以查询到:
#sql_attr_uint = trade_id #sql_attr_timestamp = trade_time #sql_attr_float = goods_price #sql_attr_string = rate_txt
你把哪几个注释掉了?没明白
#1楼代码中的这几个注释后可以查询到:
#sql_attr_uint = trade_id #sql_attr_timestamp = trade_time #sql_attr_float = goods_price #sql_attr_string = rate_txt
sphinx 支持的属性如下:
无符号整数(1-32位宽)
UNIX 时间戳(timestamps)
浮点值(32位,IEEE 754单精度)
字符串叙述 (尤其是计算出的整数值);
多值属性 MVA (multi-value attributes)
#sql_attr_uint = trade_id
#sql_attr_string = rate_txt
没有这种设置啊,会报错的
你把哪几个注释掉了?没明白
#1楼代码中的这几个注释后可以查询到:
#sql_attr_uint = trade_id #sql_attr_timestamp = trade_time #sql_attr_float = goods_price #sql_attr_string = rate_txt
sphinx 支持的属性如下:
无符号整数(1-32位宽)
UNIX 时间戳(timestamps)
浮点值(32位,IEEE 754单精度)
字符串叙述 (尤其是计算出的整数值);
多值属性 MVA (multi-value attributes)
#sql_attr_uint = trade_id
#sql_attr_string = rate_txt
没有这种设置啊,会报错的
我发现 这里放在soure部分的 sql_attr_uint,sql_attr_string 就是会显示到搜索结果的$rst[matches][xxxx][attr]中,如果在souce中没有定义这些字段,那么搜索返回数据就没有附带这些字段内容。我写进去是想得到这些数据,但是发现写了之后,就运行出错或者无任何返回值。
SELECT trade_id,trade_time,goods_title,goods_price,uid_buy,uid_sell,rate_txt \
FROM ratedat
很明显 已经指定字段了啊,他会搜索trade_id,trade_time,goods_title,goods_price,uid_buy,uid_sell,rate_txt
这几个字段
但是假如我输入的是文字字符串的关键字,那么他岂不同样会检索 trade_id,trade_time,uid_buy,uid_sell的内容了?我看到网上有这样的写法,指定某个字段的搜索,代码如下:
<?php require ( 'sphinxapi.php' ); $s = new SphinxClient(); $s->setMatchMode(SPH_MATCH_EXTENDED2); $rst = $s->Query('@goods_title '.$kw); print_r($rst); print_r($s); exit();/*SphinxClient Object( [_host] => localhost [_port] => 9312 [_offset] => 0 [_limit] => 20 [_mode] => 6 [_weights] => Array ( ) [_sort] => 0 [_sortby] => [_min_id] => 0 [_max_id] => 0 [_filters] => Array ( ) [_groupby] => [_groupfunc] => 0 [_groupsort] => @group desc [_groupdistinct] => [_maxmatches] => 1000 [_cutoff] => 0 [_retrycount] => 0 [_retrydelay] => 0 [_anchor] => Array ( ) [_indexweights] => Array ( ) [_ranker] => 0 [_rankexpr] => [_maxquerytime] => 0 [_fieldweights] => Array ( ) [_overrides] => Array ( ) [_select] => * [_error] => query error: no field 'goods_title' found in schema [_warning] => [_connerror] => [_reqs] => Array ( ) [_mbenc] => [_arrayresult] => [_timeout] => 0 [_path] => [_socket] => )*/
提示: [_error] => query error: no field 'goods_title' found in schema
但是假如我 去掉 “ @goods_title”可以搜索到结果,sphinx如何才可以指定在某个文字数据串中搜索结果
现在我整个配置文件的内容如下,文件 f:/sphinx/sphinx.conf
source DB{ type = mysql sql_host = localhost sql_user = root sql_pass = zbphp.com~$ sql_db = zbphp_com sql_port = 3306 sql_query_pre = SET NAMES utf8}source Buyer : DB{ sql_query = \ SELECT trade_id,trade_time,goods_price,goods_title,uid_buy,uid_sell,rate_txt \ FROM ratedat sql_attr_uint = uid_buy sql_attr_string = goods_title sql_attr_float = goods_price sql_attr_timestamp = trade_time sql_query_info = SELECT * FROM ratedat WHERE trade_id=$id}index buyerlist{ type = plain source = Buyer path = F:/sphinx/data/buyerlist docinfo = extern mlock = 0 morphology = none stopwords = min_word_len = 1 charset_type = utf-8 html_strip = 1 min_prefix_len = 0 min_infix_len = 1 ngram_len = 1 charset_table = U+FF10..U+FF19->0..9, 0..9, U+FF41..U+FF5A->a..z, U+FF21..U+FF3A->a..z,\ A..Z->a..z, a..z, U+0149, U+017F, U+0138, U+00DF, U+00FF, U+00C0..U+00D6->U+00E0..U+00F6,\ U+00E0..U+00F6, U+00D8..U+00DE->U+00F8..U+00FE, U+00F8..U+00FE, U+0100->U+0101, U+0101,\ U+0102->U+0103, U+0103, U+0104->U+0105, U+0105, U+0106->U+0107, U+0107, U+0108->U+0109,\ U+0109, U+010A->U+010B, U+010B, U+010C->U+010D, U+010D, U+010E->U+010F, U+010F,\ U+0110->U+0111, U+0111, U+0112->U+0113, U+0113, U+0114->U+0115, U+0115, \ U+0116->U+0117,U+0117, U+0118->U+0119, U+0119, U+011A->U+011B, U+011B, U+011C->U+011D,\ U+011D,U+011E->U+011F, U+011F, U+0130->U+0131, U+0131, U+0132->U+0133, U+0133, \ U+0134->U+0135,U+0135, U+0136->U+0137, U+0137, U+0139->U+013A, U+013A, U+013B->U+013C, \ U+013C,U+013D->U+013E, U+013E, U+013F->U+0140, U+0140, U+0141->U+0142, U+0142, \ U+0143->U+0144,U+0144, U+0145->U+0146, U+0146, U+0147->U+0148, U+0148, U+014A->U+014B, \ U+014B,U+014C->U+014D, U+014D, U+014E->U+014F, U+014F, U+0150->U+0151, U+0151, \ U+0152->U+0153,U+0153, U+0154->U+0155, U+0155, U+0156->U+0157, U+0157, U+0158->U+0159,\ U+0159,U+015A->U+015B, U+015B, U+015C->U+015D, U+015D, U+015E->U+015F, U+015F, \ U+0160->U+0161,U+0161, U+0162->U+0163, U+0163, U+0164->U+0165, U+0165, U+0166->U+0167, \ U+0167,U+0168->U+0169, U+0169, U+016A->U+016B, U+016B, U+016C->U+016D, U+016D, \ U+016E->U+016F,U+016F, U+0170->U+0171, U+0171, U+0172->U+0173, U+0173, U+0174->U+0175,\ U+0175,U+0176->U+0177, U+0177, U+0178->U+00FF, U+00FF, U+0179->U+017A, U+017A, \ U+017B->U+017C,U+017C, U+017D->U+017E, U+017E, U+0410..U+042F->U+0430..U+044F, \ U+0430..U+044F,U+05D0..U+05EA, U+0531..U+0556->U+0561..U+0586, U+0561..U+0587, \ U+0621..U+063A, U+01B9,U+01BF, U+0640..U+064A, U+0660..U+0669, U+066E, U+066F, \ U+0671..U+06D3, U+06F0..U+06FF,U+0904..U+0939, U+0958..U+095F, U+0960..U+0963, \ U+0966..U+096F, U+097B..U+097F,U+0985..U+09B9, U+09CE, U+09DC..U+09E3, U+09E6..U+09EF, \ U+0A05..U+0A39, U+0A59..U+0A5E,U+0A66..U+0A6F, U+0A85..U+0AB9, U+0AE0..U+0AE3, \ U+0AE6..U+0AEF, U+0B05..U+0B39,U+0B5C..U+0B61, U+0B66..U+0B6F, U+0B71, U+0B85..U+0BB9, \ U+0BE6..U+0BF2, U+0C05..U+0C39,U+0C66..U+0C6F, U+0C85..U+0CB9, U+0CDE..U+0CE3, \ U+0CE6..U+0CEF, U+0D05..U+0D39, U+0D60,U+0D61, U+0D66..U+0D6F, U+0D85..U+0DC6, \ U+1900..U+1938, U+1946..U+194F, U+A800..U+A805,U+A807..U+A822, U+0386->U+03B1, \ U+03AC->U+03B1, U+0388->U+03B5, U+03AD->U+03B5,U+0389->U+03B7, U+03AE->U+03B7, \ U+038A->U+03B9, U+0390->U+03B9, U+03AA->U+03B9,U+03AF->U+03B9, U+03CA->U+03B9, \ U+038C->U+03BF, U+03CC->U+03BF, U+038E->U+03C5,U+03AB->U+03C5, U+03B0->U+03C5, \ U+03CB->U+03C5, U+03CD->U+03C5, U+038F->U+03C9,U+03CE->U+03C9, U+03C2->U+03C3, \ U+0391..U+03A1->U+03B1..U+03C1,U+03A3..U+03A9->U+03C3..U+03C9, U+03B1..U+03C1, \ U+03C3..U+03C9, U+0E01..U+0E2E,U+0E30..U+0E3A, U+0E40..U+0E45, U+0E47, U+0E50..U+0E59, \ U+A000..U+A48F, U+4E00..U+9FBF,U+3400..U+4DBF, U+20000..U+2A6DF, U+F900..U+FAFF, \ U+2F800..U+2FA1F, U+2E80..U+2EFF,U+2F00..U+2FDF, U+3100..U+312F, U+31A0..U+31BF, \ U+3040..U+309F, U+30A0..U+30FF,U+31F0..U+31FF, U+AC00..U+D7AF, U+1100..U+11FF, \ U+3130..U+318F, U+A000..U+A48F,U+A490..U+A4CF ngram_chars = U+4E00..U+9FBF, U+3400..U+4DBF, U+20000..U+2A6DF, U+F900..U+FAFF,\ U+2F800..U+2FA1F, U+2E80..U+2EFF, U+2F00..U+2FDF, U+3100..U+312F, U+31A0..U+31BF,\ U+3040..U+309F, U+30A0..U+30FF, U+31F0..U+31FF, U+AC00..U+D7AF, U+1100..U+11FF,\ U+3130..U+318F, U+A000..U+A48F, U+A490..U+A4CF}index rt{ type = rt path = f:/sphinx/data/rt rt_field = goods_title rt_field = rate_txt rt_attr_uint = uid_buy}indexer{ mem_limit = 128M}searchd{ listen = 9312 listen = 9306:mysql41 log = F:/sphinx/log/searchd.log query_log = F:/sphinx/log/query.log read_timeout = 5 max_children = 30 pid_file = F:/sphinx/log/searchd.pid max_matches = 1000 seamless_rotate = 1 preopen_indexes = 1 unlink_old = 1 workers = threads binlog_path = F:/sphinx/data}
1) 里面的 index rt {} 我不知道怎么来用,不是 type = mysql吗,为什么index rt 这个的type=rt ? 如果不加 index rt这一段 也是可以安装成功的
2) 这个sphinx.conf安装是安装成功的,但是如上一楼#6那样指定在某个字段中进行搜索“@goods_title $kw”返回的报错error是 query error: no field 'goods_title' found in schema。
3)如何才可以实现交表查询?我想得到的是这样的数据,三个表 ratedat,rate_buyer,userdat:
SELECT a.*,b.*,c.nick FROM rate_buyer a LEFT JOIN ratedat b ON a.uid=b.uid_buyLEFT JOIN userdat c ON a.uid=c.uid WHERE 1GROUP BY a.uid ORDER BY b.costsum DESC LIMIT $startnum , $perpage ;
我在sphinx.conf中按照这样来写,安装成功了,但是每次只能得到一个结果:
source Buyer : DB{ sql_query = \ SELECT a.uid,a.costsum,a.costmax,a.costmin,a.costavg,a.costcount \ ,b.goods_price,b.goods_title,b.trade_id,b.trade_time,b.uid_buy \ ,c.nick \ FROM rate_buyer a \ LEFT JOIN ratedat b ON a.uid=b.uid_buy \ LEFT JOIN userdat c ON a.uid=c.uid \ GROUP BY a.uid \ ORDER BY a.costsum DESC \ sql_attr_uint = uid_buy sql_attr_string = goods_title sql_attr_float = goods_price sql_attr_timestamp = trade_time sql_query_info = SELECT * FROM ratedat WHERE trade_id=$id}
安装过程bat提示记录:
SphinxSearch 服务正在停止..SphinxSearch 服务已成功停止。[SC] DeleteService SUCCESS删除文件 - F:\sphinx\data\binlog.meta删除文件 - F:\sphinx\data\rt.kill删除文件 - F:\sphinx\data\rt.lock删除文件 - F:\sphinx\data\rt.meta删除文件 - F:\sphinx\data\rt.ramsphinx-for-chinese 2.1.0-dev (r3361)Copyright (c) 2008-2012, sphinx-search.comInstalling service...Service 'SphinxSearch' installed succesfully.sphinx-for-chinese 2.1.0-dev (r3361)Copyright (c) 2008-2012, sphinx-search.comusing config file 'F:\sphinx\sphinx.conf'...indexing index 'buyerlist'...collected 136 docs, 0.0 MBsorted 0.0 Mhits, 100.0% donetotal 136 docs, 6577 bytestotal 0.305 sec, 21558 bytes/sec, 445.78 docs/secskipping non-plain index 'rt'...total 2 reads, 0.000 sec, 145.0 kb/call avg, 0.0 msec/call avgtotal 10 writes, 0.028 sec, 61.5 kb/call avg, 2.8 msec/call avgsphinx-for-chinese 2.1.0-dev (r3361)Copyright (c) 2008-2012, sphinx-search.comusing config file 'F:\sphinx\sphinx.conf'...index 'buyerlist': query 'iPhone ': returned 0 matches of 0 total in 0.000 secwords:1. 'iphone': 0 documents, 0 hitsindex 'rt': search error: failed to open f:/sphinx/data/rt.sph: No such file ordirectory.SphinxSearch 服务正在启动 .SphinxSearch 服务已经启动成功。请按任意键继续. . .

Outils d'IA chauds

Undresser.AI Undress
Application basée sur l'IA pour créer des photos de nu réalistes

AI Clothes Remover
Outil d'IA en ligne pour supprimer les vêtements des photos.

Undress AI Tool
Images de déshabillage gratuites

Clothoff.io
Dissolvant de vêtements AI

AI Hentai Generator
Générez AI Hentai gratuitement.

Article chaud

Outils chauds

Bloc-notes++7.3.1
Éditeur de code facile à utiliser et gratuit

SublimeText3 version chinoise
Version chinoise, très simple à utiliser

Envoyer Studio 13.0.1
Puissant environnement de développement intégré PHP

Dreamweaver CS6
Outils de développement Web visuel

SublimeText3 version Mac
Logiciel d'édition de code au niveau de Dieu (SublimeText3)

Sujets chauds



Laravel simplifie la gestion des données de session temporaires à l'aide de ses méthodes de flash intuitives. Ceci est parfait pour afficher de brefs messages, alertes ou notifications dans votre application. Les données ne persistent que pour la demande ultérieure par défaut: $ demande-

L'extension PHP Client URL (CURL) est un outil puissant pour les développeurs, permettant une interaction transparente avec des serveurs distants et des API REST. En tirant parti de Libcurl, une bibliothèque de transfert de fichiers multi-protocol très respectée, PHP Curl facilite Efficient Execu

La journalisation PHP est essentielle pour surveiller et déboguer les applications Web, ainsi que pour capturer des événements critiques, des erreurs et un comportement d&#39;exécution. Il fournit des informations précieuses sur les performances du système, aide à identifier les problèmes et prend en charge le dépannage plus rapide

Laravel fournit une syntaxe de simulation de réponse HTTP concise, simplifiant les tests d'interaction HTTP. Cette approche réduit considérablement la redondance du code tout en rendant votre simulation de test plus intuitive. L'implémentation de base fournit une variété de raccourcis de type de réponse: Utiliser illuminate \ support \ faades \ http; Http :: faux ([[ 'google.com' => 'Hello World', 'github.com' => ['foo' => 'bar'], 'forge.laravel.com' =>

Voulez-vous fournir des solutions instantanées en temps réel aux problèmes les plus pressants de vos clients? Le chat en direct vous permet d'avoir des conversations en temps réel avec les clients et de résoudre leurs problèmes instantanément. Il vous permet de fournir un service plus rapide à votre personnalité

L'article traite de la liaison statique tardive (LSB) dans PHP, introduite dans PHP 5.3, permettant une résolution d'exécution de la méthode statique nécessite un héritage plus flexible. Problème main: LSB vs polymorphisme traditionnel; Applications pratiques de LSB et perfo potentiel

L'article examine l'ajout de fonctionnalités personnalisées aux cadres, en se concentrant sur la compréhension de l'architecture, l'identification des points d'extension et les meilleures pratiques pour l'intégration et le débogage.

Alipay Php ...
