When I really started digging in, I realized that since I am only searching on one field per table, I don't even need this behavior. I can make the field a fulltext and then just search on that.
I've been on the issues page on the Google Code site, and a guy on there submitted a hack for building an index from scratch. They'd probably appreciate your fixes as well. acoustic_overdrive wrote: > > > I don't think you should need to set _index or _indexForId, those are > private vars used by the Behaviour. Maybe try putting them back to > false? > > Are you trying my version of the code? > > How about trying an insert rather than an update to see if that at > least adds to the index. That's how I've used it so far and it seems > to be working. > > Other than that I suggest you put some little echo 'foo' statements at > various places in the behaviour to see what parts of the behaviour are > being run (if...else), that might help you track down if something is > failing. > > Let me know if you find any bugs too! > > AO > > > > On Oct 13, 8:56 pm, RyOnLife <[EMAIL PROTECTED]> wrote: >> Thanks AO, >> >> If you make any progress on that rebuild() function, please let me know. >> >> Rebuilding the entire index aside, my search_index table is not getting >> any >> records added to it even when I do an updateAll() on an indexable field. >> I've set $_index, $index_ForId and $rebuildOnUpdate vars at the top of >> searchable.php to true. >> >> Hopefully this will work if I can get the index built! >> >> >> >> acoustic_overdrivewrote: >> >> > Hi RyOnLife, >> >> > I've been playing with that searchable behaviour recently too and I >> > think I've found a few bugs in it. >> >> > Here's my working copy: >> >> >http://bin.cakephp.org/view/1556621232 >> >> > If you DIFF this against the one you have you'll see some of the >> > changes I've made. >> >> > There doesn't seem to be any built-in function for rebuilding the >> > index so I'm thinking of writing a function to do that. It's fairly >> > clear what's going on so you could probably add a new function called >> > rebuild() or something like that. >> >> > J >> >> > On Oct 13, 7:08 pm, RyOnLife <[EMAIL PROTECTED]> wrote: >> >> I am making a little progress here. I realized $actsAs needs to go in >> the >> >> model, not the controller. That took care of the SQL error. I am still >> >> not >> >> getting any results, clearly because my search_index table is empty. >> >> >> I assume that Model::save will take care of the index on inserts and >> >> updates, is that correct? But how do I retroactively index the data >> that >> >> already exists in my tables? >> >> >> RyOnLife wrote: >> >> >> > I am trying a simple search with the searchable behavior from >> >> >http://code.google.com/p/searchable-behaviour-for-cakephp/. >> >> >> > I've created the table and put the search_index.php file in the >> models >> >> > folder and the searchable.php behavior in the behaviors folder. >> >> >> > I've got $actsAs in my controller: >> >> >> > var $actsAs = array('Searchable'); >> >> >> > And my search() method: >> >> >> > function search() { >> >> > $this->set('results', $this->ModelName->search('test')); >> >> > } >> >> >> > When I run this, I am getting an SQL error because Cake is trying to >> >> > execute this query: >> >> >> > search >> >> >> > Obviously that's not going to get the job done. >> >> >> > Any tips for me? Or resources to point me at? >> >> >> > So far I've referred to the Google Code page and also >> >> >> >http://bakery.cakephp.org/articles/view/search-feature-to-cakephp-blo.... >> >> >> > Thanks! >> >> >> -- >> >> View this message in >> >> >> context:http://www.nabble.com/SQL-errors-with-the-searchable-behavior-tp19958... >> >> Sent from the CakePHP mailing list archive at Nabble.com. >> >> -- >> View this message in >> context:http://www.nabble.com/SQL-errors-with-the-searchable-behavior-tp19958... >> Sent from the CakePHP mailing list archive at Nabble.com. > > > > -- View this message in context: http://www.nabble.com/SQL-errors-with-the-searchable-behavior-tp19958018p19964350.html Sent from the CakePHP mailing list archive at Nabble.com. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---