[FX.php List] FX: ExecuteQuery XML error

[Jon Montgomery]

Steve,
    I know you said that you didn't install the FMS 8.0 but there is an
update to 8.0v4.  Could that be the problem? I don't remember what that
update fixed, I just did it because all the posts said to.

Jon Montgomery


On 9/8/07 2:38 PM, "Steve Bennett" <steve at bentechaps.com> wrote:

> Glen,
> 
> The web server didn't change just the database files were moved to a
> new FileMaker Server. It is strange in that I am able to connect to
> the new FileMaker server using some of the php pages but suddenly get
> errors on other pages that have worked well from the same web server
> for several months. I am thinking that it is something to do with the
> FileMaker Server setup or the firewall.
> 
> I have put the database files on two other FileMaker servers and
> connected to both of them from the web server without any errors so I
> keep coming back to the FileMaker Server being the problem. The only
> thing that I have noticed between the new server and the other two
> servers I have tested is that the new FileMaker Server is running
> Windows 2000 and is accessed through port 591 while the other two
> that work are running OS-X and port 80.
> 
> I didn't install the FileMaker Advanced Server, it was recently
> updated from FMSA 7 to FMSA8 and was previously only being used for
> IWP, so maybe there is an issue with Windows 2000. I would just
> expect that if there was a problem with Windows 2000 or the FMSA 8
> install then none of the PHP pages would work.
> 
> I will try some new files and see what I find.
> 
> Thanks,
> 
> Steve
> 
> 
> 
> 
> On Sep 8, 2007, at 1:16 PM, Glenn Singleton wrote:
> 
>> Steve,
>> 
>> Just a few things to check when you say they are the same :-
>> 
>> 1. Can you see normal html pages on the new server ?
>> 2. Are they running the same web server software ie version of
>> Apache or IIS ?
>> 3. Are they running the same php version ?
>> 4. Can you run a <?php phpinfo(); ?> on the new site ?
>> 5. Can you run the fx.php example pages ?
>> 
>> If all of this is OK then try recreating one of your files on the
>> new server in say Notepad and again see if you get the same error.
>> 
>> I would check all this first, but maybe you have already done
>> that ....
>> 
>> Regards
>> Glenn Singleton
>> 
>> On 09/09/2007, at 1:57 AM, Steve Bennett wrote:
>> 
>>> I am trying to move some database files to a new FileMaker server
>>> and I am getting the following error when trying to run some FX-
>>> PHP pages.
>>> 
>>> The following error has occured: FX: ExecuteQuery XML error:
>>> Invalid document end at line 1 (100)
>>> 
>>> The FX PHP pages are still on the same web server the only thing
>>> that has changed is the new FileMaker server. If I point my FX PHP
>>> connection file back to the old server everything runs fine.
>>> 
>>> I did not get to set up the new FileMaker server and it was
>>> recently updated from FMSA 7 to FMSA 8 but from what I can tell
>>> the only difference is that the new FileMaker server is access
>>> through a firewall on port 591 rather than port 80.
>>> 
>>> Some of my FX PHP pages used for searches are working fine on the
>>> new server and initial record creation in the process that
>>> encounters the error also works. The page that encounters the
>>> error is part of a multi-page form. The first page that the user
>>> fills out is submitted to the FileMaker server correctly and a new
>>> record is created in FileMaker but then the error page comes up
>>> with the error mentioned above.
>>> 
>>> I am thinking that it must be due to the FileMaker server or
>>> firewall configuration as I can point the FX PHP pages at two
>>> other FileMaker servers and everything works fine.
>>> 
>>> Any direction on how to debug this would be appreciated.
>>> 
>>> Thanks,
>>> 
>>> Steve
>>> 
>>> _______________________________________________
>>> 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
>> 
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>