Adult Script Pro Community Forums

Create, help and share your ideas with the community!

You are not logged in.

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Video search engine not working correctly?

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...

Offline

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

Aedges
Member
Registered: 2018-03-18
Posts: 14
Website

Re: Video search engine not working correctly?

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)

Offline

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Re: Video search engine not working correctly?

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

Offline

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

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

Re: Video search engine not working correctly?

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?)?


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

Offline

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Re: Video search engine not working correctly?

Yes that embed video and title were entered manually.

Offline

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

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

Re: Video search engine not working correctly?

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


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

Offline

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Re: Video search engine not working correctly?

Email sent . Thank!

Offline

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

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

Re: Video search engine not working correctly?

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


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

Offline

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

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

Re: Video search engine not working correctly?

a solution would be to use sphinx search


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

Offline

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

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

Re: Video search engine not working correctly?

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


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

Offline

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

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

Re: Video search engine not working correctly?

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


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

Offline

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Re: Video search engine not working correctly?

Did you found a way to resolve this? Thank smile

Offline

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

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

Re: Video search engine not working correctly?

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


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

Offline

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Re: Video search engine not working correctly?

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)

Offline

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

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

Re: Video search engine not working correctly?

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


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

Offline

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Re: Video search engine not working correctly?

Yes im restarting the server once a week...

Offline

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

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

Re: Video search engine not working correctly?

run a service searchd start as root from ssh


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

Offline

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Re: Video search engine not working correctly?

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

Offline

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

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

Re: Video search engine not working correctly?

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


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

Offline

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Re: Video search engine not working correctly?

Ok,thank symtab smile

Offline

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Re: Video search engine not working correctly?

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

Offline

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

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

Re: Video search engine not working correctly?

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.


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

Offline

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Re: Video search engine not working correctly?

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 ! :-)

Offline

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Re: Video search engine not working correctly?

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 :-)

Offline

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

QuebecCoquin
Member
Registered: 2016-12-21
Posts: 180

Re: Video search engine not working correctly?

Really need this to be solved please hmm

Offline

Board footer

Powered by FluxBB