[FX.php List] ExecuteQuery Error

[Bentech Forums]

Thanks Everyone,

Setting define("DEBUG", True); gives me the following info with some  
client specific info X'd out:


Warning: session_start() [function.session-start]: Cannot send session  
cache limiter - headers already sent (output started at /Users/myfiles/ 
Sites/xxxxxxxxxfm/db_candidate_application/addcandidate2.php:5) in/ 
Users/myfiles/Sites/xxxxxxxxxfm/db_candidate_application/ 
addcandidate2.php on line 7
Accessing FileMaker Pro 7 data.


Using FileMaker URL: http://PHPUser:onlineuser@xxx.xxx.xxx.xxx:591/fmi/xml/FMPXMLRESULT.xml?-db=Application_DB&-lay=WebCandidate&-max=50&Name_First_t=Steve&Name_Middle_Initial_t=B&Name_Last_t=Test&Address_Street_t=Internal+Server+Test+Friday%2C+October+31%2C+2008+15%3A56%3A25&Address_City_t=CGY&Address_Province_t=AB&Address_Postal_code_t=T4T+4T4&Candidate_Email_Web_Entry::Contact_Email_Internet_Address_t=steve%40test.com&Candidate_Phone1_Web_Entry::Contact_Phone_Area_Code_t=403&Candidate_Phone1_Web_Entry::Contact_Phone_t=222-2222&Candidate_Phone1_Web_Entry::Contact_Location_t=Home&Candidate_Phone2_Web_Entry::Contact_Phone_Area_Code_t=404&Candidate_Phone2_Web_Entry::Contact_Phone_t=333-3333&Candidate_Phone2_Web_Entry::Contact_Location_t=Mobile&Candidate_Phone3_Web_Entry::Contact_Phone_Area_Code_t=405&Candidate_Phone3_Web_Entry::Contact_Phone_t=444-4444&Candidate_Phone3_Web_Entry::Contact_Location_t=Work&zKF_OrderInterestID=&-new


Warning: Cannot modify header information - headers already sent by  
(output started at /Users/myfiles/Sites/xxxxxxxxxfm/ 
db_candidate_application/addcandidate2.php:5) in/Users/myfiles/Sites/ 
xxxxxxxxxfm/FX/FMStudio_Tools.php on line 209





Clicking on the FileMaker URL link generated in the above error shows  
the following information:

This page contains the following errors:
error on line 1 at column 7649: Extra content at the end of the document
Below is a rendering of the page up to the first error. 
010/31/2008BSteveTest226061Internal Server Test Friday, October 31,  
2008 15:56:25CGYABT4T 4T4steve at test.com403222-2222Home403222-2222Home403222-2222Home33470







I am not sure how to interpret this but there appears to be something  
going on with Sessions? This is an online application and  
questionnaire. The first page collects candidate contact information  
which is added to the database by the second page which then displays  
the first part of the questionnaire. The data from the first page is  
submitted correctly and appears in the database but then it appears to  
error out but works fine if the same web server is pointed to another  
FileMaker server.



So now I turned on the debug and pointed to the old working server and  
get the same Session error as above BUT the page continues to load. To  
me this indicates that there is a session error that does not halt the  
old server!

Gives me something to dig into so thanks,

Steve

On Oct 31, 2008, at 3:21 PM, Andy Gaunt wrote:

> 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