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

[Dale Bengston]

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&-lay=report&-max=50&-sortfield.1=surname&-sortorder.1=ascend&-sortfield.2=otherNames&-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
> 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/20080830/ad960a04/attachment.html