[FX.php List] FX: ExecuteQuery XML error

[Steve Bennett]

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
>