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