[FX.php List] ExecuteQuery Error

[Andy Gaunt]

Hey Steve,

you can turn on PHP debug using

define("DEBUG",true);

Also, you can ratchet up your PHP Error reporting on a per page basis  
by inserting the following.


//Ensure all errors are reported to brwser
error_reporting(E_ALL);
ini_set('display_errors',1);
ini_set('error_reporting', E_ALL);

Cheers

Andy Gaunt
T: 321-206-3658
andy at fmpug.com
http://www.fmpug.com

FMPug.com: A Developer's best Friend!

FindFileMakerDevelopers.com -
The #1 listings engine for FileMaker Professionals






On Oct 31, 2008, at 5:16 PM, Bentech Forums wrote:

> Hey Jonathan,
>
> It has been a long time since I did any PHP so I am trying to get my  
> head back into it. By "Turn On Debug" do you mean enabling PHP Error  
> Reporting or is there some other Debug option that I should be  
> looking at?
>
> Thanks,
>
> Steve
>
> On Oct 31, 2008, at 2:05 PM, Jonathan Schwartz wrote:
>
>> Hi Steve,
>>
>> I'm in the middle of one of these myself.
>>
>> A piece of advice I received: turn on debug.  See if the query gets  
>> as far as executing and displaying the internal query link in the  
>> browser.  If so, click it.  The resulting XML will display in he  
>> browser for examination.  On Mac/Safari, you need to view Source.   
>> On Firefox, it will display onscreen, I believe.  Don't now about  
>> Windows side.
>>
>> In my case, I am chasing an XML based on bad data, layout, etc.
>>
>> Good luck.
>>
>> J
>>
>>
>>
>> At 1:36 PM -0600 10/31/08, Steve Bennett wrote:
>>> Sorry for the long message but not sure where to look to resolve  
>>> things so I will give as much info as I can think of.
>>>
>>> Trying to move a FileMaker File to a different server but we are  
>>> getting the following FX error when trying to work with a multi- 
>>> page fxphp form and not sure if it is the server configuration or  
>>> something in the php code which has been working correctly for  
>>> more than a year connecting to the current server.
>>>
>>> ERROR: FX: ExecuteQuery XML error: Invalid document end at line 1  
>>> (100) /
>>>
>>> The pages have been working fine for the past year when connecting  
>>> to the current server but something is wrong with configuration of  
>>> the new server that seems to be causing errors. I did not set up  
>>> the FileMaker servers and have little control over them but both  
>>> the new and old server are running FMSA 8 but the new server is  
>>> running Windows 2003 Small Business Server which I understand is  
>>> not officially supported by FileMaker.
>>>
>>> At first we were unable to connect to IWP or CWP on the new server  
>>> but this seemed to be a problem with IIS not being able to access  
>>> some of the FileMaker web publishing folder and the IT department  
>>> modified some of the permissions and IWP seems to now be working.
>>>
>>> CWP also appears to be working as some of the FXphp pages are  
>>> working but the multi-page form errors when going from the first  
>>> page to the second. When I look at the above error it indicates  
>>> that it is line 1 of my second page that is causing the error but  
>>> I am not sure what the (100) indicates in the error message. The  
>>> first line of the php page loads the connection information and is  
>>> the same on all of the pages and has been working fine on the old  
>>> server.
>>>
>>> <?php require_once('../Connections/myconnection.php'); ?>
>>>
>>> The pages also use sessions but I figure they would be using the  
>>> web server which has not changed.
>>>
>>> I am not sure if there are some other FileMaker web publishing  
>>> folders that IT may need to alter permissions on or if there is a  
>>> better way to track down specifically what is causing the error. I  
>>> am also wondering if it could be the unsupported Windows 2003  
>>> Small Business Server, is anyone running FMSA on 2003 SBS?
>>>
>>> Any thought 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
>>
>>
>> -- 
>> Jonathan Schwartz
>> Exit 445 Group
>> jonathan at exit445.com
>> http://www.exit445.com
>> 415-370-5011
>> _______________________________________________
>> 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