[FX.php List] Error 105
Jonathan Schwartz
jonathan at eschwartz.com
Wed Jun 7 17:52:05 MDT 2006
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
More information about the FX.php_List
mailing list