1 Topic by FionaCEDaR

  • FionaCEDaR
  • Administrator
  • Offline
  • From: CEDaR, Northern Ireland
  • Registered: 16-09-2009
  • Posts: 165

Topic: Create filter autocomplete not working

Hi,
When I try to filter on species in the All Records report on my site using the Create Filter function, the autocomplete for the species name won't bring back any results - the wheel just spins and spins. I noticed this on iRecord the other day but found it fixed within half an hour. An image is attached to show where I mean.

Has a bug crept in? I don't have time to update my iform module at the moment :(

Thanks,
Fiona

Fiona McCrory
CEDaR Website Officer
www.nmni.com/cedar

FionaCEDaR's Website

2 Reply by Jim Bacon

  • Jim Bacon
  • Veteran
  • Offline
  • From: BRC
  • Registered: 03-11-2008
  • Posts: 980

Re: Create filter autocomplete not working

Is it perhaps a problem with the warehouse being busy and unable to respond quickly enough?
I tried your website and it seemed okay to me, assuming I was looking in the right place.

Jim Bacon.

3 Reply by FionaCEDaR

  • FionaCEDaR
  • Administrator
  • Offline
  • From: CEDaR, Northern Ireland
  • Registered: 16-09-2009
  • Posts: 165

Re: Create filter autocomplete not working

Thanks for looking Jim. Just to clarify where I mean in case you weren't in the right place as I still can't get it to work.

On our site, you got to Explore Records > All Records, choose Create filter and then choose What.

Under What I can get it to autocomplete on Species groups but not in Families and other higher taxa or Species and lower taxa...

Can you check again and let me know how you get on as I can get it to work on iRecord no probs?

Cheers,
Fiona

Fiona McCrory
CEDaR Website Officer
www.nmni.com/cedar

FionaCEDaR's Website

4 Reply by Jim Bacon

  • Jim Bacon
  • Veteran
  • Offline
  • From: BRC
  • Registered: 03-11-2008
  • Posts: 980

Re: Create filter autocomplete not working

Hi Fiona,

I was looking in the wrong place.

I see your problem. If I try to add a family filter, the response from the warehouse begins

There was an SQL error: ERROR:  syntax error at or near "C"
LINE 4: AND taxon_rank_sort_order%3C%3D180

Looks like some url encoding for <=180 has crept in there.

Comparing with iRecord, I can see the parameters sent to the server are different in this regard.

So, your website is compiling an invalid request (probably a bug). The warehouse is responding with an error message. The javascript to handle the warehouse response doesn't manage the error and bombs out. You get left with a spinny wheel.

I can't spot a recent bug fix related to this but I may be looking in the wrong place. I was anticipating the problem would be in client_helpers/prebuilt_forms/includes/report_filters.php or client_helpers/data_entry_helper.php. This might be enough information to remind John if he has fixed something like this though.

Jim Bacon.

5 Reply by FionaCEDaR

  • FionaCEDaR
  • Administrator
  • Offline
  • From: CEDaR, Northern Ireland
  • Registered: 16-09-2009
  • Posts: 165

Re: Create filter autocomplete not working

Thanks Jim, I'll wait to see what John says.

Fiona

Fiona McCrory
CEDaR Website Officer
www.nmni.com/cedar

FionaCEDaR's Website