[FX.php List] Can't get web server to connect

Nick Trenary trenaryn at crlibrary.org
Mon Dec 10 07:50:37 MST 2007


I'm upgrading from FMServer 5.5 to FMServer 9.0v2 and have hit a snag.   
I have two web servers in my dmz and the FMServer is in the inside 
interface on my firewall.  I have opened port 80 on the inside interface 
for both web servers to the FMServer.  In my php code I have renamed by 
databases to database.fp7 and added the necessary username and password 
line:

$query = new FX ('192.168.1.250', '80');
$query->SetDBData('webboardminutes.fp7', 'web', 'All');
$query->SetDBPassword ('password', 'user');
$query->AddSortParam('meetingdate', 'descend');
$result = $query->FMFind();
$currentKey = key($result['data']);

When I open up the web page I see this:

*Warning*: Cannot use a scalar value as an array in 
*/Library/WebServer/crpl/include/getminutes.php* on line *12*

*Warning*: key() [function.key 
<http://www.crlibrary.org/about/function.key>]: Passed variable is not 
an array or object in */Library/WebServer/crpl/include/getminutes.php* 
on line *12*
fx_error Object ( [error_message_prefix] => [mode] => 1 [level] => 1024 
[code] => 100 [message] => FX: ExecuteQuery XML error: syntax error at 
line 1 [userinfo] => [backtrace] => Array ( [0] => Array ( [file] => 
/Library/WebServer/FX/FX.php [line] => 869 [function] => fx_error 
[class] => fx_error [type] => -> [args] => Array ( [0] => ExecuteQuery 
XML error: syntax error at line 1 ) ) [1] => Array ( [file] => 
/Library/WebServer/FX/FX.php [line] => 1051 [function] => executequery 
[class] => fx [type] => -> [args] => Array ( [0] => -find ) ) [2] => 
Array ( [file] => /Library/WebServer/FX/FX.php [line] => 1102 [function] 
=> fmaction [class] => fx [type] => -> [args] => Array ( [0] => -find 
[1] => 1 [2] => full ) ) [3] => Array ( [file] => 
/Library/WebServer/crpl/include/getminutes.php [line] => 11 [function] 
=> fmfind [class] => fx [type] => -> [args] => Array ( ) ) [4] => Array 
( [file] => /Library/WebServer/crpl/about/minutes.php [line] => 35 
[args] => Array ( [0] => /Library/WebServer/crpl/include/getminutes.php 
) [function] => include_once ) ) [callback] => )
*Warning*: Cannot use a scalar value as an array in 
*/Library/WebServer/crpl/include/getminutes.php* on line *22*

*Warning*: Invalid argument supplied for foreach() in 
*/Library/WebServer/crpl/include/getminutes.php* on line *22

*I can run the exact same code on my test computer on the inside 
interface and it connects without error.  What have I overlooked?

Thanks,
Nick

-- 
--

Nick Trenary
Computer Information Systems Analyst
Cedar Rapids Public Library
Office: 319.398.5145 x267
Cell: 319.310.7699




More information about the FX.php_List mailing list