Search by related record error

Archived from the Xataface Users forum.

Byrhtwulf72 — Tue May 01, 2012 7:11 pm

Hi, I’m having some trouble with searching by a related record. Whenever I try to search for a record that’s related to another table, I get the following error:
Failed to get field table_name/field: 2.

Also, if the table has multiple relationships, and I try to search for a record in one of the later relationships, I’ll get errors for all of the other fields in the other related tables. I don’t really understand what the error could be, so any help would be appreciated.

shannah — Mon May 07, 2012 11:30 am

Can you post some more details?

  1. Xataface/PHP/MySQL version
  2. Table structure, relationships.ini, fields.ini definitions that are relevant.
  3. Describe your steps (e.g. searching can be done in Xataface in multiple ways.. there is the advanced find form, the column headers, direct URL parameters, the main search box, etc….

-Steve