The forum is here for legacy reasons. No new posts will be created. User registration is disabled! If you have any questions, please email us or check https://www.adultscriptpro.com for more details!
You are not logged in.
i just fix that problem:
i get this :
root@server1 [~]# indexer --all --config /etc/sphinx/sphinx.conf
Sphinx 2.0.6-id64-release (r3473)
Copyright (c) 2001-2012, Andrew Aksyonoff
Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)
using config file '/etc/sphinx/sphinx.conf'...
indexing index 'celebvideos'...
collected 1222 docs, 0.3 MB
collected 1232 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.2 Mhits, 100.0% done
total 1222 docs, 338909 bytes
total 0.210 sec, 1608101 bytes/sec, 5798.31 docs/sec
total 3680 reads, 0.009 sec, 0.3 kb/call avg, 0.0 msec/call avg
total 12 writes, 0.005 sec, 210.4 kb/call avg, 0.4 msec/call avg
root@server1 [~]#
root@server1 [~]# !/bin/bash
/bin/bash
root@server1 [~]# /usr/bin/indexer --all --rotate --config /etc/sphinx/sphinx.conf
Sphinx 2.0.6-id64-release (r3473)
Copyright (c) 2001-2012, Andrew Aksyonoff
Copyright (c) 2008-2012, Sphinx Technologies Inc (http://sphinxsearch.com)
using config file '/etc/sphinx/sphinx.conf'...
indexing index 'celebvideos'...
collected 1222 docs, 0.3 MB
collected 1232 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.2 Mhits, 100.0% done
total 1222 docs, 338909 bytes
total 0.233 sec, 1451567 bytes/sec, 5233.89 docs/sec
total 3680 reads, 0.012 sec, 0.3 kb/call avg, 0.0 msec/call avg
total 12 writes, 0.006 sec, 210.4 kb/call avg, 0.5 msec/call avg
rotating indices: successfully sent SIGHUP to searchd (pid=25728).
i change complex from admin panel and search and related NOT work
this is my config file:
source celebvideos
{
type = mysql
sql_host = localhost
sql_user = user
sql_pass = pass
sql_db = database
sql_sock = /var/lib/mysql/mysql.sock
sql_port = 3306
sql_query_pre = SET NAMES utf8
sql_query = \
SELECT v.video_id, v.title, v.description, v.mobile, v.add_time, \
v.rating, v.total_views, v.duration, v.video_id AS celebvideo, \
GROUP_CONCAT(DISTINCT t.name SEPARATOR ' ') AS celebtags \
FROM celebvideo AS v \
LEFT JOIN celebvideo_tags AS t ON (t.video_id = v.video_id) \
AND v.status = 1 \
GROUP BY v.video_id
sql_attr_uint = celebvideo
sql_attr_uint = mobile
sql_attr_uint = total_views
sql_attr_float = duration
sql_attr_float = rating
sql_attr_timestamp = add_time
sql_attr_multi = uint celebcategories FROM query; SELECT video_id, cat_id FROM celebvideo_category
sql_query_info = SELECT video_id, add_date FROM celebvideo WHERE video_id=$id
}
index celebvideos
{
source = celebvideos
path = /var/lib/sphinx/data/videos
charset_type = utf-8
min_prefix_len = 3
enable_star = 1
}
searchd
{
port = 3312
log = /var/log/sphinx/searchd.log
query_log = /var/log/sphinx/query.log
pid_file = /var/log/sphinx/searchd.pid
}
Last edited by thiva7 (2013-02-13 15:03:11)
Offline
You cant change the index and source name. It needs to be videos.
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
ok i change it search is work....related NO!! why?? what is wrong?
source videos
{
type = mysql
sql_host = localhost
sql_user = user
sql_pass = pas
sql_db = db
sql_sock = /var/lib/mysql/mysql.sock
sql_port = 3306
sql_query_pre = SET NAMES utf8
sql_query = \
SELECT v.video_id, v.title, v.description, v.mobile, v.add_time, \
v.rating, v.total_views, v.duration, v.video_id AS celebvideo, \
GROUP_CONCAT(DISTINCT t.name SEPARATOR ' ') AS celebtags \
FROM celebvideo AS v \
LEFT JOIN celebvideo_tags AS t ON (t.video_id = v.video_id) \
AND v.status = 1 \
GROUP BY v.video_id
sql_attr_uint = celebvideo
sql_attr_uint = mobile
sql_attr_uint = total_views
sql_attr_float = duration
sql_attr_float = rating
sql_attr_timestamp = add_time
sql_attr_multi = uint celebcategories FROM query; SELECT video_id, cat_id FROM celebvideo_category
sql_query_info = SELECT video_id, add_date FROM celebvideo WHERE video_id=$id
}
index videos
{
source = videos
path = /var/lib/sphinx/data/videos
charset_type = utf-8
min_prefix_len = 3
enable_star = 1
}
searchd
{
port = 3312
log = /var/log/sphinx/searchd.log
query_log = /var/log/sphinx/query.log
pid_file = /var/log/sphinx/searchd.pid
}
Offline
This: v.rating, v.total_views, v.duration, v.video_id AS celebvideo you've changed this....
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
hi adrian
i get this result :
root@server1 [~]# indexer --all --config /etc/sphinx/sphinx.conf
Sphinx 0.9.9-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff
using config file '/etc/sphinx/sphinx.conf'...
indexing index 'videos'...
collected 1755 docs, 0.4 MB
collected 1780 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.3 Mhits, 100.0% done
total 1755 docs, 374793 bytes
total 0.239 sec, 1564335 bytes/sec, 7325.13 docs/sec
total 3 reads, 0.002 sec, 444.6 kb/call avg, 0.9 msec/call avg
total 10 writes, 0.004 sec, 328.9 kb/call avg, 0.4 msec/call avg
root@server1 [~]# !/bin/bash
/bin/bash
root@server1 [~]# /usr/bin/indexer --all --rotate --config /etc/sphinx/sphinx.conf
Sphinx 0.9.9-release (r2117)
Copyright (c) 2001-2009, Andrew Aksyonoff
using config file '/etc/sphinx/sphinx.conf'...
indexing index 'videos'...
collected 1755 docs, 0.4 MB
collected 1780 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.3 Mhits, 100.0% done
total 1755 docs, 374793 bytes
total 0.232 sec, 1611569 bytes/sec, 7546.30 docs/sec
total 3 reads, 0.001 sec, 444.6 kb/call avg, 0.6 msec/call avg
total 10 writes, 0.008 sec, 328.9 kb/call avg, 0.8 msec/call avg
rotating indices: succesfully sent SIGHUP to searchd (pid=24075).
but in search result when i use complex with "allysa milano " i get 2 video result with simple i get all.
what can be wrong|?
Offline
Are you using special characters? (utf8 for titles?)
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Are you using special characters? (utf8 for titles?)
i dont know...i just uploading via ftp !! that all
Offline
I have installed sphinx successfully (I think)
But it can only search English keywords. When I type Chinese in the search box and search, it gives zero results.
Offline
It does not work with chinese keywords. You can add UTF8, but it still wont work correctly (or at least i was not able to make it work correctly yet). You can read this article: http://www.ivinco.com/blog/using-sphinx … documents/
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline
Thanks symtab, I will take some time to read it. But do you mean that I should use simple search? It seems that it does not work correctly either.
Offline
Adrian i have installed but is not get results for new videos ..
i mean if yesterday i had upload video and i run in ssh this comand : /usr/bin/indexer --all --rotate --config /etc/sphinx/sphinx.conf
will show this video....but if i upload new video today and NOT run this command will not get result with the new video.
How i can make it to automaticaly get every new video?
Thank you
Offline
Fixed AND/WHERE bug in sphinx.conf
Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds
Offline