[FX.php List] Error 105
Jason H Awbrey
jawbrey at harmonic-data.com
Wed Jun 7 15:49:11 MDT 2006
Thanks for the response Chris.
You are correct -- only the URL query produces the error. Just to
test, I logged in with a Full Access account and still got the 105
error so I don't think it's a permissions issue. Even the limited
access accounts have view only privileges on all the layouts.
To run a simple test I added the $query->FMPostQuery(false) line to
my query. In this case FX still returns a dataset. I would think If I
changed FX.php's query method to GET, I would get the 105 error.
Your authentication theory sounded good but unfortunately I don't
think that is the issue.
Thanks again,
Jason
On Jun 7, 2006, at 4:06 PM, Chris Hansen wrote:
> Jason,
>
> Just to clarify, does FX return BOTH an error and data, or just
> data (with the error being via the URL query...)? Whatever the
> case, keep in mind that by default, FX.php performs a POST query
> (to avoid URL length limitations) and the URL returned, while
> functionally as identical as possible, will be a GET request. I
> have seen odd differences between get and post before, but they've
> usually been related to authentication.
>
> That said, what sort of permissions does the account that you're
> using have for the layout that you're accessing, and the tables
> referenced? I have seen errors before that were caused by
> permissions, but weren't permissions related errors. Let me know
> if this is of any help.
>
> Best,
>
> Chris Hansen
> Application Developer
> The Moyer Group
> chansen at moyergroup.com
> http://www.moyergroup.com/
> -
> Creator of FX.php
> "The best way from FileMaker to the Web."
> http://www.iViking.org/
> -
> FileMaker 7 Certified Developer
>
>
>
> On Jun 7, 2006, at 11:13 AM, Jason H Awbrey wrote:
>
>> I am giving up on this. Data is being returned in the $result
>> ['data'] object so at least it works (?!?). I will just use that
>> to troubleshoot instead of the $result['URL'] object.
>>
>> Chris, If you see this, could you explain why the FX class returns
>> data but the URL that is returned produces a 105 error? It seems
>> as though the FX class would be unable to return a result if there
>> were an error. I'm totally baffled!
>>
>> Cheers,
>> Jason
>>
>>
>> On Jun 6, 2006, at 9:57 PM, Jason H Awbrey wrote:
>>
>>> Great points Dale.
>>>
>>> Thinking that it may have been corruption, I created a whole new
>>> layout based on the same TO -- no dice. I also considered that
>>> there may be a strange character in the mix. I removed one field
>>> at a time from the layout until there were no fields left on the
>>> layout and I STILL got the 105 error!!! I can assure you I have
>>> checked, double-checked and triple-checked the layout name and
>>> that is not the problem.
>>>
>>> Like I said earlier, some of the layouts return the expected
>>> result, but $result['URL'] returns a URL that returns the 105 error.
>>>
>>> Thanks again,
>>> Jason
>>>
>>>
>>> On Jun 6, 2006, at 9:35 PM, Dale Bengston wrote:
>>>
>>>> Jason,
>>>>
>>>> If you are getting a 105 error from FX, then it's the FileMaker
>>>> error for "Layout is Missing." This has nothing to do with
>>>> system errors, especially over the web; I think that's a red
>>>> herring.
>>>>
>>>> Have you tried silly stuff like renaming the layout? Or
>>>> duplicating it and referring to the copy? Is something in the
>>>> raw FX query causing a problem? A non-url-encoded character or
>>>> something?
>>>>
>>>> Regards,
>>>> Dale
>>>>
>>>> On Jun 6, 2006, at 8:49 PM, Jason H Awbrey wrote:
>>>>
>>>>> Thanks for the reply Steve.
>>>>>
>>>>> I do have related fields on the layout but I have applied the
>>>>> newest version of FMSA8 to fix the 'no related records' issue.
>>>>>
>>>>> I checked the FM knowledge base to see if there was anything in
>>>>> there worth anything and found this odd little ditty:
>>>>>
>>>>> 105/102 Errors
>>>>>
>>>>> A 105 or 102 error is a system error indicating a memory
>>>>> problem, typically a problem with memory management, not
>>>>> necessarily insufficient system memory.
>>>>>
>>>>> Even though I think this is a bit off the mark, I tried to
>>>>> restart my web server and filemaker server boxes (when in
>>>>> doubt, right?!?). It didn't do any good though -- still got the
>>>>> 105 error.
>>>>>
>>>>> The one thing I don't understand is this -- how can FX.php
>>>>> produce a valid query result when the XML query URL produces a
>>>>> 105 error???
>>>>>
>>>>> Thanks,
>>>>> Jason
>>>>>
>>>>>
>>>>> On Jun 6, 2006, at 6:49 PM, Steve Winter wrote:
>>>>>
>>>>>> Jason,
>>>>>>
>>>>>> Something in the back of my mind makes me think this might be
>>>>>> associated
>>>>>> with the issue in FMSA 7 and early versions of 8, where if you
>>>>>> have fields
>>>>>> from related tables on the layout, but there are no related
>>>>>> records, you
>>>>>> get this error... the solution is to put even single fields
>>>>>> from related
>>>>>> tables into a portal, or I believe upgrading to the latest
>>>>>> version of
>>>>>> FMSA8 and the web publishing engine also fixes it (assuming
>>>>>> that's the
>>>>>> problem)...
>>>>>>
>>>>>> Have a check and see if you've got related fields on your new
>>>>>> layout,
>>>>>> which the search would produce no related records for, and
>>>>>> give this a lash...
>>>>>>
>>>>>> Cheers
>>>>>> Steve
>>>>>>
>>>>>>> No question is a stupid one -- at least at this point. And,
>>>>>>> yes, I am
>>>>>>> specifying the correct layout.
>>>>>>>
>>>>>>> The funny thing is, I seem to be getting this on all my pages
>>>>>>> against
>>>>>>> this DB now. Some of the pages produce a valid result but the
>>>>>>> XML
>>>>>>> query produces a 105 error!!!
>>>>>>>
>>>>>>> I'm starting to wonder if there might be some corruption
>>>>>>> seeping in
>>>>>>> somewhere...
>>>>>>>
>>>>>>> Thanks,
>>>>>>> Jason
>>>>>>>
>>>>>>> On Jun 6, 2006, at 5:53 PM, Kevin Futter wrote:
>>>>>>>
>>>>>>>> On 7/6/06 8:30 AM, "Jason H Awbrey" <jawbrey at harmonic-data.com>
>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Hello all,
>>>>>>>>>
>>>>>>>>> I would greatly appreciate any help from someone before I
>>>>>>>>> pull my
>>>>>>>>> hair out!
>>>>>>>>>
>>>>>>>>> I noticed a problem with a PHP script that I'm running. The
>>>>>>>>> PHP
>>>>>>>>> script has one query with one query param. The script is
>>>>>>>>> returning
>>>>>>>>> SOME of the data that I would suspect -- 2 records with
>>>>>>>>> some of the
>>>>>>>>> fields. If I print out the query URL and try to perform it,
>>>>>>>>> I get a
>>>>>>>>> 105 error (Layout is missing). The layout is correct and
>>>>>>>>> exists. I
>>>>>>>>> tried creating a new layout and adding the fields onto the
>>>>>>>>> layout
>>>>>>> but
>>>>>>>>> got the same result.
>>>>>>>>
>>>>>>>> Sorry for the stupid question, but are you actually
>>>>>>>> specifying the
>>>>>>>> correct
>>>>>>>> layout in your query?
>>>>>>>>
>>>>>>>> --
>>>>>>>> Kevin Futter
>>>>>>>> Webmaster, St. Bernard's College
>>>>>>>> http://www.sbc.melb.catholic.edu.au/
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> ------------------------------------------
>>>>>>>> This e-mail and any attachments may be confidential. You
>>>>>>>> must not
>>>>>>>> disclose or use the information in this e-mail if you are
>>>>>>>> not the
>>>>>>>> intended recipient. If you have received this e-mail in error,
>>>>>>>> please notify us immediately and delete the e-mail and all
>>>>>>>> copies.
>>>>>>>> The College does not guarantee that this e-mail is virus or
>>>>>>>> error
>>>>>>>> free. The attached files are provided and may only be used
>>>>>>>> on the
>>>>>>>> basis that the user assumes all responsibility for any loss,
>>>>>>>> damage
>>>>>>>> or consequence resulting directly or indirectly from the use
>>>>>>>> of the
>>>>>>>> attached files, whether caused by the negligence of the
>>>>>>>> sender or
>>>>>>>> not. The content and opinions in this e-mail are not
>>>>>>>> necessarily
>>>>>>>> those of the College.
>>>>>>>>
>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>> FX.php_List mailing list
>>>>>>>> FX.php_List at mail.iviking.org
>>>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>>>
>>>>>>> ~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
>>>>>>> Jason Awbrey
>>>>>>> Web Integration
>>>>>>> FileMaker 7 Certified Developer
>>>>>>> Harmonic Data Associates
>>>>>>> http://www.harmonic-data.com
>>>>>>> jawbrey at harmonic-data.com
>>>>>>> w - 214 269.2804
>>>>>>> ~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> 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
>>>>>
>>>>> ~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
>>>>> Jason Awbrey
>>>>> Web Integration
>>>>> FileMaker 7 Certified Developer
>>>>> Harmonic Data Associates
>>>>> http://www.harmonic-data.com
>>>>> jawbrey at harmonic-data.com
>>>>> w - 214 269.2804
>>>>> ~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> 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
>>>
>>> ~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
>>> Jason Awbrey
>>> Web Integration
>>> FileMaker 7 Certified Developer
>>> Harmonic Data Associates
>>> http://www.harmonic-data.com
>>> jawbrey at harmonic-data.com
>>> w - 214 269.2804
>>> ~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> 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