davidwheelock

FMS13 upgrade breaks FX.PHP query

Discussion created by davidwheelock on Jan 22, 2014
Latest reply on Feb 20, 2014 by davidwheelock

Hi All, I posted this yesterday on FM Forums, so please pardon the duplication.

 

My client recently upgraded their FileMaker Server, an xServe, to OS X 10.9 and FMS13. As a result, an existing php web site, pulling FileMaker data using fx.php, is now broken.

 

I perform a simple query, looking up a user by their account name. After the upgrade, I am returned 0 records with an error of '4'. The weird part is, when I run my script with debug on, and I manually click on the resulting query URL it works as I would expect. The XML result is the one record I asked for.

 

I can't seem to find other forum posts, from others who have had this issue after upgrading to FMS13. Is anyone aware of any differences in FMS13 which might cause this failure? any thought or suggestions are welcome. Thanks

 

Dave W

 

---- Here's the query ------------------

 

// === GRAB THE LOG IN INFO ===

$_SESSION['account_name'] = $_REQUEST['account_name'];

 

//define("DEBUG", true);

// === required FX files

require_once(/*$_SERVER['DOCUMENT_ROOT'] . */"FX/FX.php");

require_once(/*$_SERVER['DOCUMENT_ROOT'] . */"FX/FX_Error.php");

require_once(/*$_SERVER['DOCUMENT_ROOT'] . */"FX/Developer/FMErrors.php");

require_once(/*$_SERVER['DOCUMENT_ROOT'] . */"FX/server_data.php");

$database = 'MyFile.fmp12';

$layout = 'web_login';

 

// === LOOK UP THE LOGIN INFO ==

 

$login= new FX($serverIP, $webCompanionPort, $dataSourceType, $scheme);

$login->SetDBData($database, $layout);

$login->SetDBPassword($webPW, $webUN);

$login->AddDBParam('login_name',$_SESSION['account_name'] );

$loginresult = $login->FMFind();

 

$resultcount = $loginresult['foundCount'];

$resultdata = $loginresult['data'];

 

// == ADDED JUST TO HELP DEBUG THIS ISSUE ==

echo $resultcount.' count<br>';

echo $loginresult['errorCode'].' error';

die;

 

------------ End of the query -------------------

 

--------------Here's the result ------------------

 

 

Outcomes