[FX.php List] ExecuteQuery Error

[Jonathan Schwartz]

Sorry for the shorthand, Steve.

As Andy suggested, it's:

define("DEBUG",true);

Unfortunately, failure early in the FMP query process tends to throw 
less than succinct errors.

If you provide a link, we could take a look.

Jonathan

At 3:16 PM -0600 10/31/08, Bentech Forums wrote:
>Hey Jonathan,
>
>It has been a long time since I did any PHP so I am trying to get my 
>head back into it. By "Turn On Debug" do you mean enabling PHP Error 
>Reporting or is there some other Debug option that I should be 
>looking at?
>
>Thanks,
>
>Steve
>
>On Oct 31, 2008, at 2:05 PM, Jonathan Schwartz wrote:
>
>>Hi Steve,
>>
>>I'm in the middle of one of these myself.
>>
>>A piece of advice I received: turn on debug.  See if the query gets 
>>as far as executing and displaying the internal query link in the 
>>browser.  If so, click it.  The resulting XML will display in he 
>>browser for examination.  On Mac/Safari, you need to view Source.  
>>On Firefox, it will display onscreen, I believe.  Don't now about 
>>Windows side.
>>
>>In my case, I am chasing an XML based on bad data, layout, etc.
>>
>>Good luck.
>>
>>J
>>
>>
>>
>>At 1:36 PM -0600 10/31/08, Steve Bennett wrote:
>>>Sorry for the long message but not sure where to look to resolve 
>>>things so I will give as much info as I can think of.
>>>
>>>Trying to move a FileMaker File to a different server but we are 
>>>getting the following FX error when trying to work with a 
>>>multi-page fxphp form and not sure if it is the server 
>>>configuration or something in the php code which has been working 
>>>correctly for more than a year connecting to the current server.
>>>
>>>ERROR: FX: ExecuteQuery XML error: Invalid document end at line 1 (100) /
>>>
>>>The pages have been working fine for the past year when connecting 
>>>to the current server but something is wrong with configuration of 
>>>the new server that seems to be causing errors. I did not set up 
>>>the FileMaker servers and have little control over them but both 
>>>the new and old server are running FMSA 8 but the new server is 
>>>running Windows 2003 Small Business Server which I understand is 
>>>not officially supported by FileMaker.
>>>
>>>At first we were unable to connect to IWP or CWP on the new server 
>>>but this seemed to be a problem with IIS not being able to access 
>>>some of the FileMaker web publishing folder and the IT department 
>>>modified some of the permissions and IWP seems to now be working.
>>>
>>>CWP also appears to be working as some of the FXphp pages are 
>>>working but the multi-page form errors when going from the first 
>>>page to the second. When I look at the above error it indicates 
>>>that it is line 1 of my second page that is causing the error but 
>>>I am not sure what the (100) indicates in the error message. The 
>>>first line of the php page loads the connection information and is 
>>>the same on all of the pages and has been working fine on the old 
>>>server.
>>>
>>><?php require_once('../Connections/myconnection.php'); ?>
>>>
>>>The pages also use sessions but I figure they would be using the 
>>>web server which has not changed.
>>>
>>>I am not sure if there are some other FileMaker web publishing 
>>>folders that IT may need to alter permissions on or if there is a 
>>>better way to track down specifically what is causing the error. I 
>>>am also wondering if it could be the unsupported Windows 2003 
>>>Small Business Server, is anyone running FMSA on 2003 SBS?
>>>
>>>Any thought would be appreciated.
>>>
>>>Thanks,
>>>
>>>Steve
>>>
>>>
>>>_______________________________________________
>>>FX.php_List mailing list
>>>FX.php_List at mail.iviking.org
>>>http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>>--
>>Jonathan Schwartz
>>Exit 445 Group
>>jonathan at exit445.com
>>http://www.exit445.com
>>415-370-5011
>>_______________________________________________
>>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
Exit 445 Group
jonathan at exit445.com
http://www.exit445.com
415-370-5011