search plugin sql error

[skyrun]

on my site www.skyrun.com/skyforce, getting a search error that you can see if you type anything into the search box (top right) AND PRESS ENTER which shows the results vs. waiting for ajax to return which it won't due to an error...

not sure why fabrik thinks it should get person_id (un-raw) from sf_all_person table vs. sf_leads where it is and where the raw is coming from...

most likely related to the 'person_id' element on the lead list which is a database join to the sf_all_person table, but i can't see anything wrong in now i defined it and fabrik works fine, just the search is amiss.

500​

Error: 500​

Fabrik has generated an incorrect query for the list Leads: ​

​

Unknown column 'sf_all_person.person_id' in 'field list' SQL=SELECT DISTINCT `sf_lead`.`id` AS `sf_lead___id`, ​

`sf_lead`.`id` AS `sf_lead___id_raw`, ​

`sf_lead`.`person_id` AS `sf_lead___person_id_raw`, ​

`sf_all_person`.`person_id` AS `sf_lead___person_id`, ​

`sf_lead`.`add_person` AS `sf_lead___add_person`, ​

...​

...​

etc ​

​

...​

 

[rob]

id need admin access to test this, I think simply saving the 'person_id' element will fix it but im not sure

 

[skyrun]

i tried resaving person_id but that didn't fix it. i have upped your authority to superadmin. thanks!