Gift Registry search stopped working

[dewed]

Helping the owner of a store, about a year ago I added the registry redux add on, and tested it. It worked. Now, the search doesn't find anything.

 

I can see in the database that a particular customer created a registry, yet searching for it gives nothing... I've gone back over the install instructions that came with the add-on, everything seems in order. I also printed out the queries that doing a search generates... Pasting the query directly into PHPMyAdmin also gives no errors, and no matches.. but it should do one or the other...

 

 

select distinct c.customers_id, c.customers_firstname, c.customers_lastname, c.customers_email_address, r.registry_id, r.co_registrant_first_name, r.co_registrant_last_name from customers c, registry_products rp, registry r where rp.customers_id = c.customers_id AND rp.registry_id = r.registry_id AND r.registry_occasion_id = '1' AND (r.co_registrant_first_name like 'Jo%' AND r.co_registrant_last_name LIKE 'Blo%') order by r.co_registrant_last_name, r.co_registrant_first_name

 

There is in fact a registry created for Joe Blow, of occasion type 1 (wedding) I can see it in the registry table of the database.. but am at a loss why the query above which is generated by registry_search_result.php doesn't find it.

 

Any clues ?

[dewed]

Disregard.. It turns out search wasn't working because the person reporting the problem didn;t add any products to it ...

so of course registry_products.customers_id = customers.customers_id wouldn't find any matches.... :blush: