[FX.php List] communication problem

[DC]

also, xml parser can choke on corrupt data coming out of the database 
fields (including high ascii chars).

cheers,dan

Dale Bengston wrote:
> 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
> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>