I have a FMP database being served with php created from the php site assistant. On the search page I have several fields that when ever anything is entered into them the search gives an error when preformed

Error: 102 - Field is missing

Home page is here:

http://mlsmax.com:80/eMLS_Listings/home.php?

OK I'll answer.

Field that are on the search page and have a value entered into them to search for must be on the search results page. Or you will get the field missing error.

I have not tried hiding the fields on the results page yet.

Does anybody know if this will work?

Hope it helps somebody!

Field that are on the search page and have a value entered into them to search for must be on the search results page. Or you will get the field missing error.

Well Untrue mainly due to the fact it will not throw an error on get field - just won't retrieve any contents if you make a call to that field which is missing.

NO - It gave an error - Error 102 Field is missing.

Tried and tested on about 6 separate fields with the same result. Not a theory. It was tried and tested many times.

Your results may differ but those were my results.

Post your code? Its not clear whether you're talking about FileMaker layouts or Web Portion. If you're talking about the Web portion, then yes the fields will need to be present on your FILEMAKER layout as you are performing a find.. however there is a difference between a search and the retrieval of data from search results. A call to $rec->getField('fieldName') for example would return nothing if that field didn't exist... where as if you were to misreference a field as part of a search command for example then yes it would throw an error.

There will probably be a fairly easy way to tweak the code if you wanted to hide them off the web layout. Additionally, you do not need to append :80 to an address that begins with http://.

PS For something as simple as this site, I would recommend you possibly look at manually writing the code, or if you're not a code buff, take a look at http://www.fmwebschool.com - their FMStudio product. It'll make the site a little more usable than the site assistant does especially if you want clients to be able to use this.

Otherwise, feel free to post your code and i'll try help you tweak it.

further investigation -

I'm taking a simple site created with the filemaker PHP site assistant and going straight to the web. To keep it simple I'm using the same layout in filemaker for the layout reference for search, report and the results page and have all of the fields displayed. I test a few searches and all is good. Clicking the report button gives the "Error 102- field is missing".

If I go back to the beginning and start over no searches will work. Not even the find all command created by the site assistant. All pages and searches give the same error. "Error 102- field is missing"

The database is working. I can than pull up the database and do a search in IWP and it works fine.

Opening a different browser ( FireFox ) works for a few searches and than provides the same error after clicking the report button

I have attempted to rebuild the site from scratch several times with the same result.

My solution - I did not need the report page any way! Went into the navigation.php file and removed the link to it.