[PARTIAL FIX] Related video repeat

mmpo · 2012-10-06 23:21:06

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

symtab · 2012-10-06 23:48:01

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.

mmpo · 2012-10-07 04:50:08

captura
Its the problem how i can solved?

symtab · 2012-10-07 09:52:01

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

symtab · 2012-10-07 09:52:19

Are you using related with category? Or without?

MS_DA · 2012-10-07 12:17:03

I have the same on our tube.

mmpo · 2012-10-07 16:33:49

Thank you is ok now

symtab · 2012-10-08 06:32:50

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

symtab · 2012-10-27 09:16:28

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.

symtab · 2012-10-28 11:58:20

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 Script Pro Community Forums

#1 2012-10-06 23:21:06

[PARTIAL FIX] Related video repeat

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

Re: [PARTIAL FIX] Related video repeat

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

Re: [PARTIAL FIX] Related video repeat

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

Re: [PARTIAL FIX] Related video repeat

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

Re: [PARTIAL FIX] Related video repeat

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

Re: [PARTIAL FIX] Related video repeat

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

Re: [PARTIAL FIX] Related video repeat

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

Re: [PARTIAL FIX] Related video repeat

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

Re: [PARTIAL FIX] Related video repeat

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

Re: [PARTIAL FIX] Related video repeat

Board footer