Related Movies not showing??

porntube · 2011-10-13 20:11:55

no related Movies showing on my site??

sphinx running:

Sphinx 2.0.1-id64-beta (r2792)
Copyright (c) 2001-2011, Andrew Aksyonoff
Copyright (c) 2008-2011, Sphinx Technologies Inc (http://sphinxsearch.com)

using config file '/etc/sphinx/sphinx.conf'...
indexing index 'videos'...
WARNING: collect_hits: mem_limit=0 kb too low, increasing to 26624 kb
collected 93 docs, 0.0 MB
collected 216 attr values
sorted 0.0 Mvalues, 100.0% done
sorted 0.0 Mhits, 100.0% done
total 93 docs, 18791 bytes
total 0.041 sec, 457959 bytes/sec, 2266.52 docs/sec
total 406 reads, 0.000 sec, 0.2 kb/call avg, 0.0 msec/call avg
total 11 writes, 0.001 sec, 17.5 kb/call avg, 0.1 msec/call avg
rotating indices: succesfully sent SIGHUP to searchd (pid=29122).

My settings for related Movies:

Show related videos = yes
related Categors = no
Complex(Sphinxsearch)
Limit = 100
per page = 10

i use the config file from here: Install Sphinx for Adult Script Pro
anyone knows what's wrong??

symtab · 2011-10-14 08:40:40

I will update the documentation for sphinx. You need to add a few more lines to the sphinx configuratation and then restart sphinx. Updating now.

porntube · 2011-10-14 14:55:42

ok i use your updated file but now comes an Error when i want restart:

ERROR: unknown key name 'GROUP_CONCAT' in /etc/sphinx/sphinx.conf line 19 col 22.
FATAL: failed to parse config file '/etc/sphinx/sphinx.conf'

what is now wrong??

symtab · 2011-10-14 19:01:22

I have no idea. Never saw that error before. Please email me ssh root access and i will check and fix tomorrow. Could be possible that there is a space needed after v.video_id AS video, but i'm not sure.

porntube · 2011-10-14 20:52:42

hmm when i use the old form it runs without errors so the problem comes after your changes to RC4?
i use it on Cent OS5.7

Coscast · 2011-10-14 22:34:46

CENTos is based on debian.
Which version are you running ?

symtab · 2011-10-14 22:36:40

Centos is not based on debian. Its based on RHEL. Probably almost the same as rhel, but free.

Coscast · 2011-10-14 22:37:57

OK. Overpowered. Be real: What is NOT based on DEB ?!

porntube · 2011-10-14 22:50:41

first i have run:

Sphinx 2.0.1-id64-beta (r2792)

after the config file update and the error i remove the beta and install the last stable:

Sphinx 0.9.9-release (r2117)

but the error comes allways:

ERROR: unknown key name 'GROUP_CONCAT' in /etc/sphinx/sphinx.conf line 19 col 22.
FATAL: failed to parse config file '/etc/sphinx/sphinx.conf'

this is line 19 before update: GROUP_CONCAT(DISTINCT t.name SEPARATOR ' ') AS tags \
this is line 19 after update : GROUP_CONCAT(DISTINCT t.name SEPARATOR ' ') AS tags \

for me it looks same?!

so it can only be an error/problem in line 18

befor update: v.rating, v.total_views, v.duration, \
after update: v.rating, v.total_views, v.duration, v.video_id AS video, \

symtab · 2011-10-15 15:26:32

Please email me ssh root access. I dont know exactly what the problem is. Is there a space after v.video_id AS video,?

porntube · 2011-10-15 15:41:49

the line is exactly why i post it in my last post
i sent you an mail

porntube · 2011-10-16 12:26:33

anyone new of this problem?

symtab · 2011-10-16 14:38:50

Fixed. I dont know what the problem was, i actually only added:

v.video_id AS video,

Restarted searchd and also reloaded with indexer, just to see if it works.

porntube · 2011-10-16 15:12:34

Hmm i think it works!

Thanks.
but i dont understand this the 2 config files are absolutly same?!
but ok it runs and this is good.

Thanks again.

symtab · 2011-10-17 06:45:19

I do not know, like i said i only added what was missing. Probably you forgot a space or , (happens to me all the time when i code and then i search hours for a comma and i cant find it).

@Coscast: redhat, slackware, archlinux are not based on debian. Ubuntu, Mint and other distributions are based on debian. I used to like debian, but now i use archlinux on my desktop/laptop and centos (mostly because most clients use centos) on my servers. Debian was considered the most stable and secure linux distribution like 3-5 years ago, i dont know how its now, lost track to linux since i moved from server administration to php.

ptsguy · 2012-09-12 02:23:10

symtab wrote:

Fixed. I dont know what the problem was, i actually only added:
v.video_id AS video,
Restarted searchd and also reloaded with indexer, just to see if it works.

where did you add this? I am having an issue with sphinx and related videos

symtab · 2012-09-13 12:05:52

In sphinx.conf.

Adult Script Pro Community Forums

#1 2011-10-13 20:11:55

Related Movies not showing??

#2 2011-10-14 08:40:40

Re: Related Movies not showing??

#3 2011-10-14 14:55:42

Re: Related Movies not showing??

#4 2011-10-14 19:01:22

Re: Related Movies not showing??

#5 2011-10-14 20:52:42

Re: Related Movies not showing??

#6 2011-10-14 22:34:46

Re: Related Movies not showing??

#7 2011-10-14 22:36:40

Re: Related Movies not showing??

#8 2011-10-14 22:37:57

Re: Related Movies not showing??

#9 2011-10-14 22:50:41

Re: Related Movies not showing??

#10 2011-10-15 15:26:32

Re: Related Movies not showing??

#11 2011-10-15 15:41:49

Re: Related Movies not showing??

#12 2011-10-16 12:26:33

Re: Related Movies not showing??

#13 2011-10-16 14:38:50

Re: Related Movies not showing??

#14 2011-10-16 15:12:34

Re: Related Movies not showing??

#15 2011-10-17 06:45:19

Re: Related Movies not showing??

#16 2012-09-12 02:23:10

Re: Related Movies not showing??

#17 2012-09-13 12:05:52

Re: Related Movies not showing??

Board footer