Adult Script Pro Community Forums

fitboy

Member

Registered: 2013-01-14

Posts: 123

sphinx search re-index

Hi,
I have installed and enabled sphinx search on my site. However, search results only include videos that were uploaded after setting up sphinx. I have migrated from another script and so 99% of all videos don't come up in the search results.
Is there a way I can make sphinx re-index all videos?
Or if this doesn't work, could you please post the current sphinx settings for 2.0.12 please?

symtab

Administrator

Registered: 2010-08-23

Posts: 7,501

Website

Re: sphinx search re-index

Did you run the indexer command? All videos should be indexed. The sphinx config is the same as for any script version.

---

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds

fitboy

Member

Registered: 2013-01-14

Posts: 123

Re: sphinx search re-index

Hi,
yes, the indexer is on a cronjob and runs every day at 00:00 server time.
We are thinking it may be a problem on the search query, or maybe the conf is not ok.

again, all videos that were added after sphinx installation are included, but no video from the time before.

Could you give me a working conf with latest sphinx? We'll try again

Thanks!

symtab

Administrator

Registered: 2010-08-23

Posts: 7,501

Website

Re: sphinx search re-index

source videos
{
    type        = mysql
    sql_host    = localhost
    sql_user    = asp
    sql_pass    = asp
    sql_db      = asp_b4
    sql_sock    = /var/run/mysqld/mysqld.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 video, \
         GROUP_CONCAT(DISTINCT t.name SEPARATOR ' ') AS tags \
    FROM video AS v \
    LEFT JOIN video_tags AS t ON (t.video_id = v.video_id) \
    WHERE v.status = 1 \
    GROUP BY v.video_id

    sql_attr_uint       = video
    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 categories FROM query; SELECT video_id, cat_id FROM video_category
    sql_query_info      = SELECT video_id, add_date FROM video WHERE video_id=$id
}

index videos
{
    source          = videos
    path            = /var/lib/sphinxsearch/data/videos
    charset_type    = utf-8
    min_prefix_len  = 3
    enable_star     = 1
}

Some data might be different, like database credentials or socket/index path.

---

Adult Scripts: Adult Script Pro - Adult Search Script
Adult Advertising/Traffic: Plug Rush - EXOClick - PopAds