Date: 2009-01-19 22:48
Posted By: Paul Lemke (lemkepf)

The fix is to remove the "LIMIT 1" from the re-index modules. Example:

$q = "SELECT id FROM ".cms_db_prefix()."module_search_items WHERE
                  extra_attr = ? AND content_id = ? LIMIT 1";

$template_indexed = $db->GetOne( $q, array( 'template', $content->TemplateId()
));

Should be: 

$q = "SELECT id FROM ".cms_db_prefix()."module_search_items WHERE
                  extra_attr = ? AND content_id = ? ";
$template_indexed = $db->GetOne( $q, array( 'template',
$content->TemplateId() ));
      

Date: 2009-02-15 11:22
Posted By: Robert Campbell (calguy1000)

I can't see what you're talking about.... I see the code, but don't understand
what the problem is.
      

Date: 2009-04-21 11:02
Posted By: Troy Spruit (densefog)

The solution from lemkepf resolved a problem I was seeing as well. The search
won't index regular content when using adodb but will under adodb-lite. Removing
the limit 1 allows the indexing to work. There's a related discussion here:
http://forum.cmsmadesimple.org/index.php/topic,24332.15.html