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

[Glenn Singleton]

Thanks for the reply Dale but as I said below, the Filemaker URL works
perfectly (ie returning the data I am looking for), doesn't that prove that
WPE is configured properly for XML publishing and so forth ?
 
How else do I test ?, I am about to try FM PHP API instead of FX.PHP, with a
simple enquiry, but don't know how else to test...
 
Glenn 

  _____  

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Dale Bengston
Sent: Saturday, 30 August 2008 11:57 PM
To: FX.php Discussion List
Subject: Re: [FX.php List] Error contacting database: FX: ExecuteQuery
XMLerror: Mismatched tag


Hi Glenn, 

Since all your queries are failing, I think you can take FX at its word when
it says "Error contacting database." In cases like yours when you've just
migrated from one server to another and/or one version of FMP to another,
it's good to start with the WPE and make sure it can see your databases,
that it's configured properly for XML publishing, and so forth. 

Hope this helps,
Dale

On Aug 30, 2008, at 1:55 AM, Glenn Singleton wrote:


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.

 


 

 
_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list



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