[FX.php List] Error code question

Jim McNeely jim at newcenturydata.com
Mon Nov 6 16:14:57 MST 2006


I am having some trouble with a PHP file that was working perfectly with 
FMSA 7, but upon updating to FMSA 8 is not working properly. Other 
queries are working correctly that reference the same FM file, but not 
this one. I used var_dump() to examine the contents of the array that 
isn't working, and got this; what EXACTLY is the filemaker error in all 
of this? - Also, if I comment the web_web query and do the web_products 
query, it works. And yes, the layout is there and is named correctly, as 
are all of the fields. So, WHAT???!!!  TIA, Jim
==========================
query:
==========================
$linkq = new FX("10.42.6.153","80");   
//$linkq->SetDBData("soi_data.fp7", "web_products");
$linkq->SetDBData("soi_data.fp7", "web_web");

$linkq->SetDBUserPass("web","bewbew2005");

//$linkq->AddDBParam("f_new_prd_flag", "1");
$linkq->AddDBParam("c_table", "Links");

$link=$linkq->FMFind();

echo var_dump($link);

==========================
result:
==========================
object(fx_error)(8) {
  ["error_message_prefix"]=>
  string(0) ""
  ["mode"]=>
  int(1)
  ["level"]=>
  int(1024)
  ["code"]=>
  int(100)
  ["message"]=>
  string(54) "FX: ExecuteQuery XML error: no element found at line 2"
  ["userinfo"]=>
  NULL
  ["backtrace"]=>
  array(5) {
    [0]=>
    array(6) {
      ["file"]=>
      string(38) "/Library/WebServer/Documents/FX/FX.php"
      ["line"]=>
      int(895)
      ["function"]=>
      string(8) "fx_error"
      ["class"]=>
      string(8) "fx_error"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(50) "ExecuteQuery XML error: no element found at line 2"
      }
    }
    [1]=>
    array(6) {
      ["file"]=>
      string(38) "/Library/WebServer/Documents/FX/FX.php"
      ["line"]=>
      int(1057)
      ["function"]=>
      string(12) "executequery"
      ["class"]=>
      string(2) "fx"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(1) {
        [0]=>
        string(5) "-find"
      }
    }
    [2]=>
    array(6) {
      ["file"]=>
      string(38) "/Library/WebServer/Documents/FX/FX.php"
      ["line"]=>
      int(1108)
      ["function"]=>
      string(8) "fmaction"
      ["class"]=>
      string(2) "fx"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(3) {
        [0]=>
        string(5) "-find"
        [1]=>
        bool(true)
        [2]=>
        string(4) "full"
      }
    }
    [3]=>
    array(6) {
      ["file"]=>
      string(41) "/Library/WebServer/Documents/spot_hdr.php"
      ["line"]=>
      int(70)
      ["function"]=>
      string(6) "fmfind"
      ["class"]=>
      string(2) "fx"
      ["type"]=>
      string(2) "->"
      ["args"]=>
      array(0) {
      }
    }
    [4]=>
    array(4) {
      ["file"]=>
      string(38) "/Library/WebServer/Documents/index.php"
      ["line"]=>
      int(20)
      ["args"]=>
      array(1) {
        [0]=>
        string(41) "/Library/WebServer/Documents/spot_hdr.php"
      }
      ["function"]=>
      string(7) "include"
    }
  }
  ["callback"]=>
  NULL
}



More information about the FX.php_List mailing list