FORUMS CLOSED DUE TO SPAM. YOU STILL CAN ADD POST!

FSearch - Simple full-text search with MySQL

Feed 15 posts, 3 voices

Avatar
10 posts

Hey everybody!

I just completed and released my FSearch plugin.
The FSearch plugin adds MySQL full-text search to your Frog CMS.

MySQL full-text search is a good choice if your running your site on a co-hosted server, since these hosting solutions don’t allow you to run external search engine software.

It’s quick and easy to set up. Requires almost no installation (only snippets) and no third-party software, just make sure your running your site with MySQL backend.

See details and installation instructions at:
http://github.com/acrookston/fsearch/

Please let me know if you find it useful!

/Andrew

 
Avatar
26 posts

It would be rather usefull if it worked.
I have a MySQL database and i’ve followed the installation instructions.
I did check the “Make this page searchable” checkbox.
But still there’s no returned results, nor any warning at all.

What can I do?

 
Avatar
10 posts

Can you check the database and see if there is an index on the page_part table called fsearchable_ix and also it should have a column called content_fsearchable. I’m thinking you have a problem with MySQL rights. I don’t really know where to start otherwise.

I think I found a bug just 10min ago though. The plugin doesn’t seem to index the page title. But the content shouldn’t be a problem!

 
Avatar
26 posts

Hi Andrew,

I can confirm fsearchable_ix and content_fsearchable exist in the mysql database.
I’ve done a reinstall of Frog and your plugin and it does show the search forum.
But there’s no “Make this page searchable” checkbox to be found anywhere on the page edit.
Any new idea’s?

 
Avatar
15 posts

PFFhaha! So I used the instructions on Github for fSearch – except – the git URL is for ckfrog… So I pulled down the repo – and was looking through the plugins scratching my head for several minutes… Uh – I don’t see it here…

For the record: git clone git://github.com/acrookston/fsearch.git

Ok – let me see if that works…

 
Avatar
15 posts

@fortron So I had the same problem with the “make searchable” not showing.

If you alter – index.php in fsearch

line 78 – from:
function fsearch_display_checkbox(&$page) {
to:
function fsearch_display_checkbox($page) {

(remove the ‘&’ from both parameter variables)

Same with line 91:
function fsearch_clean_contents($page_part) {

Now – I’m no 1337 php coder, but this made the check box appear – and the search work…at least somewhat so far.

@Andrew – not sure if this will hinder functionality. Currently – my search results return the entire content that the search finds.

 
Avatar
26 posts

Well the “make searchable” is visible thats a good thing.
Buts that is all is does, no search results are returned.
Its a good thing that i’ve found a alternative search function :)

 
Avatar
15 posts

@fortron – yeah, I’m in the process of trying various solutions also.

 
Avatar
26 posts

Well this is what I use with Frog:
http://www.wolfcms.org/forum/topic84.html

I’m happy with it :)

 
Avatar
15 posts

Haha – just looking at this one in fact. w00t. Let me know how it works out for ya.

 
Avatar
26 posts

Well i’m happy with it.
Works just fine for me.
If you have problems and noone can help you
then give us a call ;)

 
Avatar
10 posts

HMMMmm.. Update long overdue but it’s finally released.
I also updated the installation instructions after testing the plugin on a fresh Frog installation. Eg: MOD_REWRITE must be enabled for the examples to work.

adc Thanks for the note on the faulty URL. It’s been fixed.
adc I also removed the & before $page. Must have copied that from another plugin. ;)

Upgrade instructions:
For those who used Git as installmethod run: git pull --rebase
For those who downloaded the tarball you will need to download the “new” (same link) tarball and replace previous extracted files.

 
Avatar
15 posts

Right on @Andrew! I’ll check this one out if I get some a little break in dev cycle grind…. ;)
Thanks for the updates.

 
Avatar
26 posts

Andrew,

could you also provide a zip or 7zip file of the FSearch download?
Would be much appreciated.

 
Avatar
10 posts

Oh and checkout any changes in the readme and code over at my github page

 
Avatar
10 posts

@Fortron You can download the tar-zip from http://github.com/acrookston/fsearch/tarball/master

I’d prefer not to put up a .zip file because I would need to update and maintain it outside of github.