[FX.php List] Error 105
Jason H Awbrey
jawbrey at harmonic-data.com
Wed Jun 7 20:54:47 MDT 2006
Hi Jonathan,
Thanks for the post. I did log in with one of the developer accounts
(a Full Access account) and still got the 105 error. I have not
checked the permissions on the file. I will check that first thing in
the morning. Account permissions was definitely something I had
thought of but checking the FILE permissions had escaped me. I was
out of the office for a week. There is no telling what those guys did
while I was gone... :-)
I'll post in the morning to let you all know what the result is.
Cheers,
Jason
~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
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
~-~-~-~~-~-~-~-~-~-~-~-~-~-~-~-~-~-~
On Jun 7, 2006, at 6:52 PM, Jonathan Schwartz wrote:
> Jason,
>
> I must be crazy to offer up advise after Chris and the experts.
> However, I successfully worked through a couple of these Error 105
> issues. The problem I found dealt with the permissions to view the
> layout. If the permissions were insufficient, the layout would not
> be "found", and the error appeared. That was my analysis of the
> issue.
>
> To fix the problem at the time, I did two things, and I'm not sure
> which actually resolved the issues:
> 1) Switch back to user with full admin permissions in FMP. I
> believe Chris suggested this.
> 2) Examine the file's Get Info/Ownership & Permissions. Set all
> to "Read and Write". I have found that these permissions change
> sometimes when the file is moved on the hard disk.
>
> If this works, then you will need to set up these permissions back
> to protect your solution.
>
> Again, I could be way off. Your mileage may vary.
>
> HTH,
>
> Jonathan
>
>
>
> At 4:49 PM -0500 6/7/06, Jason H Awbrey wrote:
>> 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
>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>
> --
>
> Jonathan Schwartz
> Schwartz & Company
> 817 Marin Drive
> Mill Valley, CA 94941
> Phone: 415-381-1852
> jonathan at eschwartz.com - http://www.eschwartz.com
>
> _______________________________________________
> 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