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 2012-10-06 23:21:06

mmpo
Member
Registered: 2012-01-23
Posts: 240
Website

[PARTIAL FIX] Related video repeat

How i can fix Related video repeat? Check this example http://www.ismytube.com/106343/naughty- … d-screwed/

Offline

#2 2012-10-06 23:48:01

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

Re: [PARTIAL FIX] Related video repeat

Hmmm...this bug is anoying. I cannot reproduce it on my box. Its a easy fix, but i need to figure out why this is happening, because it shouldnt.


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

Offline

#3 2012-10-07 04:50:08

mmpo
Member
Registered: 2012-01-23
Posts: 240
Website

Re: [PARTIAL FIX] Related video repeat

captura
Its the problem how i can solved?

Offline

#4 2012-10-07 09:52:01

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

Re: [PARTIAL FIX] Related video repeat

Edit modules/video/components/video_view.php replace following lines:

'sql'   => "SELECT v.video_id, v.title, v.slug, v.rating, v.rated_by, v.duration, v.thumb,

with:

'sql'   => "SELECT DISTINCT v.video_id, v.title, v.slug, v.rating, v.rated_by, v.duration, v.thumb,

same replacement for templates/your-template/extend/ajax/related.plugin.php


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

Offline

#5 2012-10-07 09:52:19

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

Re: [PARTIAL FIX] Related video repeat

Are you using related with category? Or without?


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

Offline

#6 2012-10-07 12:17:03

MS_DA
Member
Registered: 2011-04-26
Posts: 401
Website

Re: [PARTIAL FIX] Related video repeat

I have the same on our tube.

Offline

#7 2012-10-07 16:33:49

mmpo
Member
Registered: 2012-01-23
Posts: 240
Website

Re: [PARTIAL FIX] Related video repeat

Thank you is ok now

Offline

#8 2012-10-08 06:32:50

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

Re: [PARTIAL FIX] Related video repeat

Are you using Related with Category in Admin -> Video -> Config -> View?


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

Offline

#9 2012-10-27 09:16:28

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

Re: [PARTIAL FIX] Related video repeat

So problem here is that if you use Related Category it will create duplicates. The fix is easy, however it will create slow queries, so until a proper fix is found, please disable the Related Category option in Admin -> Video -> Config -> View.


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

Offline

#10 2012-10-28 11:58:20

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

Re: [PARTIAL FIX] Related video repeat

There is no viable fix for this. Whatever we do we have to use DISTINCT (because videos can be in more than one category). DISTINCT needs a temporary table which is slow. If you have a lot of traffic and videos, please either stop using Related Category or use Sphinx!


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

Offline

Board footer

Powered by FluxBB