[FIXED] Related Videos with Sphinx not showing

Coscast · 2011-08-31 18:30:20

Hi,

I just mentioned that the latest Version does not show related videos with sphinx enabled.
Tested with the "old" version of modules/video/components/view.php and it works again.

Not working: http://pastebin.com/iUVz51Cv

Working: http://pastebin.com/EWeutjHd

symtab · 2011-09-01 08:18:46

Yes. There is a error in the code, you need to edit modules/video/components/view.php and templates/your-template/extend/plugins/ajax/related.plugin.php and replace:

$sphinx->SetFilter('video', array($video_id), true);

with:

$sphinx->SetFilter('vid', array($video_id), true);

Also edit sphinx.conf and make sure your final source for the videos looks like:

    sql_query_pre   = SET NAMES utf8
    sql_query       = \
    SELECT v.video_id, v.title, v.description, v.add_time, \
         v.total_views, v.duration, v.site, v.video_id AS vid, \
         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) \
    AND v.status = 1 \
    GROUP BY v.video_id
    
    sql_attr_uint        = vid
    sql_attr_uint       = total_views
    sql_attr_uint       = duration
    sql_attr_uint       = site
    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

Coscast · 2011-09-01 17:30:26

hmm i don't have the "site" column in my database as you stated in the query above
I removed that from my query, but i get an empty search term in my sphinx query.log

working:

[Thu Sep  1 11:14:10.810 2011] 0.005 sec [any/0/rel 697 (0,10)] [videos] big tits brunette dildo lesbian uniform school girl teachers

with the changes above:

[Thu Sep  1 19:23:59.256 2011] 0.000 sec [any/1/rel 0 (0,10)] [videos] ""/1

symtab · 2011-09-01 18:00:52

Hmm....please email me ssh root access.

symtab · 2011-09-02 12:07:05

Fixed on your site (also fixed in RC4).

ptsguy · 2012-09-12 02:27:59

not fixed in 1.0 or 1.0.1... I just edited lines 299 and 354

ptsguy · 2012-09-12 02:30:35

Coscast wrote:

hmm i don't have the "site" column in my database as you stated in the query above
I removed that from my query, but i get an empty search term in my sphinx query.log
working:
[Thu Sep  1 11:14:10.810 2011] 0.005 sec [any/0/rel 697 (0,10)] [videos] big tits brunette dildo lesbian uniform school girl teachers
with the changes above:
[Thu Sep  1 19:23:59.256 2011] 0.000 sec [any/1/rel 0 (0,10)] [videos] ""/1

site might be mean size... dunno though

ptsguy · 2012-09-12 02:33:01

I can not for the life of me get related videos to work... I've read several posts and nothing.. Sphinx on regular search works perfectly... can someone post to me just the sql_query pre to sql_query_info that they have and is working

Adult Script Pro Community Forums

#1 2011-08-31 18:30:20

[FIXED] Related Videos with Sphinx not showing

#2 2011-09-01 08:18:46

Re: [FIXED] Related Videos with Sphinx not showing

#3 2011-09-01 17:30:26

Re: [FIXED] Related Videos with Sphinx not showing

#4 2011-09-01 18:00:52

Re: [FIXED] Related Videos with Sphinx not showing

#5 2011-09-02 12:07:05

Re: [FIXED] Related Videos with Sphinx not showing

#6 2012-09-12 02:27:59

Re: [FIXED] Related Videos with Sphinx not showing

#7 2012-09-12 02:30:35

Re: [FIXED] Related Videos with Sphinx not showing

#8 2012-09-12 02:33:01

Re: [FIXED] Related Videos with Sphinx not showing

Board footer