[FX.php List] OK, this is driving me crazy... SOLVED

Jonathan Schwartz jonathan at exit445.com
Sat Apr 25 09:33:34 MDT 2015 

My money is on non-standard characters hidden in one of the value lists.  FileMaker tolerates but PHP objects.

J

Jonathan Schwartz
jonathan at exit445.com



On Apr 25, 2015, at 6:19 AM, Bob Patin <bob at patin.com> wrote:

> So here is what was so odd about my issue yesterday:
> 
> This is a simple table with a bunch of text fields and a half-dozen value lists; I put the value lists onto fields on the layout so that I could access them in FX.php, then created my search form; all the value lists populated on the input form without any issues.
> 
> Same layout now for the search query... some of the fields would succeed in returning results, some would not. All I was looking for was a found count at first, just to confirm that it was working... and even that would fail on 2 of the 10 fields in my search form.
> 
> Then, this morning, when I created a new layout with a single field on it, it worked immediately; this leads me to see that something about that layout that I created yesterday was causing the query to fail.
> 
> My path today will be to slowly add only the fields I need, rather than nuking the ones that I don't, and see how far that takes me without error.
> 
> This client's data is messy, so I'm wondering if perhaps one or more fields have something odd in them...
> 
> Bob Patin
> Longterm Solutions
> bob at longtermsolutions.com
> 615-333-6858
> FileMaker 9, 10, 11, 12 & 13 Certified Developer
> http://www.longtermsolutions.com
> -
> iChat: bobpatin at me.com
> Twitter: bobpatin
> —
> FileMaker Consulting 
> FileMaker Hosting for all versions of FileMaker
> PHP • Full email services • Free DNS hosting • Colocation • Consulting
> 
>> On Apr 25, 2015, at 8:07 AM, Bob Patin <bob at patin.com> wrote:
>> 
>> Created a new layout with one field on it… problem solved.
>> 
>> Too weird. The layout I was using was one I created yesterday—no graphics, just 100 fields or so with labels. I was planning to weed out all the unused fields after I confirmed connection… but never got there.
>> 
>> Too weird. Never seen that happen in 12 years using FX.php.
>> 
>> 
>> Bob Patin
>> Longterm Solutions
>> bob at longtermsolutions.com
>> 615-333-6858
>> FileMaker 9, 10, 11, 12 & 13 Certified Developer
>> http://www.longtermsolutions.com
>> -
>> iChat: bobpatin at me.com
>> Twitter: bobpatin
>> —
>> FileMaker Consulting 
>> FileMaker Hosting for all versions of FileMaker
>> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>> 
>>> On Apr 25, 2015, at 8:01 AM, Bob Patin <bob at patin.com> wrote:
>>> 
>>> I already did that; as I mentioned, a previous page accesses value lists without any trouble—same layout, same database, same query structure except for the last line.
>>> 
>>> What’s odder, I can search one field but not others...
>>> 
>>> Makes no sense.
>>> 
>>> Bob Patin
>>> Longterm Solutions
>>> bob at longtermsolutions.com
>>> 615-333-6858
>>> FileMaker 9, 10, 11, 12 & 13 Certified Developer
>>> http://www.longtermsolutions.com
>>> -
>>> iChat: bobpatin at me.com
>>> Twitter: bobpatin
>>> —
>>> FileMaker Consulting 
>>> FileMaker Hosting for all versions of FileMaker
>>> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>>> 
>>>> On Apr 24, 2015, at 11:16 PM, James Dcunha <jdcunha at supportgroup.com> wrote:
>>>> 
>>>> Try to do a basic XML query to check if custom web publishing is working. 
>>>> 
>>>> James 
>>>> 
>>>> Sent from my Phone
>>>> 
>>>>> On Apr 24, 2015, at 7:47 PM, Bob Patin <bob at patin.com> wrote:
>>>>> 
>>>>> Good idea about the layout. I tried FindAll and it didn't work either... which is what is so odd.
>>>>> 
>>>>> Another thing: the same layout is used on a form where I'm pulling a half-dozen value lists...
>>>>> 
>>>>> Also, I could do a search by one field but not another--both text fields, both indexed, both straight-ahead text fields with nothing exotic...
>>>>> 
>>>>> I even tried recovering the file just to see if that was it; I tried re-indexing the field I was testing with...
>>>>> 
>>>>> Argh...
>>>>> 
>>>>> 
>>>>>> On Apr 24, 2015, at 6:30 PM, Jonathan Schwartz <jonathan at exit445.com> wrote:
>>>>>> 
>>>>>> Bob,
>>>>>> 
>>>>>> Oh…I thought that you actually saw the Parse Error.
>>>>>> 
>>>>>> I would start substituting to troubleshoot.
>>>>>> 
>>>>>> Here are some ideas:
>>>>>>   - Same query, create new layout.
>>>>>>   - Change to FindAll
>>>>>>   - Same query, limit to one record (Could be a content issue).
>>>>>> 
>>>>>> Hope that helps.
>>>>>> 
>>>>>> Jonathan Schwartz
>>>>>> jonathan at exit445.com
>>>>>> 
>>>>>> 
>>>>>> 
>>>>>>> On Apr 24, 2015, at 4:03 PM, Bob Patin <bob at patin.com> wrote:
>>>>>>> 
>>>>>>> Unfortunately, not that… that was just a copy error when I was writing the email...
>>>>>>> 
>>>>>>> I just can’t find it.
>>>>>>> 
>>>>>>> Here’s the code straight from the page:
>>>>>>> 
>>>>>>> <?php
>>>>>>> 
>>>>>>> include_once('FX/FX.php');
>>>>>>> include_once('FX/server_data.php');
>>>>>>> 
>>>>>>> $comp = "bac";
>>>>>>> 
>>>>>>> $q = new FX ($serverIP,'80',$dataType,$scheme);
>>>>>>> $q->SetDBData($dbname,'web_catalog');
>>>>>>> $q->SetDBPassword($webpw,$webun);
>>>>>>> $q->AddDBParam('composer',$comp);
>>>>>>> $qResult = $q->FMFind();
>>>>>>> 
>>>>>>> echo $qResult['foundCount'];
>>>>>>> ?>
>>>>>>> 
>>>>>>> It never finishes, which indicates a parse error, but I can’t for the life of me find it.
>>>>>>> 
>>>>>>> What’s interesting is that an FMView works fine on the previous page, so I know that it’s connecting properly to the database and that WPE is working…
>>>>>>> 
>>>>>>> I wasted over an hour on it… headed to the couch… :)
>>>>>>> 
>>>>>>> Bob Patin
>>>>>>> Longterm Solutions
>>>>>>> bob at longtermsolutions.com
>>>>>>> 615-333-6858
>>>>>>> FileMaker 9, 10, 11, 12 & 13 Certified Developer
>>>>>>> http://www.longtermsolutions.com
>>>>>>> -
>>>>>>> iChat: bobpatin at me.com
>>>>>>> Twitter: bobpatin
>>>>>>> —
>>>>>>> FileMaker Consulting 
>>>>>>> FileMaker Hosting for all versions of FileMaker
>>>>>>> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>>>>>>> 
>>>>>>> 
>>>>>>>> On Apr 24, 2015, at 5:29 PM, James Dcunha <jdcunha at supportgroup.com> wrote:
>>>>>>>> 
>>>>>>>> You missing the $ symbol for webCompanionPort variable in the FX object instantiation step. 
>>>>>>>> 
>>>>>>>> James
>>>>>>>> 
>>>>>>>> Sent from my Phone
>>>>>>>> 
>>>>>>>>> On Apr 24, 2015, at 6:14 PM, Bob Patin <bob at patin.com> wrote:
>>>>>>>>> 
>>>>>>>>> well, i could set it to 80 manually; seems like i had that issue once before… will try it.
>>>>>>>>> 
>>>>>>>>> … and…
>>>>>>>>> 
>>>>>>>>> … no joy.
>>>>>>>>> 
>>>>>>>>> 
>>>>>>>>>> On Apr 24, 2015, at 5:02 PM, Jonathan Schwartz <jonathan at exit445.com> wrote:
>>>>>>>>>> 
>>>>>>>>>> Webcompanionport isn’t a variable?
>>>>>>>>>> 
>>>>>>>>>> J
>>>>>>>>>> 
>>>>>>>>>> Jonathan Schwartz
>>>>>>>>>> jonathan at exit445.com
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>> 
>>>>>>>>>>> On Apr 24, 2015, at 2:59 PM, Bob Patin <bob at patin.com> wrote:
>>>>>>>>>>> 
>>>>>>>>>>> What can be wrong with this?
>>>>>>>>>>> 
>>>>>>>>>>> Here’s my server data page:
>>>>>>>>>>> 
>>>>>>>>>>> <?php
>>>>>>>>>>> $serverIP = “fms5.longtermsolutions.com";
>>>>>>>>>>> $webCompanionPort = "80";
>>>>>>>>>>> $scheme = 'http';
>>>>>>>>>>> $dataType = 'FMPro7';
>>>>>>>>>>> $dbname = ’thedatabase.fp7';
>>>>>>>>>>> $webun = ‘yada';
>>>>>>>>>>> $webpw = ‘more-yada';
>>>>>>>>>>> ?>
>>>>>>>>>>> 
>>>>>>>>>>> and here’s my query; I can’t for the life of me figure out why this never finishes when I try to load it…
>>>>>>>>>>> 
>>>>>>>>>>> <?php
>>>>>>>>>>> include_once('FX/FX.php');
>>>>>>>>>>> include_once('FX/server_data.php');
>>>>>>>>>>> 
>>>>>>>>>>> $composer =‘bach’;
>>>>>>>>>>> 
>>>>>>>>>>> $q = new FX ($serverIP,webCompanionPort,$dataType,$scheme);
>>>>>>>>>>> $q->SetDBData($dbname,'web_catalog',50);
>>>>>>>>>>> $q->SetDBPassword($webpw,$webun);
>>>>>>>>>>> $q->AddDBParam('composer',$composer);
>>>>>>>>>>> $qResult = $q->FMFind();
>>>>>>>>>>> echo $qResult['errorCode’];
>>>>>>>>>>> ?>
>>>>>>>>>>> 
>>>>>>>>>>> I’ve echoed back all of the variables, and they’re legit; this is a silly little FIND and yet I can’t make it work.
>>>>>>>>>>> 
>>>>>>>>>>> Could it be something to do with FMS 11?
>>>>>>>>>>> 
>>>>>>>>>>> This should return 206 records, but instead, the page never loads, which indicates a parse error… and I just don’t see it…
>>>>>>>>>>> 
>>>>>>>>>>> The version of FX that I’m running is v6.0.
>>>>>>>>>>> 
>>>>>>>>>>> Thanks for any help,
>>>>>>>>>>> 
>>>>>>>>>>> Bob Patin
>>>>>>>>>>> Longterm Solutions
>>>>>>>>>>> bob at longtermsolutions.com
>>>>>>>>>>> 615-333-6858
>>>>>>>>>>> FileMaker 9, 10, 11, 12 & 13 Certified Developer
>>>>>>>>>>> http://www.longtermsolutions.com
>>>>>>>>>>> -
>>>>>>>>>>> iChat: bobpatin at me.com
>>>>>>>>>>> Twitter: bobpatin
>>>>>>>>>>> —
>>>>>>>>>>> FileMaker Consulting 
>>>>>>>>>>> FileMaker Hosting for all versions of FileMaker
>>>>>>>>>>> PHP • Full email services • Free DNS hosting • Colocation • Consulting
>>>>>>>>>>> 
>>>>>>>>>>> 
>>>>>>>>>>> _______________________________________________
>>>>>>>>>>> FX.php_List mailing list
>>>>>>>>>>> FX.php_List at mail.iviking.org
>>>>>>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>>>>>> 
>>>>>>>>>> _______________________________________________
>>>>>>>>>> FX.php_List mailing list
>>>>>>>>>> FX.php_List at mail.iviking.org
>>>>>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>>>>> 
>>>>>>>>> _______________________________________________
>>>>>>>>> FX.php_List mailing list
>>>>>>>>> FX.php_List at mail.iviking.org
>>>>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>>>> _______________________________________________
>>>>>>>> FX.php_List mailing list
>>>>>>>> FX.php_List at mail.iviking.org
>>>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>>> 
>>>>>>> _______________________________________________
>>>>>>> FX.php_List mailing list
>>>>>>> FX.php_List at mail.iviking.org
>>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>> 
>>>>>> _______________________________________________
>>>>>> FX.php_List mailing list
>>>>>> FX.php_List at mail.iviking.org
>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>> 
>>>>> _______________________________________________
>>>>> FX.php_List mailing list
>>>>> FX.php_List at mail.iviking.org
>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>> 
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>> 
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

More information about the FX.php_List mailing list