[FIXED] search feature

mfeat50 · 2010-12-13 21:26:24

It seems that the search featrue is not working properly. If you try to search for somethnig like brunette this is what you get back ** No videos found while searching for ''! **

symtab · 2010-12-14 09:07:38

Fixed. You just need to set search_type to simple in admin (complex will be for sphinx).

mfeat50 · 2010-12-14 12:33:30

symtab wrote:

Fixed. You just need to set search_type to simple in admin (complex will be for sphinx).

I changed the search_type to simple in the admin and I am still getting the same thing ** No videos found while searching for ''! **

symtab · 2010-12-14 12:56:39

Hmm...worked for me. Here's another way to fix, edit modules/video/components/search.php and replace:

                $sql_count      = "SELECT COUNT(DISTINCT v.video_id) AS total_videos
                                   FROM #__video_tags AS t, #__video AS v
                                   WHERE t.name IN (".implode(',', $sql_add).")
                                   OR v.title LIKE '".$this->db->escape($query)."'";
                $sql            = "SELECT DISTINCT v.video_id, v.title, v.slug, v.rating, v.rated_by, v.duration, v.thumb,
                                          v.thumbs, v.total_views, v.add_time, v.ext, v.premium, u.username
                                   FROM #__video_tags AS t, #__video AS v
                                   WHERE t.name IN (".implode(',', $sql_add).")
                                   OR v.title LIKE '".$this->db->escape($query)."'";

with:

                $sql_count      = "SELECT COUNT(*) AS total_videos
                                   FROM #__video_tags AS t
                                   LEFT JOIN #__video AS v ON (v.video_id = t.video_id AND v.status = 1)
                                   WHERE t.name IN (".implode(',', $sql_add).")";
                $sql            = "SELECT DISTINCT v.video_id, v.title, v.slug, v.rating, v.rated_by, v.duration, v.thumb,
                                          v.thumbs, v.total_views, v.add_time, v.ext, v.premium, u.username
                                   FROM #__video_tags AS t
                                   LEFT JOIN #__video AS v ON (v.video_id = t.video_id AND v.status = 1)
                                   LEFT JOIN #__user AS u ON (u.user_id = v.user_id)
                                   WHERE t.name IN (".implode(',', $sql_add).")
                                   ORDER BY v.video_id DESC";

Coscast · 2010-12-14 18:51:28

mfeat50 wrote:

symtab wrote:
Fixed. You just need to set search_type to simple in admin (complex will be for sphinx).
I changed the search_type to simple in the admin and I am still getting the same thing ** No videos found while searching for ''! **

Tested at your Site. Works for me with brunette.

mfeat50 · 2010-12-14 23:47:48

Coscast wrote:

mfeat50 wrote:
symtab wrote:
Fixed. You just need to set search_type to simple in admin (complex will be for sphinx).
I changed the search_type to simple in the admin and I am still getting the same thing ** No videos found while searching for ''! **

Tested at your Site. Works for me with brunette.

lol I must not have been fully awake as I did not refresh my screen.... It was a DOH moment..... It worked just fine by changing the search_type.

symtab · 2010-12-15 05:17:55

Initially the search_type simple was for title based search (which is slow, and mysql cannot use a key for this kind of search and even with a key it works with word*ANYTHINGHERE, not *word*) and complex was for mysql MATCH_AGAINST which is a pretty good method for searching, however after you have 10.000 its slow.

Right now search_type simple searches by tags, which is like very very fast (i cant give a aproximate number here) and complex will be for sphinx based search once done (which will also work instantly, even for 500.000 videos).

Adult Script Pro Community Forums

#1 2010-12-13 21:26:24

[FIXED] search feature

#2 2010-12-14 09:07:38

Re: [FIXED] search feature

#3 2010-12-14 12:33:30

Re: [FIXED] search feature

#4 2010-12-14 12:56:39

Re: [FIXED] search feature

#5 2010-12-14 18:51:28

Re: [FIXED] search feature

#6 2010-12-14 23:47:48

Re: [FIXED] search feature

#7 2010-12-15 05:17:55

Re: [FIXED] search feature

Board footer