[FX.php List] OK, this is driving me crazy... SOLVED
Bob Patin
bob at patin.com
Sat Apr 25 07:19:55 MDT 2015
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 <mailto:bob at longtermsolutions.com>
> 615-333-6858
> FileMaker 9, 10, 11, 12 & 13 Certified Developer
> http://www.longtermsolutions.com <http://www.longtermsolutions.com/>
> -
> iChat: bobpatin at me.com <mailto: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 <mailto: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 <mailto:bob at longtermsolutions.com>
>> 615-333-6858
>> FileMaker 9, 10, 11, 12 & 13 Certified Developer
>> http://www.longtermsolutions.com <http://www.longtermsolutions.com/>
>> -
>> iChat: bobpatin at me.com <mailto: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 <mailto: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 <mailto: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 <mailto: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 <mailto:jonathan at exit445.com>
>>>>>
>>>>>
>>>>>
>>>>>> On Apr 24, 2015, at 4:03 PM, Bob Patin <bob at patin.com <mailto: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 <mailto: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 <mailto: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 <mailto:FX.php_List at mail.iviking.org>
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list <http://www.iviking.org/mailman/listinfo/fx.php_list>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org <mailto:FX.php_List at mail.iviking.org>
>>> http://www.iviking.org/mailman/listinfo/fx.php_list <http://www.iviking.org/mailman/listinfo/fx.php_list>
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org <mailto: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 <mailto:FX.php_List at mail.iviking.org>
> http://www.iviking.org/mailman/listinfo/fx.php_list <http://www.iviking.org/mailman/listinfo/fx.php_list>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20150425/ea200b19/attachment-0001.html
More information about the FX.php_List
mailing list