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_overdrive wrote: > > > 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-tp19958018p19961714.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 [email protected] 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 -~----------~----~----~----~------~----~------~--~---
