[FX.php List] Error contacting database: FX: ExecuteQueryXMLerror: Mismatched tag FIXED

Sun Aug 31 00:41:06 MDT 2008

Hi

Just wanted to let you know that the problem was to do with IIS Web Server
permissions, which then caused the error discribed.

Found a server script to clear all permissions and started again.

Glenn

  _____  

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Glenn Singleton
Sent: Sunday, 31 August 2008 7:10 AM
To: 'FX.php Discussion List'
Subject: RE: [FX.php List] Error contacting database: FX:
ExecuteQueryXMLerror: Mismatched tag

No SSL cert being used here and Filemaker PHP test page works as well (but
that's not my database). 

So Web Server talking to WPE talking to FM Server, right ?

I will try a print_r() on the returned dataset to see what it says...

Glenn

  _____  

From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Bob Patin
Sent: Sunday, 31 August 2008 1:16 AM
To: FX.php Discussion List
Subject: Re: [FX.php List] Error contacting database: FX: ExecuteQuery
XMLerror: Mismatched tag

... 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&-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

_______________________________________________
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/8a65b018/attachment-0001.html