Video search engine not working correctly?

QuebecCoquin · 2018-04-29 21:05:42

Is it possible that the video engine not working correctly? Exemplle: Im searching for a specific title : http://quebeccoquin.ca/search/video/?s=amy and it give me 0 result... but i have amy in title of videos like this one : http://quebeccoquin.ca/video/13851/peti … with-anal/

Sometime search engine seem to work on other search but a lot dont...

Aedges · 2018-04-30 08:14:10

To me it looks like it is searching the tags and not the actual title.

Also the video above does not seem to have been published yet so maybe its waiting approval or the cache has not updated yet

Last edited by Aedges (2018-04-30 08:21:11)

QuebecCoquin · 2018-04-30 09:36:27

The videos have the published status and the cache is not activated...

symtab · 2018-05-02 08:20:18

Hmm...i first thought the title does not contain the word amy...then i saw slug != title...are you using sphinx or mysql full text? Was the video edited after the initial upload (the title was changed?)?

QuebecCoquin · 2018-05-02 17:56:19

Yes that embed video and title were entered manually.

symtab · 2018-05-04 07:52:14

Hmm...email me ssh root access, it seems you are using MySQL Fulltext. It should work.

QuebecCoquin · 2018-05-04 09:01:08

Email sent . Thank!

symtab · 2018-05-04 15:29:32

Pff this is a big bug. I didnt update the fulltext part of the videos correctly. I fixed this on your site, however for some reason the fulltext search does not work as expected on your mysql.

MariaDB [quebecco_asp3]> select video_id, title from video_fulltext where title like 'Amy%';
+----------+----------------------------------------------+
| video_id | title                                        |
+----------+----------------------------------------------+
|      354 | Amy Lee get an Anal Massage                  |
|     2976 | Amy Anderssen Incredibles Huge Tits          |
|     5696 | Amy Lee get Nailed in the Ass                |
|     5701 | Amy Lee Fourre avec 6 Gars                   |
|     5748 | Amy Anderssen really big knockers            |
|    13826 | Amy Sweet l'tudiante s'amuse avec son dildo |
|    13848 | Amy Sweet l'colire suce son prof           |
|    13851 | Amy Sweet et Shana Lane dans un trip  trois |
+----------+----------------------------------------------+
8 rows in set (0.00 sec)

MariaDB [quebecco_asp3]> select video_id, title from video_fulltext where match (title) against ('amy' IN BOOLEAN MODE);;
Empty set (0.00 sec)

ERROR: No query specified

MariaDB [quebecco_asp3]> select video_id, title from video_fulltext where match (title) against ('amy' IN BOOLEAN MODE);
Empty set (0.00 sec)

MariaDB [quebecco_asp3]> select video_id, title from video_fulltext where match (title) against ('Amy' IN BOOLEAN MODE);
Empty set (0.00 sec)

MariaDB [quebecco_asp3]> select video_id, title from video_fulltext where match (title) against ('Amy');
Empty set (0.00 sec)

MariaDB [quebecco_asp3]>

still debugging why

symtab · 2018-05-04 15:31:21

a solution would be to use sphinx search

symtab · 2018-05-04 15:34:41

and the weird thing is you are using almost the same version of mariadb i have on all my servers...

symtab · 2018-05-04 15:51:49

and to make it even a weirder bug, i installed sphinx search and it works, but not for amy ))

QuebecCoquin · 2018-05-05 22:29:08

Did you found a way to resolve this? Thank

symtab · 2018-05-07 08:51:20

Not yet, amy is still not available, other 3 words searches work perfectly...but not amy

QuebecCoquin · 2018-05-07 09:04:59

Ive tried with another keyword that it is in title http://quebeccoquin.ca/search/video/?s=calypso and it showing that error in header :
(string) connection to localhost:9312 failed (errno=111, msg=Connection refused)

symtab · 2018-05-10 16:56:15

Did you restart the server or did someone stop the sphinx search daemon?

QuebecCoquin · 2018-05-10 17:22:30

Yes im restarting the server once a week...

symtab · 2018-05-10 18:55:31

run a service searchd start as root from ssh

QuebecCoquin · 2018-05-10 22:33:31

i dont understan what you are saying...is it possible to have a service that restar when i reboot my server?

symtab · 2018-05-12 11:01:21

yes, but in some cases the service wont restart...for different reasons...i cant connetc to your server atm, but later today i'll fix

QuebecCoquin · 2018-05-12 11:29:31

Ok,thank symtab

QuebecCoquin · 2018-05-13 11:06:43

Do you think you have time to work on it today ?

symtab · 2018-05-14 15:02:55

Sorry for my delay, i just became a father a few days ago and i'm still getting used to the new shedule i have until my wife recovers. I will work on this asap.

QuebecCoquin · 2018-05-15 00:07:54

symtab wrote:

Sorry for my delay, i just became a father a few days ago and i'm still getting used to the new shedule i have until my wife recovers. I will work on this asap.

Congrat symtab ! :-)

QuebecCoquin · 2018-05-18 13:34:26

symtab wrote:

Sorry for my delay, i just became a father a few days ago and i'm still getting used to the new shedule i have until my wife recovers. I will work on this asap.

Did you have free time to work on this? Thank :-)

QuebecCoquin · 2018-05-25 21:11:09

Really need this to be solved please

Adult Script Pro Community Forums

#1 2018-04-29 21:05:42

Video search engine not working correctly?

#2 2018-04-30 08:14:10

Re: Video search engine not working correctly?

#3 2018-04-30 09:36:27

Re: Video search engine not working correctly?

#4 2018-05-02 08:20:18

Re: Video search engine not working correctly?

#5 2018-05-02 17:56:19

Re: Video search engine not working correctly?

#6 2018-05-04 07:52:14

Re: Video search engine not working correctly?

#7 2018-05-04 09:01:08

Re: Video search engine not working correctly?

#8 2018-05-04 15:29:32

Re: Video search engine not working correctly?

#9 2018-05-04 15:31:21

Re: Video search engine not working correctly?

#10 2018-05-04 15:34:41

Re: Video search engine not working correctly?

#11 2018-05-04 15:51:49

Re: Video search engine not working correctly?

#12 2018-05-05 22:29:08

Re: Video search engine not working correctly?

#13 2018-05-07 08:51:20

Re: Video search engine not working correctly?

#14 2018-05-07 09:04:59

Re: Video search engine not working correctly?

#15 2018-05-10 16:56:15

Re: Video search engine not working correctly?

#16 2018-05-10 17:22:30

Re: Video search engine not working correctly?

#17 2018-05-10 18:55:31

Re: Video search engine not working correctly?

#18 2018-05-10 22:33:31

Re: Video search engine not working correctly?

#19 2018-05-12 11:01:21

Re: Video search engine not working correctly?

#20 2018-05-12 11:29:31

Re: Video search engine not working correctly?

#21 2018-05-13 11:06:43

Re: Video search engine not working correctly?

#22 2018-05-14 15:02:55

Re: Video search engine not working correctly?

#23 2018-05-15 00:07:54

Re: Video search engine not working correctly?

#24 2018-05-18 13:34:26

Re: Video search engine not working correctly?

#25 2018-05-25 21:11:09

Re: Video search engine not working correctly?

Board footer