[FX.php List] communication problem

[Robert Janssen]

Hello people
 
I have a rather puzzling problem with the FX module. I’ll try to be as succinct as possible but that is proving difficult.
 
I have two different timesheet programs, one for Dutch timesheets, one for Belgian. These two programs are largely similar in their communication ( databases ).  Last week Filemaker was transferred to another server ( both windows 2003 servers ) (filemaker version 8.0.2.208 advanced ) 
 
After this migration the Dutch version failed to operate properly. However the Belgian version works flawlessly. 
 
I’ve isolated the code where the problem occurs.
 
include_once($_SERVER['DOCUMENT_ROOT'] . "/FX/FX.php");                      include_once($_SERVER['DOCUMENT_ROOT'] . "/FX/server_data_urenstaat.php");
 
$gekozen_week = 24;$gekozen_jaar = 2008;$filemaker_id = 1999001;        $query = new FX($serverIP, $webCompanionPort, $dataSourceType, $scheme); $query->SetDBUserPass ($webUN, $webPW); 
 
$query->SetDBData($databaseName, "urenregistratie"); $query->AddDBParam('weeknummer', $gekozen_week);$query->AddDBParam('weekjaar', (100*$gekozen_jaar+$gekozen_week));$query->AddDBParam('medewerkernummer', $filemaker_id);$query->AddSortParam('project_nr', 'ascend', 1);$query->AddSortParam('activiteit_code', 'ascend', 2);$query->AddSortParam('opmerking', 'ascend', 3);$query->AddSortParam('datum', 'ascend', 4);   $data = $query->FMFind();        print_r($data);
 
if I run the code on the belgian database which for the "urenregistratie" layout is the same as the Dutch version, I get results.If I run the code on the dutch database an error occurs and the print_r($data) returns the following code
 
FX_Error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 [code] => 100 [message] => FX: ExecuteQuery XML error: Invalid document end at line 2 [userinfo] => [backtrace] => Array ( [0] => Array ( [file] => c:\Inetpub\intranet-ace-eu\FX\FX.php [line] => 1473 [function] => FX_Error [class] => FX_Error [type] => -> [args] => Array ( [0] => ExecuteQuery XML error: Invalid document end at line 2 ) ) [1] => Array ( [file] => c:\Inetpub\intranet-ace-eu\FX\FX.php [line] => 1687 [function] => ExecuteQuery [class] => FX [type] => -> [args] => Array ( [0] => -find ) ) [2] => Array ( [file] => c:\Inetpub\intranet-ace-eu\FX\FX.php [line] => 1921 [function] => FMAction [class] => FX [type] => -> [args] => Array ( [0] => -find [1] => 1 [2] => full [3] => 1 ) ) [3] => Array ( [file] => c:\Inetpub\intranet-ace-eu\gogo.php [line] => 23 [function] => FMFind [class] => FX [type] => -> [args] => Array ( ) ) ) [callback] => ) 
 
I observed a similar problem in the online fx trouble forum:[FX.php List] FX: ExecuteQuery XML errorSteve Bennett (steve at bentechaps.com)Sat Sep 8 09:57:39 MDT 2007 
 
however that never ended in a sollution, 
 
best regards,
 
Robert Janssen
_________________________________________________________________
Check je Hotmail nu ook op je mobiel!
http://windowslivemobile.msn.com/BrowserServiceHotmail.aspx?lang=nl-nl
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20080612/ae4234e9/attachment.html