Adult Script Pro Community Forums

All is good (if sleeping 5 hours / day works ! Version 3 is done! I just need a new presentation site now )

For some reason on your server the sphinx search mode MATCH_EXTENDED2 does not return any results, not even MATCH_ANY does not return any results, only MATCH ANY with *keyword* returns results. This is not required on other servers (even though you are running similar software versions). Email me about the bugs and i'll see what i can do.

Hmm...sorry i forgot about this...will check asap. Works correctly for other installs, so i have to debug!

If the videos remain in queued waiting it means that the cron script is not running or it returns a error. Since it worked on the other server it means that the cron script is not running. If no thumbs are being generated please make sure image magick convert is installed.

This means it worked. Do you have a separate conversion server or?

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.

no, i dont know what the problem is, if you move to another server have the hosting company check whats different

run a service searchd start as root from ssh

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

Still the same...i get 800% more traffic...so i guess google loves my site which btw has nothing special, adult script pro (default template, default everything) + uploaded videos (i edit the titles).

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

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