[FIXED] Related Videos with Sphinx are the same for all videos

Eri · 2011-09-01 18:43:26

Related Videos with Sphinx are the same for all videos, maybe there is a cache problem ( it shows only the oldes videos. from id 1 to 10

Last edited by Eri (2011-09-01 19:22:09)

Eri · 2011-09-01 19:41:22

fixed, after

 private function get_related_videos($video_id, $title, $tags, $categories)
    {
      $cache_id    = 'video_related_'.$video_id;
          if (!$related = $this->cache->get($cache_id, 3600) OR
              !$related_total = $this->cache->get($cache_id.'_total', 3600)) {

added

$sql_tag    = array();
              $tags        = explode(',', $tags);
              foreach ($tags as $tag) {
                    $sql_tag[] = "'".$this->db->escape($tag)."'";
              }

symtab · 2011-09-02 07:50:19

Ok. I'm gonna review this right now and launch RC4 with all the fixes.

symtab · 2011-09-02 11:57:30

Fixed in RC4 (i had to make some more modifications though, so some small edits to sphinx.conf will be needed).

Adult Script Pro Community Forums

#1 2011-09-01 18:43:26

[FIXED] Related Videos with Sphinx are the same for all videos

#2 2011-09-01 19:41:22

Re: [FIXED] Related Videos with Sphinx are the same for all videos

#3 2011-09-02 07:50:19

Re: [FIXED] Related Videos with Sphinx are the same for all videos

#4 2011-09-02 11:57:30

Re: [FIXED] Related Videos with Sphinx are the same for all videos

Board footer