[FX.php List] ExecuteQuery Error

[Jonathan Schwartz]

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