[FX.php List] communication problem

[Dale Bengston]

Hi Robert,

What happens if you do FMFindall() or FMView() queries against the  
Dutch database? Can you retrieve data at all?

Can you confirm in the Web Publishing admin console that the Dutch  
database is available to the web? There is a page showing hosted  
databases. Are both the Dutch and Belgian versions showing?

Another thing to check would be file access permissions (at the  
operating system level) after the transfer.

Hope this helps,
Dale


  --
Dale Bengston
Partner, The Whole Brain Group, LLC
thewholebraingroup.com

On Jun 12, 2008, at 8:29 AM, Robert Janssen wrote:

> 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 error
> Steve Bennett (steve at bentechaps.com)
> Sat Sep 8 09:57:39 MDT 2007
>
> however that never ended in a sollution,
>
> best regards,
>
> Robert Janssen
>
> Het beste van Windows, nu ook online. Deel jouw wereld met Windows  
> Live. Download nu._______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list