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.

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

Coscast
Member
From: Germany
Registered: 2010-10-03
Posts: 546

[FIXED] Related Videos with Sphinx not showing

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


sgt-halfsize-banner.jpg

Offline

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

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

Re: [FIXED] Related Videos with Sphinx not showing

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

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

Offline

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

Coscast
Member
From: Germany
Registered: 2010-10-03
Posts: 546

Re: [FIXED] Related Videos with Sphinx not showing

hmm i don't have the "site" column in my database as you stated in the query above sad
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

sgt-halfsize-banner.jpg

Offline

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

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

Re: [FIXED] Related Videos with Sphinx not showing

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


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

Offline

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

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

Re: [FIXED] Related Videos with Sphinx not showing

Fixed on your site (also fixed in RC4).


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

Offline

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

ptsguy
Member
Registered: 2012-08-06
Posts: 135

Re: [FIXED] Related Videos with Sphinx not showing

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

Offline

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

ptsguy
Member
Registered: 2012-08-06
Posts: 135

Re: [FIXED] Related Videos with Sphinx not showing

Coscast wrote:

hmm i don't have the "site" column in my database as you stated in the query above sad
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

Offline

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

ptsguy
Member
Registered: 2012-08-06
Posts: 135

Re: [FIXED] Related Videos with Sphinx not showing

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

Offline

Board footer

Powered by FluxBB