Problem with Sphinx

ivatigoal · 2013-11-11 08:31:31

So any ideas why i dont get any results with search? But i do get results with related videos

ivatigoal · 2013-11-11 08:36:26

Also when i try to run the indexer command i get an error

FATAL: failed to lock /var/lib/sphinx/videos.spl: Resource temporarily anavailable, will not index. Try --rotate option

symtab · 2013-11-11 09:08:42

Run:

indexer --all --rotate --config /etc/sphinx/sphinx.conf

Send me ssh root access and i will check why no results.

ivatigoal · 2013-11-11 10:03:02

So should i always run this command instead of the other one?

I did sent you the ssh details

Last edited by ivatigoal (2013-11-11 10:08:31)

ivatigoal · 2013-11-12 11:00:32

Did you have the time to look?

symtab · 2013-11-13 13:30:20

Really sorry, no time yet. Will check ASAP.

ivatigoal · 2013-11-19 18:40:09

Any change to check this ?

symtab · 2013-11-19 20:12:28

Will check tomorrow. Sorry for my delay.

ivatigoal · 2013-11-23 11:48:18

still waiting

ivatigoal · 2013-11-30 09:13:12

Symtab really now can you check this please?

ivatigoal · 2013-11-30 09:41:06

I also get this if i enable sphinx for the related premium videos

Query: SELECT 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 aspvideo AS v LEFT JOIN aspuser AS u on (u.user_id = v.user_id) WHERE v.video_id IN (156,1100,1607,230,476,614) ORDER BY FIELD (v.video_id, 156,1100,1607,230,476,614)
Error Message: FUNCTION analtube_asp.FIELD does not exist
Error Number: 1305

ivatigoal · 2013-12-02 18:36:44

please advise me what to do those are my last problems search and premium related videos when sphinx is enabled.

symtab · 2013-12-03 12:10:39

edit modules/premium/components/view.php and remove the space after FIELD (its should be FIELD( not FIELD ().

ivatigoal · 2013-12-03 13:28:02

Thanks now the inly problem remains is the zero results from search when sphinx is enabled

symtab · 2013-12-03 14:42:24

Did we setup sphinx for you?

ivatigoal · 2013-12-03 15:44:40

Part of the setup yes

symtab · 2013-12-03 16:05:21

Yes, but did i install and configure sphinx for you after you ordered Sphinx Setup? :-)

ivatigoal · 2013-12-03 16:23:35

No i did the installation of sphinx and i had some problems which you did corrected. So sphinx s working fine for the related videos but at search it just returns no results

symtab · 2013-12-03 16:54:31

Oki. Please email me ssh root access and i will check as soon as possible.

ivatigoal · 2013-12-03 17:54:09

you do have my details if you check my last pm to you

symtab · 2013-12-04 12:59:55

I do not save your credentials, so you will have to send them again.

Adult Script Pro Community Forums

#26 2013-11-11 08:31:31

Re: Problem with Sphinx

#27 2013-11-11 08:36:26

Re: Problem with Sphinx

#28 2013-11-11 09:08:42

Re: Problem with Sphinx

#29 2013-11-11 10:03:02

Re: Problem with Sphinx

#30 2013-11-12 11:00:32

Re: Problem with Sphinx

#31 2013-11-13 13:30:20

Re: Problem with Sphinx

#32 2013-11-19 18:40:09

Re: Problem with Sphinx

#33 2013-11-19 20:12:28

Re: Problem with Sphinx

#34 2013-11-23 11:48:18

Re: Problem with Sphinx

#35 2013-11-30 09:13:12

Re: Problem with Sphinx

#36 2013-11-30 09:41:06

Re: Problem with Sphinx

#37 2013-12-02 18:36:44

Re: Problem with Sphinx

#38 2013-12-03 12:10:39

Re: Problem with Sphinx

#39 2013-12-03 13:28:02

Re: Problem with Sphinx

#40 2013-12-03 14:42:24

Re: Problem with Sphinx

#41 2013-12-03 15:44:40

Re: Problem with Sphinx

#42 2013-12-03 16:05:21

Re: Problem with Sphinx

#43 2013-12-03 16:23:35

Re: Problem with Sphinx

#44 2013-12-03 16:54:31

Re: Problem with Sphinx

#45 2013-12-03 17:54:09

Re: Problem with Sphinx

#46 2013-12-04 12:59:55

Re: Problem with Sphinx

Board footer