...arch是否支持时下很火的lbs搜索呢？ sphinx配置： [code] sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `fandian` sql_query = SELECT `id`,`type`, `name`, RADIANS(`lat`) AS `latitude`, RADIANS(`lon`) AS `longitude` FROM `fandian` WHERE (`id` >= $start AND ...
...，我是有指定项目名称的，因为导入数据的命令里有我的sql密码等很多信息，所以换个简单的命令来论坛里问下。 [code][root@a107 ~]# /usr/local/php/bin/php /usr/local/xunsearch/sdk/php/util/Indexer.php --project=xxx –-source=mysql://xxx:xxx@localhost/xxx -...
mysql导入数据配置文件里的字段要和数据库里的一样吗？ #1 {main}警告：添加第 35000 条数据失败 - Missing value of primarky key (FIELD:pid) #0 /usr/local/xunsearch/sdk/php/util/Indexer.php(195): XSIndex->update(Object(XSDocument)) sql语句： sql="select c.content...
... [content] type = body #导入 php util/Indexer.php --rebuild --source=mysql://数据库用户名:数据库密码@数据库地址/数据库名 --sql="select t.tid as tid, t.fid as fid, t.author as author, t.authorid as authorid, t.postdate as postdate, t.subject as subject, tm.content as content f...
...来创建索引 /usr/local/xunsearch/sdk/php/util/Indexer.php --source=mysql://xxx --sql="SELECT p.ID,UNIX_TIMESTAMP(p.post_date) AS post_date_sec,DATE_FORMAT(post_date,'%Y%m%d') AS post_time,p.post_title,p.post_content,p.post_content AS post_content_full,u.user_login AS author,t.name AS category,t...