Adult Script Pro Community Forums

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.

#76 2013-02-13 14:25:43

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: [HOWTO] Install Sphinx for Adult Script Pro

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 hmm

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

#77 2013-02-13 20:23:55

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

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

#78 2013-02-13 20:48:25

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: [HOWTO] Install Sphinx for Adult Script Pro

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

#79 2013-02-14 07:51:30

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

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

#80 2013-03-07 19:14:37

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: [HOWTO] Install Sphinx for Adult Script Pro

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

#81 2013-03-08 11:50:02

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

Are you using special characters? (utf8 for titles?)


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

Offline

#82 2013-03-08 13:02:45

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: [HOWTO] Install Sphinx for Adult Script Pro

symtab wrote:

Are you using special characters? (utf8 for titles?)


i dont know...i just uploading via ftp !! that all hmm

Offline

#83 2013-03-10 08:22:42

discuss4u
Member
Registered: 2013-03-06
Posts: 163

Re: [HOWTO] Install Sphinx for Adult Script Pro

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

#84 2013-03-11 15:48:45

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

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

#85 2013-03-11 16:48:10

discuss4u
Member
Registered: 2013-03-06
Posts: 163

Re: [HOWTO] Install Sphinx for Adult Script Pro

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

#86 2013-07-10 15:23:08

thiva7
Member
Registered: 2011-04-30
Posts: 1,022

Re: [HOWTO] Install Sphinx for Adult Script Pro

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

#87 2015-08-04 13:44:20

symtab
Administrator
Registered: 2010-08-23
Posts: 7,501
Website

Re: [HOWTO] Install Sphinx for Adult Script Pro

Fixed AND/WHERE bug in sphinx.conf


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

Offline

Board footer

Powered by FluxBB