ok, so i went into the config.php and changed the sphinx server hostname. solved the problems. now the indexes show a proper number of documents and the searches produce results.
im going to continue doing a little testing.
but basically ito looks like in your install you need to differentiate between the DB host and the Sphinx Host
Oh ok, the Host should be where sphinx is actively running at. There may be more info in the sphinx docs, but basically here is where I set the server in code. I'm assuming this is how the sphinx client attempts to connect to searchd.
In the next few commits, I am going to add that debug info that I posted. It is extremely useful and I'm not sure why I don't just echo it out. Also, can you explain your setup again? Sphinx Client is installed on webserver, yet the daemon is installed on the DB server?
sphinx client, indexer and daemon are on the webserver. The Vanilla database is on a separate machine.
Last time i installed, during the installation config process, i specified localhost in the first step. when i wrote the config file out using the dashboard, it has localhost in the mysql host name in the config file, so this time i entered the mysql DB hostname in the install.
not sure if i was supposed to do that, but the config file ended up looking correct this time.
@422 said:
well over my head but fantastic reading !
you should really install this plugin. i can't begin to describe how much of an improvement it makes over the default search tool. and the related discussion capability is exactly what i need to improve my bounce rate for search engine visitors. i've seen a remarkable difference. bounce rate dropped by 25% since i installed the tool.
Here is where the problem lies with respect to the auth error:
Delete this single line here. It was preventing non-admins access to any of the plugin's internal controller methods. You should now be able to see the results above the "Ask a Question"
Here is where the problem lies with respect to the auth error:
Delete this single line here. It was preventing non-admins access to any of the plugin's internal controller methods. You should now be able to see the results above the "Ask a Question"
Thank you. I'll try that this evening when I get home.
Thanks for all your help, really appreciate it.
Oh, I haven't forgotten about the test instance, I'm still trying to figure out how to best go about it and give you access. Right now I don't expose the telnet/ssh and ftp ports to the outside world, so I really need to secure the server a little better before I do
So I think what you are seeing is that sphinx can't find any related discussions. What you can try is seaching for any discussions without an related threads and see if the main search yields any results. Be sure that "Titles Only" checkbox is selected since this is what the script does internally.
And enter that title into the search box and click the "titles only" box, then no results are returned, which is what we expect. However, if you strip everything out except the word, "recipe", then there are discussions that are returned with that word in the title.
The query should be doing an OR operation, mad | else | clone ... so I'm surprised why no theads with the word "recipe" are included. I'd have to investigate further.
Edit: Ok I investigated further. I'm willing to bet that discussions that don't have any related threads is either because one of two things:
Simply put, no related threads - be sure to verify in main search
There is a special character in the title ( parentheses, commands, appostrphies, etc)
The example thread above has an apostrophe in it which is screwing up the script that is forumulating the query...it is probably chocking up on it. This is what should be produced for related threads:
notice how the extend query checkbox is selected. That enable you to basically do anything sphinx supports here Pretty niffty features if you want to search like a ninja
Alright I think I solved it with just one line of code. See this github issue.
I was not decoding the special characters correctly. Once fixed, a search for Troeg's is handled internally by Sphinx as a search for Troeg s. The apostrophe turns into a space as explained by Shodan (guy who developed Sphinx) in this post.
See barryhunter's response in this thread on the sphinxforum for alternatives. It involves messing with the charset_table and adding exceptions.
Comments
uhh... i just re-read my post... pardon my english, im american.
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
i would edit it, but im lazy enough to just type an apology.
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
ok, so i went into the config.php and changed the sphinx server hostname. solved the problems. now the indexes show a proper number of documents and the searches produce results.
im going to continue doing a little testing.
but basically ito looks like in your install you need to differentiate between the DB host and the Sphinx Host
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
Oh ok, the Host should be where sphinx is actively running at. There may be more info in the sphinx docs, but basically here is where I set the server in code. I'm assuming this is how the sphinx client attempts to connect to searchd.
In the next few commits, I am going to add that debug info that I posted. It is extremely useful and I'm not sure why I don't just echo it out. Also, can you explain your setup again? Sphinx Client is installed on webserver, yet the daemon is installed on the DB server?
sphinx client, indexer and daemon are on the webserver. The Vanilla database is on a separate machine.
Last time i installed, during the installation config process, i specified localhost in the first step. when i wrote the config file out using the dashboard, it has localhost in the mysql host name in the config file, so this time i entered the mysql DB hostname in the install.
not sure if i was supposed to do that, but the config file ended up looking correct this time.
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
been doing some testing, new error
"error (Authorization Required)" shows up in the related questions when a member starts to create a new discussion.
I can create a discussion and see related titles fine as an admin.
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
Yea interesting, I never tested this with another user than the admin. I can also replicate it which is good....I'm looking into it
cool, thanks
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
im asking some guys to start testing with basic and mod accounts to see if everything is working as expected.
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
well over my head but fantastic reading !
There was an error rendering this rich post.
you should really install this plugin. i can't begin to describe how much of an improvement it makes over the default search tool. and the related discussion capability is exactly what i need to improve my bounce rate for search engine visitors. i've seen a remarkable difference. bounce rate dropped by 25% since i installed the tool.
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
Awesome news.
Here is where the problem lies with respect to the auth error:
Delete this single line here. It was preventing non-admins access to any of the plugin's internal controller methods. You should now be able to see the results above the "Ask a Question"
Thank you. I'll try that this evening when I get home.
Thanks for all your help, really appreciate it.
Oh, I haven't forgotten about the test instance, I'm still trying to figure out how to best go about it and give you access. Right now I don't expose the telnet/ssh and ftp ports to the outside world, so I really need to secure the server a little better before I do
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
yep, that did it.
any idea why http://homebrewforums.net/discussion/760/troegs-mad-elf-clone-recipe-pm#Item_5
would not have the related discussions box pop up?
I'm finding that some discussions dont display related discussions, i haven't found a pattern though.
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
Are they all from comment splits?
i'd have to check, we have a lot of splits... i'll look
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
just checked another split discussion and it shows related discussions just fine.
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
So I think what you are seeing is that sphinx can't find any related discussions. What you can try is seaching for any discussions without an related threads and see if the main search yields any results. Be sure that "Titles Only" checkbox is selected since this is what the script does internally.
You can modify the criteria here.
If we look at your example thread: http://homebrewforums.net/discussion/760/troegs-mad-elf-clone-recipe-pm#Item_5
And enter that title into the search box and click the "titles only" box, then no results are returned, which is what we expect. However, if you strip everything out except the word, "recipe", then there are discussions that are returned with that word in the title.
The query should be doing an
ORoperation,mad | else | clone ...so I'm surprised why no theads with the word "recipe" are included. I'd have to investigate further.Edit: Ok I investigated further. I'm willing to bet that discussions that don't have any related threads is either because one of two things:
The example thread above has an apostrophe in it which is screwing up the script that is forumulating the query...it is probably chocking up on it. This is what should be produced for related threads:
http://homebrewforums.net/search?Search=@title+Troegs+|+Mad+|+Elf+|+Clone+|+Recipe+|+PM&child=&forums=&or=Relevance&mem=&tag=&pg=&date=All&titles=1&Checkboxes[]=titles&Checkboxes[]=WithReplies&res=Classic&match=Extended
notice how the extend query checkbox is selected. That enable you to basically do anything sphinx supports here Pretty niffty features if you want to search like a ninja
Thanks for looking into it and explaining whats going on. i'll think about what to do to address it.
Vanilla Wiki, Tastes Great! 31,000 viewers can't be wrong. || Plugin Development Explained
Alright I think I solved it with just one line of code. See this github issue.
I was not decoding the special characters correctly. Once fixed, a search for
Troeg'sis handled internally by Sphinx as a search forTroeg s. The apostrophe turns into a space as explained by Shodan (guy who developed Sphinx) in this post.See barryhunter's response in this thread on the sphinxforum for alternatives. It involves messing with the charset_table and adding exceptions.