I'm in the process of trying to upgrade my server setup which I run for a non-profit genealogy society, along with versions of Mac OS X, PHP, all on a new (well refurbished) Mac mini - yes a lot of changes all at once, and it hasn't all be plain sailing :-( The new setup is:
Apache and Web Publishing Engine
Mac mini Quad Core i17 - 8 GB RAM - 120GB SSD - Mac OS X 10.8.5
FileMaker Server Advanced 18.104.22.1685
Mac mini Core 2 Duo - 8 GB RAM - 60GB SSE - Mac OS X 10.8.5
FileMaker Server Advanced 12.0.405
I'm here at this forum trying to get help with how to get BlackBelt running with FileMaker Server 12 Advanced. I have been using BlackBelt and all my databases for a couple of years or more now with FileMaker Server 11, and before that FileMaker Server 9 and 8.5 (I skipped over 10) but something has changed in FileMaker Server 12 it seems with how search fields are treated apparently.
One specific issue I'm stuck on is performing a search, and how empty search fields are submitted and processed. Using the search page here for examplehttp://data.wmgs.org:8888/Newspapers/FMPro?-db=Orders&-lay=NewspapersOrders&-format=search.htm&-New
there are two fields there that have "Equals" set as the operator - Soundex and Year - so if I do a search which leaves both of them empty - say a search for "Surname begins with Moff", I get no search results because there are no records in this database where Soundex and Year are both empty (there are zero records where Soundex is empty in fact), so any search done with Soundex field empty return no results. If I put "M130" into the Soundex field, there are 6 results because there are 6 matching records in my database where the Year field is empty.
So it seems like when a search field is empty, and the operator defined for it is "equals", FileMaker Server 12 is now doing an "equals empty" search, whereas all previous versions up to and including FileMaker Server 11 have essentially ignored these inputs. The Server Admin Log shows this
22.214.171.124 127.0.0.1:55233 webuser XML 401 496 "/fmi/xml/FMPXMLRESULT.xml?-db=Newspapers&-lay=web&-max=20&Soundex=&Soundex.op=eq&Surname=Moffat&Surname.op=bw&FirstName=&FirstName.op=bw&Year=&Year.op=eq&-find"
I'm not sure where I should be looking to try and fix this - in the BlackBelt code somewhere?
In the FX code somewhere? I have downloaded the latest FX from GitHub, and as a trial just put that entire folder into the BB/lib/ folder in place of the current one, but that made no difference. (at least it continued working an didn't apparently break anything).
I am at a complete loss to follow anything in the BB code, but if someone else has already tackled this and solved this issue, or could point me to a solution I'd be much appreciative.