[FX.php List] Error contacting database: FX: ExecuteQuery XML error: Mismatched tag

Glenn Singleton glenn at possiblesolutions.com.au
Sat Aug 30 00:55:59 MDT 2008


Hi,

I am converting an existing FM7SA FX.php web application to single FM9S/Web
Server and getting a strange error.

I have copied the databases and web code and the only difference I know is
that it is using the FM installed PHP.

I have tried updating to the latest FX.php and get the same error.

If I copy the URL below it works perfectly as does access from FMP direct
and IWP. 

xxx:xxx is of course the user name and password which has all priveledges
set on the file.

I have tried 127.0.0.1 as the IP as well, same error and simplified the
layout in FM.

Response to a find request....

Accessing FileMaker Pro 7/8/9 data.

Using FileMaker URL:
<http://xxx:xxx@192.168.1.3:80/fmi/xml/FMPXMLRESULT.xml?-db=security.fp7&-la
y=report&-max=50&-sortfield.1=surname&-sortorder.1=ascend&-sortfield.2=other
Names&-sortorder.2=ascend&fileNo=&surname=Be&-find>
http://xxx:xxx@192.168.1.3:80/fmi/xml/FMPXMLRESULT.xml?-db=security.fp7&-lay
=report&-max=50&-sortfield.1=surname&-sortorder.1=ascend&-sortfield.2=otherN
ames&-sortorder.2=ascend&fileNo=&surname=Be&-find

Error contacting database: FX: ExecuteQuery XML error: Mismatched tag at
line 11
 
I have read on other posts that this is most likely "dirty" data, is that
the likely reason ?
 
The line it is performing is :-
 
$new = count($searchResult['data']);
 
but also comes up with the same error for any other request.
 
Regards
Glenn Singleton B.App.Sc
possible SOLUTIONS (Australia)
2/12 Nabiac Street, Nabiac NSW 2312
 <http://www.possiblesolutions.com.au/> www.possiblesolutions.com.au
P: 02 6554 1001 F: 02 6554 1038 M: 0411 282 290
 



The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee(s). Access to this email by anyone
else is unauthorised. If you are not the intended recipient, any disclosure,
copying, distribution or any action taken or omitted to be taken in reliance
on it, is prohibited and may be unlawful.

 

 

 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.iviking.org/pipermail/fx.php_list/attachments/20080830/4d51c212/attachment-0001.html


More information about the FX.php_List mailing list