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. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
