Problem with Sphinx

ivatigoal · 2013-10-25 17:25:08

I have followed your guide up to the letter bur when i run the index command i get the uknown key name 'GROUP CONCAT' error. I did made sure that i have the v.video_id AS video, line correct.

Any ideas?

symtab · 2013-10-26 08:07:05

Probably you forgot , \ after v.rating, v.total_views, v.duration, v.video_id AS video, \

ivatigoal · 2013-10-26 08:13:00

No it is there ..... I was very carefull with the code and did write everything according to your guide.

ivatigoal · 2013-10-29 16:10:38

Is there any way you can help me with this problem of mine please?

symtab · 2013-10-29 18:23:18

Ahh...you have a old version of mysql? What version of mysql do you have? GROUP_CONCAT is only supported in 5.x i think.

ivatigoal · 2013-10-29 19:07:57

5.0.96

ivatigoal · 2013-10-30 10:14:43

So do you still think it is the mysql version which is wrong?

symtab · 2013-10-30 11:30:36

In that version of MySQL GROUP_CONCAT is supported. What version of mysql is linked to the searchd and indexer binary? Please email me ssh access.

ivatigoal · 2013-10-30 11:34:03

sent you the codes for ssh access thanks

ivatigoal · 2013-10-30 21:16:16

Did you found the problem?

symtab · 2013-10-31 09:56:51

Its fixed. Is that config from our script? There were like 20 errors in the sphinx.conf file, and i've done tons of configurations, but those errors are not in our example file.

ivatigoal · 2013-10-31 10:06:05

yes it was from your instructions BUT i have to say i wrote them and not copied and paste (i didnt know how to do that in the editor using ssh) but i was really carefull not to do any mistake. I am really sorry for any loss of time it might occured to you because of me

ivatigoal · 2013-10-31 10:58:01

i now get this error if i enable sphinx

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 (656,1103,479,1107,1372,660,82,375,853,523) ORDER BY FIELD (v.video_id, 656,1103,479,1107,1372,660,82,375,853,523)
Error Message: FUNCTION analtube_asp.FIELD does not exist
Error Number: 1305

symtab · 2013-10-31 14:18:51

Edit modules/video/components/view.php and remove the space between FIELD and (. No idea why this bug, probably something to do with mysql, because for me it works without this bug on several installations.

ivatigoal · 2013-11-01 09:58:09

thank toy for that. Now the only problem that remains is that at related videos i dont have any problem. But at search i get a white page after i hit enter or search (once of course i enter the keyword)

symtab · 2013-11-01 12:30:39

Go to Admin -> Config and enable debug. Once enabled try the search again, if a error appears, please paste it here (i will be gone for the weekend, so i will only reply on Monday,sorry for my delay).

ivatigoal · 2013-11-04 07:56:47

Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 775501358 bytes) in /home/analtube/public_html/libraries/sphinxapi/sphinxapi.php on line 634

ivatigoal · 2013-11-07 18:40:50

i am still waiting for your kind reply

symtab · 2013-11-08 08:17:05

That means that you need to increase the memory_limit in php.ini

ivatigoal · 2013-11-08 08:38:00

Since I have a vps can I access thus file or should I contact my hoster to do that for me. What size should I enter there?

ivatigoal · 2013-11-08 12:00:53

now i get a message saying that no videos found with blablabla.....

symtab · 2013-11-08 19:02:20

Did the indexer run and searched started?

ivatigoal · 2013-11-08 19:09:04

Well I guess since it shows the related videos

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

Well actually does the sphinx search at ghe tags too? Otherwise there is no need for me to use it.

symtab · 2013-11-10 06:59:49

It searches through tags also, but the title is the most important.

Adult Script Pro Community Forums

#1 2013-10-25 17:25:08

Problem with Sphinx

#2 2013-10-26 08:07:05

Re: Problem with Sphinx

#3 2013-10-26 08:13:00

Re: Problem with Sphinx

#4 2013-10-29 16:10:38

Re: Problem with Sphinx

#5 2013-10-29 18:23:18

Re: Problem with Sphinx

#6 2013-10-29 19:07:57

Re: Problem with Sphinx

#7 2013-10-30 10:14:43

Re: Problem with Sphinx

#8 2013-10-30 11:30:36

Re: Problem with Sphinx

#9 2013-10-30 11:34:03

Re: Problem with Sphinx

#10 2013-10-30 21:16:16

Re: Problem with Sphinx

#11 2013-10-31 09:56:51

Re: Problem with Sphinx

#12 2013-10-31 10:06:05

Re: Problem with Sphinx

#13 2013-10-31 10:58:01

Re: Problem with Sphinx

#14 2013-10-31 14:18:51

Re: Problem with Sphinx

#15 2013-11-01 09:58:09

Re: Problem with Sphinx

#16 2013-11-01 12:30:39

Re: Problem with Sphinx

#17 2013-11-04 07:56:47

Re: Problem with Sphinx

#18 2013-11-07 18:40:50

Re: Problem with Sphinx

#19 2013-11-08 08:17:05

Re: Problem with Sphinx

#20 2013-11-08 08:38:00

Re: Problem with Sphinx

#21 2013-11-08 12:00:53

Re: Problem with Sphinx

#22 2013-11-08 19:02:20

Re: Problem with Sphinx

#23 2013-11-08 19:09:04

Re: Problem with Sphinx

#24 2013-11-08 19:11:26

Re: Problem with Sphinx

#25 2013-11-10 06:59:49

Re: Problem with Sphinx

Board footer