[FX.php List] Error code question

Jim McNeely jim at newcenturydata.com
Tue Nov 7 08:33:09 MST 2006


Gjermund,

Actually we always do it like that, but I put this together for a test, 
and I wanted everything hard coded to take every possible variance out 
of the picture.

Jim

Gjermund Gusland Thorsen wrote:
> Hi Jim
>
> For you own convenience, please put IP, port and username/passwords
> into variables and use /FX/server_data.php or
> /FX/server_data_<<projectName>>.php to hold them.
>
> In case of changing database location you will have only one place to
> change IP/port/database/username/password
>
> Gjermund
>
> 2006/11/7, Jim McNeely <jim at newcenturydata.com>:
>> Andy,
>>
>> Yes, and that fixed it! So that bug is still there. THANKS!!!!!!!!!
>>
>> Jim
>>
>> Andy Gaunt wrote:
>> > Jim,
>> >
>> > Any related fields outside portals?
>> >
>> > Andy Gaunt
>> > Office: 321.206.3658
>> > Mobile: 407.810.4722
>> > andy at fmpug.com
>> > http://www.fmpug.com
>> >
>> > 2006 FileMaker Excellence Award Winner
>> > Recipient of FileMaker's 2005 "Mad Dog" Public Relations Award
>> >
>> > For chapter locations, dates & times please visit the website at
>> > http://www.fmpug.com If you can make it to a meeting, please RSVP at
>> > http://www.fmpug.com/rsvp.php
>> >
>> > -----Original Message-----
>> > From: fx.php_list-bounces at mail.iviking.org
>> > [mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Jim McNeely
>> > Sent: Monday, November 06, 2006 6:15 PM
>> > To: FX.php_List at mail.iviking.org
>> > Subject: [FX.php List] Error code question
>> >
>> > 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
>> > }
>> >
>> > _______________________________________________
>> > 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
>> >
>> >
>>
>> _______________________________________________
>> 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
>



More information about the FX.php_List mailing list