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

[Bob Patin]

... which brings up a question that I had yesterday:

If the web server or the WPE isn't communicating properly with FM  
Server, as happened on one of my clients' machines yesterday, the only  
way that I knew to determine that there was no communication going on  
was to ask for the errorCode from the query. Since I didn't get one, I  
knew there was no query being done...

Is there another way? I could use print_r() I suppose, right? Is that  
what you guys would check in that case?

On this machine her SSL cert, which worked for a month, suddenly quit  
working; I have to think she'd changed something that broke things,  
but at any rate all of the queries, which I was trying to do using a  
secure connection, were failing to occur. Finally tracked down the  
error though.

Thanks,

--
Bob Patin
Longterm Solutions
bob at longtermsolutions.com
615-333-6858
http://www.longtermsolutions.com
iChat: bobpatin
AIM: longterm1954
FileMaker 9 Certified Developer
Member of FileMaker Business Alliance and FileMaker TechNet
--------------------------
FileMaker hosting and consulting for all versions of FileMaker
PHP • Full email services • Free DNS hosting • Colocation • Consulting

On Aug 30, 2008, at 8:56 AM, Dale Bengston wrote:

> 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
>
> _______________________________________________
> 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/7a965532/attachment.html