[FX.php List] ExecuteQuery Error

[Gareth Evans]

The error is the result of FX trying to parse the XML returned from
FileMaker.  The " Invalid document end at line 1" bit probably means the XML
data is empty. The (100) is just the default error code for the FX_Error
class and means nothing here.

Maybe you have a bad path to a related file in your db? Windows likes \
backslashes for its paths instead of the / forward slashes we're used to on
the Mac.
-- 
GARETH EVANS


> From: Steve Bennett <steve at bentechaps.com>
> Reply-To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Date: Fri, 31 Oct 2008 13:36:44 -0600
> To: "FX.php Discussion List" <fx.php_list at mail.iviking.org>
> Subject: [FX.php List] ExecuteQuery Error
> 
> 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